public static Dock Find(int id) { var db = new MarinaEntities(); var dock = db.Docks.SingleOrDefault(d => d.ID == id); return(dock); }
public static List <Dock> GetAll() { var db = new MarinaEntities(); var docks = db.Docks.ToList(); return(docks); }
public static void Add(Customer cust) { var db = new MarinaEntities(); db.Customers.Add(cust); db.SaveChanges(); }
public static Customer Find(int CustomerId) { var db = new MarinaEntities(); var auth = db.Customers.SingleOrDefault(a => a.ID == CustomerId); return(auth); }
public IList GetAllAsListItems() { var db = new MarinaEntities(); var docks = db.Docks.Select(d => new { ID = d.ID, Name = d.Name }).ToList(); return(docks); }
// check user for log in public static CustomerDTO Authenticate(string FirstName, string LastName) { CustomerDTO cust = null; var db = new MarinaEntities(); var auth = db.Customers. SingleOrDefault(a => a.FirstName == FirstName && a.LastName == LastName); if (auth != null) // authentication passsed { cust = new CustomerDTO { ID = auth.ID, FullName = $"{auth.FirstName} {auth.LastName}" }; } return(cust); }