public async Task <IActionResult> Edit(int id, [Bind("Reportid,Claimreason,Reportdate,Policyid,Userid")] ClaimReport claimReport) { if (id != claimReport.Reportid) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(claimReport); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ClaimReportExists(claimReport.Reportid)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["Policyid"] = new SelectList(_context.PolicyDetails, "Policyid", "Policyid", claimReport.Policyid); ViewData["Userid"] = new SelectList(_context.PolicyHolder, "Userid", "Email", claimReport.Userid); return(View(claimReport)); }
public async Task Save(ClaimReport report) { var fileStream = File.Create(Path.Combine(_folderName, $"{DateTime.Now:dd.MM.yyyy HH.mm.ss}.json")); using (var streamWriter = new StreamWriter(fileStream)) { await streamWriter.WriteLineAsync(JsonConvert.SerializeObject(report)); } }
public async Task <IActionResult> Create([Bind("Reportid,Claimreason,Reportdate,Policyid,Userid")] ClaimReport claimReport) { if (ModelState.IsValid) { _context.Add(claimReport); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["Policyid"] = new SelectList(_context.PolicyDetails, "Policyid", "Policyid", claimReport.Policyid); ViewData["Userid"] = new SelectList(_context.PolicyHolder, "Userid", "Email", claimReport.Userid); return(View(claimReport)); }
public ActionResult getClaimsData(ClaimModel data) { var context = new RRRoadwaysDBContext(); int vehicleNumber = Convert.ToInt32(data.VehicleNumber); List <ClaimReport> griddata = new List <ClaimReport>(); var claims = context.VehicleClaim .Join(context.Vehicle, vc => vc.VehicleId, v => v.Id, (vc, v) => new { VoucherNumber = v.Voucher, Date = vc.ClaimDate, Vechicle = vc.VehicleId, VechicleNumber = v.VehicleNumber, Claim = vc.Claim, Description = vc.Description, Amount = vc.Amount }).Where(c => c.Date.Value.Date >= data.StartDate.Date) .Where(c => c.Date.Value.Date <= data.EndDate.Date) .Where(c => data.VehicleNumber != "-1" ? c.Vechicle == vehicleNumber : 1 == 1).ToList(); if (claims.Count > 0) { foreach (var item in claims) { ClaimReport obj = new ClaimReport() { SerialNo = griddata.Count + 1, Date = item.Date.Value.Date, VehicleNumber = item.VechicleNumber, Claim = item.Claim, Description = item.Description, Amount = item.Amount, }; griddata.Add(obj); } } return(Json(new { data = griddata }, new Newtonsoft.Json.JsonSerializerSettings())); }
private ClaimReportView getClaimListingReport(List <ClaimReport> reportData, DateTime txtFromDateTime, DateTime txtToDateTime, int[] ddlCarrierList, string[] gvLocationList) { List <ClaimReport> ClaimReportArr = new List <ClaimReport>(); int clientID = SessionHelper.getClientId(); ClaimReportView ClaimReportViewObj = new ClaimReportView(); List <ClaimReportAverage> ClaimReportAverageArr = new List <ClaimReportAverage>(); ClaimReportAverage ClaimReportAverageObj = new ClaimReportAverage(); decimal totalCoverageA = 0; decimal totalCoverageB = 0; decimal totalCoverageC = 0; decimal totalCoverageD = 0; decimal totalCoverageE = 0; decimal totalOtherCoverage = 0; decimal totalOurInvoice = 0; decimal totalQty = 0; for (var i = 0; i < reportData.Count; i++) { string insureBranch = getInsureBranch(reportData[i].claimId); string insuredName = getInsuredName(reportData[i].claimId); string examinerName = ""; if (reportData[i].ExaminerId != null) { int examinerId = Convert.ToInt32(reportData[i].ExaminerId); examinerName = getExaminerName(examinerId); } if (((reportData[i].DateReceived >= txtFromDateTime && reportData[i].DateClosed <= txtToDateTime) || txtToDateTime == DateTime.MinValue) && gvLocationList.Contains(insureBranch) && ddlCarrierList.Contains(Convert.ToInt32(reportData[i].CarrierId))) { ClaimReport ClaimReportObj = new ClaimReport(); ClaimReportObj.AdjusterClaimNumber = reportData[i].AdjusterClaimNumber; ClaimReportObj.InsurerClaim = reportData[i].InsurerClaim; ClaimReportObj.InsuredName = insuredName; TimeSpan span = Convert.ToDateTime(reportData[i].DateClosed) - Convert.ToDateTime(reportData[i].DateReceived); ClaimReportObj.DaystoClose = span.Days; ClaimReportObj.DateReceived = reportData[i].DateReceived; ClaimReportObj.DateClosed = reportData[i].DateClosed; ClaimReportObj.InsureBranch = reportData[i].InsureBranch; ClaimReportObj.OurAdjuster = reportData[i].OurAdjuster; ClaimReportObj.claimId = reportData[i].claimId; ClaimReportObj.CarrierExaminer = examinerName; int policyId = reportData[i].policyId; ClaimReportObj.CoverageA = 0; ClaimReportObj.CoverageB = 0; ClaimReportObj.CoverageC = 0; ClaimReportObj.CoverageD = 0; ClaimReportObj.CoverageE = 0; ClaimReportObj.OtherCoverage = 0; ClaimReportObj.CoverageA = PolicyLimitManager.getPolicyLimitAmount("A", policyId); ClaimReportObj.CoverageB = PolicyLimitManager.getPolicyLimitAmount("B", policyId); ClaimReportObj.CoverageC = PolicyLimitManager.getPolicyLimitAmount("C", policyId); ClaimReportObj.CoverageD = PolicyLimitManager.getPolicyLimitAmount("D", policyId); ClaimReportObj.CoverageE = PolicyLimitManager.getPolicyLimitAmount("E", policyId); ClaimReportObj.OtherCoverage = PolicyLimitManager.getPolicyLimitAmountOther(policyId); ClaimReportObj.OurInvoice = InvoiceDetailManager.getTotalInvoice(reportData[i].claimId); ClaimReportObj.Miles = InvoiceDetailManager.getTotalMiles(reportData[i].claimId, clientID); ClaimReportObj.CoverageA = Decimal.Round(Convert.ToDecimal(ClaimReportObj.CoverageA), 2); ClaimReportObj.CoverageB = Decimal.Round(Convert.ToDecimal(ClaimReportObj.CoverageB), 2); ClaimReportObj.CoverageC = Decimal.Round(Convert.ToDecimal(ClaimReportObj.CoverageC), 2); ClaimReportObj.CoverageD = Decimal.Round(Convert.ToDecimal(ClaimReportObj.CoverageD), 2); ClaimReportObj.CoverageE = Decimal.Round(Convert.ToDecimal(ClaimReportObj.CoverageE), 2); ClaimReportObj.OtherCoverage = Decimal.Round(Convert.ToDecimal(ClaimReportObj.OtherCoverage), 2); ClaimReportObj.OurInvoice = Decimal.Round(Convert.ToDecimal(ClaimReportObj.OurInvoice), 2); ClaimReportObj.Miles = Decimal.Round(Convert.ToDecimal(ClaimReportObj.Miles), 2); if (ClaimReportObj.CoverageA != null) { totalCoverageA = Decimal.Round(totalCoverageA + Convert.ToDecimal(ClaimReportObj.CoverageA), 2); } if (ClaimReportObj.CoverageB != null) { totalCoverageB = Decimal.Round(totalCoverageB + Convert.ToDecimal(ClaimReportObj.CoverageB), 2); } if (ClaimReportObj.CoverageC != null) { totalCoverageC = Decimal.Round(totalCoverageC + Convert.ToDecimal(ClaimReportObj.CoverageC), 2); } if (ClaimReportObj.CoverageD != null) { totalCoverageD = Decimal.Round(totalCoverageD + Convert.ToDecimal(ClaimReportObj.CoverageD), 2); } if (ClaimReportObj.CoverageE != null) { totalCoverageE = Decimal.Round(totalCoverageE + Convert.ToDecimal(ClaimReportObj.CoverageE), 2); } if (ClaimReportObj.OtherCoverage != null) { totalOtherCoverage = Decimal.Round(totalOtherCoverage + Convert.ToDecimal(ClaimReportObj.OtherCoverage), 2); } if (ClaimReportObj.OurInvoice != null) { totalOurInvoice = Decimal.Round(totalOurInvoice + Convert.ToDecimal(ClaimReportObj.OurInvoice), 2); } if (ClaimReportObj.Miles != null) { totalQty = Decimal.Round(totalQty + Convert.ToDecimal(ClaimReportObj.Miles), 2); } ClaimReportArr.Add(ClaimReportObj); } } if (reportData != null && reportData.Count != 0) { ClaimReportViewObj.claimReportArr = ClaimReportArr; ClaimReportAverageObj.totalCoverageA = totalCoverageA; ClaimReportAverageObj.totalCoverageB = totalCoverageB; ClaimReportAverageObj.totalCoverageC = totalCoverageC; ClaimReportAverageObj.totalCoverageD = totalCoverageD; ClaimReportAverageObj.totalCoverageE = totalCoverageE; ClaimReportAverageObj.totalOtherCoverage = totalOtherCoverage; ClaimReportAverageObj.totalOurInvoice = totalOurInvoice; ClaimReportAverageObj.totalMiles = totalQty; } if (reportData != null && reportData.Count != 0) { ClaimReportAverageObj.avgCoverageA = Decimal.Round(totalCoverageA / reportData.Count, 2); ClaimReportAverageObj.avgCoverageB = Decimal.Round(totalCoverageB / reportData.Count, 2); ClaimReportAverageObj.avgCoverageC = Decimal.Round(totalCoverageC / reportData.Count, 2); ClaimReportAverageObj.avgCoverageD = Decimal.Round(totalCoverageD / reportData.Count, 2); ClaimReportAverageObj.avgCoverageE = Decimal.Round(totalCoverageE / reportData.Count, 2); ClaimReportAverageObj.avgOtherCoverage = Decimal.Round(totalOtherCoverage / reportData.Count, 2); ClaimReportAverageObj.avgOurInvoice = Decimal.Round(totalOurInvoice / reportData.Count, 2); ClaimReportAverageObj.avgMiles = Decimal.Round(totalQty / reportData.Count, 2); } ClaimReportAverageArr.Add(ClaimReportAverageObj); ClaimReportViewObj.ClaimReportAverageObj = ClaimReportAverageArr; return(ClaimReportViewObj); }