コード例 #1
0
        /// <summary>
        /// Updates an existing shipping method
        /// </summary>
        public static bool UpdateShippingMethod(int id, string title, decimal price)
        {
            ShippingMethodDetails record = new ShippingMethodDetails(id, DateTime.Now, "", title, price);
            bool ret = SiteProvider.Store.UpdateShippingMethod(record);

            BizObject.PurgeCacheItems("store_shippingmethod");
            return(ret);
        }
コード例 #2
0
        /// <summary>
        /// Creates a new shipping method
        /// </summary>
        public static int InsertShippingMethod(string title, decimal price)
        {
            ShippingMethodDetails record = new ShippingMethodDetails(0, DateTime.Now,
                                                                     BizObject.CurrentUserName, title, price);
            int ret = SiteProvider.Store.InsertShippingMethod(record);

            BizObject.PurgeCacheItems("store_shippingmethod");
            return(ret);
        }
コード例 #3
0
 /// <summary>
 /// Returns a ShippingMethod object filled with the data taken from the input ShippingMethodDetails
 /// </summary>
 private static ShippingMethod GetShippingMethodFromShippingMethodDetails(ShippingMethodDetails record)
 {
     if (record == null)
     {
         return(null);
     }
     else
     {
         return(new ShippingMethod(record.ID, record.AddedDate, record.AddedBy, record.Title, record.Price));
     }
 }
コード例 #4
0
 /// <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);
     }
 }
コード例 #5
0
 /// <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);
     }
 }
コード例 #6
0
 /// <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);
      }
 }
コード例 #7
0
 /// <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;
      }
 }