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