public static void UpdateOrderStatus(OrderStatus status)
{
SQLDataAccess.ExecuteNonQuery("[Order].[sp_UpdateOrderStatus]", CommandType.StoredProcedure,
new SqlParameter("@OrderStatusID", status.StatusID),
new SqlParameter("@StatusName", status.StatusName),
new SqlParameter("@CommandID", (int)status.Command),
new SqlParameter("@IsDefault", status.IsDefault),
new SqlParameter("@IsCanceled", status.IsCanceled),
new SqlParameter("@Color", status.Color.IsNotEmpty() ? status.Color : (object)DBNull.Value),
new SqlParameter("@SortOrder", status.SortOrder)
);
}
public static int AddOrderStatus(OrderStatus status)
{
return SQLDataAccess.ExecuteScalar<int>("[Order].[sp_AddOrderStatus]", CommandType.StoredProcedure,
new SqlParameter("@OrderStatusID", status.StatusID),
new SqlParameter("@StatusName", status.StatusName),
new SqlParameter("@CommandID", (int)status.Command),
new SqlParameter("@IsDefault", status.IsDefault),
new SqlParameter("@IsCanceled", status.IsCanceled),
new SqlParameter("@Color", status.Color.IsNotEmpty() ? status.Color : (object)DBNull.Value),
new SqlParameter("@SortOrder", status.SortOrder)
);
}
