public static void InsertCustomer(Customer customer)
{
using (var dbContext = new NorthwindEntities())
{
dbContext.Customers.Add(customer);
dbContext.SaveChanges();
}
}
public static void InsertCustomer(string customerID, string companyName)
{
using (NorthwindEntities northwindDBContext = new NorthwindEntities())
{
Customer customer = new Customer
{
CustomerID = customerID,
CompanyName = companyName,
};
northwindDBContext.Customers.Add(customer);
northwindDBContext.SaveChanges();
Console.WriteLine("Customer is inserted");
}
}
public static void ModifyCustomer(Customer customer)
{
using (var dbContext = new NorthwindEntities())
{
var obsoleteCustomer = dbContext
.Customers
.Where(x => x.CustomerID == customer.CustomerID)
.FirstOrDefault();
if (obsoleteCustomer == null)
{
throw new ArgumentNullException("No such user in database!");
}
dbContext.Customers.Remove(obsoleteCustomer);
dbContext.Customers.Add(customer);
dbContext.SaveChanges();
}
}
public static void Main()
{
using (var dbContext = new NorthwindEntities())
{
var customer = new Customer()
{
CustomerID = "ZAZA",
CompanyName = "Mad House LTD",
ContactName = "Mad Man",
ContactTitle = "Owner",
};
DataAccessUtils.InsertCustomer(customer);
customer.Country = "Bulgaria";
DataAccessUtils.ModifyCustomer(customer);
DataAccessUtils.DeleteCustomer(customer.CustomerID);
}
}
static void Main()
{
DAO.InsertCustomer("BUBLA", "SamsaraBeach");
Customer customer = new Customer
{
CustomerID = "BUBLA",
CompanyName = "SamsaraBeach",
ContactName = "Samuel",
ContactTitle = "God",
Address = "Everywhere",
City = "CityOfGod",
Region = "Earth",
PostalCode = "123",
Country = "Atlantice",
Phone = "555 Banana Drive",
Fax = "nah"
};
DAO.UpdateCustomer("BUBLA", customer);
DAO.DeleteCustomer("BUBLA");
}
public static void UpdateCustomer(string customerID, Customer newCustomer)
{
using (NorthwindEntities northwindDBContext = new NorthwindEntities())
{
Customer customer = northwindDBContext.Customers.First(x => x.CustomerID == customerID);
customer.CompanyName = newCustomer.CompanyName;
customer.ContactName = newCustomer.ContactName;
customer.ContactTitle = newCustomer.ContactTitle;
customer.Address = newCustomer.Address;
customer.City = newCustomer.City;
customer.Region = newCustomer.Region;
customer.PostalCode = newCustomer.PostalCode;
customer.Country = newCustomer.Country;
customer.Phone = newCustomer.Phone;
customer.Fax = newCustomer.Fax;
northwindDBContext.SaveChanges();
Console.WriteLine("Customer is updated.");
}
}
