public List <Employee> GetEmployeeList() { using (mvcCrudDb db = new mvcCrudDb()) { List <Employee> empList = db.Employees.ToList <Employee>(); return(empList); } }
public ActionResult RenderEditEmployee(string employeeId) { Employee emp = new Employee(); int employeeIdInt = Convert.ToInt32(employeeId); using (mvcCrudDb db = new mvcCrudDb()) { emp = db.Employees.First(e => e.EmployeeId == employeeIdInt); } return(PartialView("Add", emp)); }
public ActionResult DeleteEmployee(string employeeId) { Employee emp = new Employee { EmployeeId = Convert.ToInt32(employeeId) }; using (mvcCrudDb db = new mvcCrudDb()) { db.Employees.Attach(emp); db.Employees.Remove(emp); db.SaveChanges(); } return(Content("Success")); }
public ActionResult DeleteSelectedEmployee(List <string> employeeIds) { for (int i = 0; i < employeeIds.Count; i++) { Employee emp = new Employee { EmployeeId = Convert.ToInt32(employeeIds[i]) }; using (mvcCrudDb db = new mvcCrudDb()) { db.Employees.Attach(emp); db.Employees.Remove(emp); db.SaveChanges(); } } return(Content("Success")); }
public ActionResult AddOrEditEmployee(Employee emp) { using (mvcCrudDb db = new mvcCrudDb()) { if (emp.EmployeeId > 0) { db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); } else { db.Employees.Add(emp); db.SaveChanges(); } } return(Content("Success")); }