public static List <string> getAllDocumentsbyYear(int year)
{
//#region Get all albums that contain the track with the word 'Love' in its title
//var query = context.Tracks
// .Include(t => t.Album)
// .Where(t => t.Name.Contains("Love"))
// .Select(t => t.Album)
// .Distinct();
using (var context = new MyContextDb())
{
var query = context.Document
.Include(tesis => tesis.Tesis)
.Include(libros => libros.Libro)
.Include(articles => articles.Articulo)
.Where(d => d.year == year);
//foreach (var item in query)
//{
// item.
//}
}
return(new List <string>());
}
public static List <string> GetAllAutors_Names()
{
using (var context = new MyContextDb())
{
UnitOfWork unit = new UnitOfWork(context);
Repository <Autor> r = new Repository <Autor>(unit);
return(r.All
.Select(a => a.nombre)
.ToList());
}
}
public DocumentServices()
{
var context = new MyContextDb();
_unitOfWork = new UnitOfWork(context);
_repositoryDocument = new Repository <Document>(_unitOfWork);
_repositoryTesis = new Repository <Tesis>(_unitOfWork);
_repositoryLibro = new Repository <Libro>(_unitOfWork);
_repositoryArticulo = new Repository <Articulo>(_unitOfWork);
_repositoryAutor = new Repository <Autor>(_unitOfWork);
_repositoryKeyWord = new Repository <Key_Words>(_unitOfWork);
}
public RoomTypeRepository(MyContextDb myContextDb)
{
_context = myContextDb;
}
public RoomCategoryRepository(MyContextDb myContextDb)
{
_context = myContextDb;
}
public Repository(UnitOfWork.UnitOfWork uow)
{
_context = uow.Context as MyContextDb;
}
public UnitOfWork(MyContextDb context)
{
_context = context;
}
