public Order_DataAccessLayer.Model.Order GetOrderByID(int?id)
{
try
{
Order_DataAccessLayer.Model.Order entity = _context.Orders.FirstOrDefault(x => x.OrderId == id);
if (entity != null)
{
_context.Orders.Find(id);
}
else
{
throw new Exception("Order not found");
}
return(entity);
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public void UpdateOrder(Order_DataAccessLayer.Model.Order order)
{
try
{
_context.Entry(order).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
Commit();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public Order_DataAccessLayer.Model.Order AddOrder(Order_DataAccessLayer.Model.Order order)
{
try
{
_context.Orders.Add(order);
Commit();
return(order);
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}