public RepoToTeamMemberListPagedModel GetReportedTeamMembers(int pageNo, int pageSize, string sort, string sortDir, string Search = "", short TeamDepartmentRowID = 0)
{
try
{
if (pageNo < 0)
{
pageNo = 1;
}
var ReportingTo = db.TeamMemberReportings.Where(r => r.TeamDepartmentRowID == TeamDepartmentRowID).Select(r => r.ReportingTo).ToList();
RepoToTeamMemberListPagedModel model = new RepoToTeamMemberListPagedModel();
var data = db.TeamDepartments.Where(t => ReportingTo.Contains(t.TeamDepartmentRowID)).Select(t => new RepoToTeamMemberViewModel
{
TeamMemberName = t.TeamMember.TMTitle + " " + t.TeamMember.TMFirstName + " " + t.TeamMember.TMLastName + " (" + t.MasterDesignation.DesignationName + ")",
ReportTeamRowID = db.TeamMemberReportings.Where(r => r.TeamDepartmentRowID == TeamDepartmentRowID && r.ReportingTo == t.TeamDepartmentRowID).FirstOrDefault().ReportTeamRowID,
});
model.PageSize = pageSize;
model.TotalRecords = data.Count();
model.RepoToTeamMembers = data;
return(model);
}
catch (Exception)
{
throw;
}
}
public ActionResult ManageReportedTeamMembers(short tdid = 0)
{
RepoToTeamMemberListPagedModel model = new RepoToTeamMemberListPagedModel();
try
{
int page = 1; string sort = "EmployeeID"; string sortDir = "asc"; string Search = "";
int pageSize = clsGlobalCommon.PageSize;
model = repoTeamMember.GetReportedTeamMembers(page, pageSize, sort.ToLower(), sortDir.ToLower(), Search, tdid);
if (model == null)
{
ViewBag.ErrorMsg = "No item found!";
}
}
catch (Exception Ex)
{
ViewBag.ErrorMsg = Ex.Message;
}
return(View(model));
}