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