public ActionResult Save(Employee emp)
{
bool status = false;
if (ModelState.IsValid)
{
using (MydataEntities dc = new MydataEntities())
{
if (emp.EmployeeID > 0)
{
//Edit
var v = dc.Employees.Where(a => a.EmployeeID == emp.EmployeeID).FirstOrDefault();
if (v != null)
{
v.FirstName = emp.FirstName;
v.LastName = emp.LastName;
v.EmailID = emp.EmailID;
v.City = emp.City;
v.Country = emp.Country;
}
}
else
{
//Save
dc.Employees.Add(emp);
}
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Save(int id)
{
using (MydataEntities dc = new MydataEntities())
{
var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault();
return(View(v));
}
}
public ActionResult GetEmployees()
{
using (MydataEntities dc = new MydataEntities())
{
var employees = dc.Employees.OrderBy(a => a.FirstName).ToList();
return(Json(new { data = employees }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (MydataEntities dc = new MydataEntities())
{
var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault();
if (v != null)
{
return(View(v));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult DeleteEmployee(int id)
{
bool status = false;
using (MydataEntities dc = new MydataEntities())
{
var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault();
if (v != null)
{
dc.Employees.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
