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