public static IQuery SelectLeaseFor(long slipId)
{
return(DatabaseSelect.From(LeaseTable.TableName)
.AddColumn(LeaseTable.StartDate)
.AddColumn(LeaseTable.EndDate)
.Where(LeaseTable.SlipID, slipId).Build( ));
}
public bool IsLeased(long slipId)
{
IQuery query =
DatabaseSelect.From(LeaseTable.TableName).AddColumn(LeaseTable.SlipID).Where(LeaseTable.SlipID, slipId).Build( );
return(!_gateway.LoadRowUsing(query).Equals(DatabaseRow.Blank));
}
public static IQuery SelectCustomerBy(string username)
{
return(DatabaseSelect.From(AuthorizationTable.TableName)
.AddColumn(AuthorizationTable.CustomerID)
.AddColumn(AuthorizationTable.UserName)
.Where(AuthorizationTable.UserName, "'" + username + "'")
.Build( ));
}
public static IQuery SelectBoatsFor(long customerId)
{
return(DatabaseSelect.From(BoatTable.TableName)
.AddColumn(BoatTable.Length)
.AddColumn(BoatTable.Manufacturer)
.AddColumn(BoatTable.ModelYear)
.AddColumn(BoatTable.RegistrationNumber)
.AddColumn(BoatTable.BoatID)
.Where(BoatTable.CustomerID, customerId.ToString( )).Build( ));
}
public static IQuery SelectLeasesFor(long customerId)
{
return(DatabaseSelect
.From(LeaseTable.TableName)
.AddColumn(LeaseTable.EndDate)
.AddColumn(LeaseTable.ID)
.AddColumn(LeaseTable.LeaseTypeID)
.AddColumn(LeaseTable.SlipID)
.AddColumn(LeaseTable.StartDate)
.Where(LeaseTable.CustomerID, customerId).Build( ));
}
public static IQuery SelectRegistrationFor(long customerId)
{
return(DatabaseSelect.From(CustomerTable.TableName)
.AddColumn(CustomerTable.FirstName)
.AddColumn(CustomerTable.LastName)
.AddColumn(CustomerTable.Phone)
.AddColumn(CustomerTable.City)
.AddColumn(AuthorizationTable.UserName)
.AddColumn(AuthorizationTable.Password)
.InnerJoinOn(AuthorizationTable.CustomerID, CustomerTable.CustomerID)
.Where(CustomerTable.CustomerID, customerId.ToString( )).Build( ));
}
public static IQuery SelectDockBy(long dockId)
{
return(DatabaseSelect
.From(DockTable.TableName)
.AddColumn(DockTable.DockID)
.AddColumn(DockTable.DockName)
.AddColumn(DockTable.LocationId)
.AddColumn(DockTable.WaterService)
.AddColumn(DockTable.ElectricalService)
.AddColumn(LocationTable.Name)
.InnerJoinOn(LocationTable.ID, DockTable.LocationId)
.Where(DockTable.DockID, dockId).Build( ));
}
private static ISelectQueryBuilder SelectAllColumns()
{
return(DatabaseSelect
.From(SlipTable.TableName)
.AddColumn(SlipTable.ID)
.AddColumn(SlipTable.Width)
.AddColumn(SlipTable.Length)
.AddColumn(SlipTable.DockID)
.AddColumn(DockTable.DockName)
.AddColumn(DockTable.WaterService)
.AddColumn(DockTable.ElectricalService)
.AddColumn(LocationTable.Name)
.InnerJoinOn(DockTable.DockID, SlipTable.DockID)
.InnerJoinOn(LocationTable.ID, DockTable.LocationId));
}
