コード例 #1
0
ファイル: MainWindow.xaml.cs プロジェクト: Vovanus0372/KP
 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);
             }
         }
     }
 }
コード例 #2
0
 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);
             }
         }
     }
 }