// GET: EscalationUsers/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EscalationUser escalationUser = db.EscalationUsers.Find(id); List <Category> category = db.Categories.Where(c => c.EscalationUserId == id).ToList(); List <int> categoryids = new List <int>(); foreach (Category i in category) { categoryids.Add(i.Id); } escalationUser.CategoriesIds = categoryids; if (escalationUser == null) { return(HttpNotFound()); } ViewBag.CostCenterList = db.CostCenters.OrderBy(m => m.CostCenterCode).ToList(); ViewBag.DepartmentList = db.Departments.Where(m => m.type == Constants.FORWARD).ToList(); ViewBag.UserList = db.Users.ToList(); ViewBag.Categories = db.Categories.Where(m => m.DepartmentId == escalationUser.DepartmentId && m.FeedBackType.name == Constants.Complaints).ToList(); ViewBag.Status = "Delete"; return(View("CreateList", new EscalationUserViewModel { EscalationUser = escalationUser, EscalationUsers = db.EscalationUsers.ToList() })); }
public ApplicationUser getOperationsEscalationUser(int?costCenterId) { EscalationUser escUser = db.EscalationUsers.Where(m => m.CostCenterId == costCenterId).FirstOrDefault(); ApplicationUser user = db.Users.Find(escUser.firstEscalationUserId); return(user); }
public ActionResult Edit(EscalationUser escalationUser) { if (!db.Departments.Find(escalationUser.DepartmentId).name.Equals(Constants.OPERATIONS)) { if (escalationUser.CategoriesIds == null) { ModelState.AddModelError("add_categories", "Please Add Categories for The Departments other than Operations"); } } if (ModelState.IsValid) { List <Category> categories = db.Categories.Where(c => c.EscalationUserId == escalationUser.Id).ToList(); if (!db.Departments.Find(escalationUser.DepartmentId).name.Equals(Constants.OPERATIONS)) { foreach (Category i in categories) { i.EscalationUserId = null; db.Entry(i).State = EntityState.Modified; db.SaveChanges(); } db.Entry(escalationUser).State = EntityState.Modified; db.SaveChanges(); foreach (int cid in escalationUser.CategoriesIds) { Category c = db.Categories.Find(cid); c.EscalationUserId = escalationUser.Id; db.Entry(c).State = EntityState.Modified; db.SaveChanges(); } TempData["SuccessMsg"] = "Escalation User has been Updated"; return(RedirectToAction("Create")); } else { if (userInterface.getEscalationUserCostCentr(escalationUser) <= 0) { db.Entry(escalationUser).State = EntityState.Modified; db.SaveChanges(); TempData["SuccessMsg"] = "Escalation User has been Updated"; return(RedirectToAction("Create")); } else { TempData["FailMsg"] = "Cost Center is already assigned to Escalation User"; } } } ViewBag.CostCenterList = db.CostCenters.OrderBy(m => m.CostCenterCode).ToList(); ViewBag.DepartmentList = db.Departments.Where(m => m.type == Constants.FORWARD).ToList(); ViewBag.UserList = db.Users.ToList(); //ViewBag.Categories = db.Categories.Where(c => c.EscalationUserId == null).ToList(); ViewBag.Status = "Update"; // return RedirectToAction("CreateList", new EscalationUserViewModel { EscalationUsers = db.EscalationUsers.ToList() }); return(RedirectToAction("Edit", new { id = escalationUser.Id })); }
public ApplicationUser getEscalationUser(int?departmentId, int?categoryId) { var query = from e in db.EscalationUsers join Category in db.Categories on e.Id equals Category.EscalationUserId where e.DepartmentId == departmentId && Category.Id == categoryId select e; EscalationUser user = (EscalationUser)query.FirstOrDefault(); return(db.Users.Find(user.firstEscalationUserId)); }
public int getEscalationUserCostCentr(EscalationUser escalationUser) { if (escalationUser.Id > 0) { return(db.EscalationUsers.OrderByDescending(m => m.Id).Where(m => m.CostCenterId == escalationUser.CostCenterId && m.Id != escalationUser.Id).ToList().Count()); } else { return(db.EscalationUsers.OrderByDescending(m => m.Id).Where(m => m.CostCenterId == escalationUser.CostCenterId).ToList().Count()); } }
public ActionResult Create(EscalationUser escalationUser) { if (!db.Departments.Find(escalationUser.DepartmentId).name.Equals(Constants.OPERATIONS)) { if (escalationUser.CategoriesIds == null) { ModelState.AddModelError("add_categories", "Please Add Categories for The Departments other than Operations"); } } Debug.WriteLine(ModelState.IsValid + "0-----------------------"); if (ModelState.IsValid) { if (!db.Departments.Find(escalationUser.DepartmentId).name.Equals(Constants.OPERATIONS)) { db.EscalationUsers.Add(escalationUser); db.SaveChanges(); foreach (int cid in escalationUser.CategoriesIds) { Category c = db.Categories.Find(cid); c.EscalationUserId = escalationUser.Id; db.Entry(c).State = EntityState.Modified; db.SaveChanges(); TempData["SuccessMsg"] = "Escalation User Added"; return(RedirectToAction("Create")); } } else { if (userInterface.getEscalationUserCostCentr(escalationUser) <= 0) { db.EscalationUsers.Add(escalationUser); db.SaveChanges(); TempData["SuccessMsg"] = "Escalation User Added"; return(RedirectToAction("Create")); } else { TempData["FailMsg"] = "Cost Center is already assigned to Escalation User"; } } } ViewBag.CostCenterList = db.CostCenters.OrderBy(m => m.CostCenterCode).ToList(); ViewBag.DepartmentList = db.Departments.Where(m => m.type == Constants.FORWARD).ToList(); ViewBag.UserList = db.Users.ToList(); ViewBag.Categories = db.Categories.Where(m => m.DepartmentId == escalationUser.DepartmentId && m.FeedBackType.name == Constants.Complaints).ToList(); ViewBag.Status = "Add"; return(View("CreateList", new EscalationUserViewModel { EscalationUsers = db.EscalationUsers.ToList() })); }
// GET: EscalationUsers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EscalationUser escalationUser = db.EscalationUsers.Find(id); if (escalationUser == null) { return(HttpNotFound()); } return(View(escalationUser)); }
public bool getTicketsOnCategory(int id) { EscalationUser escUser = db.EscalationUsers.Find(id); var categories = db.Categories.Where(c => c.EscalationUserId == (db.EscalationUsers.FirstOrDefault(e => e.firstEscalationUserId == escUser.firstEscalationUserId)).Id).Select(c => c.Id).ToList();; int tickets = db.Feedbacks.Where(f => f.categoryId != null).Where(f => categories.Contains(f.categoryId.Value)).ToList().Count(); if (tickets > 0) { return(true); } else { return(false); } }
public void deleteEscalationUser(int id) { List <Category> categories = db.Categories.Where(c => c.EscalationUserId == id).ToList(); foreach (Category i in categories) { i.EscalationUserId = null; db.Entry(i).State = EntityState.Modified; db.SaveChanges(); } EscalationUser escalationUser = db.EscalationUsers.Find(id); db.EscalationUsers.Remove(escalationUser); db.SaveChanges(); TempData["SuccessMsg"] = "Escalation User is deleted Successfully"; }
public ActionResult DeleteConfirmed(int id) { List <Category> categories = db.Categories.Where(c => c.EscalationUserId == id).ToList(); foreach (Category i in categories) { i.EscalationUserId = null; db.Entry(i).State = EntityState.Modified; db.SaveChanges(); } EscalationUser escalationUser = db.EscalationUsers.Find(id); db.EscalationUsers.Remove(escalationUser); db.SaveChanges(); return(RedirectToAction("Create")); }
public ActionResult Edit(EscalationUser escalationUser) { if (!db.Departments.Find(escalationUser.DepartmentId).name.Equals(Constants.OPERATIONS)) { if (escalationUser.CategoriesIds == null) { ModelState.AddModelError("add_categories", "Please Add Categories for The Departments other than Operations"); } } if (ModelState.IsValid) { List <Category> categories = db.Categories.Where(c => c.EscalationUserId == escalationUser.Id).ToList(); foreach (Category i in categories) { i.EscalationUserId = null; db.Entry(i).State = EntityState.Modified; db.SaveChanges(); } db.Entry(escalationUser).State = EntityState.Modified; db.SaveChanges(); if (!db.Departments.Find(escalationUser.DepartmentId).name.Equals(Constants.OPERATIONS)) { foreach (int cid in escalationUser.CategoriesIds) { Category c = db.Categories.Find(cid); c.EscalationUserId = escalationUser.Id; db.Entry(c).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Create")); } ViewBag.CostCenterList = db.CostCenters.OrderBy(m => m.CostCenterCode).ToList(); ViewBag.DepartmentList = db.Departments.Where(m => m.type == Constants.FORWARD).ToList(); ViewBag.UserList = db.Users.ToList(); //ViewBag.Categories = db.Categories.Where(c => c.EscalationUserId == null).ToList(); ViewBag.Status = "Update"; return(View("CreateList", new EscalationUserViewModel { EscalationUsers = db.EscalationUsers.ToList() })); }