public void Create(string catName)
{
using (App164Context context = new App164Context())
{
context.ArticleCategories.Add(new EntityArticleCategory
{
name = catName
});
try
{
context.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
}
public void Delete(int id)
{
using (App164Context context = new App164Context())
{
EntityArticleCategory articleCat = context.ArticleCategories.SingleOrDefault(m => m.CategoryID == id);
context.ArticleCategories.Remove(articleCat);
context.SaveChanges();
}
}
public void Create(EntityArticle article)
{
using (App164Context context = new App164Context())
{
context.Articles.Add(article);
context.SaveChanges();
}
}
public void UpdatePriority(int id, int prio)
{
using (App164Context context = new App164Context())
{
EntityArticle article = context.Articles.SingleOrDefault(m => m.ArticleID == id);
EntityArticle articleToModify = context.Articles.SingleOrDefault(m => m.ArticleID == id);
articleToModify.priority = prio;
context.Entry(article).CurrentValues.SetValues(articleToModify);
context.SaveChanges();
}
}
public List <EntityArticleCategory> GetAllArticleCategories()
{
App164Context context = new App164Context();
return(context.ArticleCategories.ToList());
}
