//Метод непосредственного добавления записи в БД
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;
}
