public List <int> GetAvailableSlipIDs(int dockID) { var db = new MarinaEntities(); var result = new List <int>(); var myList = new List <int>(); using (db) { var query = from slips in db.Slips join docks in db.Docks on slips.DockID equals dockID where !(from l in db.Leases select l.SlipID) .Contains(slips.ID) select slips.ID; foreach (var slip in query) { myList.Add(slip); } } result = myList.GroupBy(slip => slip) .Select(grp => grp.First()) .ToList(); return(result); }
public int GetSlipWidth(int slipID) { var db = new MarinaEntities(); var query = (from slip in db.Slips where slip.ID == slipID select slip.Width).Single(); int result = Convert.ToInt32(query); return(result); }
public IList GetDocks() { var db = new MarinaEntities(); var result = new List <int>(); using (db) { var query = from d in db.Docks select d.ID; foreach (var dock in query) { result.Add(dock); } } return(result); }
public void AddLeaseToCust(int custID, int slipID) { var db = new MarinaEntities(); var lease = new Lease(); lease.CustomerID = custID; lease.SlipID = slipID; db.Leases.Add(lease); try { db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); throw e; } }
public static Customer Authenticate(string firstName, string lastName) { Customer sessionCustomer = null; var db = new MarinaEntities(); var customer = db.Customers.SingleOrDefault(cust => cust.FirstName == firstName && cust.LastName == lastName); if (customer != null) { sessionCustomer = new Customer { ID = customer.ID, FirstName = customer.FirstName, LastName = customer.LastName, City = customer.City, Phone = customer.Phone }; } return(sessionCustomer); }
public Slip GetSlip(int dockID, int slipID) { var db = new MarinaEntities(); var slip = new Slip(); using (db) { var query = from s in db.Slips where s.ID == slipID && s.DockID == dockID select s; foreach (var slip1 in query) { slip.Width = slip1.Width; slip.Length = slip1.Length; slip.DockID = slip1.DockID; } } return(slip); }
public IList GetLeasesByCustomer(int custID) { var db = new MarinaEntities(); var result = new List <Lease>(); using (db) { var query = from c in db.Customers join l in db.Leases on c.ID equals l.CustomerID where c.ID == custID select l; foreach (var lease in query) { result.Add(lease); } } return(result); }
public Customer GetCustomerByID(int id) { var db = new MarinaEntities(); var customer = new Customer(); using (db) { var query = from c in db.Customers where c.ID == id select c; foreach (var cust in query) { customer.FirstName = cust.FirstName; customer.LastName = cust.LastName; customer.City = cust.City; customer.Phone = cust.Phone; } } return(customer); }
public List <int> GetSlipIDs(int dockID) { var db = new MarinaEntities(); var result = new List <int>(); using (db) { var query = from slips in db.Slips join docks in db.Docks on slips.DockID equals dockID //where !(from l in db.Leases // select l.SlipID) // .Contains(slips.ID) select slips.ID; foreach (var slip in query) { result.Add(slip); } } return(result); }
public IList GetAvailableSlips(int dockID) { var db = new MarinaEntities(); var result = new List <Slip>(); using (db) { var query = from slips in db.Slips join docks in db.Docks on slips.DockID equals dockID where !(from l in db.Leases select l.SlipID) .Contains(slips.ID) select slips; foreach (var slip in query) { result.Add(slip); } } return(result); }
public bool RegisterUser(Customer cust) { Validate vl = new Validate(); var db = new MarinaEntities(); if (vl.ValidateCustomer(cust)) { db.Customers.Add(cust); } else { return(false); } try { db.SaveChanges(); return(true); } catch (DbEntityValidationException) { return(false); } }
public bool ValidateDoesNotExist(string firstName, string lastName) { var db = new MarinaEntities(); var existingCustomers = new List <Customer>(); using (db) { var query = from cust in db.Customers where cust.FirstName == firstName && cust.LastName == lastName select cust; foreach (var c in query) { existingCustomers.Add(c); } } if (existingCustomers.Count == 0) { return(true); } else { return(false); } }