public static IList GetAllSlip() { var db = new MarinaEntities(); var slip = db.Slips.ToList(); return(slip); }
public static Slip FindSlip(int id) { var db = new MarinaEntities(); var slip = db.Slips.SingleOrDefault(c => c.ID == id); return(slip); }
public static List <Slip> getAllslipsfromDock(int id) { var db = new MarinaEntities(); List <Slip> slips = (from s in db.Slips where s.DockID == id select s).ToList(); return(slips); }
public IList GetAllSlips() { var db = new MarinaEntities(); var slip = db.Slips.Select(slp => new { DockID = slp.DockID, SlipId = slp.ID }).ToList(); return(slip); }
public IList GetAllDocks() { var db = new MarinaEntities(); var dock = db.Docks.Select(d => new { ID = d.ID, Name = d.Name, WaterService = d.WaterService, Electrical = d.ElectricalService }).ToList(); return(dock); }
public static Dock FindDock(int id) { var db = new MarinaEntities(); var dock = db.Docks.SingleOrDefault(c => c.ID == id); return(dock); }
public static void AddCustomer(Customer auth) { var db = new MarinaEntities(); db.Customers.Add(auth); db.SaveChanges(); }
public static Customer FindCustomer(int id) { var db = new MarinaEntities(); var auth = db.Customers.SingleOrDefault(a => a.ID == id); return(auth); }
public static Customer Authenticate(string firstName, string lastName) { var db = new MarinaEntities(); var auth = db.Customers.SingleOrDefault(a => a.FirstName == firstName && a.LastName == lastName); return(auth); }
public static IList <Slip> GetAllSlipsAvailable(int id) { var db = new MarinaEntities(); List <Slip> slips = (from slip in db.Slips where (!(from lease in db.Leases select lease.SlipID).Contains(slip.ID) && slip.DockID == id) select slip).ToList(); return(slips); }
public static ICollection <Lease> GetLeaseByCustomerID(int id) { var db = new MarinaEntities(); ICollection <Lease> x = (from s in db.Customers join l in db.Leases on s.ID equals l.CustomerID where l.CustomerID == id select l).ToList(); return(x); }