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