public void LoadData() { string username = Request.Cookies["loginHiddenPage"].Value; var acc = AccountController.GetByUsername(username); DateTime DateConfig = new DateTime(2019, 12, 15); var config = ConfigController.GetByTop1(); if (config.ViewAllOrders == 1) { DateConfig = new DateTime(2018, 6, 22); } DateTime fromDate = DateConfig; DateTime toDate = DateTime.Now; if (!String.IsNullOrEmpty(Request.QueryString["orderfromdate"])) { fromDate = Convert.ToDateTime(Request.QueryString["orderfromdate"]); } if (!String.IsNullOrEmpty(Request.QueryString["ordertodate"])) { toDate = Convert.ToDateTime(Request.QueryString["ordertodate"]).AddDays(1).AddMinutes(-1); } rFromDate.SelectedDate = fromDate; rFromDate.MinDate = DateConfig; rFromDate.MaxDate = DateTime.Now; rToDate.SelectedDate = toDate; rToDate.MinDate = DateConfig; rToDate.MaxDate = DateTime.Now; string textSearch = ""; int categoryID = 0; int registerStatus = 0; int Page = 1; if (Request.QueryString["textsearch"] != null) { textSearch = Request.QueryString["textsearch"].Trim(); } if (Request.QueryString["categoryid"] != null) { categoryID = Request.QueryString["categoryid"].ToInt(); } if (Request.QueryString["registerstatus"] != null) { registerStatus = Request.QueryString["registerstatus"].ToInt(0); } if (Request.QueryString["Page"] != null) { Page = Request.QueryString["Page"].ToInt(); } txtSearchProduct.Text = textSearch; ddlCategory.SelectedValue = categoryID.ToString(); ddlRegisterStatus.SelectedValue = registerStatus.ToString(); // Create order fileter var filter = new RegisterProductFilterModel() { search = textSearch, category = categoryID, status = registerStatus, createdBy = acc.Username, fromDate = fromDate, toDate = toDate }; // Create pagination var page = new PaginationMetadataModel() { currentPage = Page, pageSize = 30 }; List <RegisterProductList> rs = new List <RegisterProductList>(); rs = RegisterProductController.Filter(filter, ref page); pagingall(rs, page); ltrHeading.Text = "Danh sách đặt hàng (" + page.totalCount.ToString() + ")"; ltrAccount.Text = "Tài khoản: <strong>" + acc.Username + "</strong>"; }
public void LoadData() { string username = Request.Cookies["usernameLoginSystem"].Value; var acc = AccountController.GetByUsername(username); if (acc != null) { DateTime DateConfig = new DateTime(2019, 12, 15); var config = ConfigController.GetByTop1(); if (config.ViewAllOrders == 1) { DateConfig = new DateTime(2018, 6, 22); } DateTime fromDate = DateConfig; DateTime toDate = DateTime.Now; if (!String.IsNullOrEmpty(Request.QueryString["orderfromdate"])) { fromDate = Convert.ToDateTime(Request.QueryString["orderfromdate"]); } if (!String.IsNullOrEmpty(Request.QueryString["ordertodate"])) { toDate = Convert.ToDateTime(Request.QueryString["ordertodate"]).AddDays(1).AddMinutes(-1); } rFromDate.SelectedDate = fromDate; rFromDate.MinDate = DateConfig; rFromDate.MaxDate = DateTime.Now; rToDate.SelectedDate = toDate; rToDate.MinDate = DateConfig; rToDate.MaxDate = DateTime.Now; string textSearch = String.Empty; int registerStatus = 0; string createdBy = String.Empty; string color = String.Empty; string size = String.Empty; var isRegisterProductSession = false; int Page = 1; if (Request.QueryString["textsearch"] != null) { textSearch = Request.QueryString["textsearch"].Trim(); } if (Request.QueryString["registerstatus"] != null) { registerStatus = Request.QueryString["registerstatus"].ToInt(0); } if (Request.QueryString["createdby"] != null) { createdBy = Request.QueryString["createdby"]; } if (Request.QueryString["color"] != null) { color = Request.QueryString["color"]; } if (Request.QueryString["size"] != null) { size = Request.QueryString["size"]; } if (Request.QueryString["isregisterproductsession"] != null) { isRegisterProductSession = true; } if (Request.QueryString["Page"] != null) { Page = Request.QueryString["Page"].ToInt(); } txtSearchOrder.Text = textSearch; ddlRegisterStatus.SelectedValue = registerStatus.ToString(); ddlCreatedBy.SelectedValue = createdBy.ToString(); // Create order fileter var filter = new RegisterProductFilterModel() { search = textSearch, status = registerStatus, createdBy = createdBy, fromDate = fromDate, toDate = toDate, color = color, size = size, selected = isRegisterProductSession, account = acc }; // Create pagination var page = new PaginationMetadataModel() { currentPage = Page }; List <RegisterProductList> rs = new List <RegisterProductList>(); rs = RegisterProductController.Filter(filter, ref page); var data = SessionController.getRegisterProductSession(acc); hdfSession.Value = JsonConvert.SerializeObject(data); pagingall(rs, page); ltrNumberOfOrder.Text = page.totalCount.ToString(); } }