Exemplo n.º 1
0
 public static DataSet GetBuildProjectParameterDefaults()
 {
     SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.GetBuildProjectParameterDefaults");
     return sp.GetDsResult();
 }
Exemplo n.º 2
0
        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();
        }
Exemplo n.º 3
0
 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();
 }
Exemplo n.º 4
0
        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;
        }