public static List <Dock> GetAll()
{
var db = new MarinaEntities();
var docks = db.Docks.ToList();
return(docks);
}
public static Dock Find(int id)
{
var db = new MarinaEntities();
var dcks = db.Docks.SingleOrDefault(d => d.ID == id);
return(dcks);
}
//Code written by Julie Tran
//Last Modified Febuary 7 2021
/// <summary>
/// retrieves all Dock Name and Dock ID
/// </summary>
/// <returns></returns>
public IList GetAllAsListItem()
{
var db = new MarinaEntities();
var dockName = db.Docks.Select(d => new { ID = d.ID, Name = d.Name }).ToList();
return(dockName);
}
/// <summary>
/// retrieves dock by ID
/// </summary>
/// <param name="dockID">dock ID</param>
/// <returns></returns>
public static Dock Find(int dockID)
{
var db = new MarinaEntities();
var dock = db.Docks.SingleOrDefault(d => d.ID == dockID);
return(dock);
}
public static void Add(Customer auth) //add new customer
{
var db = new MarinaEntities();
db.Customers.Add(auth);
db.SaveChanges();
}
//select leased slips for the customer
public static IList FindLeasedSlip(int customerId)
{
var db = new MarinaEntities();
var leasedSlips = db.Leases.Where(s => s.CustomerID == customerId).Select(s => new { SlipsLeased = s.SlipID }).ToList();
return(leasedSlips);
}
//add lease to db
public static void Add(Lease lease)
{
var db = new MarinaEntities();
db.Leases.Add(lease);
db.SaveChanges();
}
/// <summary>
/// find all slips that is associated to dockID
/// </summary>
/// <param name="dockID"> dock ID</param>
/// <returns>a list of slips</returns>
public static List <Slip> FindAvailableSlipByDock(int dockID)
{
var db = new MarinaEntities(); //any data retrieval in .Data
var availableSlips = db.Slips.Where(s => s.Leases.Count == 0 && s.DockID == dockID).ToList();
return(availableSlips);
}
/// <summary>
/// Find all slips that has not been leased
/// </summary>
/// <returns>a list of slips</returns>
public static List <Slip> FindAvailableSlip()
{
var db = new MarinaEntities();
var availSlip = db.Slips.Where(s => s.Leases.Count == 0).ToList();
return(availSlip);
}
/// <summary>
/// This method takes user inputted login informatio and compares it against values stored in the database.
/// If a match is found, the user is authenticated.
/// </summary>
/// <param name="FirstName">User inputted first name.</param>
/// <param name="LastName">User inputted last name.</param>
/// <param name="Phone">User inputted phone number.</param>
/// <param name="City">User inputted city.</param>
/// <returns>Authentication userDTO with the user's unique ID and full name.</returns>
public static object Authenticate(string FirstName, string LastName, string Phone, string City)
{
userDTO dto = null;
//Gets a reference to the database entity.
var dbContext = new MarinaEntities();
//Gets a reference to the object within the Customers table that matches the user specified input fields.
var authObj = (from cust in dbContext.Customers
where cust.FirstName == FirstName && cust.LastName == LastName && cust.Phone == Phone && cust.City == City
select cust).SingleOrDefault();
if (authObj is null)
{
//User is not authenticated.
}
else
{
//Sets parameters for the userDTO that will be used for authentication.
//A direct reference to authObj might pass it by reference, so we'll create a new object.
dto = new userDTO
{
custID = authObj.ID,
FullName = $"{authObj.FirstName} {authObj.LastName}"
};
}
return(dto);
}
/// <summary>
/// This method takes a Customer object (as defined by Entity Framework) and adds it to the DataContext.
/// The changes are then saved to update the database with a new customer.
/// </summary>
/// <param name="newCust">Customer object. Can be user defined or generated from a registration control.</param>
public static void Add(Customer newCust)
{
var dbContext = new MarinaEntities(); //Gets a reference to the database entity.
dbContext.Customers.Add(newCust); //Adds the new record to the DataContext.
dbContext.SaveChanges(); //Saves all changes made in the DataContext to the database it is modelling.
}
public static Dock FindDock(int id)
{
var db = new MarinaEntities();
var dock = db.Docks.SingleOrDefault(c => c.ID == id);
return(dock);
}
public static AuthenticationDTO AuthenticateCustomer(string username, string password)
{
//declare a dto object
AuthenticationDTO dto = null;
//creating the session to the database (called a context or DbContext)
var db = new MarinaEntities();
//find the authentication object based on credentials passed in
var auth = db.Customers.
SingleOrDefault(a => a.FirstName == username && a.LastName == password); // pseudo login
if (auth != null)
{
//authentication passed, so instantiate the dto object
dto = new AuthenticationDTO
{
Id = auth.ID.ToString(),
FirstName = auth.FirstName,
LastName = auth.LastName,
Phone = auth.Phone,
City = auth.City,
Username = $"{auth.FirstName}", // pseudo login
Password = $"{auth.LastName}" // pseudo login
};
}
//return the dto object
return(dto);
}
// Add a newly registered customer to DB
public static void Add(Customer cust)
{
using (var db = new MarinaEntities())
{
db.Customers.Add(cust);
db.SaveChanges();
}
}
public static IList FindSlip(int id)
{
var db = new MarinaEntities();
var availableSlips = db.Slips.Where(s => s.Leases.Count == 0 && s.DockID == id).Select(a => new { a.ID }).ToList();
return(availableSlips);
}
public IList GetAllAsListDocks()
{
var db = new MarinaEntities();
var docks = db.Docks.Select(dks => new
{ ID = dks.ID, Name = dks.Name }).ToList();
return(docks);
}
public static Customer Find(int custId) //find the customer if exists in db
{
var db = new MarinaEntities();
var auth = db.Customers.
SingleOrDefault(a => a.ID == custId);
return(auth);
}
public void LeaseSlip(Lease newLease)
{
using (var db = new MarinaEntities())
{
db.Leases.Add(newLease);
db.SaveChanges();
}
}
/// <summary>
/// Finds all lease associated to customer that is logged in
/// </summary>
/// <param name="custID">customer ID</param>
/// Code written by Julie Tran
//Last Modified Febuary 8 2021
public static List <Lease> Find(int custID)
{
var db = new MarinaEntities();
List <Lease> leases = db.Leases.ToList();
var previouslyLeased = (from pl in leases where pl.CustomerID == custID select pl).ToList();
return(previouslyLeased);
}
// find a single customer based on ID.
public static Customer Find(int id)
{
using (var db = new MarinaEntities())
{
var cust = db.Customers.SingleOrDefault(c => c.ID == id);
if (cust != null) // if customer is found
{
return(cust);
}
return(cust);
}
}
// update customer in db.
public static void Update(Customer cust)
{
using (var db = new MarinaEntities())
{
var custFromContext = db.Customers
.SingleOrDefault(c => c.ID == cust.ID);
custFromContext.FirstName = cust.FirstName;
custFromContext.LastName = cust.LastName;
custFromContext.City = cust.City;
custFromContext.Phone = cust.Phone;
db.SaveChanges();
}
}
public static void EnrollService(LeaseDTO LeaseToDB)
{
var db = new MarinaEntities();
var sc = new Lease
{
SlipID = int.Parse(LeaseToDB.SlipID),
CustomerID = int.Parse(LeaseToDB.CustomerID)
};
//add lease object to the context and save changes in the database
db.Leases.Add(sc);
db.SaveChanges();
}
public List <LeaseDTO> GetLeasesByCustomer(int custID)
{
using (var db = new MarinaEntities())
{
var leases = (from l in db.Leases
where l.CustomerID == custID
select new LeaseDTO
{
LeaseID = l.ID,
SlipID = l.SlipID
}).ToList();
return(leases);
}
}
public static List <LeaseOnBoardDTO> GetCustomerLeaseEnrollment(int id)
{
var db = new MarinaEntities();
//get the list of leases registered by the customer
var leaseList = db.Leases.Where(cs => cs.CustomerID == id).
Select(s => new LeaseOnBoardDTO
{
CustomerName = s.Customer.FirstName + " " + s.Customer.LastName,
DockName = s.Slip.Dock.Name.ToString(),
SlipID = s.SlipID.ToString()
}).ToList();
return(leaseList);
}
public List <DockDTO> GetDocks()
{
// get all docks.
using (var db = new MarinaEntities())
{
var docks = db.Docks.Select(d => new DockDTO
{
ID = d.ID,
Name = d.Name,
WaterService = d.WaterService,
ElectricalService = d.ElectricalService
}).ToList();
return(docks);
}
}
public static List <SlipDTO> GetAllSlipsByDockId(int id)
{
var db = new MarinaEntities();
//get the filtered data using Where and transform to dto objects using Select
var slips = db.Slips.
Where(cs => cs.DockID == id && cs.Leases.Count == 0).
Select(s => new SlipDTO
{
ID = s.ID.ToString(),
Width = s.Width.ToString(),
Length = s.Length.ToString(),
DockID = s.DockID.ToString()
}).ToList();
return(slips);
}
/// <summary>
/// Static method handles adding a new authentication object to the DB
/// </summary>
/// <param name="auth">The authentication object is a DTO object</param>
public static void AddAuthentication(AuthenticationDTO auth)
{
//use the context to add a new authentication object
var db = new MarinaEntities();
//assign from dto object to the entity object
var authFromContext = new Customer
{
FirstName = auth.FirstName,
LastName = auth.LastName,
Phone = auth.Phone,
City = auth.City
};
db.Customers.Add(authFromContext);
db.SaveChanges();
}
public static CustomerDTO Authenticate(string fname, string lname) //autheticate the user
{
CustomerDTO dto = null;
var db = new MarinaEntities();
var auth = db.Customers.
SingleOrDefault(a => a.FirstName == fname && a.LastName == lname);
if (auth != null) // authentication passsed
{
dto = new CustomerDTO
{
ID = auth.ID,
FullName = $"{auth.FirstName} {auth.LastName}"
};
}
return(dto);
}
/// <summary>
/// Static method handles the update of an existing authentication object
/// </summary>
/// <param name="auth">The authentication object as a DTO</param>
public static void UpdateAuthentication(AuthenticationDTO auth)
{
//use the context to update an existing record
var id = Convert.ToInt32(auth.Id);
var db = new MarinaEntities();
//we need to get an authentication object from the context
//so that we can update it with values from the dto passed in
var authFromContext = db.Customers.SingleOrDefault(a => a.ID == id);
authFromContext.FirstName = auth.FirstName;
authFromContext.Phone = auth.Phone;
authFromContext.City = auth.City;
//save changes--no need to add the object back to the context as the context
//already has it
db.SaveChanges();
}
public DockDTO GetSingleDock(int dockID)
{
using (var db = new MarinaEntities())
{
DockDTO dto = null;
var dock = db.Docks.SingleOrDefault(d => d.ID == dockID);
if (dock != null)
{
dto = new DockDTO
{
ID = dock.ID,
Name = dock.Name,
WaterService = dock.WaterService,
ElectricalService = dock.ElectricalService
};
}
return(dto);
}
}