public ActionResult DeleteConfirmed(int id, audit_trail audit) { var check = db.employees.Where(s => s.Employee_Type_ID == id).FirstOrDefault(); if (check == null) { employee_type employee_type = db.employee_type.Find(id); var userId = System.Web.HttpContext.Current.Session["UserID"] as String; int IntID = Convert.ToInt32(userId); audit.Employee_ID = IntID; audit.Trail_DateTime = DateTime.Now.Date; audit.Deleted_Record = employee_type.Employee_Type_ID.ToString() + " " + employee_type.Type_Name + " " + employee_type.Type_Description; audit.Trail_Description = "Deleted a Employee Type"; db.audit_trail.Add(audit); db.employee_type.Remove(employee_type); db.SaveChanges(); return(RedirectToAction("Index")); } else { employee_type employee_type = db.employee_type.Find(id); ViewBag.Error = "Can't delete a type that is in-use please add a new type instead, or delete all employees related to this type first."; return(View(employee_type)); } }
public ActionResult DeleteConfirmed(int id) { employee_type employee_type = db.employee_type.Find(id); db.employee_type.Remove(employee_type); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Employee_Type_ID,Type_Name,Type_Description")] employee_type employee_type) { if (ModelState.IsValid) { db.Entry(employee_type).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee_type)); }
public ActionResult Create([Bind(Include = "Employee_Type_ID,Type_Name,Type_Description")] employee_type employee_type) { if (ModelState.IsValid) { db.employee_type.Add(employee_type); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee_type)); }
// GET: employee_type/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } employee_type employee_type = db.employee_type.Find(id); if (employee_type == null) { return(HttpNotFound()); } return(View(employee_type)); }
public ActionResult Edit([Bind(Include = "Employee_Type_ID,Type_Name,Type_Description")] employee_type employee_type) { bool val = db.employee_type.Any(s => s.Type_Name == employee_type.Type_Name && s.Employee_Type_ID != employee_type.Employee_Type_ID); if (ModelState.IsValid && val == false) { db.Entry(employee_type).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else if (val == true) { ViewBag.StatusMessage = "There is already an: " + employee_type.Type_Name + " type in the database."; return(View()); } return(View(employee_type)); }
public ActionResult Create([Bind(Include = "Employee_Type_ID,Type_Name,Type_Description")] employee_type employee_type) { bool val = Validate(employee_type.Type_Name); if (ModelState.IsValid && val == false) { db.employee_type.Add(employee_type); db.SaveChanges(); return(RedirectToAction("Index")); } else if (val == true) { ViewBag.StatusMessage = "There is already an: " + employee_type.Type_Name + " type in the database."; return(View()); } return(View(employee_type)); }
public void AddEmployeeType() { employee_type empType = new employee_type(); AddEmployeeType addWindow = new AddEmployeeType(); addWindow.DataContext = new { employeeType = empType }; addWindow.ShowDialog(); try { dataHandler.AddOrUpdate(empType); } catch (Exception e) { System.Windows.MessageBox.Show("Error: " + e.Message); } NotifyOfPropertyChange("EmployeeTypes"); }
public void Modify(employee_type empType) { AddEmployeeType addWindow = new AddEmployeeType(); addWindow.DataContext = new { employeeType = empType }; if (addWindow.ShowDialog() == true) { try { dataHandler.AddOrUpdate(empType); } catch (Exception e) { System.Windows.MessageBox.Show("Error: " + e.Message); } } else { ((System.Data.Entity.Infrastructure.IObjectContextAdapter)dataHandler.GetEntities()).ObjectContext.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, empType); } NotifyOfPropertyChange("EmployeeTypes"); }
public void Delete(employee_type obj) { dataHandler.RemoveData(obj); NotifyOfPropertyChange("EmployeeTypes"); }