public ActionResult save(Employee emp) { bool status = false; if (ModelState.IsValid) { using (mydatabaseEntities1 dc = new mydatabaseEntities1()) { if (emp.EmployeeId > 0) { //update 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 (mydatabaseEntities1 dc = new mydatabaseEntities1()) { var v = dc.Employees.Where(a => a.EmployeeId == id).FirstOrDefault(); return(View(v)); } }
public ActionResult GetEmployees() { using (mydatabaseEntities1 dc = new mydatabaseEntities1()) { var employees = dc.Employees.OrderBy(a => a.FirstName).ToList(); return(Json(new { data = employees }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (mydatabaseEntities1 dc = new mydatabaseEntities1()) { 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 (mydatabaseEntities1 dc = new mydatabaseEntities1()) { 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 } }); }