private void deleteTicketButton_Click(object sender, RoutedEventArgs e) { // var itm = (Ticket)TicketsGrid.SelectedItem; // var tmp = ( //from tmpTicket in MyDBContext.DBContext.Ticket.ToList<Ticket>() //where tmpTicket.ID_Ticket == itm.ID_Ticket //select tmpTicket // ).ToList(); // MyDBContext.DBContext.Ticket.Remove(tmp[0]); // MyDBContext.DBContext.SaveChanges(); // ShowAll(); if (TicketsGrid.SelectedItems.Count > 0) { for (int i = 0; i < TicketsGrid.SelectedItems.Count; i++) { WFAEntity.API.Ticket objectSkatesTicket = TicketsGrid.SelectedItems[i] as WFAEntity.API.Ticket; //if (objectSkates != null) try { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { //WFAEntity.API.Ticket Skates = WFAEntity.API.DatabaseRequest.GetSkatesById(objectMyDBContext, objectSkates.ID_skates_hire); //objectMyDBContext.Skates_hire.Attach(Skates); //objectMyDBContext.Skates_hire.Remove(Skates); objectMyDBContext.SaveChanges(); } //this.ShowAll(SELECTED_TAB.STUDENT); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
private void ButtonAddEditTicket_Click(object sender, RoutedEventArgs e) { if (!IsEdit) { if (textBlockAddEditCost.Text != string.Empty) { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Ticket objectTicket = new WFAEntity.API.Ticket( textBlockAddEditCost.Text, textBlockAddEditAmount.Text, textBlockAddEditStatus.Text, (WFAEntity.API.Client)ComboBoxAddEditClient.SelectedItem, (WFAEntity.API.MK_schedule)ComboBoxAddEditShedule.SelectedItem, (WFAEntity.API.Other_services)ComboBoxAddEditServices.SelectedItem, (WFAEntity.API.Skates_hire)ComboBoxAddEditSkates.SelectedItem ); try { objectMyDBContext.Ticket.Add(objectTicket); objectMyDBContext.SaveChanges(); MessageBox.Show("Билет добавлен"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } else { MessageBox.Show("Заполните все поля!", "Ошибка!"); this.DialogResult = false; } } else { using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext()) { WFAEntity.API.Employees objectTicket = new WFAEntity.API.Employees(); EditTicket.Cost = textBlockAddEditCost.Text; EditTicket.Amount = textBlockAddEditAmount.Text; EditTicket.Status = textBlockAddEditStatus.Text; try { objectMyDBContext.Ticket.AddOrUpdate(EditTicket); objectMyDBContext.SaveChanges(); MessageBox.Show("Билет Редактирован"); this.DialogResult = true; AF.ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error); } } } }