public List <MVwPeopleKeyWord> GetPersonalCollectionByKW(int IdKW)
{
List <VwPeopleKeyWord> data = null;
NostradamusContextFactory factory = new NostradamusContextFactory();
using (var context = factory.CreateDbContext(new string[] { _connection }))
{
data = context.VwPeopleKeyWords.Where(x => x.Idkw == IdKW).ToList();
}
return(ModelsTransformer.TransferModelList <VwPeopleKeyWord, MVwPeopleKeyWord>(data));
}
public List <MPersonBase> GetPersonalCollectionByLastName(string LastName)
{
List <Person> data = new List <Person>();
NostradamusContextFactory factory = new NostradamusContextFactory();
using (var context = factory.CreateDbContext(new string[] { _connection }))
{
var tem = context.People;
data.AddRange(context.People);
data = data.Where(x => x.SecondName.Contains(LastName)).ToList();
}
return(ModelsTransformer.TransferModelList <Person, MPersonBase>(data));
}
public List <MKeyword> GetKeywordsCollection(int refId)
{
List <Keyword> data = new List <Keyword>();
NostradamusContextFactory factory = new NostradamusContextFactory();
using (var context = factory.CreateDbContext(new string[] { _connection }))
{
var tem = context.Keywords;
data.AddRange(context.Keywords);
data = data.Where(x => x.ReferenceId == refId && x.Idkw != 0 && x.Idkw != 400).ToList();
}
return(ModelsTransformer.TransferModelList <Keyword, MKeyword>(data));
}