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"); } } }