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