public static void AddEmployee(Employee employee)
{
using (var ctx = new SampleDBContext())
{
//ctx.Employee.Add(employee);
//ctx.SaveChanges();
}
}
public static void AddDepartment(Department department)
{
using (var context = new SampleDBContext())
{
//context.Department.Add(department);
//context.SaveChanges();
}
}
public static List <Employee> Get()
{
using (var ctx = new SampleDBContext())
{
//var e = from ent in ctx.Employee select ent;
//return e.ToList();
return(new List <Employee> {
new Employee {
Id = 8, EmployeeName = "TOM", Department = "HRD", IsActive = true
}
});
}
}
public static Employee EmployeeExist(Employee employee)
{
using (var ctx = new SampleDBContext())
{
//var id = from e
// in ctx.Employee
// where
// e.EmployeeName == employee.EmployeeName
// && e.Department == employee.Department
// select e;
//return id.FirstOrDefault();
return(new Employee {
Id = 8, EmployeeName = "TOM", Department = "HRD", IsActive = true
});
}
}
public static Department DepartmentExist(Department department)
{
using (var ctx = new SampleDBContext())
{
//var id = from d
// in ctx.Department
// where
// d.Name == department.Name
// select d;
//return id.FirstOrDefault();
return(new Department {
Id = 1, Name = "HRD", IsActive = true
});
}
}