public static void GetAllInspections()
{
sqlconn.Open();
Engine.inspectionList.Clear();
string sql = @"
SELECT [Id]
,[RegistrationNumber]
,[PerformedAt]
,[IsApproved]
FROM [FIRSTTURNINADO].[dbo].[Inspection]
";
SqlCommand command = new SqlCommand(sql, sqlconn);
//Skicka SQL kommando till servern
//Servern svarar nu i dataReader
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
int id = int.Parse(dataReader["Id"].ToString());
string registrationNumber = dataReader["RegistrationNumber"].ToString();
DateTime date = DateTime.Parse(dataReader["PerformedAt"].ToString());
bool isApproved = bool.Parse(dataReader["IsApproved"].ToString());
Inspection inspectionPlaceHolder = new Inspection(id, registrationNumber, date, isApproved);
// string completed = dataReader["Completed"].ToString();
Engine.inspectionList.Add(inspectionPlaceHolder);
}
//Console.WriteLine("Hello Database Yes?");
sqlconn.Close();
}
