public void DeletePersonal_SelectedItem_NotFounded_NotDelete() { PersonalTelephone n = null; var list = new List <PersonalTelephone> { new PersonalTelephone { PhoneNumber = "1234567890000", Id = 5 } }.AsQueryable(); DataGrid grid = new DataGrid() { ItemsSource = list, SelectedItem = list.FirstOrDefault() }; var mockSet = new Mock <DbSet <PersonalTelephone> >(); mockSet.As <IQueryable <PersonalTelephone> >().Setup(m => m.Provider).Returns(list.Provider); mockSet.As <IQueryable <PersonalTelephone> >().Setup(m => m.Expression).Returns(list.Expression); mockSet.As <IQueryable <PersonalTelephone> >().Setup(m => m.ElementType).Returns(list.ElementType); mockSet.As <IQueryable <PersonalTelephone> >().Setup(m => m.GetEnumerator()).Returns(list.GetEnumerator()); var mockContext = new Mock <PhoneContext>(); mockContext.Setup(m => m.PersPhone).Returns(mockSet.Object); mockSet.Setup(m => m.Find(It.IsAny <int>())).Returns(n); DeleteService service = new DeleteService(mockContext.Object); service.DeletePersonal(grid); mockSet.Verify(m => m.Remove(It.IsAny <PersonalTelephone>()), Times.Never()); mockContext.Verify(m => m.SaveChanges(), Times.Never()); }
public virtual Phone PersonalAdd(Data data) { Phone added = new PersonalTelephone() { PhoneNumber = data.Number, Address = data.Address, Surname = data.Surname, Name = data.Name, Patronymic = data.Patronymic }; context.PersPhone.Add((PersonalTelephone)added); context.SaveChanges(); MessageBox.Show("Добавление записи", "Данные успешно добавлены в базу.", MessageBoxButton.OK); return(added); }
public void PersonalRedaction(PersonalTelephone phone, Data data, bool valid) { if (valid) { PersonalTelephone redPhone = context.PersPhone.Find(phone.Id); redPhone.PhoneNumber = data.Number; redPhone.Address = data.Address; redPhone.Surname = data.Surname; redPhone.Name = data.Name; redPhone.Patronymic = data.Patronymic; context.SaveChanges(); MessageBox.Show("Изменения успешно добавлены в базу.", "Редактирование записи", MessageBoxButton.OK); } else { MessageBox.Show("Ошибка при внесении изменений.", "Редактирование записи", MessageBoxButton.OK); } }
public DataGrid DeletePersonal(DataGrid pGrid) { if (pGrid.SelectedItem != null) { PersonalTelephone phone = pGrid.SelectedItem as PersonalTelephone; PersonalTelephone del = context.PersPhone.Find(phone.Id); if (del != null) { var result = MessageBox.Show("Вы действительно хотите удалить эту запись?", "Удаление", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { context.PersPhone.Remove(del); context.SaveChanges(); } } } pGrid.ItemsSource = context.PersPhone.ToList(); return(pGrid); }
private void Page_Loaded(object sender, RoutedEventArgs e) { typeBox.SelectedIndex = Table; if (Table == 0) { PersonalTelephone phone = Phone as PersonalTelephone; numberTextBox.Text = phone.PhoneNumber; addressTextBox.Text = phone.Address; surnameTextBox.Text = phone.Surname; nameTextBox.Text = phone.Name; patronymicTextBox.Text = phone.Patronymic; } else { CorporativeTelephone phone = Phone as CorporativeTelephone; numberTextBox.Text = phone.PhoneNumber; addressTextBox.Text = phone.Address; companyTextBox.Text = phone.Company; occupationBox.Text = phone.Occupation; } }