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