public ActionResult UpdateHoliday(FormCollection frmcollection) { HolidayTable holiinfo = null; int ParsedIntID = int.Parse(frmcollection["ID"]); holiinfo = db.HolidayTable.Find(ParsedIntID); if (holiinfo != null) { //compinfo.CompanyCode = frmcollection["CompanyCode"].ToString(); holiinfo.HolidayTableDate = Convert.ToDateTime(frmcollection["Date"].ToString()).Date; holiinfo.HolidayTableDescription = frmcollection["Description"].ToString(); db.Entry(holiinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { throw new Exception("Invalid transaction."); } int parsedID = int.Parse(frmcollection["ID"]); SearchHolidayTableViewModel searchholiday = new SearchHolidayTableViewModel(); searchholiday.HolidayList = db.HolidayTable.SqlQuery("Select * from HolidayTables").ToList(); return(View("ViewHolidayTable", searchholiday)); }
public PartialViewResult Edit(int DivisionIdEdit, string DivisionCodeEdit, string DivisionNameEdit) { IEnumerable <Division> divisions = new List <Division>(); BCS_Context db = new BCS_Context(); try { using (var dbtransaction = db.Database.BeginTransaction()) { Division division = new Division(); division = db.Division.FirstOrDefault(m => m.DivisionId == DivisionIdEdit); division.Code = DivisionCodeEdit; division.Name = DivisionNameEdit; db.Entry(division).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); dbtransaction.Commit(); divisions = db.Division.ToList().OrderBy(m => m.Name); //divisions.Add(division); SL.LogInfo(User.Identity.Name, Request.RawUrl, "Division - Division Edited - from Terminal: " + ipaddress); return(PartialView("_DivisionPartial", divisions)); } } catch (Exception) { SL.LogInfo(User.Identity.Name, Request.RawUrl, "Division - Edit division failed - from Terminal: " + ipaddress); divisions = db.Division.ToList().OrderBy(m => m.Name); return(PartialView("_DivisionPartial", divisions)); } }
public ActionResult UpdateOPAccount(FormCollection frmcollection) { SL.LogInfo(User.Identity.Name, Request.RawUrl, "User Updated Item! (Maintenance Nature of Payments) - from Terminal:" + ipaddress); OPAccount opaccountinfo = null; ApplicationDbContext context = new ApplicationDbContext(); var OPAFee = frmcollection["OPAccountFee"].ToString().Replace(",", ""); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; string Division = context.Users.FirstOrDefault(x => x.Id == userid).Division; int ParsedIntCompanyID = int.Parse(frmcollection["OPAccountId1"]); opaccountinfo = db.OPAccount.Find(ParsedIntCompanyID); if (opaccountinfo != null) { opaccountinfo.OPAccountCode = frmcollection["OPAccountCode"].ToString(); opaccountinfo.NGASCode = frmcollection["OPAccountNGASCode"].ToString(); opaccountinfo.OPAccountDescription = frmcollection["OPAccountDescription"].ToString(); opaccountinfo.OPAccountFee = Convert.ToDecimal(OPAFee); opaccountinfo.DivisionCode = frmcollection["DivisionCode"]; opaccountinfo.ZoneGroupCode = ZoneGroup; opaccountinfo.OPAccountDescription = frmcollection["OPAccountDescription"].ToString(); opaccountinfo.OPAccountValidity = frmcollection["OPAccountValidity"].ToString(); opaccountinfo.AccountTag = frmcollection["AccountTag"].ToString(); db.Entry(opaccountinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } foreach (var results in db.OrderOfPaymentDetail.Where(b => b.OPAccountId == ParsedIntCompanyID)) { results.AccountTag = frmcollection["AccountTag"].ToString(); } db.SaveChanges(); int parsedCompanyID = int.Parse(frmcollection["OPAccountId1"]); SearchOPAccountsViewModel searchopaccount = new SearchOPAccountsViewModel(); //searchopaccount.OPAccountList = db.OPAccount.Where(x => x.ZoneGroupCode == ZoneGroup).OrderBy(x => x.OPAccountDescription).Take(10).ToList(); searchopaccount.OPAccountList = db.OPAccount.Where(x => x.OPAccountId == parsedCompanyID).ToList(); searchopaccount.DivisionList = db.Division.SqlQuery("Select * from Divisions").ToList(); ViewBag.TransactionSuccess = "Edit"; ViewBag.CompanySelected = "OK"; return(View("ViewOrderOfPaymentAccounts", searchopaccount)); }
public ActionResult UpdateZoneGroup(FormCollection frmcollection) { ZoneGroup zonegroupinfo = null; int ParsedIntID = int.Parse(frmcollection["ZoneGId"]); string zonegroupcode = frmcollection["ZoneGroupCode"].ToString(); zonegroupinfo = db.ZoneGroup.Find(ParsedIntID); string zoneCodeOrig = db.ZoneGroup.FirstOrDefault(m => m.ZoneGroupId == ParsedIntID).ZoneGroupCode; int newzonecodeId = 0; if (db.ZoneGroup.Any(m => m.ZoneGroupCode == zonegroupcode)) { newzonecodeId = db.ZoneGroup.FirstOrDefault(m => m.ZoneGroupCode == zonegroupcode).ZoneGroupId; } if ((db.ZoneGroup.Any(m => m.ZoneGroupCode == zonegroupcode) && newzonecodeId == ParsedIntID) || (!db.ZoneGroup.Any(m => m.ZoneGroupCode == zonegroupcode))) { if (zonegroupinfo != null) { zonegroupinfo.ZoneGroupCode = frmcollection["ZoneGroupCode"].ToString(); zonegroupinfo.ZoneGroupName = frmcollection["ZoneGroupName"].ToString(); zonegroupinfo.ZoneGroupAddress = frmcollection["ZoneGroupAddress"].ToString(); zonegroupinfo.ZoneGroupRole = frmcollection["ZoneGroupRole"].ToString(); zonegroupinfo.ZoneGroupInitials = frmcollection["ZoneGroupInitial"].ToString(); db.Entry(zonegroupinfo).State = System.Data.Entity.EntityState.Modified; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Admin Zone - Zone Group Edited - from Terminal: " + ipaddress); db.SaveChanges(); TempData["TransactionSuccess"] = "Edit"; } } else { TempData["TransactionSuccess"] = "Duplicate"; } return(RedirectToAction("ViewZoneGroup")); }
public ActionResult Edit_Post(RoleAssignmentMatrix roleAssignmentMatrix, string All, string user2) { roleAssignmentMatrix.UserName = user2; ApplicationDbContext context = new ApplicationDbContext(); string zonegroup = context.Users.FirstOrDefault(m => m.UserName == roleAssignmentMatrix.UserName).ZoneGroup; roleAssignmentMatrix.ZoneGroup = zonegroup; TryUpdateModel(roleAssignmentMatrix); roleAssignmentMatrix.ZoneGroup = zonegroup; if (All == "All") { roleAssignmentMatrix.Administrative = true; roleAssignmentMatrix.Aging = true; roleAssignmentMatrix.Billing = true; roleAssignmentMatrix.Collection = true; roleAssignmentMatrix.Company = true; roleAssignmentMatrix.Franchise = true; roleAssignmentMatrix.Garbage = true; roleAssignmentMatrix.HO = true; roleAssignmentMatrix.JBR = true; roleAssignmentMatrix.PassedOnBilling = true; roleAssignmentMatrix.Payment = true; roleAssignmentMatrix.Period = true; roleAssignmentMatrix.Pole = true; roleAssignmentMatrix.Rate = true; roleAssignmentMatrix.Rentals = true; roleAssignmentMatrix.Security = true; roleAssignmentMatrix.Sewerage = true; roleAssignmentMatrix.SubsidiaryLedger = true; roleAssignmentMatrix.Water = true; } db.Entry(roleAssignmentMatrix).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["TransactionSuccess"] = "Edit"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Role Assignment - Role Edited - from Terminal: " + ipaddress); return(RedirectToAction("Details")); }
public ActionResult UpdatePeriod(FormCollection frmcollection) { var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Period; BillingPeriod Periodinfo = null; int ParsedIntID = int.Parse(frmcollection["BillingPeriodId"]); string BillingStatus = db.BillingPeriod.Where(m => m.BillingPeriodId == ParsedIntID).SingleOrDefault().Finalized; if (BillingStatus.ToUpper() == "NO") { Periodinfo = db.BillingPeriod.Find(ParsedIntID); if (Periodinfo != null) { Periodinfo.PeriodText = frmcollection["PeriodText"].ToString(); Periodinfo.DateFrom = Convert.ToDateTime(frmcollection["DateFrom"].ToString()); Periodinfo.DateTo = Convert.ToDateTime(frmcollection["DateTo"].ToString()); //Periodinfo.groupCode = Group; db.Entry(Periodinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { throw new Exception("Invalid transaction."); } } else { Response.Write("<script>alert('Unable to edit finalized billing period.')</script>"); } int parsedID = int.Parse(frmcollection["BillingPeriodId"]); SL.LogInfo(User.Identity.Name, Request.RawUrl, "Maintenance Period Table - Period Table Updated - from Terminal: " + ipaddress); return(RedirectToAction("ViewPeriodTablePRG", "MaintenancePeriodTable")); }
public ActionResult AddPoleRental(FormCollection frm) { var origamt = frm["Amount"]; var amt = frm["Amount"].Split(','); var newAmount = ""; foreach (var item in amt) { newAmount += item; } var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Pole; //SL.LogInfo(User.Identity.Name, Request.RawUrl, "User Added Item! (Data Entry Pole Rental) - from Terminal:" + ipaddress); string isEdit = frm["isEdit"].ToString(); SearchPoleInformationViewModel SearchPoleRentalViewModels = new SearchPoleInformationViewModel(); PoleInformation PoleRentalAssignment = new PoleInformation(); int CompanyId = int.Parse(frm["CompanyId"].ToString()); var errors = ModelState.Values.SelectMany(v => v.Errors); TryUpdateModel(PoleRentalAssignment); //if (ModelState.IsValid) //{ if (isEdit != "True") { PoleRentalAssignment.Amount = Convert.ToDecimal(origamt); PoleRentalAssignment.CreatedDate = DateTime.Now; PoleRentalAssignment.CreatedBy = userid; PoleRentalAssignment.BillMode = frm["BillMode"]; PoleRentalAssignment.BillingMonths = frm["billingMonths"]; //PoleRentalAssignment.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12"; db.PoleInformation.Add(PoleRentalAssignment); db.SaveChanges(); TempData["TransactionSuccess"] = "Add"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Pole Rental- Add - from Terminal:" + ipaddress); } else { int ParsedIntID = int.Parse(frm["ID"]); PoleRentalAssignment = db.PoleInformation.Find(ParsedIntID); //compinfo.CompanyCode = frmcollection["CompanyCode"].ToString(); PoleRentalAssignment.Amount = Convert.ToDecimal(newAmount); PoleRentalAssignment.StartDate = Convert.ToDateTime(frm["StartDate"].ToString()); PoleRentalAssignment.EndDate = Convert.ToDateTime(frm["EndDate"].ToString()); PoleRentalAssignment.UpdateDate = DateTime.Now; PoleRentalAssignment.UpdatedBy = userid; PoleRentalAssignment.BillingMonths = frm["billingMonths"]; //PoleRentalAssignment.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12"; PoleRentalAssignment.BillMode = frm["BillMode"]; db.Entry(PoleRentalAssignment).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["TransactionSuccess"] = "Edit"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Pole Rental- Edit - from Terminal:" + ipaddress); //ViewBag.TransactionSuccess = "Add"; } ViewBag.ValidatePostback = "True"; //} //else //{ // ViewBag.ValidatePostback = "False"; //} ViewBag.CompanySelected = "OK"; SearchPoleRentalViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); SearchPoleRentalViewModels.PoleInformationList = db.PoleInformation.Where(m => m.CompanyId == CompanyId).ToList(); TempData["SearchPoleRentalViewModels"] = SearchPoleRentalViewModels; return(RedirectToAction("ViewPoleRentalsRPG", "DataEntryPoleRental")); //return View("ViewPoleRentals", SearchPoleRentalViewModels); }
public ActionResult ViewGenerate(FormCollection frm) { int generatePerCompanyId = 0; string BillingGenerateValue = ""; ApplicationDbContext context = new ApplicationDbContext(); var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); string ZoneGroup1 = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.SingleOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Billing; //CoverageFrom CoverageTo int billingPeriodId = int.Parse(frm["PeriodId"].ToString()); VerifyBillingPeriod verify = new VerifyBillingPeriod(billingPeriodId, ZoneGroup1); if (verify.canGenerate()) //Verify if previous billing already generated a billing. { string FxRate = frm["FxRate"].ToString(); DateTime dtCoverageFrom = Convert.ToDateTime(frm["CoverageFrom"].ToString()); DateTime dtCoverageTo = Convert.ToDateTime(frm["CoverageTo"].ToString()); DateTime dtBillingDate = Convert.ToDateTime(frm["BillDate"].ToString()); DateTime dtBillingDue = Convert.ToDateTime(frm["DueDate"].ToString()); Company company = new Company(); string TypeOfBillingGenerate = frm["TypeOfBillingGenerate"].ToString(); if (TypeOfBillingGenerate == "PerCompany") { generatePerCompanyId = Convert.ToInt32(frm["generatePerCompanyId"].ToString()); BillingGenerateValue = frm["TypeOfBillingGeneratePerCompany"].ToString(); } else if (TypeOfBillingGenerate == "PerPOB") { BillingGenerateValue = frm["TypeOfBillingGeneratePerPOB"].ToString(); } else if (TypeOfBillingGenerate == "PerBillingType") { BillingGenerateValue = frm["TypeOfBillingGeneratePerBillingType"].ToString(); } else if (TypeOfBillingGenerate == "PerAdminFee") { BillingGenerateValue = frm["TypeOfBillingGeneratePerAdminFee"].ToString(); } //Get the current user //ApplicationDbContext context = new ApplicationDbContext(); string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; BillingPeriod billingPeriod = db.BillingPeriod.Find(billingPeriodId); string isgenerated = billingPeriod.Generated; bool isGenerated = true; // delete this line of need to delete first the records in regenerate //bool isGenerated = false; //The role is Delete first the data then return as true. #region delete_records //08-01-2017 do not delete records in regenerate.. update only the changes //if (isgenerated.ToLower() == "yes") //{ // if (!string.IsNullOrEmpty(TypeOfBillingGenerate) && TypeOfBillingGenerate.ToUpper() == "PERCOMPANY") //Delete base on type of billing generate // { // int companyId = Convert.ToInt32(generatePerCompanyId); // BillingRegenerateBLL billingRegenerateBLL = new BillingRegenerateBLL(billingPeriodId, companyId); // isGenerated = billingRegenerateBLL.RegenerateBillingPerCompany(); // SL.LogInfo(User.Identity.Name, Request.RawUrl, "Billing Regenerate- Billing generate percompany. - from Terminal: " + ipaddress); // } // else if (!string.IsNullOrEmpty(TypeOfBillingGenerate) && TypeOfBillingGenerate.ToUpper() == "PERENTERPRISE") // { // BillingRegenerateBLL billingRegenerateBLL = new BillingRegenerateBLL(billingPeriodId, BillingGenerateValue); // isGenerated = billingRegenerateBLL.RegenerateBillingPerEnterprise(); // SL.LogInfo(User.Identity.Name, Request.RawUrl, "Billing Regenerate- Billing generate perenterprise. - from Terminal: " + ipaddress); // } // else if (!string.IsNullOrEmpty(TypeOfBillingGenerate) && TypeOfBillingGenerate.ToUpper() == "PERBILLINGTYPE") // { // BillingRegenerateBLL billingRegenerateBLL = new BillingRegenerateBLL(billingPeriodId, BillingGenerateValue); // isGenerated = billingRegenerateBLL.RegenerateBillingPerBillingType(); // SL.LogInfo(User.Identity.Name, Request.RawUrl, "Billing Regenerate- Billing generate perbillingtype. - from Terminal: " + ipaddress); // } // else if (!string.IsNullOrEmpty(TypeOfBillingGenerate) && TypeOfBillingGenerate.ToUpper() == "PERADMINFEE") // { // BillingRegenerateBLL billingRegenerateBLL = new BillingRegenerateBLL(billingPeriodId, BillingGenerateValue); // isGenerated = billingRegenerateBLL.RegenerateBillingPerAdminFee(); // SL.LogInfo(User.Identity.Name, Request.RawUrl, "Billing Regenerate- Billing generate peradminfee. - from Terminal: " + ipaddress); // } // else // { // BillingRegenerateBLL billingRegenerateBLL = new BillingRegenerateBLL(billingPeriodId); // isGenerated = billingRegenerateBLL.RegenerateBilling(); // SL.LogInfo(User.Identity.Name, Request.RawUrl, "Billing Regenerate- Billing generate all company. - from Terminal: " + ipaddress); // } //} #endregion delete_records //BillingBusinessLayer billingBusinessLayer = new BillingBusinessLayer(ZoneGroup, dtCoverageFrom, dtCoverageTo, dtBillingDate, dtBillingDue, billingPeriodId, userid, FxRate, generatePerCompanyId, TypeOfBillingGenerate); BillingBusinessLayerNewAlgo billingBusinessLayerNewAlgoTemp = new BillingBusinessLayerNewAlgo(ZoneGroup, dtCoverageFrom, dtCoverageTo, dtBillingDate, dtBillingDue, billingPeriodId, userid, FxRate, generatePerCompanyId, TypeOfBillingGenerate, BillingGenerateValue); //bool isCurrencyValid = true; bool isCurrencyValid = billingBusinessLayerNewAlgoTemp.isValidFxRate(FxRate); if (dtBillingDue >= dtCoverageFrom && dtBillingDate >= dtCoverageFrom) { if (db.BillingRates.Any(m => m.Category == "Sewerage" && m.ZoneGroup == ZoneGroup)) { if (isCurrencyValid) { BillingPeriod CloseBillingPeriod = db.BillingPeriod.Find(billingPeriodId); CloseBillingPeriod.IsPaymentOpen = false; db.Entry(CloseBillingPeriod).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); using (var dbtransaction = db.Database.BeginTransaction()) { try //If Custom error is Enabled. Delete this try catch block.. "Using" statement above will automatically rollback transaction when error occur. { if (isgenerated.ToLower() == "yes" && isGenerated) { //BillingBusinessLayerNewAlgo billingBusinessLayerNewAlgo = new BillingBusinessLayerNewAlgo(ZoneGroup, dtCoverageFrom, dtCoverageTo, dtBillingDate, dtBillingDue, billingPeriodId, userid, FxRate, generatePerCompanyId, TypeOfBillingGenerate, BillingGenerateValue); //billingBusinessLayer.generateBilling(); billingBusinessLayerNewAlgoTemp.generateBilling(); SL.LogInfo(User.Identity.Name, Request.RawUrl, "Billing Regenerate - Billing generate complete. - from Terminal: " + ipaddress); TempData["BillingStatus"] = "Billing generate complete";//Response.Write("<script>alert('Billing generate complete.')</script>"); } else { //BillingBusinessLayerNewAlgo billingBusinessLayerNewAlgo = new BillingBusinessLayerNewAlgo(ZoneGroup, dtCoverageFrom, dtCoverageTo, dtBillingDate, dtBillingDue, billingPeriodId, userid, FxRate, generatePerCompanyId, TypeOfBillingGenerate, BillingGenerateValue); //billingBusinessLayer.generateBilling(); billingBusinessLayerNewAlgoTemp.generateBilling(); SL.LogInfo(User.Identity.Name, Request.RawUrl, "Billing Generate- Billing generate complete. - from Terminal: " + ipaddress); TempData["BillingStatus"] = "Billing generate complete"; //Response.Write("<script>alert('Billing generate complete.')</script>"); } } catch (DbEntityValidationException ex) { // catch (DbEntityValidationException dbEx) //{ foreach (var validationErrors in ex.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } // } } string ex1 = ex.Message; TempData["BillingStatus"] = ex1; //Response.Write("<script>alert('Billing Generation failed.')</script>"); dbtransaction.Rollback(); } }//End of using //BillingPeriod OpenBillingPeriod = db.BillingPeriod.Find(billingPeriodId); //OpenBillingPeriod.IsPaymentOpen = true; //db.Entry(OpenBillingPeriod).State = System.Data.Entity.EntityState.Modified; //db.SaveChanges(); }//End of is not USD else { TempData["BillingStatus"] = "Billing Generation failed. The system has detected USD type of billing. Please input data in FX Rate field."; SL.LogWarning(User.Identity.Name, Request.RawUrl, "Billing Generate- Billing Generation failed. - from Terminal: " + ipaddress); //Response.Write("<script>alert('Billing Generation failed. The system has detected USD type of billing. Please input data in FX Rate field.')</script>"); } } else { TempData["BillingStatus"] = "Unable to proceed. No Sewerage rate detected."; SL.LogError(User.Identity.Name, Request.RawUrl, "Billing Generate- Unable to proceed.No Sewerage rate detected. - from Terminal: " + ipaddress); //Response.Write("<script>alert('Unable to proceed. No Sewerage rate detected.')</script>"); } } else { TempData["BillingStatus"] = "Unable to proceed. Billing Date/Due Date must be greater than Coverage Date."; } } else { TempData["BillingStatus"] = "Unable to proceed. Previous billing period already generated a billing."; //Response.Write("<script>alert('Unable to proceed. Previous billing period already generated a billing.')</script>"); } // List <BillingPeriod> billingperiodlist = new List <BillingPeriod>(); billingperiodlist = db.BillingPeriod.ToList(); //return View("ViewGenerate", billingperiodlist); TempData["Toggled"] = "Toggled"; return(RedirectToAction("ViewGeneratePRG", "BillingGenerate")); }
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")); }
public ActionResult AddFranchiseInformation(FormCollection formcollection) { string isEdit = formcollection["isEdit"].ToString(); var userid = User.Identity.GetUserId(); var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.Franchise; SL.LogInfo(User.Identity.Name, Request.RawUrl, "User Added Item! (Data Entry Franchise Information) - from Terminal:" + ipaddress); int CompanyId = Convert.ToInt32(formcollection["CompanyId"].ToString()); //FranchiseFeeInformation fran = new FranchiseFeeInformation(); //TryUpdateModel(fran); //if (ModelState.IsValid) //{ DateTime DateStart = Convert.ToDateTime(formcollection["StartDate"].ToString()); DateTime EndDate = Convert.ToDateTime(formcollection["EndDate"].ToString()); string BillMode = formcollection["BillMode"]; int DueOn = Convert.ToInt32(formcollection["DueOn"].ToString()); decimal Amount = Convert.ToDecimal(formcollection["Amount"].ToString()); if (isEdit != "True") { FranchiseFeeInformation franchiseFeeInformation = new FranchiseFeeInformation(); franchiseFeeInformation.CompanyId = CompanyId; franchiseFeeInformation.Amount = Amount; franchiseFeeInformation.BillMode = BillMode; franchiseFeeInformation.DueOn = DueOn; franchiseFeeInformation.StartDate = DateStart; franchiseFeeInformation.EndDate = EndDate; franchiseFeeInformation.BillingMonths = formcollection["billingMonths"]; //franchiseFeeInformation.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12"; franchiseFeeInformation.CreatedBy = userid; franchiseFeeInformation.CreateDate = DateTime.Now; db.FranchiseFeeInformation.Add(franchiseFeeInformation); db.SaveChanges(); TempData["TransactionSuccess"] = "Add"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Franchise - Franchise Information Added - from Terminal: " + ipaddress); ViewBag.ValidatePostback = "True"; } else { int FranchiseFeeInformationId = Convert.ToInt32(formcollection["FranchiseFeeInformationId"].ToString()); FranchiseFeeInformation franchiseFeeInformation = new FranchiseFeeInformation(); franchiseFeeInformation = db.FranchiseFeeInformation.Where(m => m.FranchiseFeeInformationId == FranchiseFeeInformationId).FirstOrDefault(); franchiseFeeInformation.Amount = Amount; franchiseFeeInformation.BillMode = BillMode; franchiseFeeInformation.DueOn = DueOn; franchiseFeeInformation.StartDate = DateStart; franchiseFeeInformation.EndDate = EndDate; franchiseFeeInformation.BillingMonths = formcollection["billingMonths"]; //franchiseFeeInformation.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12"; franchiseFeeInformation.UpdatedBy = userid; franchiseFeeInformation.UpdateDate = DateTime.Now; db.Entry(franchiseFeeInformation).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["TransactionSuccess"] = "Edit"; ViewBag.ValidatePostback = "True"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Franchise - Franchise Information Edit - from Terminal: " + ipaddress); } //} //else //{ // ViewBag.ValidatePostback = "False"; //} ViewBag.CompanySelected = "OK"; SearchFranchiseViewModel searchFranchiseViewModel = new SearchFranchiseViewModel(); searchFranchiseViewModel.Companies = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); searchFranchiseViewModel.FranchiseFeeInformations = db.FranchiseFeeInformation.Where(m => m.CompanyId == CompanyId).ToList(); TempData["SearchFranchiseViewModels"] = searchFranchiseViewModel; return(RedirectToAction("ViewFranchiseRPG", "DataEntryFranchise")); //return View("ViewFranchise", searchFranchiseViewModel); }
public ActionResult ViewRentals(string SearchInput, FormCollection frm, RentalInformation rentalinfo, string isEdit) { ApplicationDbContext context = new ApplicationDbContext(); 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.Rentals; //Result of initial search button if (!string.IsNullOrEmpty(SearchInput)) { SearchCompany searchcompany1 = new SearchCompany(); searchcompany1.SearchInput = SearchInput.ToString(); 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.CompanyList = db.Company.SqlQuery("Select * from Companies where CompanyName like '%" + SearchInput + "%' and ZoneGroup").ToList(); ViewBag.CompanySelected = ""; 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); SearchCompany searchcompany1 = new SearchCompany(); if (CanParse) { int ParsedCompanyID = int.Parse(frm[1].ToString()); searchcompany1.RentalInformationList = db.RentalInformation.Where(m => m.CompanyId == ParsedCompanyID).ToList(); searchcompany1.CompanyList = db.Company.Where(m => m.CompanyID == ParsedCompanyID).ToList(); searchcompany1.BillingRate = db.BillingRates.Where(m => m.Category == "Rental Fee").Where(m => m.ZoneGroup == ZoneGroup).ToList(); var bill = searchcompany1.BillingRate.GroupBy(m => m.SubCategory).ToList(); foreach (var item in bill) { searchcompany1.SubCategory.Add(item.Key.ToString()); } SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Rental - Search Company - from Terminal: " + ipaddress); ViewBag.CompanySelected = "OK"; } else { ViewBag.CompanySelected = ""; } return(View(searchcompany1)); } else if (isEdit == "True") //Edit transaction { var area = frm["Area"].Split(','); var newArea = ""; foreach (var item in area) { newArea = newArea + item; } RentalInformation rent = new RentalInformation(); int CompanyID = int.Parse(frm["CompanyID"].ToString()); //TryUpdateModel(rent); //if (ModelState.IsValid) //{ RentalInformation rentinfo = null; int ParsedIntRentID = int.Parse(frm["rentID"]); rentinfo = db.RentalInformation.Find(ParsedIntRentID); if (rentinfo != null) { rentinfo.Type = frm["Type"].ToString(); rentinfo.Rate = decimal.Parse(frm["Rate"]); rentinfo.Area = Math.Round(decimal.Parse(newArea), 2); rentinfo.Amount = Math.Round(decimal.Parse(frm["Rate"]) * decimal.Parse(frm["Area"]), 2); rentinfo.StartDate = DateTime.Parse(frm["StartDate"].ToString()); rentinfo.EndDate = DateTime.Parse(frm["EndDate"].ToString()); rentinfo.BillMode = frm["BillMode"].ToString(); rentinfo.DueOn = int.Parse(frm["DueOn"]); rentinfo.BillingMonths = frm["billingMonths"]; //rentinfo.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12"; rentinfo.Currency = frm["Currency"].ToString(); rentinfo.UpdateDate = DateTime.Now; rentinfo.UpdatedBy = userid; db.Entry(rentinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); ViewBag.ValidatePostback = "True"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Rental - Edit - from Terminal: " + ipaddress); TempData["TransactionSuccess"] = "Edit"; //ViewBag.TransactionSuccess = "Edit"; } //} else { ViewBag.ValidatePostback = "False"; } SearchCompany searchcompany = new SearchCompany(); searchcompany.RentalInformationList = db.RentalInformation.Where(m => m.CompanyId == CompanyID).ToList(); searchcompany.CompanyList = db.Company.Where(m => m.CompanyID == CompanyID).ToList(); searchcompany.BillingRate = db.BillingRates.Where(m => m.Category == "Rental Fee").Where(m => m.ZoneGroup == ZoneGroup).ToList(); var bill = searchcompany.BillingRate.GroupBy(m => m.SubCategory).ToList(); foreach (var item in bill) { searchcompany.SubCategory.Add(item.Key); } ViewBag.CompanySelected = "OK"; TempData["SearchCompany"] = searchcompany; return(RedirectToAction("ViewRentalsRPG", "DataEntryRental")); //return View(searchcompany); } //If returned key/value pairs is > 3. "Add transaction is invoked else if (frm.Count > 3) { int OutIntParse; decimal OutDecimalParse; bool canParse = int.TryParse(frm["CompanyID"].ToString(), out OutIntParse); int parsedCompanyID = (canParse) ? int.Parse(frm["CompanyID"].ToString()) : 0; //int ParsedIntRentID = int.Parse(frm["RentalInformationId"]); RentalInformation rent = new RentalInformation(); TryUpdateModel(rent); //var errors = ModelState.Values.SelectMany(v => v.Errors); //UpdateModel<IRentalInformation>(rent); //if (ModelState.IsValid) //{ try { var r = frm["Rate"].ToString(); var s = r.Split(','); var newRate = ""; foreach (var item in s) { newRate += item; } decimal rate = Math.Round((decimal.TryParse(newRate, out OutDecimalParse)) ? decimal.Parse(newRate) : 0, 2); decimal area = Math.Round((decimal.TryParse(frm["Area"].ToString(), out OutDecimalParse)) ? decimal.Parse(frm["Area"].ToString()) : 0, 2); decimal amt = Math.Round(rate * area, 2); int RentalBillMode = (int.TryParse(frm["BillMode"].ToString(), out OutIntParse)) ? int.Parse(frm["BillMode"].ToString()) : 0; RentalInformation rentalinformation = new RentalInformation(); rentalinformation.CompanyId = parsedCompanyID; rentalinformation.Type = frm["Type"].ToString(); rentalinformation.Rate = rate; rentalinformation.Area = area; string str = frm["StartDate"].ToString(); rentalinformation.StartDate = Convert.ToDateTime(frm["StartDate"].ToString()); rentalinformation.EndDate = Convert.ToDateTime(frm["EndDate"].ToString()); //rentalinformation.BillMode = (int.TryParse(frm["BillMode"].ToString(), out OutIntParse)) ? int.Parse(frm["BillMode"].ToString()) : 0; rentalinformation.BillMode = frm["BillMode"].ToString(); rentalinformation.DueOn = (int.TryParse(frm["DueOn"].ToString(), out OutIntParse)) ? int.Parse(frm["DueOn"].ToString()) : 0; rentalinformation.BillingMonths = frm["billingMonths"]; //rentalinformation.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12"; rentalinformation.CreatedDate = DateTime.Now; rentalinformation.Amount = amt; rentalinformation.Currency = frm["Currency"].ToString(); rentalinformation.CreatedBy = userid; db.RentalInformation.Add(rentalinformation); db.SaveChanges(); SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Rental - Add - from Terminal: " + ipaddress); TempData["TransactionSuccess"] = "Add"; //ViewBag.TransactionSuccess = "Add"; ViewBag.ValidatePostback = "True"; } catch (Exception) { ViewBag.ValidatePostback = "False"; } //} //else //{ // ViewBag.ValidatePostback = "False"; //} ViewBag.CompanySelected = "OK"; SearchCompany searchcompany = new SearchCompany(); searchcompany.RentalInformationList = db.RentalInformation.Where(m => m.CompanyId == parsedCompanyID).ToList(); searchcompany.CompanyList = db.Company.Where(m => m.CompanyID == parsedCompanyID).ToList(); searchcompany.BillingRate = db.BillingRates.Where(m => m.Category == "Rental Fee").Where(m => m.ZoneGroup == ZoneGroup).ToList(); var bill = searchcompany.BillingRate.GroupBy(m => m.SubCategory).ToList(); foreach (var item in bill) { searchcompany.SubCategory.Add(item.Key); } TempData["SearchCompany"] = searchcompany; return(RedirectToAction("ViewRentalsRPG", "DataEntryRental")); //return View(searchcompany); } //Default value else { SearchCompany searchcompany1 = new SearchCompany(); return(View(searchcompany1)); } }
public ActionResult AddMeter(FormCollection frm) { 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.Water; string isEdit = frm["isEdit"].ToString(); int CompanyID = int.Parse(frm["CompanyID"].ToString()); SearchWaterViewModel SearchWaterViewModels = new SearchWaterViewModel(); WaterMeterAssignment waterMeterAssignment = new WaterMeterAssignment(); TryUpdateModel(waterMeterAssignment); if (ModelState.IsValid) { if (string.IsNullOrEmpty(isEdit) || isEdit != "True") { string MeterNumber = frm["MeterNumber"].ToString(); DateTime StartDate = Convert.ToDateTime(frm["StartDate"].ToString()); DateTime EndDate = Convert.ToDateTime(frm["EndDate"].ToString()); string Size = frm["Size"].ToString(); string Phase = frm["Phase"].ToString(); int IncludeInBilling = frm["IncludeInBilling"].ToString() == "YES" ? 1 : 0; DateTime MeterNumberEndDate = new DateTime(); WaterMeterAssignment tempMeterAssignment = new WaterMeterAssignment(); tempMeterAssignment = db.WaterMeterAssignment.Where(m => m.MeterNumber == MeterNumber).FirstOrDefault(); if (tempMeterAssignment != null) { MeterNumberEndDate = tempMeterAssignment.EndDate; } if (MeterNumberEndDate < StartDate) { waterMeterAssignment.CompanyId = CompanyID; waterMeterAssignment.MeterNumber = MeterNumber; waterMeterAssignment.StartDate = Convert.ToDateTime(StartDate); waterMeterAssignment.EndDate = Convert.ToDateTime(EndDate); waterMeterAssignment.Size = Size; waterMeterAssignment.Phase = Phase; waterMeterAssignment.Createdby = userid; waterMeterAssignment.CreateDate = DateTime.Now; waterMeterAssignment.IncludeBilling = IncludeInBilling; db.WaterMeterAssignment.Add(waterMeterAssignment); db.SaveChanges(); //ViewBag.TransactionSuccess = "Add"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Water - Add Meter - from Terminal: " + ipaddress); TempData["TransactionSuccess"] = "Add"; ViewBag.ValidatePostback = "True"; } else { TempData["TransactionSuccess"] = "MeterNumberExist"; ViewBag.ValidatePostback = "False"; } } else { int waterAssignmentId = int.Parse(frm["wid"].ToString()); WaterMeterAssignment waterMeterAssignmentEdit = new WaterMeterAssignment(); string MeterNumber = frm["MeterNumber"].ToString(); DateTime StartDate = Convert.ToDateTime(frm["StartDate"].ToString()); DateTime EndDate = Convert.ToDateTime(frm["EndDate"].ToString()); string Size = frm["Size"].ToString(); string Phase = frm["Phase"].ToString(); int IncludeInBilling = frm["IncludeInBilling"].ToString() == "YES" ? 1 : 0; waterMeterAssignmentEdit = db.WaterMeterAssignment.Where(m => m.WaterMeterAssignmentId == waterAssignmentId).Single(); waterMeterAssignmentEdit.MeterNumber = MeterNumber; waterMeterAssignmentEdit.StartDate = Convert.ToDateTime(StartDate); waterMeterAssignmentEdit.EndDate = Convert.ToDateTime(EndDate); waterMeterAssignmentEdit.Size = Size; waterMeterAssignmentEdit.Phase = Phase; waterMeterAssignmentEdit.UpdatedBy = userid; waterMeterAssignmentEdit.UpdateDate = DateTime.Now; waterMeterAssignmentEdit.IncludeBilling = IncludeInBilling; db.Entry(waterMeterAssignmentEdit).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); ViewBag.ValidatePostback = "True"; //ViewBag.TransactionSuccess = "Edit"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Water - Edit Meter - from Terminal: " + ipaddress); TempData["TransactionSuccess"] = "Edit"; } } else { ViewBag.ValidatePostback = "False"; } ViewBag.CompanySelected = "OK"; SearchWaterViewModels.Companies = db.Company.Where(m => m.CompanyID == CompanyID).ToList(); SearchWaterViewModels.WaterMeterAssignments = db.WaterMeterAssignment.Where(m => m.CompanyId == CompanyID).ToList(); SearchWaterViewModels.BillingPeriods = BillingPeriods(); TempData["WaterAssignmentData"] = SearchWaterViewModels; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Water - Meter Added - from Terminal: " + ipaddress); return(RedirectToAction("ViewWaterPRG", "DataEntryWater")); //return View("ViewWater", SearchWaterViewModels); }
public ActionResult UpdateCompany(FormCollection frmcollection) { ApplicationDbContext context = new ApplicationDbContext(); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; int SingleZoneGroupId = db.ZoneGroup.FirstOrDefault(d => d.ZoneGroupCode == ZoneGroup).ZoneGroupId; Company compinfo = null; int ParsedIntCompanyID = int.Parse(frmcollection["CompanyID"]); compinfo = db.Company.Find(ParsedIntCompanyID); SearchCompany searchcompany1 = new SearchCompany(); List <Company> NewCompanies = new List <Company>(); if (compinfo != null) { //compinfo.CompanyCode = frmcollection["CompanyCode"].ToString(); compinfo.CompanyName = frmcollection["CompanyName"].ToString(); compinfo.Phase = frmcollection["Phase"].ToString(); compinfo.Address = frmcollection["Address"].ToString(); searchcompany1.ZoneList = db.Zone.Where(x => x.ZoneGroup == SingleZoneGroupId.ToString()).ToList(); searchcompany1.BillingRateList = db.BillingRates.Select(z => z).ToList(); compinfo.UpdateDate = DateTime.Now.Date; compinfo.Status = frmcollection["Status"].ToString(); compinfo.OwnershipType = frmcollection["EditOwnershipType"].ToString(); compinfo.EnterpriseType = frmcollection["EnterpriseType"].ToString(); compinfo.SendEmail = frmcollection["SendEmail"].ToString(); compinfo.PrimaryEmailAddress = frmcollection["EmailAddress"].ToString(); compinfo.SecondaryEmailAddress = frmcollection["SecondaryEmailAddress"].ToString(); if (frmcollection["Vatable"].ToString() == "YES") { compinfo.Vat = 12; compinfo.VatableItems = frmcollection["Vatable"].ToString(); } else if (frmcollection["Vatable"].ToString() == "NO") { compinfo.VatableItems = "NO"; } else { compinfo.VatableItems = ""; } try { compinfo.DateOfRegistration = Convert.ToDateTime(frmcollection["EditDateOfRegistration"].ToString()); } catch { } if (searchcompany1.ZoneList.Count != 0) { compinfo.ZoneCode = frmcollection["ZoneCode"].ToString(); } try { if (searchcompany1.BillingRateList.Count != 0) { compinfo.WithHolding = frmcollection["WithHolding"].ToString(); } } catch (Exception) { //compinfo.VatableItems = null; compinfo.WithHolding = null; db.Entry(compinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } finally { db.Entry(compinfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } else { Response.Write("<script> alert('Update Failed!') </script>"); TempData["IsSuccess"] = false; } int parsedCompanyID = int.Parse(frmcollection["CompanyID"]); SearchCompany searchcompany = new SearchCompany(); int CompId = Convert.ToInt32(frmcollection["CompanyID"]); //NewCompanies = db.Company.Select(x => x).OrderBy(x => x.CompanyName).Take(10).ToList(); NewCompanies = db.Company.Where(x => x.CompanyID == CompId).ToList(); SearchCompanyPerGroup searchCompanyPerGroup = new SearchCompanyPerGroup(NewCompanies, ZoneGroup); searchcompany.CompanyList = searchCompanyPerGroup.Companies; searchcompany.ZoneList = db.Zone.Where(x => x.ZoneGroup == SingleZoneGroupId.ToString()).ToList(); TempData["IsSuccess"] = true; TempData["TransactionSuccess"] = "Edit"; TempData["searchcompany"] = searchcompany; TempData["SelectedCompany"] = "COMPHIDE"; return(RedirectToAction("ViewCompany", "MaintenanceCompany")); }
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); }