/// <summary>
 /// Updates a shipping method
 /// </summary>
 public override bool UpdateShippingMethod(ShippingMethodDetails shippingMethod)
 {
     using (SqlConnection cn = new SqlConnection(this.ConnectionString))
      {
     SqlCommand cmd = new SqlCommand("tbh_Store_UpdateShippingMethod", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@ShippingMethodID", SqlDbType.Int).Value = shippingMethod.ID;
     cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = shippingMethod.Title;
     cmd.Parameters.Add("@Price", SqlDbType.Money).Value = shippingMethod.Price;
     cn.Open();
     int ret = ExecuteNonQuery(cmd);
     return (ret == 1);
      }
 }
 /// <summary>
 /// Creates a new shipping method
 /// </summary>
 public override int InsertShippingMethod(ShippingMethodDetails shippingMethod)
 {
     using (SqlConnection cn = new SqlConnection(this.ConnectionString))
      {
     SqlCommand cmd = new SqlCommand("tbh_Store_InsertShippingMethod", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = shippingMethod.AddedDate;
     cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = shippingMethod.AddedBy;
     cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = shippingMethod.Title;
     cmd.Parameters.Add("@Price", SqlDbType.Money).Value = shippingMethod.Price;
     cmd.Parameters.Add("@ShippingMethodID", SqlDbType.Int).Direction = ParameterDirection.Output;
     cn.Open();
     int ret = ExecuteNonQuery(cmd);
     return (int)cmd.Parameters["@ShippingMethodID"].Value;
      }
 }