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