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));
        }
示例#3
0
        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));
        }
示例#4
0
        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));
        }
示例#6
0
        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));
        }