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);
}
