public PQClientUserListPagedModel GetClientUsers(int pageNo, int pageSize, string sort, string sortDir, string Search = "", short ClientRowID = 0) { try { if (pageNo < 0) { pageNo = 1; } IQueryable <PQClientLogin> data = db.PQClientLogins; if (ClientRowID > 0) { data = data.Where(c => c.ClientRowID == ClientRowID); } if (!string.IsNullOrEmpty(Search)) { data = data.Where(b => b.PQClientMaster.MasterAbbreviation.ClientName.ToString().Contains(Search)); } switch (sort) { case "clientname": data = sortDir == "asc" ? data.OrderBy(d => d.PQClientMaster.MasterAbbreviation.ClientName) : data.OrderByDescending(d => d.PQClientMaster.MasterAbbreviation.ClientName); break; default: data = sortDir == "asc" ? data.OrderBy(d => d.ModifiedTime) : data.OrderByDescending(d => d.ModifiedTime); break; } PQClientUserListPagedModel model = new PQClientUserListPagedModel(); model.PageSize = pageSize; model.TotalRecords = data.Count(); model.ClientUsers = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new PQClientLoginViewModel { ClientUserRowID = item.ClientUserRowID, ClientRowID = item.ClientRowID, ClientName = item.PQClientMaster.MasterAbbreviation.ClientName, ClientBranch = item.ClientBranch, CreatedTime = item.CreatedTime, ModifiedTime = item.ModifiedTime, UserID = item.UserID, CreatedBy = item.CreatedBy, SentMailStatus = item.SentMailStatus, SentMailDate = item.SentMailDate, Status = item.Status, }).ToList(); return(model); } catch (Exception) { throw; } }
public PQClientUserListPagedModel GetBlockedClientUser(int pageNo, int pageSize, string sort, string sortDir, string ClientName = "", string UserName = "") { try { if (pageNo < 0) { pageNo = 1; } IQueryable <PQClientLogin> data = db.PQClientLogins.Where(w => w.Status == 3); if (!string.IsNullOrEmpty(ClientName) || !string.IsNullOrEmpty(UserName)) { data = data.Where(b => (b.UserID.Contains(UserName) //|| b.PQClientMaster.MasterAbbreviation.ClientName.Contains(UserName) )); } switch (sort) { case "clientname": data = sortDir == "asc" ? data.OrderBy(d => d.PQClientMaster.MasterAbbreviation.ClientName) : data.OrderByDescending(d => d.PQClientMaster.MasterAbbreviation.ClientName); break; case "createdtime": data = sortDir == "asc" ? data.OrderBy(d => d.CreatedTime) : data.OrderByDescending(d => d.CreatedTime); break; default: data = sortDir == "asc" ? data.OrderBy(d => d.ModifiedTime) : data.OrderByDescending(d => d.ModifiedTime); break; } PQClientUserListPagedModel model = new PQClientUserListPagedModel(); model.PageSize = pageSize; model.TotalRecords = data.Count(); model.ClientUsers = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new PQClientLoginViewModel { ClientUserRowID = item.ClientUserRowID, ClientRowID = item.ClientRowID, ClientName = item.PQClientMaster.MasterAbbreviation.ClientName, CreatedTime = item.CreatedTime, ModifiedTime = item.ModifiedTime, UserID = item.UserID, CreatedBy = item.CreatedBy, SentMailStatus = item.SentMailStatus, SentMailDate = item.SentMailDate, Status = item.Status, }).ToList(); return(model); } catch (Exception) { throw; } }
public ActionResult UnBlockedUserClient(int page = 1, string sort = "CRPUserName", string sortDir = "asc", string ClientName = "", string UserName = "") { PQClientUserListPagedModel model = new PQClientUserListPagedModel(); try { BindClientList(); int pageSize = clsGlobalCommon.PageSize; model = repoLogin.GetBlockedClientUser(page, pageSize, sort.ToLower(), sortDir.ToLower(), ClientName, UserName); if (model == null) { ViewBag.ErrorMsg = "No item found!"; } } catch (Exception Ex) { ViewBag.ErrorMsg = Ex.Message; } return(View(model)); }