public ActionResult DeletePassedOnBilling(int idToDelete, FormCollection frm) { var id = frm[0].ToString(); int CompanyId = int.Parse(id); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; PassedOnBillingInformation passedOnBillingInformation = new PassedOnBillingInformation(); passedOnBillingInformation = db.PassedOnBillingInformation.Find(idToDelete); db.PassedOnBillingInformation.Remove(passedOnBillingInformation); db.SaveChanges(); PassedOnBillingViewModel passedonBillingViewModels = new PassedOnBillingViewModel(); passedonBillingViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); passedonBillingViewModels.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).ToList(); try { passedonBillingViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).Sum(x => x.Amount); SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Passed OnBilling - Delete Record -from Terminal:" + ipaddress); } catch (Exception) { passedonBillingViewModels.TotalAmount = 0; } ViewBag.CompanySelected = "OK"; passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = passedonBillingViewModels.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); passedonBillingViewModels.BillingPeriodList = billp.ToList(); TempData["TransactionSuccess"] = "delete"; TempData["PassedOnBillingData"] = passedonBillingViewModels; return(RedirectToAction("ViewPassedOnBillingPRG", "DataEntryPassedOnBilling")); }
public ActionResult ViewPassedOnBilling() { var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; PassedOnBillingViewModel searchcompany = new PassedOnBillingViewModel(); searchcompany.ZoneList = db.Zone.Select(x => x).ToList(); List <BillingPeriod> billingPeriods = new List <BillingPeriod>(); billingPeriods = db.BillingPeriod.Where(m => m.groupCode == ZoneGroup).ToList(); var billp = billingPeriods.OrderByDescending(m => m.BillingPeriodId); billingPeriods = billp.ToList(); searchcompany.BillingPeriodList = billingPeriods; return(View(searchcompany)); }
public ActionResult ViewPassedOnBillingPRG() { PassedOnBillingViewModel PassedList = new PassedOnBillingViewModel(); PassedList.ZoneList = db.Zone.Select(x => x).ToList(); var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.PassedOnBilling; ViewBag.CompanySelected = "OK"; PassedOnBillingViewModel temp = TempData["PassedOnBillingData"] as PassedOnBillingViewModel; ViewBag.TransactionSuccess = TempData["TransactionSuccess"] as string; TempData.Keep("PassedOnBillingData"); return(View("ViewPassedOnBilling", temp)); }
public ActionResult DisplayPassedOnBilling(int CompId, FormCollection frmcollection) { PassedOnBillingViewModel searchcompany = new PassedOnBillingViewModel(); searchcompany.ZoneList = db.Zone.Select(x => x).ToList(); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.PassedOnBilling; PassedOnBillingViewModel SearchCompanyViewModels = new PassedOnBillingViewModel(); if (frmcollection.Count == 0) { SearchCompanyViewModels.PassedOnBillingList = db.PassedOnBillingInformation.SqlQuery("Select * from SecurityGuardFeeInformations where CompanyId = '" + frmcollection["CompanyId"] + "'").ToList(); SearchCompanyViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompId).Sum(x => x.Amount); return(View(SearchCompanyViewModels)); } else if (frmcollection.Count >= 1) { PassedOnBillingViewModel passedonBillingViewModels = new PassedOnBillingViewModel(); int parsedID = int.Parse(frmcollection["PassedOnBillingInformationId"]); PassedOnBillingInformation securityfee = db.PassedOnBillingInformation.Find(parsedID); //db.PassedOnBillingInformation.Remove(securityfee); //db.SaveChanges(); passedonBillingViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompId).ToList(); passedonBillingViewModels.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompId).ToList(); passedonBillingViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompId).Sum(x => x.Amount); return(View("ViewPassedOnBilling", passedonBillingViewModels)); } ViewBag.CompanySelected = "OK"; //SearchCompanyViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); SearchCompanyViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = SearchCompanyViewModels.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); SearchCompanyViewModels.BillingPeriodList = billp.ToList(); return(View()); }
public ActionResult ViewPassedOnBilling(string SearchInput, FormCollection frm) { var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.PassedOnBilling; //Result of initial search button if (!string.IsNullOrEmpty(SearchInput)) { PassedOnBillingViewModel searchcompany1 = new PassedOnBillingViewModel(); searchcompany1.ZoneList = db.Zone.Select(x => x).ToList(); ApplicationDbContext context = new ApplicationDbContext(); List <Company> NewCompanies = new List <Company>(); NewCompanies = db.Company.SqlQuery("Select * from Companies where CompanyName like '%" + SearchInput + "%'").ToList(); SearchCompanyPerGroup searchCompanyPerGroup = new SearchCompanyPerGroup(NewCompanies, ZoneGroup); searchcompany1.CompanyList = searchCompanyPerGroup.Companies; //searchcompany1.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); searchcompany1.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = searchcompany1.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); searchcompany1.BillingPeriodList = billp.ToList(); return(View(searchcompany1)); } //Result of selected company shown by "Search button" else if (frm.Count == 2) { int OutParseValue; bool CanParse = int.TryParse(frm[1].ToString(), out OutParseValue); PassedOnBillingViewModel searchcompany1 = new PassedOnBillingViewModel(); searchcompany1.ZoneList = db.Zone.Select(x => x).ToList(); if (CanParse) { int ParsedCompanyID = int.Parse(frm[1].ToString()); searchcompany1.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == ParsedCompanyID).ToList(); searchcompany1.CompanyList = db.Company.Where(m => m.CompanyID == ParsedCompanyID).ToList(); if (searchcompany1.PassedOnBillingList.Count >= 1) { searchcompany1.TotalAmount = searchcompany1.PassedOnBillingList.Sum(x => x.Amount); } SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Passed OnBilling - Search Company -from Terminal:" + ipaddress); ViewBag.CompanySelected = "OK"; } //searchcompany1.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); searchcompany1.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = searchcompany1.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); searchcompany1.BillingPeriodList = billp.ToList(); return(View(searchcompany1)); } //Default value else { PassedOnBillingViewModel searchcompany1 = new PassedOnBillingViewModel(); searchcompany1.ZoneList = db.Zone.Select(x => x).ToList(); //searchcompany1.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); searchcompany1.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = searchcompany1.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); searchcompany1.BillingPeriodList = billp.ToList(); return(View(searchcompany1)); } }
public ActionResult AddPassedOnBilling(int CompanyId, Decimal Amount, DateTime OriginDateAdd, DateTime BillingDateAdd, int BillingPeriod, string Type, string isEdit, string PassedOnBillingInfoId) { PassedOnBillingViewModel searchcompany = new PassedOnBillingViewModel(); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.PassedOnBilling; //SL.LogInfo(User.Identity.Name, Request.RawUrl, "User Added Item! (Data Entry PassOnBilling) - from Terminal:" + ipaddress); PassedOnBillingInformation passedonBillingInfo = null; passedonBillingInfo = db.PassedOnBillingInformation.Find(CompanyId); if (isEdit != "Edit") { PassedOnBillingViewModel passedonBillingViewModels = new PassedOnBillingViewModel(); PassedOnBillingInformation passedonBillingAssignment = new PassedOnBillingInformation(); passedonBillingViewModels.ZoneList = db.Zone.Select(x => x).ToList(); passedonBillingAssignment.CompanyId = CompanyId; passedonBillingAssignment.Amount = Amount; passedonBillingAssignment.Type = Type; passedonBillingAssignment.OriginDate = OriginDateAdd; passedonBillingAssignment.BillingDate = BillingDateAdd; passedonBillingAssignment.CreateDate = DateTime.Now; passedonBillingAssignment.CreatedBy = userid; passedonBillingAssignment.BillingPeriod = BillingPeriod; db.PassedOnBillingInformation.Add(passedonBillingAssignment); db.SaveChanges(); passedonBillingViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); passedonBillingViewModels.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).ToList(); passedonBillingViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).Sum(x => x.Amount); //passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = passedonBillingViewModels.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); passedonBillingViewModels.BillingPeriodList = billp.ToList(); //return View("ViewSecurityGuardFee", SearchSecurityGuardFeeViewModels); TempData["TransactionSuccess"] = "Add"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Passed OnBilling - Add -from Terminal:" + ipaddress); TempData["PassedOnBillingData"] = passedonBillingViewModels; } else { int passedonbillingid = Convert.ToInt32(PassedOnBillingInfoId); passedonBillingInfo = db.PassedOnBillingInformation.FirstOrDefault(m => m.PassedOnBillingInformationId == passedonbillingid); PassedOnBillingViewModel passedonBillingViewModels = new PassedOnBillingViewModel(); passedonBillingViewModels.ZoneList = db.Zone.Select(x => x).ToList(); passedonBillingInfo.Amount = Amount; passedonBillingInfo.OriginDate = OriginDateAdd; passedonBillingInfo.BillingDate = BillingDateAdd; passedonBillingInfo.BillingPeriod = BillingPeriod; passedonBillingInfo.Type = Type; passedonBillingInfo.UpdatedBy = userid; passedonBillingInfo.UpdateDate = DateTime.Now; db.Entry(passedonBillingInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); passedonBillingViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); passedonBillingViewModels.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).ToList(); passedonBillingViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).Sum(x => x.Amount); ViewBag.CompanySelected = "OK"; //passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = passedonBillingViewModels.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); passedonBillingViewModels.BillingPeriodList = billp.ToList(); TempData["TransactionSuccess"] = "Edit"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Passed OnBilling - Edit -from Terminal:" + ipaddress); TempData["PassedOnBillingData"] = passedonBillingViewModels; } return(RedirectToAction("ViewPassedOnBillingPRG", "DataEntryPassedOnBilling")); }