// Single objects;
public MPersonBase GetPersonById(int Id)
{
Person data = null;
NostradamusContextFactory factory = new NostradamusContextFactory();
using (var context = factory.CreateDbContext(new string[] { _connection }))
{
data = context.People.Where(x => x.Id == Id).FirstOrDefault();
}
return(ModelsTransformer.TransferModel <Person, MPersonBase>(data));
}
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));
}
public MKeyword GetKWbyId(int Id)
{
Keyword kw = null;
NostradamusContextFactory factory = new NostradamusContextFactory();
using (var context = factory.CreateDbContext(new string[] { _connection }))
{
var tem = context.Keywords;
kw = context.Keywords.Where(x => x.Idkw == Id).FirstOrDefault();
if (kw != null)
{
return(ModelsTransformer.TransferModel <Keyword, MKeyword>(kw));
}
}
return(null);
}