public static DriverRatesDS GetMileageRouteRates(DateTime date, string terminalAgent, string route)
{
//Return applicable route-based mileage rates for the specified date
DriverRatesDS rates = new DriverRatesDS();
try {
DataSet ds = Mediator.FillDataset(USP_RATEMILEAGEROUTE, TBL_RATEMILEAGEROUTE, new object[] { date, terminalAgent, route });
if (ds.Tables[TBL_RATEMILEAGEROUTE].Rows.Count > 0)
{
rates.Merge(ds);
}
}
catch (ApplicationException ex) { throw ex; }
catch (Exception ex) { throw new DriverRateException("Unexpected error while reading rates.", ex); }
return(rates);
}
public DriverRatesDS GetUnitRouteRates(DateTime date, string terminalAgent, string route)
{
//Return applicable route-based unit rates (i.e. multi-trip, carton, pallet) for the specified date
DriverRatesDS rates = new DriverRatesDS();
try {
DataSet ds = new DataService().FillDataset(this.mConnectionID, USP_RATEUNITROUTE, TBL_RATEUNITROUTE, new object[] { date, terminalAgent, route });
if (ds.Tables[TBL_RATEUNITROUTE].Rows.Count > 0)
{
rates.Merge(ds);
}
}
catch (ApplicationException ex) { throw ex; }
catch (Exception ex) { throw new DriverRateException("Unexpected error while reading rates.", ex); }
return(rates);
}
public DriverRatesDS GetMileageRates(DateTime date, string terminalAgent, int equipmentTypeID)
{
//Return applicable mileage rates for the specified date
DriverRatesDS rates = new DriverRatesDS();
try {
object id = null; if (equipmentTypeID > -1)
{
id = equipmentTypeID;
}
DataSet ds = new DataService().FillDataset(this.mConnectionID, USP_RATEMILEAGE, TBL_RATEMILEAGE, new object[] { date, terminalAgent, id });
if (ds.Tables[TBL_RATEMILEAGE].Rows.Count > 0)
{
rates.Merge(ds);
}
}
catch (ApplicationException ex) { throw ex; }
catch (Exception ex) { throw new DriverRateException("Unexpected error while reading rates.", ex); }
return(rates);
}
public static DriverRatesDS GetUnitRates(DateTime date, string terminalAgent, int equipmentTypeID)
{
//Return applicable unit rates (i.e. multi-trip, carton, pallet) for the specified date
DriverRatesDS rates = new DriverRatesDS();
try {
object id = null; if (equipmentTypeID > -1)
{
id = equipmentTypeID;
}
DataSet ds = Mediator.FillDataset(USP_RATEUNIT, TBL_RATEUNIT, new object[] { date, terminalAgent, id });
if (ds.Tables[TBL_RATEUNIT].Rows.Count > 0)
{
rates.Merge(ds);
}
}
catch (ApplicationException ex) { throw ex; }
catch (Exception ex) { throw new DriverRateException("Unexpected error while reading rates.", ex); }
return(rates);
}