public void SelectAuthors(object _)
{
FirstColName = "Id";
SecondColName = "Name";
using (var context = new DBContextLASTEDITION())
{
var query = from author in context.Authors
select new DataItem
{
FirstDataItem = author.IdA.ToString(),
SecondDataItem = author.Name
};
Data = new ObservableCollection <DataItem>(query);
OnProperyChanged(nameof(Data));
ChangeNames();
}
}
public void SelectReaders(object _)
{
FirstColName = "Id";
SecondColName = "Expiration date";
using (var context = new DBContextLASTEDITION())
{
var query = from reader in context.Readers.Include("PersonTicket")
select new DataItem
{
FirstDataItem = reader.IdR.ToString(),
SecondDataItem = reader.PersonTicket.ExpirationDate.ToString()
};
Data = new ObservableCollection <DataItem>(query);
OnProperyChanged(nameof(Data));
ChangeNames();
}
}
public void SelectBooks(object _)
{
FirstColName = "Author";
SecondColName = "Create date";
using (var cotnext = new DBContextLASTEDITION())
{
var query = from book in cotnext.Books
select new DataItem
{
FirstDataItem = book.Author.Name,
SecondDataItem = book.CreateDate.ToString()
};
Data = new ObservableCollection <DataItem>(query);
OnProperyChanged(nameof(Data));
ChangeNames();
}
}
