/*
* Programmer: Megan Villwock
* Last Modified Date: 10/30/2018
*
* Gets data from the database and stores it in class/objects.
*
*/
public static bool GetTestSessions(List <TestSession> testSessionList, ref string error)
{
List <TestSession> TestSessionList = new List <TestSession>();
SqlConnection Connection = new SqlConnection();
SqlDataReader TestSessionDataReader;
SqlCommand Command;
TestSession testSession;
try
{
// Connect to database and get data.
Connection = DatabaseHelper.Connect();
Connection.Open();
Command = new SqlCommand();
Command.Connection = Connection;
Command.CommandText = "SELECT SessionID, TestID, UserID, CreationDate FROM TestSessions;";
TestSessionDataReader = Command.ExecuteReader();
// Add data to list.
while (TestSessionDataReader.Read())
{
testSession = new TestSession();
testSession.intSessionID = TestSessionDataReader.GetInt32(0);
testSession.intTestID = TestSessionDataReader.GetInt32(1);
testSession.intUserID = TestSessionDataReader.GetInt32(2);
testSession.datetimeCreationDate = TestSessionDataReader.GetDateTime(3);
testSessionList.Add(testSession);
}
return(true);
}
catch (Exception ex)
{
Console.Error.WriteLine(ex.Message);
return(false);
}
finally
{
if (Connection != null)
{
Connection.Close();
}
}
}
public static bool GetTestDate(List <TestSession> dateList, ref string error, int UserID, int TestID)
{
List <TestSession> TestSessionList = new List <TestSession>();
SqlConnection Connection = new SqlConnection();
SqlDataReader TestSessionDataReader;
SqlCommand Command;
TestSession testsession;
try
{
// Connect to database and get data.
Connection = DatabaseHelper.Connect();
Connection.Open();
Command = new SqlCommand();
Command.Connection = Connection;
Command.CommandText = "SELECT TestSessions.TestID, TestSessions.CreationDate FROM TestSessions" +
" WHERE TestSessions.UserID = @UserID AND TestSessions.TestID = @TestID;";
Command.Parameters.AddWithValue("@UserID", UserID);
Command.Parameters.AddWithValue("@TestID", TestID);
TestSessionDataReader = Command.ExecuteReader();
// Add data to list.
while (TestSessionDataReader.Read())
{
testsession = new TestSession();
testsession.intTestID = TestSessionDataReader.GetInt32(0);
testsession.datetimeCreationDate = TestSessionDataReader.GetDateTime(1);
dateList.Add(testsession);
}
return(true);
}
catch (Exception ex)
{
Console.Error.WriteLine(ex.Message);
return(false);
}
finally
{
if (Connection != null)
{
Connection.Close();
}
}
}
