public static void ModifyCustomer(string customerId, string name)
{
NorthwindEntities northwindEntities = new NorthwindEntities();
Customer customer = GetCustomerById(northwindEntities, customerId);
customer.ContactName = name;
northwindEntities.SaveChanges();
Console.WriteLine("Customer modified");
}
public static void DeleteCustomer(string customerId)
{
NorthwindEntities northwindEntities = new NorthwindEntities();
Customer customer = GetCustomerById(northwindEntities, customerId);
northwindEntities.Customers.Remove(customer);
northwindEntities.SaveChanges();
Console.WriteLine("Customer deleted");
}
static void Edit(string id, string newContactName)
{
using (NorthwindEntities db = new NorthwindEntities())
{
var customer = db.Customers.Where(x => x.CustomerID == id).FirstOrDefault();
customer.ContactName = newContactName;
db.SaveChanges();
}
}
static void Delete(string id)
{
using (NorthwindEntities db = new NorthwindEntities())
{
var customer = db.Customers.Where(x => x.CustomerID == id).FirstOrDefault();
db.Customers.Remove(customer);
db.SaveChanges();
}
}
public static void InsertCustomer(Customer customer)
{
using (var db = new NorthwindEntities())
{
if (customer==null)
{
throw new ArgumentNullException("Customer cannot be null");
}
db.Customers.Add(customer);
db.SaveChanges();
}
Console.WriteLine("Customer added");
}
// TASK 2
// Create a DAO class with static methods which provide functionality for inserting, modifying and deleting customers.
// Write a testing class.
static void Add(string name, string id)
{
Customer newCustomer = new Customer()
{
CompanyName = name,
CustomerID = id
};
using (NorthwindEntities db = new NorthwindEntities())
{
bool isInDB = IsInDataBase(db, id);
if (!isInDB)
{
db.Customers.Add(newCustomer);
db.SaveChanges();
Console.WriteLine("Added Successful.");
}
else
{
throw new ArgumentException("Such customer already exists");
}
}
}
