/// <summary>
/// Adds article do DB
/// </summary>
public void AddArticle(Article article)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.Articles.Add(article);
context.SaveChanges();
}
}
public void Add(PageContent pageContent)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
context.PageContents.Add(pageContent);
context.SaveChanges();
}
}
/// <summary>
/// Updates given article
/// </summary>
public void UpdateArticle(Article article)
{
using (KrisDbContext context = new KrisDbContext(csKris))
{
//context.Articles.Attach(article);
context.Entry(article).State = EntityState.Modified;
context.SaveChanges();
}
}
public List <T> GetItems <T>() where T : DictionaryItem
{
List <T> items = null;
using (KrisDbContext context = new KrisDbContext(csKris))
{
items = context.Set <T>().AsNoTracking().ToList();
}
return(items);
}
public async Task <List <PageContent> > GetPageContents()
{
List <PageContent> pageContents = new List <PageContent>();
using (KrisDbContext context = new KrisDbContext(csKris))
{
pageContents = await context.PageContents.AsNoTracking()
.ToListAsync();
}
return(pageContents);
}
public PageContent GetPageContentByCode(string code)
{
PageContent pageContent = null;
using (KrisDbContext context = new KrisDbContext(csKris))
{
pageContent = context.PageContents.AsNoTracking()
.Where(x => x.Code == code).FirstOrDefault();
}
return(pageContent);
}
/// <summary>
/// Returns all articles with Type included
/// </summary>
public List <Article> GetArticles()
{
List <Article> articles = null;
using (KrisDbContext context = new KrisDbContext(csKris))
{
articles = context.Articles.AsNoTracking()
.Include(x => x.Type)
.ToList();
}
return(articles);
}
public Article GetByCode(string code)
{
Article a = null;
using (KrisDbContext context = new KrisDbContext(csKris))
{
a = context.Articles.AsNoTracking()
.Where(x => x.Code == code)
.Include(x => x.Type)
.FirstOrDefault();
}
return(a);
}
/// <summary>
/// Returns articles of a given type
/// </summary>
public List <Article> GetArticlesByType(string typeCode)
{
List <Article> articles = null;
using (KrisDbContext context = new KrisDbContext(csKris))
{
articles = context.Articles.AsNoTracking()
.Where(x => x.Type.Code == typeCode)
.Include(x => x.Type)
.ToList();
}
return(articles);
}
/// <summary>
/// Returns articles whose title contains a given part
/// </summary>
public List <Article> GetArticlesByTitlePart(string titlePart)
{
List <Article> articles = null;
using (KrisDbContext context = new KrisDbContext(csKris))
{
articles = context.Articles.AsNoTracking()
.Where(r => r.Title.ToUpper().Contains(titlePart.ToUpper()))
.Include(x => x.Type)
.ToList();
}
return(articles);
}
/// <summary>
/// Returns an article with a given ID
/// </summary>
public Article GetByID(int id)
{
Article a = null;
using (KrisDbContext context = new KrisDbContext(csKris))
{
a = context.Articles.AsNoTracking()
.Where(x => x.Id == id)
.Include(x => x.Type)
.FirstOrDefault();
}
return(a);
}
