public static decimal GetTotalForOrder(int order)
        {
            string query = string.Format(QUERY_GET_TOTAL, order);

            return((decimal)DatabaseManager.ExecuteScalar(query));
        }