public List <Cars> Reader(string query, string function)
{
List <Cars> allCars = new List <Cars>();
try
{
using (SQLiteConnection connection = new SQLiteConnection(_30122020_EXAMEN_SQLAppConfig.ConnectionString))
{
using (SQLiteCommand command = new SQLiteCommand(query, connection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Cars c = new Cars
{
Id = (long)reader["id"],
Manufacturer = reader["manufacturer"].ToString(),
Model = reader["model"].ToString(),
Year = (int)reader["year"]
};
allCars.Add(c);
}
}
return(allCars);
}
}
}
catch (Exception ex)
{
_30122020_EXAMEN_SQLAppConfig._log.Error($"Process '{ function}' failed.Exception : {ex}");
Console.WriteLine($"Process '{ function}' failed.Exception : {ex}");
Console.ReadKey();
Environment.Exit(-1);
}
return(null);
}
public void AddCar(Cars c)
{
_query = $"INSERT INTO tests" +
$"VALUES ({c.Manufacturer},{c.Model},{c.Year})";
int row = NonReader(_query, "Add Car");
}
public void UpdateCar(int id, Cars c)
{
_query = $"UPDATE tests SET id = {c.Id},manufacturer = {c.Manufacturer}, model = {c.Model},year = {c.Year} ";
NonReader(_query, "Update Car");
}
public override bool Equals(object obj)
{
Cars test = obj as Cars;
return(this.Id.Equals(test.Id));
}