public long CreateOrder(string orderReference, DateTime orderDatetime, decimal orderTotal, decimal deliveryCost, string email, string telephone, string originalJson) { var order = new tOrders { OrderStatus = "Order Confirmed", CreatedAt = orderDatetime, ReferenceNumber = orderReference, OriginalSiteflowJson = originalJson }; _contextPicsMe.tOrders.Add(order); _contextPicsMe.SaveChanges(); return(order.ID); }
public void DownloadRoiOrder(long orderId, double orderTotal, DateTime orderPlacesDate) { var order = _context.tOrders.FirstOrDefault(o => o.ROIOrderId == orderId); if (order == null) { order = new tOrders { ROIOrderId = orderId, CreatedAt = DateTime.Now, OrderTotal = Convert.ToDecimal(orderTotal), OrderPlacedDate = orderPlacesDate }; _context.tOrders.Add(order); _context.SaveChanges(); } }
public void CreateOrderNow(DateTime startDate, DateTime endDate) { var liveorder = (from LO in _context.tLiveOrders where LO.IsConvertedToOrder == false select LO).FirstOrDefault(); if (liveorder != null) { liveorder.IsConvertedToOrder = true; _context.SaveChanges(); tOrders addNewOrder = new tOrders() { LiveOrderId = liveorder.LiveOrderId, OrderStatusId = 1, OrderDate = DateTime.Now, OrderCycleStartDate = startDate, OrderCycleEndDate = endDate, IsDelivered = false, }; _context.tOrders.Add(addNewOrder); _context.SaveChanges(); } }
public void CreateReOrderNow(Int64 liveorderid, DateTime fromDate, DateTime toDate, string OrderFriendlyName) { var liveorder = (from LO in _context.tLiveOrders where LO.LiveOrderId == liveorderid && LO.IsConvertedToOrder == false select LO).FirstOrDefault(); if (liveorder != null) { liveorder.IsConvertedToOrder = true; _context.SaveChanges(); tOrders addNewOrder = new tOrders() { LiveOrderId = liveorder.LiveOrderId, OrderStatusId = 1, OrderDate = DateTime.Now, OrderCycleStartDate = fromDate, OrderCycleEndDate = toDate, IsDelivered = false, OrderFriendlyName = OrderFriendlyName, }; _context.tOrders.Add(addNewOrder); _context.SaveChanges(); } }