public static void AddData(Employees emp)
{
EmployeeDataContainer e = new EmployeeDataContainer();
e.Employee.Add(emp);
e.SaveChanges();
}
public static void PreloadData()
{
//initialises the dbcontext object
EmployeeDataContainer e = new EmployeeDataContainer();
if (e.Employee.Count().Equals(0))
{
//adds records to the db context
e.Employee.Add(new Employees {
Id = 0, Name = "robert", Gender = "male", Birthday = new DateTime(1978, 6, 15)
});
e.Employee.Add(new Employees {
Id = 0, Name = "denise", Gender = "female", Birthday = new DateTime(1975, 1, 23)
});
e.Employee.Add(new Employees {
Id = 0, Name = "robert", Gender = "male", Birthday = new DateTime(1988, 3, 21)
});
e.Employee.Add(new Employees {
Id = 0, Name = "sally", Gender = "female", Birthday = new DateTime(1979, 2, 5)
});
//saves changes to the data base
e.SaveChanges();
}
}
public void SaveEmployee(Employees employee)
{
//Saves the employee object to the database
EmployeeDataContainer em = new EmployeeDataContainer();
em.Employee.Add(employee);
em.SaveChanges();
}
public static Employees FindEmployee(int id)
{
//find the record
EmployeeDataContainer e = new EmployeeDataContainer();
Employees foundperson = e.Employee.FirstOrDefault(x => x.Id == id);
//returns the found record
return(foundperson);
}
public void UpdateEmployee(Employees employee)
{
//finds the record from the db context class
EmployeeDataContainer em = new EmployeeDataContainer();
//assigns an "Employee object to the variable
//and applies the ext method find by "employee id"
//extracting a single record.
Employees person = em.Employee.Find(employee.Id);
//Use the repository version!
//Employees person = EmployeesRepository.FindEmployee(employee.Id);
//assigns the new variable to the properties passed in
//person.Id = employee.Id;
person.Name = employee.Name;
person.Gender = employee.Gender;
person.Birthday = employee.Birthday;
//Saves the changees back to the database
em.SaveChanges();
}
public static List <Employees> GetEmployees()
{
EmployeeDataContainer emp = new EmployeeDataContainer();
return(emp.Employee.ToList());
}
