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