public int GetNumberOfOrdersWithStatus(OrderStatus orderStatus) { var query = new SQLQueryScaler <int>(SQLCountOrderOfStatus); query.Parameters.Add("OrderStatus", (int)orderStatus); var count = queryHelper.RunScalerQuery <int>(query); return(count); }