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