public ActionResult FillSubCategory(string Category) { var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Rate; ViewBag.NGASCode = db.NGAS.ToList(); SearchBillingAndCollectionRates searchBillingAndCollectionRates = new SearchBillingAndCollectionRates(); if (!string.IsNullOrEmpty(Category)) { searchBillingAndCollectionRates.BillingRate = db.BillingRates.Where(m => m.Category == Category).ToList(); var bill = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).GroupBy(m => m.Category).Select(g => new { Category = g.Key }).ToList(); var subcat = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).Where(m => m.Category == Category).GroupBy(m => m.SubCategory).Select(g => new { SubCategory = g.Key }).ToList(); foreach (var item in bill) { searchBillingAndCollectionRates.Category.Add(item.Category); } foreach (var item in subcat) { searchBillingAndCollectionRates.SubCategory.Add(item.SubCategory); } } ViewBag.ZoneGroup = ZoneGroup; ViewBag.Category = Category; return(View("ViewBillingAndCollectionRates", searchBillingAndCollectionRates)); }
public ActionResult ViewBillingAndCollectionRatesRPG() { var username = User.Identity.GetUserName(); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; ViewBag.ZoneGroup = ZoneGroup; RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Rate; ViewBag.NGASCode = db.NGAS.ToList(); SearchBillingAndCollectionRates temp = TempData["searchBillingAndCollectionRates"] as SearchBillingAndCollectionRates; ViewBag.Category = TempData["Category"] as string; ViewBag.TransactionSuccess = TempData["TransactionSuccess"] as string; TempData.Keep("searchBillingAndCollectionRates"); return(View("ViewBillingAndCollectionRates", temp)); }
public ActionResult EditCategory(string EditCategory, string Category) { var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username); SearchBillingAndCollectionRates searchBillingAndCollectionRates = new SearchBillingAndCollectionRates(); ViewBag.IsValidRole = roleAssignmentMatrix.Rate; ViewBag.Groups = db.ZoneGroup.ToList(); if (!string.IsNullOrEmpty(Category)) { db.Database.ExecuteSqlCommand("Update BillingRates set Category = '" + Category + "' where Category = '" + EditCategory + "'"); searchBillingAndCollectionRates.BillingRate = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).Where(m => m.Category == Category).ToList(); ViewBag.Category = Category; TempData["TransactionSuccess"] = "Edit"; } else { ViewBag.ShowAdd = false; Response.Write("<script>alert('Unable to edit Category. Please check blank field.')</script>"); } var bill = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).GroupBy(m => m.Category).Select(g => new { Category = g.Key }).ToList(); var subcat = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).Where(m => m.Category == Category).GroupBy(m => m.SubCategory).Select(g => new { SubCategory = g.Key }).ToList(); foreach (var item in bill) { searchBillingAndCollectionRates.Category.Add(item.Category); } foreach (var item in subcat) { searchBillingAndCollectionRates.SubCategory.Add(item.SubCategory); } TempData["searchBillingAndCollectionRates"] = searchBillingAndCollectionRates; TempData["Category"] = Category; return(RedirectToAction("ViewBillingAndCollectionRatesRPG", "MaintenanceBillingAndCollectionRates")); //return View("ViewBillingAndCollectionRates", searchBillingAndCollectionRates); }
public ActionResult AddCategory(string Category) { ApplicationDbContext context = new ApplicationDbContext(); var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Rate; ViewBag.Groups = db.ZoneGroup.ToList(); //ViewBag.Groups = new SelectList(db.ZoneGroup.ToList(), "ZoneGroupCode", "ZoneGroupName"); SearchBillingAndCollectionRates searchBillingAndCollectionRates = new SearchBillingAndCollectionRates(); if (!string.IsNullOrEmpty(Category)) { if (Category.ToUpper() == "SEWERAGE") { TempData["TransactionSuccess"] = "ErrorSewerage"; } else { BillingRate billingRate = new BillingRate(); billingRate.Category = Category; billingRate.ZoneGroup = ZoneGroup; if (Category == "Rental Fee") { billingRate.SubCategory = "PHP Rental"; } else { billingRate.SubCategory = Category; } billingRate.Rate = 0; db.BillingRates.Add(billingRate); db.SaveChanges(); TempData["TransactionSuccess"] = "Add"; } searchBillingAndCollectionRates.BillingRate = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).Where(m => m.Category == Category).ToList(); ViewBag.Category = Category; } else { ViewBag.ShowAdd = false; Response.Write("<script>alert('Unable to add Category. Please check blank field.')</script>"); } var bill = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).GroupBy(m => m.Category).Select(g => new { Category = g.Key }).ToList(); var subcat = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).Where(m => m.Category == Category).GroupBy(m => m.SubCategory).Select(g => new { SubCategory = g.Key }).ToList(); foreach (var item in bill) { searchBillingAndCollectionRates.Category.Add(item.Category); } foreach (var item in subcat) { searchBillingAndCollectionRates.SubCategory.Add(item.SubCategory); } TempData["searchBillingAndCollectionRates"] = searchBillingAndCollectionRates; TempData["Category"] = Category; return(RedirectToAction("ViewBillingAndCollectionRatesRPG", "MaintenanceBillingAndCollectionRates")); //return View("ViewBillingAndCollectionRates", searchBillingAndCollectionRates); }
public ActionResult AddSubCategory(string SubCategory, string Category, string Currency, string SubCat, string TransactionType, string NGAS) { var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Rate; ViewBag.Groups = db.ZoneGroup.ToList(); SearchBillingAndCollectionRates searchBillingAndCollectionRates = new SearchBillingAndCollectionRates(); if (TransactionType.ToUpper() == "ADD") //Add sub category { if (!string.IsNullOrEmpty(SubCategory)) { List <BillingRate> billrate = db.BillingRates.Where(m => m.Category.ToUpper() == Category.ToUpper() && m.SubCategory.ToUpper() == SubCategory.ToUpper() && m.ZoneGroup == ZoneGroup).ToList(); if (Category.ToUpper() == "SEWERAGE") { TempData["TransactionSuccess"] = "ErrorSewerage"; } else { BillingRate billingRate = new BillingRate(); billingRate.Category = Category; billingRate.ZoneGroup = ZoneGroup; billingRate.NGASCode = NGAS; if (Category != "Rental Fee") //If billing rate. add prefix currency. { billingRate.SubCategory = SubCategory; } else { billingRate.SubCategory = Currency + " " + SubCategory; } billingRate.Rate = 0; db.BillingRates.Add(billingRate); db.SaveChanges(); TempData["TransactionSuccess"] = "Add"; } } searchBillingAndCollectionRates.BillingRate = db.BillingRates.Where(m => m.Category == Category).ToList(); var bill = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).GroupBy(m => m.Category).Select(g => new { Category = g.Key }).ToList(); var subcat = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).Where(m => m.Category == Category).GroupBy(m => m.SubCategory).Select(g => new { SubCategory = g.Key }).ToList(); foreach (var item in bill) { searchBillingAndCollectionRates.Category.Add(item.Category); } foreach (var item in subcat) { searchBillingAndCollectionRates.SubCategory.Add(item.SubCategory); } } else if (TransactionType.ToUpper() == "EDIT") // Modify subcategory { if (!string.IsNullOrEmpty(SubCategory)) { BillingRate billingRate = new BillingRate(); //billingRate = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).Where(m => m.Category == Category).Where(m => m.SubCategory == SubCat).Single(); billingRate = db.BillingRates.FirstOrDefault(x => x.ZoneGroup == ZoneGroup && x.Category == Category && x.SubCategory == SubCat); if (Category != "Rental Fee") //If billing rate. add prefix currency. { billingRate.SubCategory = SubCategory; billingRate.NGASCode = NGAS; } else { billingRate.SubCategory = Currency + " " + SubCategory; billingRate.NGASCode = NGAS; } db.Entry(billingRate).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["TransactionSuccess"] = "Edit"; } else { Response.Write("<script>alert('Unable to edit SubCategory. Please check blank field.')</script>"); } searchBillingAndCollectionRates.BillingRate = db.BillingRates.Where(m => m.Category == Category).ToList(); var bill = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).GroupBy(m => m.Category).Select(g => new { Category = g.Key }).ToList(); var subcat = db.BillingRates.Where(x => x.ZoneGroup == ZoneGroup).Where(m => m.Category == Category).GroupBy(m => m.SubCategory).Select(g => new { SubCategory = g.Key }).ToList(); foreach (var item in bill) { searchBillingAndCollectionRates.Category.Add(item.Category); } foreach (var item in subcat) { searchBillingAndCollectionRates.SubCategory.Add(item.SubCategory); } } ViewBag.Category = Category; TempData["searchBillingAndCollectionRates"] = searchBillingAndCollectionRates; TempData["Category"] = Category; return(RedirectToAction("ViewBillingAndCollectionRatesRPG", "MaintenanceBillingAndCollectionRates")); //return View("ViewBillingAndCollectionRates", searchBillingAndCollectionRates); }