private void btnAdaug_Click(object sender, RoutedEventArgs e) { var avn = App.AvionDb; RezervareBilet rb = new RezervareBilet(); rb.IDRezervare = Convert.ToInt32(txtCodRezervare.Text); txtCodRezervare.Clear(); rb.Clasa = txtClasa.Text; txtClasa.Clear(); rb.DataSosire = Convert.ToDateTime(dpDataSosire.Text); //dpDataSosire.Clear(); rb.DataPlecare = Convert.ToDateTime(dpDataPlecare.Text); //dpDataPlecare.Clear(); rb.Destinatie = txtDestinatie.Text; txtDestinatie.Clear(); rb.Tarif = Convert.ToInt32(txtTarif.Text); txtTarif.Clear(); rb.IDPasager = Convert.ToInt32(txtIDPasager.Text); txtIDPasager.Clear(); avn.RezervareBiletes.Add(rb); avn.SaveChanges(); lbRezervareBilet.Items.Clear(); foreach (var rb1 in avn.RezervareBiletes) { var itm = new ListViewItem(); itm.Content = rb1.IDRezervare + " " + rb1.Clasa + " " + rb1.DataSosire + " " + rb1.DataPlecare + " " + rb1.Destinatie + " " + rb1.Tarif + " " + rb.IDPasager + " "; itm.Tag = rb1; lbRezervareBilet.Items.Add(itm); } }
private void btnSterg_Click(object sender, RoutedEventArgs e) { var avn = App.AvionDb; RezervareBilet rb1 = (lbRezervareBilet.SelectedItem as ListViewItem).Tag as RezervareBilet; txtSters.Text = " "; var s = (from s1 in avn.RezervareBiletes where s1.IDRezervare == rb1.IDRezervare select s1).First(); avn.RezervareBiletes.Remove(s); avn.SaveChanges(); }
private void btnModific_Click(object sender, RoutedEventArgs e) { var avn = App.AvionDb; // if(lbClient.SelectedItem!=null) RezervareBilet rezbilet = (lbRezervareBilet.SelectedItem as ListViewItem).Tag as RezervareBilet; var rb = (from rb1 in avn.RezervareBiletes where rezbilet.IDRezervare == rb1.IDRezervare select rb1).First(); rb.IDRezervare = Convert.ToInt32(txtCodRezervare.Text); txtCodRezervare.Clear(); rb.Clasa = txtClasa.Text; txtClasa.Clear(); rb.DataSosire = Convert.ToDateTime(dpDataSosire.Text); //dpDataSosire.Clear(); rb.DataPlecare = Convert.ToDateTime(dpDataPlecare.Text); //dpDataPlecare.Clear(); rb.Destinatie = txtDestinatie.Text; txtDestinatie.Clear(); rb.Tarif = Convert.ToInt32(txtTarif.Text); txtTarif.Clear(); rb.IDPasager = Convert.ToInt32(txtIDPasager.Text); txtIDPasager.Clear(); avn.SaveChanges(); }