public void DeletePlane(Plane myPlane) { try { using (var conn = new SQLiteConnection(connString)) { var cmdSql = new SQLiteCommand("DELETE FROM [MyPlanes] WHERE companny = (@companny) AND idPlaneModel = (@idPlaneModel)", conn); conn.Open(); cmdSql.Parameters.AddWithValue("@companny", myPlane.Companny); cmdSql.Parameters.AddWithValue("@idPlaneModel", myPlane.Model.id); int result = cmdSql.ExecuteNonQuery(); conn.Close(); } } catch (Exception ex) { Console.WriteLine(ex); throw ex; } }
public List<Plane> SelectlPlanesByCountry(string country) { try { using (var conn = new SQLiteConnection(connString)) { var cmdSql = new SQLiteCommand("SELECT * FROM [MyPlanes] WHERE UPPER(country) = UPPER(@country)", conn); conn.Open(); cmdSql.Parameters.AddWithValue("@country", country); var reader = cmdSql.ExecuteReader(); var listAll = new List<Plane>(); while (reader.Read()) { var plane = new Plane(); plane.Companny = reader["companny"].ToString().Trim(); plane.Country = reader["country"].ToString().Trim(); var idModel = reader["idPlaneModel"].ToString().Trim(); plane.Model = SelectModel(long.Parse(idModel)); listAll.Add(plane); } reader.Dispose(); conn.Close(); return listAll; } } catch (Exception ex) { Console.WriteLine(ex); throw ex; } }
public void InsertPlane(Plane myPlane) { try { using (var conn = new SQLiteConnection(connString)) { var cmdSql = new SQLiteCommand("INSERT INTO [MyPlanes] (Companny, Country, IdPlaneModel) VALUES (@companny, @country, @idPlaneModel)", conn); conn.Open(); cmdSql.Parameters.AddWithValue("@companny", myPlane.Companny); cmdSql.Parameters.AddWithValue("@country", myPlane.Country); cmdSql.Parameters.AddWithValue("@idPlaneModel", myPlane.Model.id); cmdSql.ExecuteNonQuery(); conn.Close(); } } catch (Exception ex) { Console.WriteLine(ex); throw ex; } }