public ActionResult AjaxFeedbackList(VmJqueryDatatable param) { var userid = HttpContext.Request.GetOwinContext().Request.User.Identity.GetUserId(); var loggedInDonorId = appDbContext.Users.FirstOrDefault(f => f.Id == userid).ReferrenceId ?? 0; var test = db.Blog.Where(w => w.BloodDonorHeaderId == loggedInDonorId).ToList(); var result = test.Where(p => p.Attribute1 == "feedback" && p.IsDisabled != true).Select(s => new { BlogHeaderId = s.BlogId, Date = s.CreationDate != null ? s.CreationDate.Value.ToString("dd MMM yyyy") : "", Description = s.Details }).ToList(); return(Json(new { sEcho = param.draw, iTotalRecords = result.Count, iTotalDisplayRecords = result, data = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult AjaxDonorList(VmJqueryDatatable param) { var test = db.BloodDonors.Where(w => w.ReadyForDonate != false).ToList(); var flex = db.ConfigValueSets.AsEnumerable(); var district = db.District.AsEnumerable(); var division = db.Division.AsEnumerable(); var result = test.Select(s => new { DonorHeaderId = s.BloodDonorHeaderId, BloodGroup = flex.FirstOrDefault(f => f.ConfigValueId == s.Bloodgroup) != null? flex.FirstOrDefault(f => f.ConfigValueId == s.Bloodgroup).ConfigValue:"", Location = (division.FirstOrDefault(f => f.DivisionHeaderId == s.Division) != null ? division.FirstOrDefault(f => f.DivisionHeaderId == s.Division).DivisionName + ", " : "") + (district.FirstOrDefault(f => f.DistrictHeaderId == s.District) != null ? district.FirstOrDefault(f => f.DistrictHeaderId == s.District).DistrictName : ""), Mobile = s.MobileNo, Name = s.BloodDonorName, LastDonationDate = s.LastDonated != null?s.LastDonated.Value.ToString("dd MMM yyyy"):"" }).ToList(); return(Json(new { sEcho = param.draw, iTotalRecords = result.Count, iTotalDisplayRecords = result, data = result }, JsonRequestBehavior.AllowGet)); }