public static int TableArticles(Table_Article tblArticle) { if (tblArticle.ArticleId <= 0) Db.Table_Articles.InsertOnSubmit(tblArticle); Db.SubmitChanges(); Table_Article article = (from c in Db.Table_Articles where (c.Title == tblArticle.Title) select c).SingleOrDefault(); return (article == null) ? -1 : article.ArticleId; }
public static void TableArticle(Table_Article article) { //TODO transaction int articleId = article.ArticleId; var delTaks = Filter.GetTaktzirimByArticleId(articleId); foreach (var tak in delTaks) { TableTaktzirim(tak); } Db.Table_Articles.DeleteOnSubmit(article); Db.SubmitChanges(); }