/// <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); }
/// <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); }
/// <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)); } }
/// <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); } }
/// <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; } }