public static Shipper GetShipperById(int ShipperId)
{
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@ShipperId", ShipperId);
DataSet dsShipper = SQLHelper.ExecuteDataset("dbo.GetShipperById", Parameters);
Shipper Shipper = new Shipper();
if (dsShipper.Tables[0].Rows.Count > 0)
{
Shipper = MapShipperObject(dsShipper.Tables[0].Rows[0]);
}
return(Shipper);
}
public static List <Shipper> GetShippers()
{
DataSet dsShippers = SQLHelper.ExecuteDataset("dbo.GetShippers", null);
List <Shipper> Shippers = new List <Shipper>();
if (dsShippers.Tables[0].Rows.Count > 0)
{
Shipper Shipper = new Shipper();
for (int i = 0; i < dsShippers.Tables[0].Rows.Count; i++)
{
Shipper = MapShipperObject(dsShippers.Tables[0].Rows[i]);
Shippers.Add(Shipper);
}
}
return(Shippers);
}