public async Task <IActionResult> Create([Bind("IdCustomerRegion,CustomerRegionName,IdCustomerCountry")] CustomerCountryRegionVM customerCountryRegionVM) { if (ModelState.IsValid) { try { CustomerRegions region = new CustomerRegions(); region.CustomerRegionName = customerCountryRegionVM.CustomerRegionName; region.IdCustomerCountry = customerCountryRegionVM.IdCustomerCountry; _context.Add(region); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } catch (Exception e) { Console.WriteLine(e.Message); } } ViewData["IdCustomerCountry"] = new SelectList(_context.CustomerCountries, "IdCustomerCountry", "IdCustomerCountry"); return(View(customerCountryRegionVM)); }
public async Task <IActionResult> Edit(int id, [Bind("IdCustomerRegion,CustomerRegionName,IdCustomerCountry")] CustomerRegions customerRegions) { if (id != customerRegions.IdCustomerRegion) { return(NotFound()); } if (ModelState.IsValid) { try { var region = _context.CustomerRegions.FirstOrDefault(c => c.IdCustomerRegion == customerRegions.IdCustomerRegion); region.CustomerRegionName = customerRegions.CustomerRegionName; _context.Update(region); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CustomerRegionsExists(customerRegions.IdCustomerRegion)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["IdCustomerCountry"] = new SelectList(_context.CustomerCountries, "IdCustomerCountry", "IdCustomerCountry"); return(View(customerRegions)); }
} // constructor public List <LoanStatsReportEntry> Generate() { var oResult = new List <LoanStatsReportEntry>(); foreach (KeyValuePair <int, List <LoanStatsDataEntry> > pair in Data) { int nCustomerID = pair.Key; foreach (LoanStatsDataEntry lse in pair.Value) { var lre = new LoanStatsReportEntry(); oResult.Add(lre); lre.IsFirstLoan = lse.IsLoanIssued ? ((lse.IsFirstLoan ? "" : "not ") + "first") : ""; lre.ClientLoanOrderNo = lse.LoanSeqNo; lre.TypeOfLoan = lse.ApprovedType; lre.CustomerSelection = lse.IsLoanTypeSelectionAllowed ? 1 : 0; lre.DiscountPlan = lse.DiscountPlanName; lre.Offline = lse.IsOffline ? "offline" : "online"; lre.LoanID = lse.IsLoanIssued ? lse.LoanID : (int?)null; lre.ClientID = lse.CustomerID; lre.ClientName = lse.CustomerName; lre.DateFirstApproved = lse.FirstDecisionDate; lre.DateLastApproved = lse.LastDecisionDate.Date; lre.NewOrOldClient = lse.IsNewClient ? "new" : "old"; lre.LoanOffered = lse.ApprovedSum; lre.InterestRate = lse.ApprovedRate; lre.LoanIssued = lse.IsLoanIssued ? lse.LoanAmount : (decimal?)null; lre.IsLoanIssued = lse.IsLoanIssued ? "yes" : "no"; lre.LoanIssueDate = lse.IsLoanIssued ? lse.IssueDate : (DateTime?)null; lre.LoanDuration = lse.IsLoanIssued ? lse.LoanTerm : (int?)null; lre.CreditScore = lse.CreditScore; lre.TotalAnnualTurnover = lse.AnnualTurnover; lre.Medal = ((object)lse.Medal).ToString().ToLower(); SortedDictionary <int, int> oMarketplaceCount = CustomerMarketplaces.ContainsKey(lse.CustomerID) ? CustomerMarketplaces[lse.CustomerID].Count(lse.FirstDecisionDate) : LoanStatsMarketplaces.Count(); foreach (KeyValuePair <int, int> mpc in oMarketplaceCount) { lre.MarketplaceCount[mpc.Key] = mpc.Value; } lre.PaypalTotal = CustomerPaypalTotals.ContainsKey(lse.CustomerID) ? CustomerPaypalTotals[lse.CustomerID].Calculate(lse.FirstDecisionDate) : 0; lre.Gender = lse.Gender.ToString().ToLower(); lre.YearOfBirth = lse.BirthDate.Year; switch (lse.MaritalStatus) { case MaritalStatus.Married: lre.FamilyStatus = 1; break; case MaritalStatus.Single: lre.FamilyStatus = 0; break; case MaritalStatus.Divorced: lre.FamilyStatus = 2; break; case MaritalStatus.Widowed: lre.FamilyStatus = 3; break; case MaritalStatus.LivingTogether: lre.FamilyStatus = 4; break; case MaritalStatus.Separated: lre.FamilyStatus = 5; break; case MaritalStatus.Other: lre.FamilyStatus = 0; break; default: throw new ArgumentOutOfRangeException( "MaritalStatus", (object)lse.MaritalStatus, "Unsupported marital status." ); } // switch if (lse.IsHomeOwner) { lre.HomeOwnership = 1; } else { switch (lse.PropertyStatusDescription.ToLower()) { case "social house": lre.HomeOwnership = 3; break; case "renting": lre.HomeOwnership = 0; break; case "living with parents": lre.HomeOwnership = 2; break; default: lre.HomeOwnership = null; break; } // switch } switch (lse.TypeOfBusiness) { case TypeOfBusiness.Entrepreneur: case TypeOfBusiness.SoleTrader: lre.TypeOfBusiness = 0; break; case TypeOfBusiness.LLP: case TypeOfBusiness.Limited: lre.TypeOfBusiness = 2; break; case TypeOfBusiness.PShip3P: case TypeOfBusiness.PShip: lre.TypeOfBusiness = 1; break; default: throw new ArgumentOutOfRangeException(); } // switch lre.SourceRef = lse.ReferenceSource; lre.Category1 = ""; // TODO lre.Category2 = ""; // TODO lre.Category3 = ""; // TODO lre.Region = CustomerRegions.ContainsKey(nCustomerID) ? CustomerRegions[nCustomerID] : ""; lre.LastCashRequestID = lse.RequestIDHistory[lse.RequestIDHistory.Count - 1]; } // for each entry } // for each customer return(oResult); } // Generate