public List <Resultater> GetFromDatabase()
{
List <Resultater> results = new List <Resultater>();
sqlCom.CommandText = "SELECT * FROM Results;";
sqlCom.Connection = sqlCon;
try
{
sqlCon.Open();
using (SqlDataReader reader = sqlCom.ExecuteReader())
{
while (reader.Read())
{
Resultater result = new Resultater();
results.Add(result);
}
}
}
catch (SqlException s)
{
throw s;
}
finally
{
sqlCon.Close();
}
return(results);
}
public void SendAnswer(Resultater resultat)
{
string[] values = new string[] {
resultat.Q1,
resultat.Q1Comments,
resultat.Q2,
resultat.Q2Comments,
resultat.Q3,
resultat.Q3Comments,
resultat.Q4,
resultat.Q4Comments,
resultat.AdditionalComments
};
db.InsertIntoDatabase(values);
}
