public static void InsertCustomer(ExtendDbContext database, Customer customer)
{
if (!string.IsNullOrWhiteSpace(customer.CompanyName))
{
database.Customers.Add(customer);
database.SaveChanges();
}
else
{
throw new ArgumentNullException("Company name is mandatory");
}
}
public static void AddNewOrder(ExtendDbContext db, ICollection<Order> orders)
{
using (TransactionScope transaction = new TransactionScope())
{
foreach (var order in orders)
{
db.Orders.Add(order);
}
db.SaveChanges();
transaction.Complete();
}
}
public static void UpdateCustomer(ExtendDbContext database, string id, string newContactName)
{
var customer = database.Customers.Where(x => x.CustomerID == id).FirstOrDefault();
if (customer != null)
{
customer.ContactName = newContactName;
database.SaveChanges();
}
else
{
throw new InvalidOperationException("This customer doens't exists.");
}
}
public static void Delete(ExtendDbContext database, string id)
{
var customer = database.Customers.Where(x => x.CustomerID == id).FirstOrDefault();
if (customer != null)
{
database.Customers.Remove(customer);
database.SaveChanges();
}
else
{
throw new InvalidOperationException("This customer doens't exists.");
}
}