public List <EmployeeInfo> GetEmployees()
{
List <EmployeeInfo> employees = new List <EmployeeInfo>();
//return new List<EmployeeInfo> { new EmployeeInfo { Id=1, Department="FR", Designation="Lead Developer", Name="Ravi K", PhotoPath=@"straoge\container\blob" } };
using (DataTableReader dtr = _employeeDAO.GetEmployees().CreateDataReader())
{
while (dtr.Read())
{
employees.Add(new EmployeeInfo
{
Id = Convert.ToInt64(dtr["Id"]),
Name = Convert.ToString(dtr["Name"]),
Department = Convert.ToString(dtr["Department"]),
Designation = Convert.ToString(dtr["Designation"]),
JoinDate = Convert.ToDateTime(dtr["JoinDate"]),
LastUpdated = Convert.ToDateTime(dtr["LastUpdated"]),
PhotoPath = Convert.ToString(dtr["PhotoPath"])
});
}
}
return(employees);
}