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