public static DataSet GetBuildProjectParameterDefaults()
{
SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.GetBuildProjectParameterDefaults");
return sp.GetDsResult();
}
public static DataSet VolunteerList(int pkOrganization, int pkBuildProject, bool ActiveOnly)
{
SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.VolunteerList");
sp.AddInputParameter("@pkOrganization", pkOrganization);
sp.AddInputParameter("@pkBuildProject", pkBuildProject);
sp.AddInputParameter("@ActiveOnly", ActiveOnly);
return sp.GetDsResult();
}
public static DataSet WorkDaySelectedVolunteers(int pkWorkDay, int pkOrganization)
{
SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.GetWorkDayVolunteersSelected");
sp.AddInputParameter("@pkWorkDay", pkWorkDay);
sp.AddInputParameter("@pkOrganization", pkOrganization);
return sp.GetDsResult();
}
public static DataSet GetWorkDays(int pkBuildProject, out decimal TotalProjectHours)
{
SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.GetWorkDays");
sp.AddInputParameter("@fkBuildProject", pkBuildProject);
DataSet ds = sp.GetDsResult();
TotalProjectHours = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
TotalProjectHours += (decimal)dr["TotalHours"];
}
return ds;
}