// 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); }