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