public OrderInfo InsertOrder(OrderInfo obj_order)
{
Guid id = Guid.NewGuid();
obj_order.OrderID = id.ToString();
obj_order.OrderNo = CreateOrderNo();
using (OnlineShoppingDataContext db = new OnlineShoppingDataContext())
{
tbl_OrderInfo tbl_order = new tbl_OrderInfo();
tbl_order.OrderID = obj_order.OrderID;
tbl_order.OrderNo = obj_order.OrderNo;
tbl_order.OrderDate = obj_order.OrderDate;
tbl_order.OrderQuantity = obj_order.OrderQuantity;
tbl_order.DiscountAmount = obj_order.DiscountAmount;
tbl_order.DeliveryCharges = obj_order.DeliveryCharges;
tbl_order.OrderAmount = obj_order.OrderAmount;
tbl_order.Tax = obj_order.Tax;
tbl_order.OrderDescription = obj_order.OrderDescription;
tbl_order.OrderStatus = obj_order.OrderStatus;
tbl_order.CustomerID = obj_order.CustomerID;
db.tbl_OrderInfos.InsertOnSubmit(tbl_order);
db.SubmitChanges();
}
return(obj_order);
}
public void UpdateOrderStatus(OrderInfo obj_orderInfo)
{
using (OnlineShoppingDataContext db = new OnlineShoppingDataContext())
{
tbl_OrderInfo table_orderinfo = (from a in db.tbl_OrderInfos where a.OrderID == obj_orderInfo.OrderID select a).FirstOrDefault();
if (table_orderinfo != null)
{
table_orderinfo.OrderStatus = obj_orderInfo.OrderStatus;
table_orderinfo.EstDeliveryDate = obj_orderInfo.EstDeliveryDate;
db.SubmitChanges();
}
}
}
