public void UpdateOrderInfo(OrderBO order)
{
orderDao.UpdateOrderInfo(order);
}
public OrderBO InsertOrderInfo(OrderBO order)
{
return orderDao.InsertOrderInfo(order);
}
public OrderBO InsertOrderInfo(OrderBO order)
{
using (var context = new InThuDoEntities())
{
Order entity = new Order() {
Deposit = order.Deposit,
DepositTypeId = order.DepositTypeId,
ShippingMethodId = order.ShippingMethodId,
OrderDate = order.OrderDate,
CustomerId = order.CustomerId,
UserId = order.BusinessManId,
CreatedBy = order.CreatedBy,
CreatedDate = order.CreatedDate,
LastEditedBy = order.LastEditedBy,
LastEditedDate = order.LastEditedDate,
ExpectedCompleteDate = order.ExpectedCompleteDate,
Note = order.Note,
DeliveryAddress = order.DeliveryAddress,
ApprovedByCustomer = order.ApprovedByCustomer,
ApprovedDate = order.ApprovedDate,
VAT = order.VAT
};
context.Orders.Add(entity);
context.Entry(entity).State = System.Data.EntityState.Added;
context.SaveChanges();
order.OrderId = entity.OrderId;
return order;
}
}
public void UpdateOrderInfo(OrderBO order)
{
using (var context = new InThuDoEntities())
{
Order entity = context.Orders.Where(o => o.OrderId == order.OrderId).FirstOrDefault();
entity.OrderDate = order.OrderDate;
entity.Deposit = order.Deposit;
entity.DepositTypeId = order.DepositTypeId;
entity.ShippingMethodId = order.ShippingMethodId;
entity.CustomerId = order.CustomerId;
entity.UserId = order.BusinessManId;
entity.LastEditedBy = order.LastEditedBy;
entity.LastEditedDate = order.LastEditedDate;
entity.ExpectedCompleteDate = order.ExpectedCompleteDate;
entity.Note = order.Note;
entity.DeliveryAddress = order.DeliveryAddress;
entity.ApprovedByCustomer = order.ApprovedByCustomer;
entity.ApprovedDate = order.ApprovedDate;
entity.VAT = order.VAT;
entity.Note = order.Note;
context.Entry(entity).State = System.Data.EntityState.Modified;
context.SaveChanges();
}
}
public decimal GetOrderTotal(OrderBO order)
{
using (var context = new InThuDoEntities())
{
var orderDetail = from od in context.OrderItems
where od.OrderId == order.OrderId
&& (od.Deleted == false || od.Deleted == null)
select od;
decimal orderTotal = 0;
if (orderDetail != null)
{
foreach (OrderItem oi in orderDetail.ToList())
{
orderTotal += oi.Quantity * oi.Price;
}
}
return orderTotal;
}
}