public ActionResult ViewClaimApplications(bool ShowNew)
{
var modelList = new List <AdminClaimApplicationModel>();
if (ShowNew)
{
}
//read all querries regardless
var query = (from application in _database.tbl_applications
join claimapplication in _database.tbl_claimapplications
on application.appl_id equals claimapplication.appl_id
where application.admin_id.Equals((int)Session["adminId"])
join claimant in _database.tbl_claimants
on claimapplication.claimant_id equals claimant.claimaint_id
select new
{
applicationid = application.appl_id,
date = application.date_created,
claimant_email = claimant.email,
status = application.isActive,
claim_nmber = claimapplication.claim_number
}).ToList();
if (query != null)
{
foreach (var item in query)
{
var model = new AdminClaimApplicationModel()
{
applicationid = item.applicationid,
datecreated = item.date,
claimnumber = item.claim_nmber,
email = item.claimant_email,
status = item.status.ToString()
};
modelList.Add(model);
}
}
return(View(modelList));
}
//[HttpPost]
public ActionResult ViewUserRegistrations()
{
var results = _database.tbl_claimapplications.ToList();
var modelList = new List <AdminClaimApplicationModel>();
foreach (var d in results)
{
var rec = _database.tbl_applications.FirstOrDefault(e => e.appl_id.Equals(d.appl_id) && e.isActive.Equals(true));
if (rec != null)
{
var model = new AdminClaimApplicationModel()
{
applicationid = rec.appl_id,
datecreated = rec.date_created,
claimnumber = d.claim_number,
email = _database.tbl_claimants.FirstOrDefault(cl => cl.claimaint_id.Equals(d.claimant_id)).email
};
modelList.Add(model);
}
}
return(View(modelList));
}
