public static void cancel(int postOfficeID)
{
DeliveryPostOfficeController.cancel(postOfficeID);
}
private void importExcel(string pathFile)
{
// Lấy stream file
var fs = new FileStream(pathFile, FileMode.Open);
// Khởi tạo workbook để đọc
var wb = new XSSFWorkbook(fs);
// Lấy sheet đầu tiên
var sheet = wb.GetSheetAt(0);
var postOffices = new List <DeliveryPostOffice>();
// Lấy data từ dòng thứ 3 cho đến hết file
for (int index = 2; index <= sheet.LastRowNum; index++)
{
var row = sheet.GetRow(index);
var item = new DeliveryPostOffice();
var regex = new Regex(@"^[0-9]+$");
var isNumber = regex.Match(row.GetCell(0).StringCellValue);
// OrderID
if (isNumber.Success)
{
item.OrderID = Convert.ToInt32(row.GetCell(0).StringCellValue);
}
// NumberID
item.NumberID = row.GetCell(1).StringCellValue;
// Customer
item.Customer = row.GetCell(8).StringCellValue;
// Phone
item.Phone = row.GetCell(9).StringCellValue;
// City
item.City = row.GetCell(10).StringCellValue;
// Town
item.Town = row.GetCell(11).StringCellValue;
// Ward
item.Ward = row.GetCell(12).StringCellValue;
// Address
item.Address = row.GetCell(13).StringCellValue;
// Delivery Status
item.DeliveryStatus = row.GetCell(26).StringCellValue;
// Start Date
item.StartDate = row.GetCell(14).DateCellValue;
// Expect Date
if (!String.IsNullOrEmpty(row.GetCell(15).ToString()))
{
item.ExpectDate = row.GetCell(15).DateCellValue;
}
else
{
item.ExpectDate = DateTime.Now;
}
// Tiền thu hộ
item.COD = Convert.ToDecimal(row.GetCell(17).NumericCellValue);
// Tiền phí
item.Fee = Convert.ToDecimal(row.GetCell(25).NumericCellValue);
// Staff
item.Staff = String.Empty;
// Setting trạng thái review với order
item.Review = (int)DeliveryPostOfficeReview.NoApprove;
item.OrderStatus = (int)OrderStatus.Exist;
postOffices.Add(item);
// Thưc thi review các order sau khi đoc 100 dòng execl
if (postOffices.Count == 100)
{
DeliveryPostOfficeController.reviewOrder(postOffices);
postOffices.Clear();
}
}
// Thưc thi review các order sau khi đoc dòng excel còn lại
if (postOffices.Count > 0)
{
DeliveryPostOfficeController.reviewOrder(postOffices);
postOffices.Clear();
}
wb.Close();
fs.Close();
}
public static string approve(int postOfficeID, int orderID)
{
return(DeliveryPostOfficeController.approve(postOfficeID, orderID));
}
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 OrderFromDate = DateConfig;
DateTime OrderToDate = DateTime.Now;
if (!String.IsNullOrEmpty(Request.QueryString["orderfromdate"]))
{
OrderFromDate = Convert.ToDateTime(Request.QueryString["orderfromdate"]);
}
if (!String.IsNullOrEmpty(Request.QueryString["ordertodate"]))
{
OrderToDate = Convert.ToDateTime(Request.QueryString["ordertodate"]).AddDays(1).AddMinutes(-1);
}
rOrderFromDate.SelectedDate = OrderFromDate;
rOrderFromDate.MinDate = DateConfig;
rOrderFromDate.MaxDate = DateTime.Now;
rOrderToDate.SelectedDate = OrderToDate;
rOrderToDate.MinDate = DateConfig;
rOrderToDate.MaxDate = DateTime.Now;
string TextSearch = String.Empty;
int orderStatus = 0;
string deliveryStatus = String.Empty;
int review = 0;
int feeStatus = 0;
int Page = 1;
if (Request.QueryString["textsearch"] != null)
{
TextSearch = Request.QueryString["textsearch"].Trim();
}
if (Request.QueryString["orderstatus"] != null)
{
orderStatus = Request.QueryString["orderstatus"].ToInt(0);
}
if (Request.QueryString["deliverystatus"] != null)
{
deliveryStatus = Request.QueryString["deliverystatus"];
}
if (Request.QueryString["review"] != null)
{
review = Request.QueryString["review"].ToInt(0);
}
if (Request.QueryString["feestatus"] != null)
{
feeStatus = Request.QueryString["feestatus"].ToInt(0);
}
if (Request.QueryString["Page"] != null)
{
Page = Request.QueryString["Page"].ToInt();
}
txtSearchOrder.Text = TextSearch;
ddlOrderStatus.SelectedValue = orderStatus.ToString();
ddlDeliveryStatus.SelectedValue = deliveryStatus.ToString();
ddlReview.SelectedValue = review.ToString();
ddlFeeStatus.SelectedValue = feeStatus.ToString();
// Create delivery post office fileter
var filter = new DeliveryPostOfficeFilterModel()
{
search = TextSearch,
orderStatus = orderStatus,
deliveryStatus = deliveryStatus,
review = review,
feeStatus = feeStatus,
orderFromDate = OrderFromDate,
orderToDate = OrderToDate
};
// Create pagination
var page = new PaginationMetadataModel()
{
currentPage = Page
};
decimal lossMoney = 0;
List <DeliveryPostOffice> rs = new List <DeliveryPostOffice>();
rs = DeliveryPostOfficeController.Filter(filter, ref page, ref lossMoney);
pagingall(rs, page);
ltrNumberOfOrder.Text = String.Format("{0} số đơn bưu điện - Số tiền phí lệch: {1:#,###} VND", page.totalCount.ToString(), lossMoney);
}
}
