public ActionResult FileClaimDetails(string sSelectedDate, string sMenu)
{
using (HiPaaS_website_offshoreEntities entites = new HiPaaS_website_offshoreEntities())
{
//List<FileClaimDetails> model = new List<FileClaimDetails>();
//foreach (FileInTake fileInTake in _entityContext.FileInTakes.OrderByDescending(p => p.FileDate))
//{
// model.Add(new FileClaimDetails
// {
// FileStatus = fileInTake.ExtraField2,
// FileData = BindFileIntakeData(fileInTake),
// IntakeClaimDataList = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).Take(10).ToList(),
// });
//}
ViewBag.FileCount = Convert.ToInt32(_entityContext.SP_GetFileInTakeCount(sSelectedDate).FirstOrDefault());
List <FileClaimDetails> model = new List <FileClaimDetails>();
if (!string.IsNullOrEmpty(sSelectedDate))
{
List <string> data = new List <string>();
string strClaimStatus = "";
string adjudication_status = "";
if (sMenu == "FEC")
{
strClaimStatus = "File Error";
data = _entityContext.FileInTakes.Where(o => o.ExtraField2 == strClaimStatus && o.FileDate.Contains(sSelectedDate)).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "SC" || sMenu == "total")
{
strClaimStatus = "";
data = _entityContext.IntakeClaimDatas.Where(o => o.FileDate.Contains(sSelectedDate)).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "AC")
{
strClaimStatus = "Accepted";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == strClaimStatus && o.FileDate.Contains(sSelectedDate)).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "EC")
{
strClaimStatus = "Rejected";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == strClaimStatus && o.FileDate.Contains(sSelectedDate)).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "Paid")
{
adjudication_status = "Paid";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == "Accepted" && o.adjudication_status == adjudication_status && o.FileDate.Contains(sSelectedDate)).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
strClaimStatus = "Accepted";
}
else if (sMenu == "Denied")
{
adjudication_status = "Partial Paid";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == "Accepted" && o.adjudication_status == adjudication_status && o.FileDate.Contains(sSelectedDate)).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
strClaimStatus = "Accepted";
}
else if (sMenu == "WIP")
{
adjudication_status = "Work in Progress";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == "Accepted" && o.adjudication_status == adjudication_status && o.FileDate.Contains(sSelectedDate)).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
strClaimStatus = "Accepted";
}
if (strClaimStatus != "")
{
foreach (var FileID in data)
{
if (strClaimStatus == "Accepted" && adjudication_status != "")
{
foreach (FileInTake fileInTake in _entityContext.FileInTakes.Where(x => x.FileID == FileID))
{
model.Add(new FileClaimDetails
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID && o.ClaimStatus == strClaimStatus && o.adjudication_status == adjudication_status).Take(10).ToList(),
intake_claim_count = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).ToList().Count(),
});
}
}
else
{
foreach (FileInTake fileInTake in _entityContext.FileInTakes.Where(x => x.FileID == FileID))
{
model.Add(new FileClaimDetails
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID && o.ClaimStatus == strClaimStatus).Take(10).ToList(),
intake_claim_count = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).ToList().Count(),
});
}
}
}
}
else
{
foreach (FileInTake fileInTake in _entityContext.FileInTakes.Where(x => x.FileDate.Contains(sSelectedDate)).OrderByDescending(p => p.FileDate))
{
model.Add(new FileClaimDetails
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).Take(10).ToList(),
intake_claim_count = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).ToList().Count(),
});
}
}
}
else
{
List <string> data = new List <string>();
string strClaimStatus = "";
string adjudication_status = "";
if (sMenu == "FEC")
{
strClaimStatus = "File Error";
data = _entityContext.FileInTakes.Where(o => o.ExtraField2 == strClaimStatus).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "SC" || sMenu == "total")
{
strClaimStatus = "";
data = _entityContext.IntakeClaimDatas.OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "AC")
{
strClaimStatus = "Accepted";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == strClaimStatus).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "EC")
{
strClaimStatus = "Rejected";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == strClaimStatus).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "Paid")
{
adjudication_status = "Paid";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == "Accepted" && o.adjudication_status == adjudication_status).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
strClaimStatus = "Accepted";
}
else if (sMenu == "Denied")
{
adjudication_status = "Partial Paid";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == "Accepted" && o.adjudication_status == adjudication_status).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
strClaimStatus = "Accepted";
}
else if (sMenu == "WIP")
{
adjudication_status = "Work in Progress";
data = _entityContext.IntakeClaimDatas.Where(o => o.ClaimStatus == "Accepted" && o.adjudication_status == adjudication_status).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
strClaimStatus = "Accepted";
}
foreach (var FileID in data)
{
if (strClaimStatus != "")
{
if (strClaimStatus == "Accepted" && adjudication_status != "")
{
foreach (FileInTake fileInTake in _entityContext.FileInTakes.Where(x => x.FileID == FileID))
{
model.Add(new FileClaimDetails
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID && o.ClaimStatus == strClaimStatus && o.adjudication_status == adjudication_status).Take(10).ToList(),
intake_claim_count = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).ToList().Count(),
});
}
}
else
{
foreach (FileInTake fileInTake in _entityContext.FileInTakes.Where(x => x.FileID == FileID))
{
model.Add(new FileClaimDetails
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID && o.ClaimStatus == strClaimStatus).Take(10).ToList(),
intake_claim_count = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).ToList().Count(),
});
}
}
}
else
{
foreach (FileInTake fileInTake in _entityContext.FileInTakes.Where(x => x.FileID == FileID))
{
model.Add(new FileClaimDetails
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).Take(10).ToList(),
intake_claim_count = _entityContext.IntakeClaimDatas.Where(o => o.FileID == fileInTake.FileID).ToList().Count(),
});
}
}
}
}
return(View("FileClaimDetails", model.OrderByDescending(x => x.FileData.FileDate)));
}
}
public ActionResult Claimspayment835Details(string sSelectedDate, string sMenu)
{
using (HiPaaS_website_offshoreEntities entites = new HiPaaS_website_offshoreEntities())
{
ViewBag.FileCount = Convert.ToInt32(_entityContext.SP_GetFileInTake835Count(sSelectedDate).FirstOrDefault());
List <FileClaimDetails835> model = new List <FileClaimDetails835>();
if (!string.IsNullOrEmpty(sSelectedDate))
{
foreach (FileInTake835 fileInTake in _entityContext.FileInTake835.Where(x => x.FileDate.Contains(sSelectedDate)).OrderByDescending(p => p.FileDate))
{
model.Add(new FileClaimDetails835
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimData835.Where(o => o.FileID == fileInTake.FileID).Take(10).ToList(),
});
}
}
else
{
List <string> data = new List <string>();
string strClaimStatus = "";
if (sMenu == "FEC")
{
strClaimStatus = "File Error";
data = _entityContext.FileInTake835.Where(o => o.ExtraField2 == strClaimStatus).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "SC" || sMenu == "total")
{
strClaimStatus = "";
data = _entityContext.IntakeClaimData835.OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "AC")
{
strClaimStatus = "Accepted";
data = _entityContext.IntakeClaimData835.Where(o => o.ClaimStatus == strClaimStatus).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
else if (sMenu == "EC")
{
strClaimStatus = "Errors";
data = _entityContext.IntakeClaimData835.Where(o => o.ClaimStatus == strClaimStatus).OrderByDescending(p => p.FileDate).Select(o => o.FileID).Distinct().ToList();
}
foreach (var FileID in data)
{
if (strClaimStatus != "")
{
foreach (FileInTake835 fileInTake in _entityContext.FileInTake835.Where(x => x.FileID == FileID))
{
model.Add(new FileClaimDetails835
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimData835.Where(o => o.FileID == fileInTake.FileID && o.ClaimStatus == strClaimStatus).Take(10).ToList(),
});
}
}
else
{
foreach (FileInTake835 fileInTake in _entityContext.FileInTake835.Where(x => x.FileID == FileID))
{
model.Add(new FileClaimDetails835
{
FileStatus = fileInTake.ExtraField2,
FileData = BindFileIntakeData(fileInTake),
IntakeClaimDataList = _entityContext.IntakeClaimData835.Where(o => o.FileID == fileInTake.FileID).Take(10).ToList(),
});
}
}
}
}
return(View("Claimspayment835Details", model));
}
}
public ClaimPaymentController()
{
_entityContext = new HiPaaS_website_offshoreEntities();
}
public AdminController()
{
_entityContext = new HiPaaS_website_offshoreEntities();
}
public Batch276Controller()
{
_entityContext = new HiPaaS_website_offshoreEntities();
}
public EligibilityController()
{
_entityContext = new HiPaaS_website_offshoreEntities();
}
