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