public DataSet GetEmployeeDataTable() { EmployeeDataContract edc; try { DAL dalObj = new DAL(); edc = new EmployeeDataContract(); DataSet ds = dalObj.GetAllEmployees(); return(ds); } catch (Exception e) { } return(null); }
public EmployeeDataContract GetEmployeeData(int value) { EmployeeDataContract edc; try { DAL dalObj = new DAL(); edc = new EmployeeDataContract(); DataSet ds = dalObj.GetAllEmployees(); var query = from row in ds.Tables[0].AsEnumerable() select new { Id = row.Field <int>("empno"), Name = row.Field <string>("ename"), Job = row.Field <string>("job"), Salary = decimal.Parse(row["Salary"].ToString()), ManagerNAme = row.Field <string>("ManagerName") }; edc.Employees = new List <Employee>(); foreach (var item in query) { Employee emp = new Employee(); emp.Id = item.Id; emp.Job = item.Job ?? "-"; emp.Name = item.Name ?? "-"; emp.Salary = double.Parse(item.Salary.ToString() == "" ? "0" : item.Salary.ToString()); emp.ManagerName = item.ManagerNAme ?? "-"; edc.Employees.Add(emp); } } catch (Exception e) { throw; } return(edc); }