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);
}
