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