public void SaveOrder(Context.Order order, List <Context.OrderProduct> products)
{
var context = _Services.GetService(typeof(OrderDomainContext)) as OrderDomainContext;
using (var transaction = context.Database.BeginTransaction())
{
try
{
context.Order.Add(order);
context.SaveChanges();
foreach (var product in products)
{
context.OrderProduct.Add(product);
}
context.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
public Domain.Model.Order GetOrderById(int orderId)
{
_logger.LogInformation($"Retrieving order id: {orderId}");
if (orderId == 0)
{
_logger.LogInformation($"Order id is 0, returning null for order.");
return(null);
}
Context.Order returnOrder = _dbContext.Orders
.Include(p => p.Person)
.Include(p => p.Item)
.FirstOrDefault(p => p.OrderId == orderId);
return(Mapper.MapOrder(returnOrder));
}
// Order Mapping
public static Library.Order Map(Context.Order order) => new Library.Order
{
Id = order.Id,
UserId = order.UserId,
LocationId = order.LocationId,
DateTime = (DateTime)order.DateTime,
Price = order.Price,
PizzaId1 = order.PizzaId1,
PizzaId2 = order.PizzaId2,
PizzaId3 = order.PizzaId3,
PizzaId4 = order.PizzaId4,
PizzaId5 = order.PizzaId5,
PizzaId6 = order.PizzaId6,
PizzaId7 = order.PizzaId7,
PizzaId8 = order.PizzaId8,
PizzaId9 = order.PizzaId9,
PizzaId10 = order.PizzaId10,
PizzaId11 = order.PizzaId11,
PizzaId12 = order.PizzaId12
};
public void AddOrder(Domain.Model.Order inputOrder)
{
if (inputOrder.Id != 0)
{
_logger.LogWarning($"Order to be added has an ID ({inputOrder.Id}) already: ignoring.");
}
_logger.LogInformation("Adding order");
Context.Order entity = new Context.Order
{
PersonId = inputOrder.UserId,
OrderDate = inputOrder.Date,
TotalOrderPrice = inputOrder.Price,
};
entity.OrderId = 0; //_dbContext.Orders.Max(p => p.OrderId)+1;
_dbContext.Add(entity);
Save();
foreach (var val in inputOrder.Items)
{
val.OrderId = _dbContext.Orders.Max(p => p.OrderId);
Repo.UpdateItem(val);
}
}
public void DeleteOrderById(int orderId)
{
_logger.LogInformation($"Deleting order with ID {orderId}");
Context.Order entity = _dbContext.Orders.Find(orderId);
_dbContext.Remove(entity);
}
