public static Inspection SelectById(SQLiteConnection conn, int id)
{
using (SQLiteCommand cmd = new SQLiteCommand(selectById, conn))
{
cmd.Parameters.AddWithValue("@Id", id);
SQLiteDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
Inspection im = new Inspection()
{
Id = Convert.ToInt32(reader["rowid"].ToString()),
Vehicle = VehicleDbMapper.SelectById(conn, Convert.ToInt32(reader["VehicleId"])),
InspectionDate = Convert.ToDateTime(reader["InspectionDate"]),
ValidTo = Convert.ToDateTime(reader["ValidTo"]),
InspectionStation = InspectionStationDbMapper.SelectById(conn, Convert.ToInt32(reader["InspectionStationId"])),
ProtocolNumber = reader["ProtocolNumber"].ToString(),
Tachometer = Convert.ToInt32(reader["Tachometer"].ToString()),
Price = Convert.ToDecimal(reader["Price"].ToString()),
Defects = reader["Defects"].ToString()
};
reader.Close();
return(im);
}
}
catch (Exception e)
{
reader?.Close();
Trace.WriteLine($"EXCEPTION: InspectionDbMapper.SelectById: {e.Message}");
}
}
return(null);
}
public static List <Inspection> SelectAll(SQLiteConnection conn)
{
List <Inspection> result = new List <Inspection>();
using (SQLiteCommand cmd = new SQLiteCommand(selectAll, conn))
{
SQLiteDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
Inspection im = new Inspection()
{
Id = Convert.ToInt32(reader["rowid"].ToString()),
Vehicle = VehicleDbMapper.SelectById(conn, Convert.ToInt32(reader["VehicleId"])),
InspectionDate = Convert.ToDateTime(reader["InspectionDate"]),
ValidTo = Convert.ToDateTime(reader["ValidTo"]),
InspectionStation = InspectionStationDbMapper.SelectById(conn, Convert.ToInt32(reader["InspectionStationId"])),
ProtocolNumber = reader["ProtocolNumber"].ToString(),
Tachometer = Convert.ToInt32(reader["Tachometer"].ToString()),
Price = Convert.ToDecimal(reader["Price"].ToString()),
Defects = reader["Defects"].ToString()
};
result.Add(im);
}
}
catch (Exception e)
{
Trace.WriteLine($"EXCEPTION: InspectionDbMapper.SelectAll: {e.Message}");
}
finally
{
reader?.Close();
}
}
return(result);
}
