public static void VolunteerHourSummary(
int pkVolunteer
, out int ProjectCount
, out int WorkDayCount
, out decimal TotalHours)
{
SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.VolunteerHourSummary");
sp.AddInputParameter("@pkVolunteer", pkVolunteer);
sp.AddOutputParameter("@ProjectCount", SqlDbType.Int);
sp.AddOutputParameter("@WorkDayCount", SqlDbType.Int);
sp.AddOutputParameter("@TotalHours", SqlDbType.Decimal);
sp.ExecNonQuery();
ProjectCount = sp.OutputParameterValueInt("@ProjectCount", 0);
WorkDayCount = sp.OutputParameterValueInt("@WorkDayCount", 0);
TotalHours = sp.OutputParameterValueDecimal("@TotalHours", 0);
}