public bool UpdateRates(OSHTRates newRates)
{
//Variables
DataAccess da = DataAccess.Instance();
//If the update failed return false
if (!da.UpdateRatesTable(newRates.FTLRate, newRates.LTLRate))
{
return(false);
}
//Return success
return(true);
}
///
/// \brief To retrieve Routes from Route table in the database
/// \details <b>Details</b>
///
/// This method interfaces with the database to retrieve the data from the routes table
///
/// \param <b>void</b> - None
///
/// \return List Destination Returns a list of the rows of routes in the database
///
public OSHTRates GetRates()
{
// create objects to hold information from DAL
DataAccess tempDA = DataAccess.Instance();
DataTable ratesTable = tempDA.GetRatesTable().Tables[0];
OSHTRates rates = new OSHTRates();
DataRowCollection ratesRow = ratesTable.Rows;
// Get the one row of data from the rowCollection
foreach (DataRow currentRow in ratesRow)
{
//Fill destination
rates.FTLRate = currentRow.Field <double>(0);
rates.LTLRate = currentRow.Field <double>(1);
}
return(rates);
}
