public static void Add(Customer cus) { var db = new MarinaEntities(); db.Customers.Add(cus); db.SaveChanges(); }
//define method to delete record from available slips public static void AddNewLease(int slipid, int cusid) { var newlease = new Lease { SlipID = slipid, CustomerID = cusid }; db.Leases.Add(newlease); db.SaveChanges(); }
public static void Update(Customer cus) { var db = new MarinaEntities(); var cusFromContext = db.Customers.SingleOrDefault(a => a.FirstName == cus.FirstName && a.LastName == cus. LastName); cusFromContext.FirstName = cus.FirstName; cusFromContext.LastName = cus.LastName; cusFromContext.Phone = cus.Phone; cusFromContext.City = cus.City; db.SaveChanges(); }