/// <summary> /// Updates an existing order status /// </summary> public static bool UpdateOrderStatus(int id, string title) { OrderStatusDetails record = new OrderStatusDetails(id, DateTime.Now, "", title); bool ret = SiteProvider.Store.UpdateOrderStatus(record); BizObject.PurgeCacheItems("store_orderstatus"); return(ret); }
/// <summary> /// Creates a new order status /// </summary> public static int InsertOrderStatus(string title) { OrderStatusDetails record = new OrderStatusDetails(0, DateTime.Now, BizObject.CurrentUserName, title); int ret = SiteProvider.Store.InsertOrderStatus(record); BizObject.PurgeCacheItems("store_orderstatus"); return(ret); }
/// <summary> /// Returns a OrderStatus object filled with the data taken from the input OrderStatusDetails /// </summary> private static OrderStatus GetOrderStatusFromOrderStatusDetails(OrderStatusDetails record) { if (record == null) { return(null); } else { return(new OrderStatus(record.ID, record.AddedDate, record.AddedBy, record.Title)); } }
/// <summary> /// Updates a order status /// </summary> public override bool UpdateOrderStatus(OrderStatusDetails orderStatus) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("tbh_Store_UpdateOrderStatus", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@OrderStatusID", SqlDbType.Int).Value = orderStatus.ID; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = orderStatus.Title; cn.Open(); int ret = ExecuteNonQuery(cmd); return(ret == 1); } }
/// <summary> /// Creates a new order status /// </summary> public override int InsertOrderStatus(OrderStatusDetails orderStatus) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("tbh_Store_InsertOrderStatus", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = orderStatus.AddedDate; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = orderStatus.AddedBy; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = orderStatus.Title; cmd.Parameters.Add("@OrderStatusID", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return((int)cmd.Parameters["@OrderStatusID"].Value); } }
/// <summary> /// Updates a order status /// </summary> public override bool UpdateOrderStatus(OrderStatusDetails orderStatus) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("tbh_Store_UpdateOrderStatus", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@OrderStatusID", SqlDbType.Int).Value = orderStatus.ID; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = orderStatus.Title; cn.Open(); int ret = ExecuteNonQuery(cmd); return (ret == 1); } }
/// <summary> /// Creates a new order status /// </summary> public override int InsertOrderStatus(OrderStatusDetails orderStatus) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("tbh_Store_InsertOrderStatus", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = orderStatus.AddedDate; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = orderStatus.AddedBy; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = orderStatus.Title; cmd.Parameters.Add("@OrderStatusID", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return (int)cmd.Parameters["@OrderStatusID"].Value; } }