//Метод непосредственного добавления записи в БД private void AddEmployee2DB() { CatalogueBD = new CatalogueDBContext(); CatalogueBD.Employees.Add(new Employee { FirstName = inputFirstName, SecondName = inputSecondName }); CatalogueBD.SaveChanges(); }
//Удаление письма из БД private void DelLetter4DB() { CatalogueBD = new CatalogueDBContext(); var foundLet = from lett in CatalogueBD.Letters where lett.Subject == selectedLetter.Subject && lett.TextMessage == selectedLetter.TextMessage select lett; CatalogueBD.Letters.Remove(foundLet.First()); CatalogueBD.SaveChanges(); Letters.Remove(selectedLetter); }
//Метод непосредственного добавления записи о новом письме в БД private void AddLetter2DB() { CatalogueBD = new CatalogueDBContext(); CatalogueBD.Letters.Add(new Letter { Date = inputDateTime, Subject = inputSubject, TextMessage = inputMessage, SenderId = FoundEmployee(selectedSender, CatalogueBD.Employees).First().Id, RecipientId = FoundEmployee(selectedRecipient, CatalogueBD.Employees).First().Id }); CatalogueBD.SaveChanges(); }
public AddLetterViewModel() { CatalogueBD = new CatalogueDBContext(); Employees = new ObservableCollection <ModelEmployee>(); //Заполнение списка сотрудников из базы foreach (Employee emp in CatalogueBD.Employees.Include(x => x.Letters).ToList()) { Employees.Add(new ModelEmployee() { FirstName = emp.FirstName, SecondName = emp.SecondName, FullName = emp.FirstName + " " + emp.SecondName }); } if (Employees.Count > 0) //Назначаем начальные значения для combobox { selectedSender = Employees[0]; selectedRecipient = Employees[0]; } inputDateTime = DateTime.Now; }
public HomeViewModel(IViewModelsResolver resolver) { //Блок для обеспечения навигации по страницам _resolver = resolver; pAddLetterViewModel = _resolver.GetViewModelInstance(PageAddLetterlAlias); pAddEmployeeViewModel = _resolver.GetViewModelInstance(PageAddEmployeelAlias); OpenPageAddLetterCommand = new RelayCommand <INotifyPropertyChanged>(OpenPageAddLetterCommandExecute); OpenPageAddEmployeeCommand = new RelayCommand <INotifyPropertyChanged>(OpenPageAddEmployeeCommandExecute); //наполняем DG при инициализации CatalogueBD = new CatalogueDBContext(); Letters = new ObservableCollection <ModelLetter>(); foreach (Letter let in CatalogueBD.Letters.Include(x => x.Recipient).Include(y => y.Sender).ToList()) { Letters.Add(new ModelLetter() { Date = let.Date.ToShortDateString(), Subject = let.Subject, Sender = let.Sender.FirstName + " " + let.Sender.SecondName, Recipient = let.Recipient.FirstName + " " + let.Recipient.SecondName, TextMessage = let.TextMessage }); } }
public CatalogueManager(CatalogueDBContext ctx) { context = ctx; }