private IEnumerable <OrderDO> Get_doOrder()
{
using (var db = new ProjectWebEntities())
{
List <OrderDO> orderList = new List <OrderDO>();
List <Tbl_Order> orderTbl = db.Tbl_Order.ToList();
foreach (var item in orderTbl)
{
var order = new OrderDO();
order.OrderId = item.Id;
var orderstatus = new OrderStatusDO();
orderstatus.OrderStatusId = (int)item.SatusId;
orderstatus.OrderStatus = item.Tbl_OrderStatus.Name;
if (item.Tbl_OrderStatus.Name == null)
{
orderstatus.OrderStatus = "";
}
order.OrderStatus = orderstatus;
order.DateCreate = item.DateCreate;
order.TotalPrice = $"{item.TotalAllPrice:0,0 đ}";
order.PromotionPrice = $"{item.PromotionPrice:0,0 đ}";
order.Payment = "";
switch (item.Payment)
{
case 1:
order.Payment = "Thanh toán qua thẻ";
break;
case 2:
order.Payment = "Thanh toán qua bưu điện";
break;
case 3:
order.Payment = "Thanh toán khi nhận hàng";
break;
}
order.NickName = item.Name;
order.Color = item.Tbl_OrderStatus.Color;
orderList.Add(order);
}
return(orderList);
}
}
public ActionResult OrderStatus_Destroy([DataSourceRequest] DataSourceRequest request, OrderStatusDO model)
{
using (var Db = new ProjectWebEntities())
{
try
{
var m = Db.Tbl_OrderStatus.Find(model.OrderStatusId);
if (m != null)
{
if (Db.Tbl_Order.FirstOrDefault(p => p.SatusId == m.Id) == null)
{
Db.Tbl_OrderStatus.Remove(m);
Db.SaveChanges();
}
// Write log system---------
//Db.pr_LogSystem_save("Xóa dữ liệu(ID = " + model.OrderStatusId + ")", "Xóa", 4, 9, User.Identity.Name, "Thành công", Request.UserHostAddress);
}
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
}
