public List <Cars> GetAllCars() { List <Cars> result = new List <Cars>(); try { using (SQLiteCommand cmd = new SQLiteCommand()) { using (cmd.Connection = new SQLiteConnection(m_conn_string)) { cmd.Connection.Open(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT * FROM Cars"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Cars c = new Cars { ID = (long)reader["ID"], Manufacturer = reader["Manufacturer"].ToString(), Year = (long)reader["YEAR"], Model = reader["Model"].ToString(), }; result.Add(c); } } } } catch (Exception ex) { my_logger.Error("Failed Function GetAllCars by query (select * from cars)"); my_logger.Error($"Failed to read from data base. Error : {ex}"); } return(result); }
public void UpdateCars(Cars c, int id) { ExecuteNonQuery( $"UPDATE Cars SET Manufacturer='{c.Manufacturer}', Year={c.Year},Model='{c.Model}'" + $"WHERE ID={id}"); }
public void AddCars(Cars c) { ExecuteNonQuery("INSERT INTO Cars(Manufacturer,Model,Year)" + $"VALUES('{c.Manufacturer}', '{c.Model}', {c.Year});"); }
public override bool Equals(object obj) { Cars c = (Cars)obj; return(this.ID == c.ID); }