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;
}
}
