public List <SelectListItem> GetAllEmployeeNames() { List <SelectListItem> EmployeeNameList = new List <SelectListItem>(); try { string empid = Session["UserID"].ToString(); //string empName = String.Format("{0} {1}", Session["FirstName"].ToString(), Session["LastName"].ToString()); MTSHRDataLayer.EmployeeLeave EmployeeNamedata = new MTSHRDataLayer.EmployeeLeave(); var EmployeeNames = EmployeeNamedata.GetAllEmployeeNames(); EmployeeNameList.Add(new SelectListItem() { Value = "", Text = "----Select Employee----" }); for (int i = 0; i < EmployeeNames.Tables[0].Rows.Count; i++) { string ID = EmployeeNames.Tables[0].Rows[i]["id"].ToString(); EmployeeNameList.Add(new SelectListItem() { Text = EmployeeNames.Tables[0].Rows[i]["EmployeeName"].ToString(), Value = ID }); } //EmployeeNameList.RemoveAt(EmployeeNameList.IndexOf(new SelectListItem() { Value = empid, Text = empName })); } catch (Exception exec) { BaseExceptionHandler.HandleException(ref exec); } return(EmployeeNameList); }
public List <SelectListItem> GetAllEmployeeNames() { MTSHRDataLayer.EmployeeLeave EmployeeNamedata = new MTSHRDataLayer.EmployeeLeave(); var EmployeeNames = EmployeeNamedata.GetAllEmployeeNames(); List <SelectListItem> EmployeeNameList = new List <SelectListItem>(); //EmployeeNameList.Insert(0, new SelectListItem() { Value = "0", Text = "----Select Employee NameA----" }); for (int i = 0; i < EmployeeNames.Tables[0].Rows.Count; i++) { EmployeeNameList.Add(new SelectListItem() { Text = EmployeeNames.Tables[0].Rows[i]["EmployeeName"].ToString(), Value = EmployeeNames.Tables[0].Rows[i]["id"].ToString() }); } return(EmployeeNameList.OrderBy(o => o.Text).ToList()); // EmployeeNameList.Insert(0, new SelectListItem() { Value = "0", Text = "----Select ALL----" }); // return EmployeeNameList; }