public ActionResult ManageTeamMembers(int page = 1, string sort = "TMFirstName", string sortDir = "asc", string Search = "") { TeamMemberListPagedModel model = new TeamMemberListPagedModel(); try { int pageSize = clsGlobalCommon.PageSize; model = repoTeamMember.GetTeamMember(page, pageSize, sort.ToLower(), sortDir.ToLower(), Search); if (model == null) { ViewBag.ErrorMsg = "No item found!"; } } catch (Exception Ex) { ViewBag.ErrorMsg = Ex.Message; clsCommonMethods.ErrorLog(Server.MapPath("~\\ErrorLogs\\Logfiles"), Ex.Message, Ex.StackTrace); } return(View(model)); }
public TeamMemberListPagedModel GetTeamMember(int pageNo, int pageSize, string sort, string sortDir, string Search = "") { try { if (pageNo < 0) { pageNo = 1; } IQueryable <TeamMember> data = db.TeamMembers; if (!string.IsNullOrEmpty(Search)) { data = data.Where(b => b.EmployeeID.ToString().Contains(Search.ToString().Trim()) || (b.TMTitle + b.TMFirstName + b.TMLastName).ToString().Contains(Search.ToString().Trim()) || b.MobileNo.ToString().Contains(Search.ToString().Trim()) || b.EmailID.ToString().Contains(Search.ToString().Trim())); } switch (sort) { case "tmfirstname": data = sortDir == "asc" ? data.OrderBy(d => d.TMFirstName) : data.OrderByDescending(d => d.TMFirstName); break; default: data = sortDir == "asc" ? data.OrderBy(d => d.EmployeeID) : data.OrderByDescending(d => d.EmployeeID); break; } TeamMemberListPagedModel model = new TeamMemberListPagedModel(); model.PageSize = pageSize; model.TotalRecords = data.Count(); model.TeamMembers = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new TeamMemberViewModel { TeamMemberRowID = item.TeamMemberRowID, LocationRowID = item.LocationRowID, CategoryRowID = item.CategoryRowID, TMTitle = item.TMTitle, TMFirstName = item.TMFirstName, TMLastName = item.TMLastName, FTitle = item.FTitle, FFirstName = item.FFirstName, FLastName = item.FLastName, FullName = item.TMTitle + " " + item.FLastName + " " + item.FLastName, FatherFullName = item.FTitle + " " + item.SpouseFirstName + " " + item.FLastName, SpouseName = item.SpouseFirstName, SpouseLastName = item.SpouseFirstName, EmployeeID = item.EmployeeID, DOB = item.DOB, DOJ = item.DOJ, PresentAddress = item.PresentAddress, PermanentAddress = item.PermanentAddress, STD = item.STD, ResidancePhoneNo = item.ResidancePhoneNo, MobileNo = item.MobileNo, EmailID = item.EmailID, DirectTelNo = item.DirectTelNo, ProcessStatus = item.ProcessStatus, UserType = item.UserType, Status = item.Status, BranchName = item.MasterCompanyBranch.BOName }).ToList(); return(model); } catch (Exception) { throw; } }