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