public IEnumerable <EmployeeModel> getAllEmployee()
{
List <EmployeeModel> empList = new List <EmployeeModel>();
SqlDataReader sdr = DBTask.ExecuteReader(Startup.ConnectionStringTS, "spGetEmployee", "GetAll", "", "", "", "", "");
if (sdr.HasRows)
{
while (sdr.Read())
{
var emp = new EmployeeModel
{
empID = Convert.ToString(sdr["empID"]),
empName = Convert.ToString(sdr["empName"]),
empSalary = Convert.ToString(sdr["empSalary"]),
DeptName = Convert.ToString(sdr["DeptName"]),
DesigName = Convert.ToString(sdr["DesigName"])
};
empList.Add(emp);
}
}
return(empList);
}
