public clsUserReg GetEUserData(int?id) { clsUserReg obj1 = new clsUserReg(); using (SqlConnection con = new SqlConnection(connectionString)) { string sqlQuery = "SELECT * FROM tblUserReg WHERE EmpID= " + id; SqlCommand cmd = new SqlCommand(sqlQuery, con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { obj1.EmpName = Convert.ToString(rdr["EmpName"]); obj1.City = Convert.ToString(rdr["City"]); obj1.EmpAdress = Convert.ToString(rdr["EmpAddress"]); obj1.Gender = Convert.ToString(rdr["Gender"]); obj1.EmpMob = Convert.ToString(rdr["EmpMob"]); obj1.EmpID = Convert.ToString(rdr["EmpID"]); obj1.DeptID = Convert.ToString(rdr["DeptID"]); obj1.EmpID = Convert.ToString(rdr["EmpID"]); obj1.bday = Convert.ToString(rdr["bday"]); obj1.bday = Convert.ToDateTime(obj1.bday).ToString("dd/MM/yyyy"); //Get all deprment clsDepartment objclsDepartment = new clsDepartment(); List <clsDepartment> lstDept = objclsDepartment.GetDept(); List <SelectListItem> itemslst = new List <SelectListItem>(); foreach (clsDepartment obj in lstDept) { SelectListItem item = new SelectListItem(); item.Value = Convert.ToString(obj.DeptID); item.Text = obj.DeptName; // adding object to list itemslst.Add(item); } obj1.Department = itemslst; // end depart } } return(obj1); }
public List <clsDepartment> GetDept() { List <clsDepartment> lstDept = new List <clsDepartment>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("sp_GetDept", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { clsDepartment obj = new clsDepartment(); obj.DeptID = Convert.ToInt32(rdr["DeptID"]); obj.DeptName = Convert.ToString(rdr["DeptName"]); lstDept.Add(obj); } con.Close(); } return(lstDept); }