/// <summary>
/// Find available slips
/// </summary>
/// <returns></returns>
public static List <Slip> AvailSlips()
{
List <Lease> Leases = null;
try
{
Leases = GenericDB.GenericRead <Lease>("Lease");
}
catch (Exception)
{
throw;
}
availSlips = new List <Slip>(Slips);
foreach (Slip s in Slips)
{
foreach (Lease l in Leases)
{
if (s.ID == l.SlipID)
{
availSlips.Remove(s);
}
}
}
return(availSlips);
}
private void LoadData()
{
//get data from DB and bound it to GridView
Orders = GenericDB.GenericRead <Orders>("Orders");
OrderDetails = GenericDB.GenericRead <OrderDetails>("[Order Details]");
ordersDataGridView.DataSource = Orders;
ordersDataGridView.Refresh();
}
static DockManager()
{
try
{
Docks = GenericDB.GenericRead <Dock>("Dock");
}
catch (Exception)
{
throw;
}
}
static LeaseManager()
{
try
{
Leases = GenericDB.GenericRead <Lease>("Lease");
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// get all Slips
/// </summary>
static SlipManager()
{
try
{
Slips = GenericDB.GenericRead <Slip>("Slip");
}
catch (Exception)
{
throw;
}
}
static CustomerManager()
{
try
{
Customers = GenericDB.GenericRead <Customer>("Customer");
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// add new lease to DB
/// </summary>
/// <param name="customerID"></param>
/// <param name="slipId"></param>
public static void addLease(int customerID, int slipId)
{
Lease newLease = new Lease()
{
CustomerID = customerID,
SlipID = slipId,
};
try
{
GenericDB.GenericInsert <Lease>("Lease", newLease);
Leases = GenericDB.GenericRead <Lease>("Lease");//Static Leases, so need update Leases after each insert.
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// DataSource for Lese History
/// </summary>
/// <param name="customerId"></param>
/// <returns></returns>
public static List <Lease> LeaseHistory(int customerId)
{
List <Lease> tempLeases = new List <Lease>();
try
{
Leases = GenericDB.GenericRead <Lease>("Lease");//read again in case concurrency inserted
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
foreach (Lease l in Leases)
{
if (l.CustomerID == customerId)
{
tempLeases.Add(l);
}
}
return(tempLeases);
}