public static Customer Find(int customerId)
{
var db = new MarinaEntities();
var auth = db.Customers.SingleOrDefault(c => c.ID == customerId);
return(auth);
}
public static void Add(Customer auth)
{
var db = new MarinaEntities();
db.Customers.Add(auth);
db.SaveChanges();
}
public static Slip Find(int dkId)
{
var db = new MarinaEntities();
var slp = db.Slips.SingleOrDefault(s => s.DockID == dkId);
return(slp);
}
public static List <Slip> GetLeaseAll()
{
var db = new MarinaEntities();
var slips = db.Slips.ToList();
return(slips);
}
public IList GetUnleasedSlip()
{
var db = new MarinaEntities();
var slips = db.Slips.Select(slp => new
{ id = slp.ID, width = slp.Width, lenght = slp.Length, dkId = slp.DockID }).ToList();
return(slips);
}
public static void Update(Customer auth)
{
var db = new MarinaEntities();
var authFromContext = db.Customers.SingleOrDefault(c => c.ID == auth.ID);
authFromContext.FirstName = auth.FirstName;
authFromContext.LastName = auth.LastName;
authFromContext.FirstName = auth.FirstName;
authFromContext.LastName = auth.LastName;
authFromContext.City = auth.City;
authFromContext.Phone = auth.Phone;
db.SaveChanges();
}
public IList GetAllDocks()
{
var db = new MarinaEntities();
var docks = db.Docks.Select(dck => new
{
Id = dck.ID,
name = dck.Name,
waterservice = dck.WaterService,
electricityservice = dck.ElectricalService
}).ToList();
return(docks);
}
public static CustomerDTO Authenticate(string firstname, string lastname)
{
CustomerDTO dto = null;
var db = new MarinaEntities();
var auth = db.Customers.SingleOrDefault
(c => c.FirstName == firstname && c.LastName == lastname);
if (auth != null)
{
// if the authentication is null the user is not a customer
dto = new CustomerDTO
{
ID = auth.ID,
FullName = $"{auth.FirstName} {auth.LastName}",
};
}
return(dto);
}