private void AddButton_Click(object sender, RoutedEventArgs e)
{
var planeModel = new PlaneModel() { Name = NameTextBox.Text, Cost = Convert.ToInt64(CostTextBox.Text), FuelConsumption = Convert.ToInt64(FuelTextBox.Text) }; // , Model = ModelComboBox.SelectedValue.ToString() };
planeModel.Insert();
planeModelViewSource.Source = planeModel.GetAll();
}
public void DeleteModel(PlaneModel myModel)
{
try
{
using (var conn = new SQLiteConnection(connString))
{
var cmdSql = new SQLiteCommand("DELETE FROM [PlaneModel] WHERE name = (@name)", conn);
conn.Open();
cmdSql.Parameters.AddWithValue("@name", myModel.Name);
int result = cmdSql.ExecuteNonQuery();
conn.Close();
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw ex;
}
}
public List<PlaneModel> SelectAllModels()
{
try
{
using (var conn = new SQLiteConnection(connString))
{
var cmdSql = new SQLiteCommand("SELECT * FROM [PlaneModel]", conn);
conn.Open();
var reader = cmdSql.ExecuteReader();
var listAll = new List<PlaneModel>();
while (reader.Read())
{
var planeModel = new PlaneModel();
planeModel.id = Convert.ToInt64(reader["id"].ToString());
planeModel.Name = reader["name"].ToString().Trim();
planeModel.Cost = Convert.ToDecimal(reader["cost"].ToString().Trim());
planeModel.FuelConsumption = Convert.ToDecimal(reader["fuelConsumption"].ToString().Trim());
listAll.Add(planeModel);
}
reader.Dispose();
conn.Close();
return listAll;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw ex;
}
}
public PlaneModel SelectModel(long id)
{
try
{
using (var conn = new SQLiteConnection(connString))
{
var cmdSql = new SQLiteCommand("SELECT * FROM [PlaneModel] WHERE id = @id", conn);
conn.Open();
cmdSql.Parameters.AddWithValue("@id", id);
var reader = cmdSql.ExecuteReader();
var planeModel = new PlaneModel();
while (reader.Read())
{
planeModel.id = Convert.ToInt64(reader["id"].ToString());
planeModel.Name = reader["name"].ToString().Trim();
planeModel.Cost = Convert.ToDecimal(reader["cost"].ToString().Trim());
planeModel.FuelConsumption = Convert.ToDecimal(reader["fuelConsumption"].ToString().Trim());
}
reader.Dispose();
conn.Close();
return planeModel;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw ex;
}
}
public void InsertModel(PlaneModel myModel)
{
try
{
using (var conn = new SQLiteConnection(connString))
{
var cmdSql = new SQLiteCommand("INSERT INTO [PlaneModel] (Name, Cost, FuelConsumption) VALUES (@name, @cost, @fuelConsumption)", conn);
conn.Open();
cmdSql.Parameters.AddWithValue("@name", myModel.Name);
cmdSql.Parameters.AddWithValue("@cost", myModel.Cost);
cmdSql.Parameters.AddWithValue("@fuelConsumption", myModel.FuelConsumption);
cmdSql.ExecuteNonQuery();
conn.Close();
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw ex;
}
}
