public ActionResult ManageDepartDesignation(int page = 1, string sort = "EmployeeID", string sortDir = "asc", string Search = "", short tmid = 0) { TeamDepartmentListPagedModel model = new TeamDepartmentListPagedModel(); try { int pageSize = clsGlobalCommon.PageSize; Session["TMName"] = repoTeamMember.GetTeamMemberNameById(tmid); Session["tmid"] = tmid; model = repoTeamDepartment.GetTeamDepartmentAndDesignation(page, pageSize, sort.ToLower(), sortDir.ToLower(), Search, tmid); 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 TeamDepartmentListPagedModel GetTeamDepartmentAndDesignation(int pageNo, int pageSize, string sort, string sortDir, string Search = "", short teammemberId = 0) { try { if (pageNo < 0) { pageNo = 1; } IQueryable <TeamDepartment> data = db.TeamDepartments.Include("TeamMember").Include("MasterDepartment").Include("MasterDesignation").Where(r => r.TeamMemberRowID == teammemberId); switch (sort) { default: data = sortDir == "asc" ? data.OrderBy(d => d.TeamDepartmentRowID) : data.OrderByDescending(d => d.TeamDepartmentRowID); break; } TeamDepartmentListPagedModel model = new TeamDepartmentListPagedModel(); model.PageSize = pageSize; model.TotalRecords = data.Count(); model.TeamDepartmentList = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new TeamDepartmentViewModel { TeamDepartmentRowID = item.TeamDepartmentRowID, DepartmentRowID = item.DepartmentRowID, DepartmentName = item.MasterDepartment.DepartmentName, DesignationRowID = item.DesignationRowID, DesignationName = item.MasterDesignation.DesignationName, TeamMemberRowID = item.TeamMemberRowID, Status = item.Status, }).ToList(); return(model); } catch (Exception) { throw; } }