// for display datatable
public ActionResult GetDonarByBloodGroupList(int id, DataTableParamModel param)
{
var members = _db.Members.ToList().Where(x => x.MemberBloodGroupId == id);
var viewMembers = members.Select(m => new MemberTableModel() { MemberId = Convert.ToString(m.Id), FullName = m.FullName, Address = m.Address, DateOfBirth = Convert.ToString(m.DateOfBirth), PhoneNumber = m.PhoneNumber, MobileNumber = m.MobileNumber, UserName = m.UserName, });
IEnumerable<MemberTableModel> filteredMembers;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredMembers = viewMembers.Where(m => (m.FullName ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredMembers = viewMembers;
}
//var viewOdjects = filteredMembers.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var viewOdjects = filteredMembers;
var result = from pMdl in viewOdjects
select new[] { pMdl.FullName, pMdl.Address, pMdl.DateOfBirth, pMdl.PhoneNumber, pMdl.MobileNumber, pMdl.UserName, pMdl.MemberId };
return Json(new
{
//sEcho = param.sEcho,
iTotalRecords = members.Count(),
iTotalDisplayRecords = filteredMembers.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
//GetBloodRequestList
public ActionResult GetBloodRequests(DataTableParamModel param)
{
var bloodRequests = _db.BloodRequests.ToList();
var viewBloodRequests = bloodRequests.Select(m => new BloodRequestTableModel() { BloodRequestId = Convert.ToString(m.Id), RequesterName = m.RequesterName, RequesterContactNo = m.RequesterContactNo, RequesterAmount = m.RequesterAmount, PresentLocation = m.PresentLocation, DateOfDonation = Convert.ToString(m.DateOfDonation), AppealMessage = m.AppealMessage, RequesterStatus = m.RequesterStatus, RequesterStatusMessage = m.RequesterStatusMessage, RequiredBloodGroupId = Convert.ToString(m.RequiredBloodGroupId), RequiredBloodGroup = m.MemberBloodGroup != null ? m.MemberBloodGroup.BloodGroupName : null, });
IEnumerable<BloodRequestTableModel> filteredBloodRequests;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredBloodRequests = viewBloodRequests.Where(m => (m.RequesterName ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredBloodRequests = viewBloodRequests;
}
var viewOdjects = filteredBloodRequests.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from pMdl in viewOdjects
//select new[] { pMdl.RequesterName, pMdl.RequesterContactNo, pMdl.RequesterAmount, pMdl.PresentLocation, pMdl.DateOfDonation, pMdl.AppealMessage, pMdl.RequiredBloodGroupId, pMdl.RequiredBloodGroup, pMdl.BloodRequestId };
select new[] { pMdl.RequesterName, pMdl.RequesterContactNo, pMdl.RequesterAmount, pMdl.PresentLocation, pMdl.DateOfDonation, pMdl.RequiredBloodGroup, pMdl.RequesterStatus, pMdl.BloodRequestId };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = bloodRequests.Count(),
iTotalDisplayRecords = filteredBloodRequests.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
// for display datatable
public ActionResult GetRoles(DataTableParamModel param)
{
var roles = _db.Roles.ToList();
var viewRoles = roles.Select(rt => new RoleTableModel() { RoleName = rt.RoleName });
IEnumerable<RoleTableModel> filteredRoles;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredRoles = viewRoles.Where(r => (r.RoleName ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredRoles = viewRoles;
}
var viewOdjects = filteredRoles.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from rMdl in viewOdjects
select new[] { rMdl.RoleName };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = roles.Count(),
iTotalDisplayRecords = filteredRoles.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
// for display datatable
public ActionResult GetSendEmailInfos(DataTableParamModel param)
{
var sendEmailInfos = _db.SendEmailInfos.ToList();
var viewSendEmailInfos = sendEmailInfos.Select(sei => new SendEmailInfoTableModel()
{
SendEmailInfoId = Convert.ToString(sei.Id),
SenderName = sei.SenderName,
SenderContactNo = sei.SenderContactNo,
Subject = sei.Subject,
Message = sei.Message,
MemberViewModelId = Convert.ToString(sei.MemberId),
MemberName = sei.Member
!= null ? sei.Member.FullName : null,
});
IEnumerable<SendEmailInfoTableModel> filteredSendEmailInfos;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredSendEmailInfos = viewSendEmailInfos.Where(m => (m.SenderName ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredSendEmailInfos = viewSendEmailInfos;
}
var viewOdjects = filteredSendEmailInfos.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from seiMdl in viewOdjects
select new[] { seiMdl.SenderName, seiMdl.SenderContactNo, seiMdl.Subject, seiMdl.Message, seiMdl.MemberName, seiMdl.SendEmailInfoId };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = sendEmailInfos.Count(),
iTotalDisplayRecords = filteredSendEmailInfos.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
// for display datatable
public ActionResult GetMemberStatues(DataTableParamModel param)
{
var memberStatues = _db.MemberStatues.ToList();
var viewMemberStatues = memberStatues.Select(ms => new MemberStatusTableModel() { MemberStatusId = Convert.ToString(ms.Id), MemberStatusTitle = ms.MemberStatusTitle, MemberStatusDescription = ms.MemberStatusDescription, MemberStatusIcon = ms.MemberStatusIcon });
IEnumerable<MemberStatusTableModel> filteredMemberStatues;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredMemberStatues = viewMemberStatues.Where(ms => (ms.MemberStatusTitle ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredMemberStatues = viewMemberStatues;
}
var viewOdjects = filteredMemberStatues.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from mzMdl in viewOdjects
select new[] { mzMdl.MemberStatusTitle, mzMdl.MemberStatusDescription, mzMdl.MemberStatusIcon, mzMdl.MemberStatusId };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = memberStatues.Count(),
iTotalDisplayRecords = filteredMemberStatues.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
// for display datatable
public ActionResult GetMemberBloodGroups(DataTableParamModel param)
{
var memberBloodGroups = _db.MemberBloodGroups.ToList();
var viewMemberBloodGroups = memberBloodGroups.Select(md => new MemberBloodGroupTableModel() { MemberBloodGroupId = Convert.ToString(md.Id), BloodGroupName = md.BloodGroupName });
IEnumerable<MemberBloodGroupTableModel> filteredMemberBloodGroups;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredMemberBloodGroups = viewMemberBloodGroups.Where(mbg => (mbg.BloodGroupName ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredMemberBloodGroups = viewMemberBloodGroups;
}
var viewOdjects = filteredMemberBloodGroups.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from mbgMdl in viewOdjects
select new[] { mbgMdl.BloodGroupName, mbgMdl.MemberBloodGroupId };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = memberBloodGroups.Count(),
iTotalDisplayRecords = filteredMemberBloodGroups.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
// for display datatable
public ActionResult GetPosts(DataTableParamModel param)
{
var posts = _db.Posts.ToList();
var viewPosts = posts.Select(pt => new PostTableModel() { PostId = Convert.ToString(pt.Id), Title = pt.Title, Content = pt.Content, CreateDate = Convert.ToString(pt.CreateDate), UserName = pt.UserName, });
IEnumerable<PostTableModel> filteredPosts;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredPosts = viewPosts.Where(m => (m.Title ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredPosts = viewPosts;
}
var viewOdjects = filteredPosts.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from pMdl in viewOdjects
select new[] { pMdl.Title, pMdl.Content, pMdl.CreateDate, pMdl.UserName, pMdl.PostId };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = posts.Count(),
iTotalDisplayRecords = filteredPosts.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
// for display datatable
public ActionResult GetComments(DataTableParamModel param)
{
var comments = _db.Comments.ToList();
var viewComments = comments.Select(ct => new CommentTableModel() { CommentId = Convert.ToString(ct.Id), Name = ct.Name, Email = ct.Email, Description = ct.Description, CreateDate = Convert.ToString(ct.CreateDate) });
IEnumerable<CommentTableModel> filteredComments;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredComments = viewComments.Where(c => (c.Name ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredComments = viewComments;
}
var viewOdjects = filteredComments.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from cMdl in viewOdjects
select new[] { cMdl.Name, cMdl.Email, cMdl.Description, cMdl.CreateDate, cMdl.CommentId };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = comments.Count(),
iTotalDisplayRecords = filteredComments.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
// for display datatable
public ActionResult GetMemberHospitals(DataTableParamModel param)
{
var memberHospitals = _db.MemberHospitals.ToList();
var viewMemberHospitals = memberHospitals.Select(mh => new MemberHospitalTableModel() { MemberHospitalId = Convert.ToString(mh.Id), HospitalName = mh.HospitalName, Address = mh.Address, LocationX = mh.LocationX, LocationY = mh.LocationY, MemberZoneId = Convert.ToString(mh.MemberZoneId), MemberZoneName = mh.MemberZone != null ? mh.MemberZone.ZoneName : null });
IEnumerable<MemberHospitalTableModel> filteredMemberHospitals;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredMemberHospitals = viewMemberHospitals.Where(mh => (mh.HospitalName ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredMemberHospitals = viewMemberHospitals;
}
var viewOdjects = filteredMemberHospitals.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from mzMdl in viewOdjects
select new[] { mzMdl.HospitalName, mzMdl.Address, mzMdl.LocationX, mzMdl.LocationY, mzMdl.MemberZoneName, mzMdl.MemberHospitalId };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = memberHospitals.Count(),
iTotalDisplayRecords = filteredMemberHospitals.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
// for display datatable
public ActionResult GetUsers(DataTableParamModel param)
{
var users = _db.Users.ToList();
var viewUsers = users.Select(usr => new UserTableModel() { UserId = Convert.ToString(usr.UserName), UserName = usr.UserName, Email = usr.Email, IsApproved = usr.IsApproved == true ? "Yes" : "No" });
IEnumerable<UserTableModel> filteredUsers;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredUsers = viewUsers.Where(usr => (usr.UserName ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredUsers = viewUsers;
}
var viewOdjects = filteredUsers.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from usrMdl in viewOdjects
select new[] { usrMdl.UserName, usrMdl.UserName, usrMdl.Email, usrMdl.IsApproved, usrMdl.UserName };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = users.Count(),
iTotalDisplayRecords = filteredUsers.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
