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