public static SelectionDS GetTerminals(bool isShipperSchedule)
{
//Get a list of terminals
SelectionDS terminals = null;
try {
terminals = new SelectionDS();
DataSet ds = null;
DataSet _ds = new DataSet();
if (isShipperSchedule)
{
ds = fillDataset(USP_SHIPPERS, TBL_SHIPPERS, new object[] {});
if (ds.Tables[TBL_SHIPPERS].Rows.Count > 0)
{
_ds.Merge(ds.Tables[TBL_SHIPPERS].Select("", "Description ASC"));
terminals.Merge(_ds);
}
}
else
{
ds = fillDataset(USP_TERMINALS, TBL_TERMINALS, new object[] { });
if (ds.Tables[TBL_TERMINALS].Rows.Count > 0)
{
_ds.Merge(ds.Tables[TBL_TERMINALS].Select("", "Description ASC"));
terminals.Merge(_ds);
}
}
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while reading terminals.", ex); }
return(terminals);
}
public static SelectionDS GetAgents()
{
//
SelectionDS agents = null;
try {
agents = new SelectionDS();
DataSet ds = fillDataset(USP_AGENTS, TBL_AGENTS, new object[] { });
if (ds.Tables[TBL_AGENTS].Rows.Count > 0)
{
DataSet _ds = new DataSet();
_ds.Merge(ds.Tables[TBL_AGENTS].Select("", "Description ASC"));
agents.Merge(_ds);
}
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while reading agents.", ex); }
return(agents);
}
public static SelectionDS GetCarriers()
{
//
SelectionDS carriers = null;
try {
carriers = new SelectionDS();
DataSet ds = fillDataset(USP_CARRIERS, TBL_CARRIERS, new object[] { });
if (ds.Tables[TBL_CARRIERS].Rows.Count > 0)
{
DataSet _ds = new DataSet();
_ds.Merge(ds.Tables[TBL_CARRIERS].Select("", "Description ASC"));
carriers.Merge(_ds);
}
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while reading carriers.", ex); }
return(carriers);
}
public static SelectionDS GetShippers()
{
//
SelectionDS shippers = null;
try {
shippers = new SelectionDS();
DataSet ds = fillDataset(USP_SHIPPERTERMINALS, TBL_SHIPPERTERMINALS, new object[] { });
if (ds.Tables[TBL_SHIPPERS].Rows.Count > 0)
{
DataSet _ds = new DataSet();
_ds.Merge(ds.Tables[TBL_SHIPPERTERMINALS].Select("", "Description ASC"));
shippers.Merge(_ds);
}
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while reading shippers.", ex); }
return(shippers);
}