private DataTable GetEmployeeData() { EmployeeDBContext employeeDBContext = new EmployeeDBContext(); List<Employee> employees = employeeDBContext.Employees.ToList(); DataTable dt = new DataTable(); DataColumn[] datacolumns = {new DataColumn("EmployeeID"), new DataColumn("FirstName"), new DataColumn("LastName"),new DataColumn("Gender")}; dt.Columns.AddRange(datacolumns); foreach (Employee employee in employees) { DataRow dr = dt.NewRow(); dr["EmployeeId"] = employee.EmployeeId; dr["FirstName"] = employee.FirstName; dr["LastName"] = employee.LastName; dr["Gender"] = employee.Gender; dt.Rows.Add(dr); } return dt; }
private DataTable GetEmployeeData() { EmployeeDBContext employeeDBContext = new EmployeeDBContext(); List <Employee> employees = employeeDBContext.Employees.ToList(); DataTable dt = new DataTable(); DataColumn[] datacolumns = { new DataColumn("EmployeeID"), new DataColumn("FirstName"), new DataColumn("LastName"), new DataColumn("Gender") }; dt.Columns.AddRange(datacolumns); foreach (Employee employee in employees) { DataRow dr = dt.NewRow(); dr["EmployeeId"] = employee.EmployeeId; dr["FirstName"] = employee.FirstName; dr["LastName"] = employee.LastName; dr["Gender"] = employee.Gender; dt.Rows.Add(dr); } return(dt); }
private DataTable GetEmployeeDataIncludingContactDetails() { EmployeeDBContext employeeDBContext = new EmployeeDBContext(); List<Employee> employees = employeeDBContext.Employees.Include("EmployeeContactDetail").ToList(); DataTable dt = new DataTable(); DataColumn[] datacolumns = {new DataColumn("EmployeeID"), new DataColumn("FirstName"), new DataColumn("LastName"),new DataColumn("Gender"), new DataColumn("Email"), new DataColumn("Mobile"), new DataColumn("LandLine")}; dt.Columns.AddRange(datacolumns); foreach(Employee employee in employees) { DataRow dr = dt.NewRow(); dr["EmployeeId"] = employee.EmployeeId; dr["FirstName"] = employee.FirstName; dr["LastName"] = employee.LastName; dr["Gender"] = employee.Gender; dr["Email"] = employee.EmployeeContactDetail.Email; dr["Mobile"] = employee.EmployeeContactDetail.Mobile; dr["LandLine"] = employee.EmployeeContactDetail.LandLine; dt.Rows.Add(dr); } return dt; }
private DataTable GetEmployeeDataIncludingContactDetails() { EmployeeDBContext employeeDBContext = new EmployeeDBContext(); List <Employee> employees = employeeDBContext.Employees.Include("EmployeeContactDetail").ToList(); DataTable dt = new DataTable(); DataColumn[] datacolumns = { new DataColumn("EmployeeID"), new DataColumn("FirstName"), new DataColumn("LastName"), new DataColumn("Gender"), new DataColumn("Email"), new DataColumn("Mobile"), new DataColumn("LandLine") }; dt.Columns.AddRange(datacolumns); foreach (Employee employee in employees) { DataRow dr = dt.NewRow(); dr["EmployeeId"] = employee.EmployeeId; dr["FirstName"] = employee.FirstName; dr["LastName"] = employee.LastName; dr["Gender"] = employee.Gender; dr["Email"] = employee.EmployeeContactDetail.Email; dr["Mobile"] = employee.EmployeeContactDetail.Mobile; dr["LandLine"] = employee.EmployeeContactDetail.LandLine; dt.Rows.Add(dr); } return(dt); }