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();
}
}
