public ActionResult Delete(Card card) { //deleting both the card and the employee to elimate all personal information from the db context.DeleteCard(card.ID); context.DeleteEmployee(card.EmployeeID); return RedirectToAction("Index"); }
public void SaveCard(Card card) { if (card.ID == 0) { context.Cards.Add(card); context.SaveChanges(); } else { Card dbEntry = context.Cards.Find(card.ID); if (dbEntry != null) { dbEntry.CardName = card.CardName; dbEntry.EmployeeID = card.EmployeeID; context.SaveChanges(); } } }
public ActionResult CreateEmployee(CreateEmployeeVM vm) { if (ModelState.IsValid) { var model = new Employee { FirstName = vm.FirstName, LastName = vm.LastName, PhoneNumber = vm.PhoneNumber, Email = vm.Email, JobTitle = vm.JobTitle, CompanyID = vm.CompanyID }; context.SaveEmployee(model); //DRJ - now let's build the card //DRJ - finding the newly created employee's id int employeeID = context.Employees .Where(e => e.LastName == model.LastName && e.CompanyID == model.CompanyID) .Select(e => e.ID) .FirstOrDefault(); var card = new Card { CardName = vm.FirstName + " " + vm.LastName + "'s Business Card", EmployeeID = employeeID }; //DRJ - creating the card context.SaveCard(card); int cardID = context.Cards .Where(c => c.CardName == card.CardName && c.EmployeeID == card.EmployeeID) .Select(c => c.ID) .FirstOrDefault(); //DRJ - sending the user to view their business card return RedirectToAction("Index", "Card", new { id = cardID }); } //need to repopulate list if there are model binding issues vm.CompanyList = context.Companies .OrderBy(c => c.CompanyName) .Select(c => new SelectListItem { Text = c.CompanyName, Value = c.ID.ToString() }); return View(vm); }
public ActionResult Edit(CardAdminVM vm) { if (ModelState.IsValid) { var Card = new Card { CardName = vm.FirstName + " " + vm.LastName + "'s Business Card", EmployeeID = vm.EmployeeID }; var Employee = new Employee { ID = vm.EmployeeID, FirstName = vm.FirstName, LastName = vm.LastName, JobTitle = vm.JobTitle, PhoneNumber = vm.PhoneNumber, Email = vm.Email, CompanyID = vm.CompanyID }; context.SaveEmployee(Employee); //context.SaveCard(Card); return RedirectToAction("Index"); } //DRJ - getting the company list vm.CompanyList = context.Companies .OrderBy(c => c.CompanyName) .Select(c => new SelectListItem { Text = c.CompanyName, Value = c.ID.ToString() }); //DRJ - getting the state list vm.StateList = context.States.OrderBy(s => s.Abbreviation) .Select(s => new SelectListItem { Text = s.Name, Value = s.Abbreviation }); return View(vm); }