public void LoadData()
{
string TextSearch = "";
string RefundFee = "";
int Status = 0;
string CreatedBy = "";
string CreatedDate = "";
if (Request.QueryString["textsearch"] != null)
{
TextSearch = Request.QueryString["textsearch"].Trim();
}
if (Request.QueryString["status"] != null)
{
Status = Request.QueryString["status"].ToInt();
}
if (Request.QueryString["refundfee"] != null)
{
RefundFee = Request.QueryString["refundfee"];
}
if (Request.QueryString["CreatedBy"] != null)
{
CreatedBy = Request.QueryString["createdby"];
}
if (Request.QueryString["createddate"] != null)
{
CreatedDate = Request.QueryString["createddate"];
}
txtSearchOrder.Text = TextSearch;
ddlStatus.SelectedValue = Status.ToString();
ddlRefundFee.SelectedValue = RefundFee.ToString();
ddlCreatedBy.Text = CreatedBy.ToString();
ddlCreatedDate.SelectedValue = CreatedDate.ToString();
List <RefundOrder> rs = new List <RefundOrder>();
rs = RefundGoodController.Filter(TextSearch, Status, RefundFee, CreatedBy, CreatedDate);
string username = Request.Cookies["userLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
if (acc.RoleID == 0)
{
if (CreatedBy != "")
{
rs = rs.Where(x => x.CreatedBy == CreatedBy).ToList();
pagingall(rs);
}
else
{
pagingall(rs);
}
}
else
{
rs = rs.Where(x => x.CreatedBy == acc.Username).ToList();
pagingall(rs);
}
// THỐNG KÊ ĐƠN HÀNG
int TotalOrders = rs.Count;
int Type1Orders = 0;
int Type2Orders = 0;
int TotalProducts = 0;
double TotalMoney = 0;
double TotalRefundFee = 0;
for (int i = 0; i < rs.Count; i++)
{
var item = rs[i];
// Tính tổng số sản phẩm trong tổng số đơn hàng
TotalProducts += item.Quantity;
// Tính tổng đơn hàng sỉ và lẻ
if (item.Status == 2)
{
Type2Orders++;
}
if (item.Status == 1)
{
Type1Orders++;
}
// Tính số tiền
TotalMoney += item.TotalPrice;
TotalRefundFee += item.TotalRefundFee;
}
ltrTotalOrders.Text = TotalOrders.ToString();
ltrType2Orders.Text = Type2Orders.ToString();
ltrType1Orders.Text = Type1Orders.ToString();
ltrTotalProducts.Text = TotalProducts.ToString();
ltrTotalMoney.Text = string.Format("{0:N0}", Convert.ToDouble(TotalMoney)).ToString();
ltrTotalRefundFee.Text = string.Format("{0:N0}", Convert.ToDouble(TotalRefundFee)).ToString();
ltrNumberOfOrder.Text = TotalOrders.ToString();
}
}
public void LoadData()
{
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
string TextSearch = String.Empty;
string RefundFee = String.Empty;
int Status = 0;
string CreatedBy = String.Empty;
string CreatedDate = String.Empty;
int Page = 1;
if (Request.QueryString["textsearch"] != null)
{
TextSearch = Request.QueryString["textsearch"].Trim();
}
if (Request.QueryString["status"] != null)
{
Status = Request.QueryString["status"].ToInt();
}
if (Request.QueryString["refundfee"] != null)
{
RefundFee = Request.QueryString["refundfee"];
}
if (Request.QueryString["CreatedBy"] != null)
{
CreatedBy = Request.QueryString["createdby"];
}
if (Request.QueryString["createddate"] != null)
{
CreatedDate = Request.QueryString["createddate"];
}
if (Request.QueryString["Page"] != null)
{
Page = Request.QueryString["Page"].ToInt();
}
txtSearchOrder.Text = TextSearch;
ddlStatus.SelectedValue = Status.ToString();
ddlRefundFee.SelectedValue = RefundFee.ToString();
ddlCreatedBy.Text = CreatedBy.ToString();
ddlCreatedDate.SelectedValue = CreatedDate.ToString();
ddlCreatedBy.Enabled = acc.RoleID == 0;
var filter = new RefundFilterModel()
{
search = TextSearch,
status = Status,
feeStatus = RefundFee,
dateTimePicker = CreatedDate,
staff = acc.RoleID != 0 ? acc.Username : CreatedBy
};
// Create pagination
var pagination = new PaginationMetadataModel()
{
currentPage = Page
};
var rs = RefundGoodController.Filter(filter, ref pagination);
pagingall(rs, pagination);
ltrNumberOfOrder.Text = pagination.totalCount.ToString();
PageCount = pagination.totalPages;
}
}