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