public List <BM_Attempt> returnAllAttemptsToday() { string query = "SELECT [Id],[secondsamt],[datetimesubmitted] FROM [hectorhaas].[precheckAverageAttempts] WHERE [datetimesubmitted] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP)) AND [datetimesubmitted] < DATEADD(DAY, 1, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP))"; List <BM_Attempt> attemptList = new List <BM_Attempt>(); SqlConnection conn = new SqlConnection(DataAccess.connstring); //Open Conn conn.Open(); SqlCommand sc = new SqlCommand(query, conn); SqlDataReader dr = sc.ExecuteReader(); //Loop the reader if (dr.HasRows) { while (dr.Read()) { //Create temp object BM_Attempt attempt = new BM_Attempt(); attempt.Id = dr.GetValue(0).ToString(); attempt.secondsamt = dr.GetValue(1).ToString(); attempt.datetimesubmitted = dr.GetValue(2).ToString(); //Add to list attemptList.Add(attempt); } } //Close Conn conn.Close(); //Return the list and end the method return(attemptList); }
public List <BM_Attempt> returnAllAttempts() { string query = "SELECT Id, secondsamt, datetimesubmitted FROM hectorhaas.precheckAverageAttempts"; List <BM_Attempt> attemptList = new List <BM_Attempt>(); SqlConnection conn = new SqlConnection(DataAccess.connstring); //Open Conn conn.Open(); SqlCommand sc = new SqlCommand(query, conn); SqlDataReader dr = sc.ExecuteReader(); //Loop the reader if (dr.HasRows) { while (dr.Read()) { //Create temp object BM_Attempt attempt = new BM_Attempt(); attempt.Id = dr.GetValue(0).ToString(); attempt.secondsamt = dr.GetValue(1).ToString(); attempt.datetimesubmitted = dr.GetValue(2).ToString(); //Add to list attemptList.Add(attempt); } } //Close Conn conn.Close(); //Return the list and end the method return(attemptList); }