public ActionResult ClaimCounts(string sDate)
{
//sDate = "20190123";
int totalFile = Convert.ToInt32(_entityContext.SP_GetFileInTake835Count(sDate).FirstOrDefault());
int SubCount = _entityContext.IntakeClaimData835.Where(o => o.FileDate.Contains(sDate)).ToList().Count();
int AccCount = _entityContext.IntakeClaimData835.Where(x => x.ClaimStatus == "Accepted" && x.FileDate.Contains(sDate)).ToList().Count();
int NotAccCount = SubCount - AccCount;
int PenCount = _entityContext.IntakeClaimData835.Where(x => x.ClaimStatus == "Pending").ToList().Count();
int RejCount = _entityContext.IntakeClaimData835.Where(x => x.ClaimStatus == "Errors" && x.FileDate.Contains(sDate)).ToList().Count();
int FailedFileCount = _entityContext.FileInTake835.Where(x => x.ExtraField2 == "File Error" && x.FileDate.Contains(sDate)).ToList().Count();
Dashboard835ViewModel model = new Dashboard835ViewModel();
model.FileDate = sDate;
model.FileCount = totalFile;
model.SubmittedClaimCount = SubCount;
model.AcceptedClaimCount = AccCount;
model.NotAcceptedClaimCount = NotAccCount;
model.PendingClaimCount = PenCount;
model.RejectedClaimCount = RejCount;
//model.EDIFailLoadCount = NotAccCount - PenCount - RejCount;
model.EDIFailLoadCount = FailedFileCount;
return(PartialView("_Dashboard835", model));
}
// GET: ClaimPayment
public ActionResult Index()
{
int SubCount = _entityContext.IntakeClaimData835.ToList().Count();
int AccCount = _entityContext.IntakeClaimData835.Where(x => x.ClaimStatus == "Accepted").ToList().Count();
int NotAccCount = SubCount - AccCount;
int PenCount = _entityContext.IntakeClaimData835.Where(x => x.ClaimStatus == "Pending").ToList().Count();
int RejCount = _entityContext.IntakeClaimData835.Where(x => x.ClaimStatus == "Errors").ToList().Count();
int FailedFileCount = _entityContext.FileInTake835.Where(x => x.ExtraField2 == "File Error").ToList().Count();
Dashboard835ViewModel model = new Dashboard835ViewModel();
model.FileCount = _entityContext.FileInTake835.ToList().Count();
model.SubmittedClaimCount = SubCount;
model.AcceptedClaimCount = AccCount;
model.NotAcceptedClaimCount = NotAccCount;
model.PendingClaimCount = PenCount;
model.RejectedClaimCount = RejCount;
//model.EDIFailLoadCount = NotAccCount - PenCount - RejCount;
model.EDIFailLoadCount = FailedFileCount;
model.PendingClaimError = _entityContext.SP_GetPendingClaimError().ToList();
model.RejectedClaimError = _entityContext.SP_GetRejectedClaimError().ToList();
model.SubmittedClaimAmount = SubCount * 1000;
model.AcceptedClaimAmount = SubCount * 800;
model.NotAcceptedClaimAmount = SubCount * 200;
model.fileclaim_list = GetFileDataForDashbaord();
return(View(model));
}