public override DeliveryOptionCollection GetDeliveryOptions(PackageInfo package, DeliveryRestrictions restrictions)
        {
            Database db = DatabaseFactory.CreateDatabase();
            string   sp = "CSK_Shipping_GetRates";

            if (restrictions == DeliveryRestrictions.Air)
            {
                sp = "CSK_Shipping_GetRates_Air";
            }
            else if (restrictions == DeliveryRestrictions.Freight || restrictions == DeliveryRestrictions.Ground)
            {
                sp = "CSK_Shipping_GetRates_Ground";
            }

            using (DbCommand cmd = db.GetStoredProcCommand(sp))
            {
                db.AddInParameter(cmd, "@weight", DbType.Decimal, package.Weight);
                IDataReader rdr = db.ExecuteReader(cmd);

                DeliveryOptionCollection coll = new DeliveryOptionCollection();
                coll.Load(rdr);
                rdr.Close();
                return(coll);
            }
        }
        public override DeliveryOptionCollection GetDeliveryOptions(PackageInfo package)
        {
            Database db = DatabaseFactory.CreateDatabase();

            using (DbCommand cmd = db.GetStoredProcCommand("CSK_Shipping_GetRates"))
            {
                db.AddInParameter(cmd, "@weight", DbType.Decimal, package.Weight);
                IDataReader rdr = db.ExecuteReader(cmd);

                DeliveryOptionCollection coll = new DeliveryOptionCollection();
                coll.Load(rdr);
                rdr.Close();
                return(coll);
            }
        }