public WebUserListPagedModel GetWebUser(int pageNo, int pageSize, string sort, string sortDir, string Search = "")
{
try
{
if (pageNo < 0)
{
pageNo = 1;
}
IQueryable <WebUser> data = db.WebUsers.Include("TeamMember").Where(w => w.Status == 1);
if (!string.IsNullOrEmpty(Search))
{
data = data.Where(w => w.CRPUserName.ToString().Contains(Search.ToString().Trim()));
}
switch (sort)
{
case "crpusername":
data = sortDir == "asc" ? data.OrderBy(d => d.CRPUserName) : data.OrderByDescending(d => d.CRPUserName);
break;
default:
data = sortDir == "asc" ? data.OrderBy(d => d.WebUserRowID) : data.OrderByDescending(d => d.WebUserRowID);
break;
}
WebUserListPagedModel model = new WebUserListPagedModel();
model.PageSize = pageSize;
model.TotalRecords = data.Count();
model.WebUsers = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new WebUserViewModel
{
WebUserRowID = item.WebUserRowID,
CRPUserName = item.CRPUserName,
CRPPassWord = item.CRPPassWord,
CreatedDate = item.CreatedDate,
TeamMemberRoWID = item.TeamMemberRoWID,
TeamMemberName = item.TeamMember.TMFirstName + " " + item.TeamMember.TMLastName,
IsExportedExcel = item.IsExportedExcel,
IsExportedPDF = item.IsExportedPDF,
IsExportedWord = item.IsExportedWord,
Status = item.Status
}).ToList();
return(model);
}
catch (Exception)
{
throw;
}
}
public ActionResult ManageWebUsers(int page = 1, string sort = "CRPUserName", string sortDir = "asc", string Search = "")
{
WebUserListPagedModel model = new WebUserListPagedModel();
try
{
int pageSize = clsGlobalCommon.PageSize;
model = repoWebUser.GetWebUser(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));
}
