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 == "Rejected").ToList().Count(); int FailedFileCount = _entityContext.FileInTake835.Where(x => x.ExtraField2 == "File Error").ToList().Count(); Dashboard837ViewModel model = new Dashboard837ViewModel(); 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)); }
// GET: Claims278 public ActionResult Index() { int total = _entityContext.Claims278.ToList().Count(); int SubCount = _entityContext.Claims278.Where(x => x.ErrorCode == "Validate Error").ToList().Count(); int FailedFileCount = _entityContext.Claims278.Where(x => x.ErrorCode == "TA1").ToList().Count(); int AccCount = total - SubCount - FailedFileCount; int NotAccCount = 0; int PenCount = 0; int RejCount = 0; Dashboard837ViewModel model = new Dashboard837ViewModel(); model.FileCount = total; 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; return(View(model)); }
public ActionResult Dashboard834() { int SubCount = _entities.IntakeClaimDatas.ToList().Count(); int AccCount = _entities.IntakeClaimDatas.Where(x => x.ClaimStatus == "Accepted").ToList().Count(); int NotAccCount = SubCount - AccCount; int PenCount = _entities.IntakeClaimDatas.Where(x => x.ClaimStatus == "Pending").ToList().Count(); int RejCount = _entities.IntakeClaimDatas.Where(x => x.ClaimStatus == "Rejected").ToList().Count(); int FailedFileCount = _entities.FileInTakes.Where(x => x.ExtraField2 == "File Error").ToList().Count(); int PaidCount = _entities.IntakeClaimDatas.Where(x => x.ClaimStatus == "Accepted" && x.adjudication_status == "Paid").ToList().Count(); int DeniedCount = _entities.IntakeClaimDatas.Where(x => x.ClaimStatus == "Accepted" && x.adjudication_status == "Denied").ToList().Count(); int WIPCount = _entities.IntakeClaimDatas.Where(x => x.ClaimStatus == "Accepted" && x.adjudication_status == "Work in Progress").ToList().Count(); //int PaidCount = 0; //int DeniedCount = 0; //int WIPCount = 0; Dashboard837ViewModel model = new Dashboard837ViewModel(); model.FileCount = _entities.FileInTakes.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 = _entities.SP_GetPendingClaimError().ToList(); model.RejectedClaimError = _entities.SP_GetRejectedClaimError().ToList(); model.SubmittedClaimAmount = SubCount * 1000; model.AcceptedClaimAmount = SubCount * 800; model.NotAcceptedClaimAmount = SubCount * 200; // model.PaidClaimsCount = PaidCount; model.DeniedClaimsCount = DeniedCount; model.WorkinPClaimsCount = WIPCount; model.fileclaim_list = GetFileDataForDashbaord(); return(View(model)); }