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