// Xuất danh sách OrderBills
public List <OrderBills> LoadOrderBillsByCustomerPhone(string customerphone)
{
List <OrderBills> orderBillsList = new List <OrderBills>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM OrderBills WHERE CUSTOMERPHONE = N'" + customerphone + "'");
foreach (DataRow item in data.Rows)
{
OrderBills orderbills = new OrderBills(item);
orderBillsList.Add(orderbills);
}
return(orderBillsList);
}
// Xuất danh sách OrderBills
public List <OrderBills> LoadOrderBills()
{
List <OrderBills> orderBillsList = new List <OrderBills>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM OrderBills WHERE RECEIVEDATE IS NOT NULL");
foreach (DataRow item in data.Rows)
{
OrderBills orderbills = new OrderBills(item);
orderBillsList.Add(orderbills);
}
return(orderBillsList);
}
public async Task <IActionResult> OrderConfirmation()
{
List <ObjProducts> objProducts = HttpContext.Session.Get <List <ObjProducts> >("ssShoppingCart");
var Id = User.FindFirstValue(ClaimTypes.NameIdentifier);
OrderBills order = new OrderBills()
{
BillName = ShoppingVM.Order.BillName,
CreatedDate = ShoppingVM.Order.CreatedDate,
CustomerId = Id,
TotalPrice = ShoppingVM.Order.TotalPrice,
ShippingFee = ShoppingVM.Order.ShippingFee,
Status = false
};
_db.Orders.Add(order);
await _db.SaveChangesAsync();
long orderId = order.Id;
ShipperAssignedForOrder forOrder = new ShipperAssignedForOrder()
{
OrderId = order.Id
};
_db.ShipperAssignedForOrders.Add(forOrder);
foreach (var item in objProducts)
{
ProductSelectedForBill productSelectedForBill = new ProductSelectedForBill()
{
ProductId = item.Id,
OrderId = orderId,
ProductQuantity = item.Quantity
};
_db.ProductSelectedForOrders.Add(productSelectedForBill);
var product = _db.Products.Where(p => p.Id == item.Id).FirstOrDefault();
product.Quantity = product.Quantity - item.Quantity;
}
await _db.SaveChangesAsync();
objProducts = new List <ObjProducts>();
HttpContext.Session.Set("ssShoppingCart", objProducts);
return(RedirectToAction("Index", "Home", new { area = "Customer" }));
}