public static void CustomerDTOUpdateARow(Guid customerOrderId, int customerOrderComplete)
{
//1 - Create instance of the database and add the new Customer Order
PapaBobsPizzasWebAppEntityModel db = new PapaBobsPizzasWebAppEntityModel();
try
{
var customerOrder = db.CustomerOrders.SingleOrDefault(p => p.CustomerOrderId == customerOrderId);
customerOrder.CustomerOrderComplete = customerOrderComplete;
db.SaveChanges();
//db.Database.Connection.Open();
//db.CustomerOrders.Attach(customerOrder);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
}
public static void PizzaSizeDTOUpdateARow(DTO.PizzaSizeDTO pizzaSizeDTO)
{
//1 - Create instance of the database and add the new Customer Order
PapaBobsPizzasWebAppEntityModel db = new PapaBobsPizzasWebAppEntityModel();
try
{
var pizzaSize = db.PizzaSizes.SingleOrDefault(p => p.PizzaSizeId == pizzaSizeDTO.PizzaSizeId);
pizzaSize.PizzaSizeName = pizzaSizeDTO.PizzaSizeName;
pizzaSize.PizzaSizeDesc = pizzaSizeDTO.PizzaSizeDesc;
pizzaSize.PizzaSizePrice = pizzaSizeDTO.PizzaSizePrice;
db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
}
public static void CustomerDTOAddARow(DTO.CustomerOrderDTO customerOrderDTO)
{
//1 - Convert the DTO object into the DB object
var customerOrder = Mapper.Map <CustomerOrder>(customerOrderDTO);
//2 - Create instance of the database and add the new Customer Order
PapaBobsPizzasWebAppEntityModel db = new PapaBobsPizzasWebAppEntityModel();
try
{
db.Database.Connection.Open();
db.CustomerOrders.Add(customerOrder);
db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
}
