public FileStreamResult ExcelView(Models.UserSearchModel data) { DataTable users = new DataTable(); try { if (data.SearchString == null) { data.SearchString = ""; } if (data.SearchString == "") { data.SearchValue = 0; } users = BLayer.User.GetAllB2BForExcel(data.Status, data.SearchString, data.SearchValue, (int)CLayer.Role.Roles.Corporate); } catch (Exception ex) { Common.LogHandler.HandleError(ex); } return(new FileStreamResult(DataTableToExcel.GetExcelStream(users, "Report", true, null, null, null), DataTableToExcel.CONTENT_TYPE_XLSX) { FileDownloadName = "CorporateDetails.xlsx" }); }
public ActionResult Filter(Models.UserSearchModel data) { if (data.SearchString == null) { data.SearchString = ""; } if (data.SearchString == "") { data.SearchValue = 0; } List <CLayer.User> users = BLayer.User.GetAllB2BForSearch(data.Status, data.SearchString, data.SearchValue, (int)CLayer.Role.Roles.Corporate, 0, PAGE_LIMIT); ViewBag.Filter = new Models.UserSearchModel(); Models.UserSearchModel forPager = new Models.UserSearchModel() { Status = data.Status, SearchString = data.SearchString, SearchValue = data.SearchValue, userlist = users, TotalRows = 0, Limit = PAGE_LIMIT, currentPage = 1 }; if (users.Count > 0) { forPager.TotalRows = users[0].TotalRows; } ViewBag.Filter = forPager; return(PartialView("_List", users)); }
public ActionResult Pager1(Models.UserSearchModel data) { if (data.SearchString == null) { data.SearchString = ""; } List <CLayer.User> users = BLayer.User.GetAllB2BForSearch(data.Status, data.SearchString, data.SearchValue, (int)CLayer.Role.Roles.Affiliate, (data.currentPage - 1) * data.Limit, data.Limit); ViewBag.Filter = new Models.UserSearchModel(); Models.UserSearchModel forPager = new Models.UserSearchModel() { Status = data.Status, SearchString = data.SearchString, SearchValue = data.SearchValue, userlist = users, TotalRows = 0, Limit = 25, currentPage = data.currentPage }; if (users.Count > 0) { forPager.TotalRows = users[0].TotalRows; } ViewBag.Filter = forPager; return(PartialView("List", users)); }
public ActionResult Pager1(Models.UserSearchModel data) { if (data.SearchString == null) { data.SearchString = ""; } if (data.SearchString == "") { data.SearchValue = 0; } int Statusfor = 1; if (data.Statusfor == false) { Statusfor = 0; } else { Statusfor = 1; } List <CLayer.User> users = new List <CLayer.User>(); if (data.InventoryAPIType <= 2) { users = BLayer.User.GetAllPropertyStatusWithType(Statusfor, data.PropertyStatus, data.InventoryAPIType, data.SearchString, data.SearchValue, (int)CLayer.Role.Roles.Supplier, 0, 25); } else { users = BLayer.User.GetAllPropertyStatus(Statusfor, data.PropertyStatus, data.SearchString, data.SearchValue, (int)CLayer.Role.Roles.Supplier, 0, 25); } ViewBag.Filter = new Models.UserSearchModel(); Models.UserSearchModel forPager = new Models.UserSearchModel() { PropertyStatus = data.PropertyStatus, SearchString = data.SearchString, SearchValue = data.SearchValue, userlist = users, TotalRows = 0, Limit = 25, Statusfor = data.Statusfor, currentPage = data.currentPage }; if (users.Count > 0) { forPager.TotalRows = users[0].TotalRows; } ViewBag.Filter = forPager; return(PartialView("_List", users)); }
public ActionResult Index() { Models.UserSearchModel search = new Models.UserSearchModel(); List <CLayer.User> users = BLayer.User.GetAllB2BForSearch((int)CLayer.ObjectStatus.StatusType.Active, "", 0, (int)CLayer.Role.Roles.Corporate, 0, PAGE_LIMIT); search.Status = (int)CLayer.ObjectStatus.StatusType.Active; search.SearchString = ""; search.SearchValue = 1; search.userlist = users; search.TotalRows = 0; if (users.Count > 0) { search.TotalRows = users[0].TotalRows; } search.Limit = PAGE_LIMIT; search.currentPage = 1; ViewBag.Filter = search; return(View(search)); }
public ActionResult Index() { Models.UserSearchModel search = new Models.UserSearchModel(); List <CLayer.User> users = BLayer.User.GetAllPropertyStatus(0, (int)CLayer.ObjectStatus.StatusType.Active, "", 0, (int)CLayer.Role.Roles.Supplier, 0, 25); search.PropertyStatus = (int)CLayer.ObjectStatus.StatusType.Active; search.Statusfor = false; search.SearchString = ""; search.SearchValue = 0; search.userlist = users; search.TotalRows = 0; if (users.Count > 0) { search.TotalRows = users[0].TotalRows; } search.Limit = 25; search.currentPage = 1; ViewBag.Filter = search; return(View(search)); }