public VendorUserLoggedListPagedModel GetBlockeddPartnerUsers(int pageNo, int pageSize, string sort, string sortDir, string PartnerName = "", string UserName = "")
{
try
{
if (pageNo < 0)
{
pageNo = 1;
}
IQueryable <MasterVendorLogin> data = db.MasterVendorLogins.Where(w => w.Status == 3);
if (!string.IsNullOrEmpty(PartnerName) || !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.MasterVendor.VendorName) : data.OrderByDescending(d => d.MasterVendor.VendorName);
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;
}
VendorUserLoggedListPagedModel model = new VendorUserLoggedListPagedModel();
model.PageSize = pageSize;
model.TotalRecords = data.Count();
model.VendorUser = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new VendorUserLoggedViewModel
{
VendorLoginRowID = item.VendorLoginRowID,
VendorRowID = item.VendorRowID,
VendorName = item.MasterVendor.VendorName,
CreatedTime = item.CreatedTime,
ModifiedTime = item.ModifiedTime,
UserID = item.UserID,
CreatedBy = item.CreatedBy,
Status = item.Status,
}).ToList();
return(model);
}
catch (Exception)
{
throw;
}
}
public ActionResult UnBlockedPartnerUsers(int page = 1, string sort = "CRPUserName", string sortDir = "asc",
string PartnerName = "", string UserName = "")
{
VendorUserLoggedListPagedModel model = new VendorUserLoggedListPagedModel();
try
{
BindClientList();
int pageSize = clsGlobalCommon.PageSize;
model = repoLogin.GetBlockeddPartnerUsers(page, pageSize, sort.ToLower(), sortDir.ToLower(), PartnerName, UserName);
if (model == null)
{
ViewBag.ErrorMsg = "No item found!";
}
}
catch (Exception Ex)
{
ViewBag.ErrorMsg = Ex.Message;
}
return(View(model));
}
