public static List <Signups> GetSignupsByHour() { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_ReportingGetSignupNumbersByHours"); List <Signups> arr = new List <Signups>(); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { Signups s = new Signups(); s.NumberOfSignups = (int)dr[0]; s.Date = new DateTime((int)dr[4], (int)dr[3], (int)dr[2], (int)dr[1], 0, 0); arr.Add(s); } dr.Close(); } return(arr); }
public static List<Signups> GetSignupsByHour() { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_ReportingGetSignupNumbersByHours"); List<Signups> arr = new List<Signups>(); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { Signups s = new Signups(); s.NumberOfSignups = (int)dr[0]; s.Date = new DateTime((int)dr[4], (int)dr[3], (int)dr[2], (int)dr[1],0,0); arr.Add(s); } dr.Close(); } return arr; }