Want to Make searchable drop down in mvc4

using Fluentx.Mvc;

using FTSWeb.Models.HouseKeeping;

using FTSWeb.Models;

using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using System.Net;

using System.Web;

using System.Web.Mvc;

using System.Collections;

using Microsoft.Ajax.Utilities;

using FTSWeb;

namespace FTSWeb.Controllers

{

public class EmployeeController : Controller

{

#region Actions

Employee Employee = new Employee();

public ActionResult Index()

{

if (Session["DisplayName"] == null)

{

return RedirectToRoute("Acsol");

}

DataSet dsList = new DataSet();

dsList = Employee.prcGetData("", "0");

ViewBag.Desig = dsList.Tables[0];

//ViewBag.Dept = dsList.Tables[1];

return View();

}

public ActionResult Load()

{

if (Session["DisplayName"] == null)

{

return RedirectToRoute("Acsol");

}

DataSet dsList = new DataSet();

dsList = Employee.prcGetData("", "0");

ViewBag.Desig = dsList.Tables[0];

return View();

}

[HttpPost]

public ActionResult Index(Employee model)

{

Dictionary postData = new Dictionary();

postData.Add("rptCode", "4");

postData.Add("sqlQuery", "Exec FTSHRIS_AL_AMIN.dbo.rptAttendSumTest '2','15-May-2016','Section'");

postData.Add("rptFormat", "PDF");

//return RedirectAndPostActionResult.RedirectAndPost("http://103.4.67.93/acs.mis/frmGeneratingReport.aspx", postData);

//return (frmGeneratingReport , postData);

return RedirectAndPostActionResult.RedirectAndPost("frmGeneratingReport.aspx", postData);

//return Redirect(Url.Action("frmGeneratingReport.aspx", postData));

return View();

}

//add by nazmul

//public PartialViewResult SucceesMesg()

//{

// return PartialView("Create");

//}

public ActionResult Create()

{

if (Session["DisplayName"] == null)

{

////return RedirectToRoute("Acsol"); ;

return RedirectToAction("Create"); ;

}

prcLoadCombo();

return View();

}

[HttpPost]

[ValidateAntiForgeryToken]

public ActionResult Create(Employee model)

{

try

{

if (ModelState.IsValid)

{

System.Threading.Thread.Sleep(700);

var values = prcSaveData(model);

if (values == "Data save sucessfully")

{

ModelState.Clear();

//return View(model);

//return RedirectToAction("Index");

//model.CardNo = String.Empty;

//model.empCode = String.Empty;

//model.GS = String.Empty;

//model.empName = String.Empty;

//model.dtJoin = String.Empty;

//model.dtBirth = String.Empty;

//prcLoadCombo();

prcLoadCombo();

//Add By Nazmul

TempData["Success"] = "Added Successfully!";

return RedirectToAction("Create");

//return View("Create");

//prcLoadCombo();

}

ModelState.AddModelError("CustomError",values);

prcLoadCombo();

return View(model);

}

prcLoadCombo();

return View(model);

}

catch (Exception ex)

{

ModelState.AddModelError("CustomError",ex.Message);

return View(model);

}

}

public ActionResult Details(Int32 id)

{

if (Session["DisplayName"] == null)

{

return RedirectToRoute("Acsol"); ;

}

if (id == 0)

{

return new HttpStatusCodeResult(HttpStatusCode.BadRequest);

}

prcLoadCombo();

Employee model = new Employee();

DataSet dsList = new DataSet();

dsList = Employee.prcGetData("",id.ToString());

ViewBag.employee = dsList.Tables[0].Rows[0];

if (model == null)

{

return HttpNotFound();

}

return View(model);

}

public ActionResult Edit(Int32 id)

{

if (id == 0)

{

return new HttpStatusCodeResult(HttpStatusCode.BadRequest);

}

prcLoadCombo();

Employee model = new Employee();

model = Employee.prcGetData(id);

if (model == null)

{

return HttpNotFound();

}

return View(model);

}

[HttpPost]

[ValidateAntiForgeryToken]

public ActionResult Edit(Employee model)

{

try

{

if (ModelState.IsValid)

{

var values = prcUpdateData(model);

if (values == "Data updated sucessfully")

{

return RedirectToAction("Index");

}

ModelState.AddModelError("CustomError", values);

prcLoadCombo();

return View(model);

}

prcLoadCombo();

return View(model);

}

catch (Exception ex)

{

ModelState.AddModelError("CustomError", ex.Message);

return View(model);

}

}

public ActionResult Delete(Int32 id)

{

if (Session["DisplayName"] == null)

{

return RedirectToRoute("Acsol"); ;

}

if (id == 0)

{

return new HttpStatusCodeResult(HttpStatusCode.BadRequest);

}

Employee = Employee.prcGetData(id);

DataSet dsList = new DataSet();

dsList = Employee.prcGetData("",id.ToString());

ViewBag.employee = dsList.Tables[0].Rows[0];

if (Employee == null)

{

return HttpNotFound();

}

return View(Employee);

}

[HttpPost]

[ValidateAntiForgeryToken]

public ActionResult Delete(Employee model)

{

prcDeleteData(model);

return RedirectToAction("Index");

}

#endregion Actions

#region procedures

public void prcLoadCombo()

{

DataSet dsList = new DataSet();

clsConnection clsCon = new clsConnection();

try

{

const string sqlQuery = "Exec prcGetEmployee_WebBased 'Initial' ";

clsCon.FTSFillDatasetWithSQLCommand(ref dsList, sqlQuery);

dsList.Tables[0].TableName = "Desig";

dsList.Tables[1].TableName = "Dept";

dsList.Tables[2].TableName = "Line";

dsList.Tables[3].TableName = "Floor";

dsList.Tables[4].TableName = "Type";

dsList.Tables[5].TableName = "Religion";

dsList.Tables[6].TableName = "Grade";

dsList.Tables[7].TableName = "Sex";

dsList.Tables[8].TableName = "Shift";

dsList.Tables[9].TableName = "Week";

dsList.Tables[10].TableName = "Blood";

dsList.Tables[11].TableName = "Paymode";

//Designation

List Desig = new List();

for (int i = 0; i < dsList.Tables["Desig"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Desig"].Rows[i][0].ToString());

item.Name = dsList.Tables["Desig"].Rows[i][1].ToString();

Desig.Add(item);

}

//Department

List Dept = new List();

for (int i = 0; i < dsList.Tables["Dept"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Dept"].Rows[i][0].ToString());

item.Name = dsList.Tables["Dept"].Rows[i][1].ToString();

Dept.Add(item);

}

//Department

List Line = new List();

for (int i = 0; i < dsList.Tables["Line"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Line"].Rows[i][0].ToString());

item.Name = dsList.Tables["Line"].Rows[i][1].ToString();

Line.Add(item);

}

//Department

List Floor = new List();

for (int i = 0; i < dsList.Tables["Floor"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Floor"].Rows[i][0].ToString());

item.Name = dsList.Tables["Floor"].Rows[i][1].ToString();

Floor.Add(item);

}

//Department

List Type = new List();

for (int i = 0; i < dsList.Tables["Type"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Type"].Rows[i][0].ToString());

item.Name = dsList.Tables["Type"].Rows[i][1].ToString();

Type.Add(item);

}

//Department

List Religion = new List();

for (int i = 0; i < dsList.Tables["Religion"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Religion"].Rows[i][0].ToString());

item.Name = dsList.Tables["Religion"].Rows[i][1].ToString();

Religion.Add(item);

}

//Department

List Grade = new List();

for (int i = 0; i < dsList.Tables["Grade"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Grade"].Rows[i][0].ToString());

item.Name = dsList.Tables["Grade"].Rows[i][1].ToString();

Grade.Add(item);

}

//Department

List Sex = new List();

for (int i = 0; i < dsList.Tables["Sex"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Sex"].Rows[i][0].ToString());

item.Name = dsList.Tables["Sex"].Rows[i][1].ToString();

Sex.Add(item);

}

//Department

List Shift = new List();

for (int i = 0; i < dsList.Tables["Shift"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Shift"].Rows[i][0].ToString());

item.Name = dsList.Tables["Shift"].Rows[i][1].ToString();

Shift.Add(item);

}

//Department

List Week = new List();

for (int i = 0; i < dsList.Tables["Week"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Week"].Rows[i][0].ToString());

item.Name = dsList.Tables["Week"].Rows[i][1].ToString();

Week.Add(item);

}

//Department

List Blood = new List();

for (int i = 0; i < dsList.Tables["Blood"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Blood"].Rows[i][0].ToString());

item.Name = dsList.Tables["Blood"].Rows[i][1].ToString();

Blood.Add(item);

}

//Department

List Paymode = new List();

for (int i = 0; i < dsList.Tables["Paymode"].Rows.Count; i++)

{

clsCommon.clsCombo2 item = new clsCommon.clsCombo2();

item.Id = Int32.Parse(dsList.Tables["Paymode"].Rows[i][0].ToString());

item.Name = dsList.Tables["Paymode"].Rows[i][1].ToString();

Paymode.Add(item);

}

ViewBag.Desig = Desig;

ViewBag.Dept = Dept;

ViewBag.Line = Line;

ViewBag.Floor = Floor;

ViewBag.Type = Type;

ViewBag.Religion = Religion;

ViewBag.Grade = Grade;

ViewBag.Sex = Sex;

ViewBag.Shift = Shift;

ViewBag.Week = Week;

ViewBag.Blood = Blood;

ViewBag.Paymode = Paymode;

}

catch (Exception ex)

{

throw (ex);

}

finally

{

clsCon = null;

}

}

public String prcSaveData(Employee model)

{

ArrayList arQuery = new ArrayList();

clsProcedure clsProc = new clsProcedure();

clsConnection clsCon = new clsConnection();

try

{

var sqlQuery = "Select Isnull(MAX(empID),0) + 1 As newId From tblEmp_info";

Int64 NewId = clsCon.FTSCountingDataLarge(sqlQuery);

int isInactive = 0;

if (model.isInactive == true)

{

isInactive = 1;

}

int isAllowOT = 0;

if (model.IsAllowOT == true)

{

isAllowOT = 1;

}

int isAllowPF = 0;

if (model.IsAllowPF == true)

{

isAllowPF = 1;

}

int IsAllowAttBns = 0;

if (model.isAttBonus == true)

{

IsAllowAttBns = 1;

}

int isConfirm = 0;

if (model.isConfirm == true)

{

isConfirm = 1;

}

int IsTranUse = 0;

if (model.isTransportUse == true)

{

IsTranUse = 1;

}

sqlQuery = "Insert into tblEmp_info(ComId,empID,aEmpID, empCode, empName, Cardno, desigId,SectIdSal,BloodGroupID,PaymodeID,WeekDayID, deptId,Sectid,LineID,dtJoin,dtbirth,FloorID,EmpTypeID,ReligionID,GradeID,GenderID,ShiftID, GS, isInactive,isAllowOT,isAllowPF,IsAllowAttBns,isConfirm,IsTranUse,PCName, LUserId) Values('" + Session["ComId"] + "','" +

NewId + "','" + NewId + "','" + clsProc.FTSSingleQuoteAvoid(model.empCode) + "','" + clsProc.FTSSingleQuoteAvoid(model.empName) + "','" +

clsProc.FTSSingleQuoteAvoid(model.CardNo) + "','" + clsProc.FTSSingleQuoteAvoid(model.desigId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.deptId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.BloodId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.PayId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.WeekId.ToString()) + "','" +

clsProc.FTSSingleQuoteAvoid(model.deptId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.deptId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.LineId.ToString()) + "','" + Convert.ToDateTime(clsProc.FTSSingleQuoteAvoid(model.dtJoin.ToString())) + "','" + Convert.ToDateTime(clsProc.FTSSingleQuoteAvoid(model.dtBirth.ToString())) + "','" +

clsProc.FTSSingleQuoteAvoid(model.FloorId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.TypeId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.ReligionId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.GradeId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.SexId.ToString()) + "','" + clsProc.FTSSingleQuoteAvoid(model.ShiftId.ToString()) + "', '" + clsProc.FTSSingleQuoteAvoid(model.GS.ToString()) + "','"+isInactive+ "','" + isAllowOT + "','" + isAllowPF + "','" + IsAllowAttBns + "','" + isConfirm + "','" + IsTranUse + "',' " + clsProc.FTSGetComputerNameWeb(Request.UserHostAddress) + " ','" + Session["UserId"] + "')"; //" + clsProc.FTSGetComputerNameWeb(Request.UserHostAddress) + "

arQuery.Add(sqlQuery);

clsCon.FTSSaveDataWithSQLCommand(arQuery);

return "Data save sucessfully";

}

catch (Exception ex)

{

return ex.Message.ToString();

}

finally

{

clsCon = null;

}

}

public String prcUpdateData(Employee model)

{

ArrayList arQuery = new ArrayList();

clsProcedure clsProc = new clsProcedure();

clsConnection clsCon = new clsConnection();

try

{

int isInactive = 0;

if (model.isInactive == true)

{

isInactive = 1;

}

int isAllowOT = 0;

if (model.IsAllowOT == true)

{

isAllowOT = 1;

}

int isAllowPF = 0;

if (model.IsAllowPF == true)

{

isAllowPF = 1;

}

int IsAllowAttBns = 0;

if (model.isAttBonus == true)

{

IsAllowAttBns = 1;

}

int isConfirm = 0;

if (model.isConfirm == true)

{

isConfirm = 1;

}

int IsTranUse = 0;

if (model.isTransportUse == true)

{

IsTranUse = 1;

}

var sqlQuery = "Update tblEmp_info Set empCode = '" + clsProc.FTSSingleQuoteAvoid(model.empCode) + "', empName = '" +

clsProc.FTSSingleQuoteAvoid(model.empName) + "', Cardno = '" + clsProc.FTSSingleQuoteAvoid(model.CardNo) + "', SectIdSal = '" + clsProc.FTSSingleQuoteAvoid(model.deptId.ToString()) + "', BloodGroupID = '" + clsProc.FTSSingleQuoteAvoid(model.BloodId.ToString()) + "', PaymodeID = '" + clsProc.FTSSingleQuoteAvoid(model.PayId.ToString()) + "', WeekDayID = '" + clsProc.FTSSingleQuoteAvoid(model.WeekId.ToString()) + "', Sectid = '" + clsProc.FTSSingleQuoteAvoid(model.deptId.ToString()) + "', desigId = '" +

clsProc.FTSSingleQuoteAvoid(model.desigId.ToString()) + "', LineID = '" + clsProc.FTSSingleQuoteAvoid(model.LineId.ToString()) + "', FloorID = '" + clsProc.FTSSingleQuoteAvoid(model.FloorId.ToString()) + "', EmpTypeID = '" + clsProc.FTSSingleQuoteAvoid(model.TypeId.ToString()) + "', ReligionID = '" + clsProc.FTSSingleQuoteAvoid(model.ReligionId.ToString()) + "', GradeID = '" + clsProc.FTSSingleQuoteAvoid(model.GradeId.ToString()) + "', GenderID = '" + clsProc.FTSSingleQuoteAvoid(model.SexId.ToString()) + "', ShiftID = '" + clsProc.FTSSingleQuoteAvoid(model.ShiftId.ToString()) + "', deptId = '" +

clsProc.FTSSingleQuoteAvoid(model.deptId.ToString()) + "', GS = '" + clsProc.FTSSingleQuoteAvoid(model.GS) + "',dtJoin = '" + Convert.ToDateTime(clsProc.FTSSingleQuoteAvoid(model.dtJoin.ToString())) + "',dtbirth = '" + Convert.ToDateTime(clsProc.FTSSingleQuoteAvoid(model.dtBirth.ToString())) + "', isInactive = '"+isInactive+ "', isAllowOT = '" + isAllowOT + "', isAllowPF = '" + isAllowPF + "', IsAllowAttBns = '" + IsAllowAttBns + "', isConfirm = '" + isConfirm + "', IsTranUse = '" + IsTranUse + "' Where empID = '" + clsProc.FTSSingleQuoteAvoid(model.empID.ToString()) + "' ";

arQuery.Add(sqlQuery);

clsCon.FTSSaveDataWithSQLCommand(arQuery);

return "Data updated sucessfully";

}

catch (Exception ex)

{

return ex.Message.ToString();

}

finally

{

clsCon = null;

}

}

public String prcDeleteData(Employee model)

{

clsConnection clsCon = new clsConnection();

clsProcedure clsProc = new clsProcedure();

try

{

var sqlQuery = "Delete From tblEmp_info Where empID = '" + clsProc.FTSSingleQuoteAvoid(model.empID.ToString()) + "' ";

clsCon.FTSSaveDataWithSQLCommand(sqlQuery);

return "Sucessfully Deleted.";

}

catch (Exception ex)

{

throw (ex);

}

finally

{

clsProc = null;

clsCon = null;

}

}

#endregion procedures

}

}

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Data;

using System.Linq;

using System.Web;

namespace FTSWeb.Models.HouseKeeping

{

public class Employee

{

//empID, empCode, empName, CardNo, A.desigId, DesigName, A.deptId,deptName,GS, LineId,FloorId,TypeId,ReligionId

//,GradeId,SexId,ShiftId,WeekId,BloodId,PayId,IsAllowOT, isInactive,IsAllowPF,isAttBonus,isConfirm,isTransportUse

[Key]

[Display(Name = "Id")]

public int empID { get; set; }

[Display(Name = "Employee Code :")]

[Required(ErrorMessage = "Please, provide employee code")]

public string empCode { get; set; }

[Display(Name = "Name :")]

[Required(ErrorMessage = "Please, provide employee name")]

public string empName { get; set; }

[Display(Name = "Card No :")]

[DisplayFormat(ConvertEmptyStringToNull = false)]

public string CardNo { get; set; }

[Display(Name = "Designation :")]

[Required(ErrorMessage = "Please, provide designation.")]

public Int32 desigId { get; set; }

[Display(Name = "Department :")]

[Required(ErrorMessage = "Please, provide department.")]

public Int32 deptId { get; set; }

[Display(Name = "GS :")]

[DisplayFormat(ConvertEmptyStringToNull = false)]

public string GS { get; set; }

[Display(Name = "Line :")]

[Required(ErrorMessage = "Please, provide Line.")]

public Int32 LineId { get; set; }

//public string LineName { get; set; }

[Display(Name = "Floor :")]

[Required(ErrorMessage = "Please, provide Floor.")]

public Int32 FloorId { get; set; }

//public string FloorName { get; set; }

[Display(Name = "Type :")]

[Required(ErrorMessage = "Please, provide Type.")]

public Int32 TypeId { get; set; }

[Display(Name = "Religion :")]

[Required(ErrorMessage = "Please, provide Religion.")]

public Int32 ReligionId { get; set; }

[Display(Name = "Grade :")]

[Required(ErrorMessage = "Please, provide Grade.")]

public Int32 GradeId { get; set; }

[Display(Name = "Sex :")]

[Required(ErrorMessage = "Please, provide Male-Female - Type.")]

public Int32 SexId { get; set; }

[Display(Name = "Shift :")]

[Required(ErrorMessage = "Please, provide Shift-Type.")]

public Int32 ShiftId { get; set; }

[Display(Name = "Weekly OFF day :")]

[Required(ErrorMessage = "Please, provide Weekly Day.")]

public Int32 WeekId { get; set; }

[Display(Name = "Blood Group :")]

[Required(ErrorMessage = "Please, provide Blood Group.")]

public Int32 BloodId { get; set; }

[Display(Name = "Paymode :")]

[Required(ErrorMessage = "Please, provide Paymode.")]

public Int32 PayId { get; set; }

[Required(ErrorMessage = "Please, provide Joining Date.")]

[Display(Name = "Join Date :")]

[DataType(DataType.Date)]

public string dtJoin { get; set; }

[Required(ErrorMessage = "Please, provide Birth Date.")]

[Display(Name = "Birth Date :")]

[DataType(DataType.Date)]

public string dtBirth { get; set; }

//[Display(Name = "Email :")]

//[DisplayFormat(ConvertEmptyStringToNull = false)]

//public string email { get; set; }

[Display(Name = "Is-Inactive : ")]

public Boolean isInactive { get; set; }

[Display(Name = "Is-Allow-OT : ")]

public Boolean IsAllowOT { get; set; }

[Display(Name = "Is-Allow-PF : ")]

public Boolean IsAllowPF { get; set; }

[Display(Name = "Is-Att-Bonus : ")]

public Boolean isAttBonus { get; set; }

[Display(Name = "Is-Confirm : ")]

public Boolean isConfirm { get; set; }

[Display(Name = "Is-Transport-Use : ")]

public Boolean isTransportUse { get; set; }

private void prcSetData(IDataRecord reader)

{

empID = Int32.Parse(reader["empID"].ToString());

empCode = reader["empCode"].ToString();

empName = reader["empName"].ToString();

CardNo = reader["CardNo"].ToString();

desigId = Int32.Parse(reader["desigId"].ToString());

deptId = Int32.Parse(reader["deptId"].ToString());

GS = reader["GS"].ToString();

dtJoin = reader["dtJoin"].ToString();

LineId = Int32.Parse(reader["LineId"].ToString());

FloorId = Int32.Parse(reader["FloorId"].ToString());

ReligionId = Int32.Parse(reader["ReligionId"].ToString());

GradeId = Int32.Parse(reader["GradeId"].ToString());

SexId = Int32.Parse(reader["SexId"].ToString());

ShiftId = Int32.Parse(reader["ShiftId"].ToString());

WeekId = Int32.Parse(reader["WeekId"].ToString());

BloodId = Int32.Parse(reader["BloodId"].ToString());

PayId = Int32.Parse(reader["PayId"].ToString());

dtBirth = reader["dtBirth"].ToString();

//email = reader["email"].ToString();

isInactive = (Int32.Parse(reader["isInactive"].ToString()) == 0) ? false : true;

IsAllowOT = (Int32.Parse(reader["IsAllowOT"].ToString()) == 0) ? false : true;

IsAllowPF = (Int32.Parse(reader["IsAllowPF"].ToString()) == 0) ? false : true;

isAttBonus = (Int32.Parse(reader["isAttBonus"].ToString()) == 0) ? false : true;

isConfirm = (Int32.Parse(reader["isConfirm"].ToString()) == 0) ? false : true;

isTransportUse = (Int32.Parse(reader["isTransportUse"].ToString()) == 0) ? false : true;

}

public static List prcGetData()

{

IDataReader reader = null;

List list = new List();

clsConnection clsCon = new clsConnection();

try

{

const string sqlQuery = "Exec prcGetEmployee_WebBased '', 0";

reader = clsCon.GetReader(sqlQuery);

while (reader.Read())

{

Employee item = new Employee();

item.prcSetData(reader);

list.Add(item);

}

return list;

}

catch (Exception ex)

{

throw (ex);

}

finally

{

clsCon = null;

}

}

public static Employee prcGetData(Int32 Id)

{

IDataReader reader = null;

Employee resPerson = new Employee();

clsConnection clsCon = new clsConnection();

try

{

string sqlQuery = "Exec prcGetEmployee_WebBased '', " + Id + "";

reader = clsCon.GetReader(sqlQuery);

while (reader.Read())

{

resPerson.prcSetData(reader);

break;

}

return resPerson;

}

catch (Exception ex)

{

throw (ex);

}

finally

{

clsCon = null;

}

}

public static DataSet prcGetData(string flag,string i)

{

DataSet dsList = new DataSet();

clsConnection clsCon = new clsConnection();

try

{

string sqlQuery = "Exec prcGetEmployee_WebBased '', '" + i + "'";

clsCon.FTSFillDatasetWithSQLCommand(ref dsList, sqlQuery);

return dsList;

}

catch (Exception ex)

{

throw (ex);

}

finally

{

clsCon = null;

}

}

}

}

@model FTSWeb.Models.HouseKeeping.Employee

@{

ViewBag.Title = "Create";

}

@using (Html.BeginForm())

{

@**@

@Html.AntiForgeryToken()

@Html.ValidationSummary(true)