示例#1
0
        public void CreateArticle(ArticleEdit article)
        {
            Article new_article = new Article()
            {
                Title = article.Title,
                Text = article.Text,
                ImgName = article.ImgName,
                DateTime = article.DateTime
            };
            Db.Articles.Create(new_article);

            using (var db = new PeriodicalContext())
            {
                var existedArticle = db.Articles.Where(e => e.Title == new_article.Title).FirstOrDefault();
                var edition = db.Editions.Where(e => e.Name == article.EditionName).FirstOrDefault();
                existedArticle.Edition = edition;
                edition.Articles.Add(existedArticle);
                db.SaveChanges();
            }
        }
示例#2
0
文件: DalHandler.cs 项目: mind0n/hive
        public static int InsertOrUpdateArtile(Article article, int flag)
        {
            int rlt = 0;
            string commText = string.Empty;
            if (flag == 0)
            {
                commText = "insert into [tArticles] (categoryid , userid ,caption , link ,articleupdate , visible , tag ,content) values ('"
                        + article.CategoryId + "'," + article.UserId + ",'" + article.Caption + "','" + article.Link + "','" + article.ArticleUpdate + "',"
                        + article.IsVisible + " ,'" + article.Tag + "','" + article.Content + "')";
                try
                {
                    rlt = OleDbHelper.ExecuteNonQuery(commText);

                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            else if (flag == 1)
            {
                commText = "update [tArticles] set categoryid ="
                        + article.CategoryId + ",userid =" + article.UserId
                        + ",caption ='" + article.Caption 
                        + "',articleupdate ='" + article.ArticleUpdate + "' ,visible= " + article.IsVisible
                        + " ,content= '" + article.Content
                        + "' where articleid =" + article.ArticleId;
                try
                {
                    rlt = OleDbHelper.ExecuteNonQuery(commText);

                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }

            return rlt;
        }
        public void Create(ArticleDTO article)
        {
            //<Tag> tags = TagModule.ReturnTags(article.Tags);

            string[] newTags = TagModule.ReturnTags(article.Tags);
            List<Tag> tags = new List<Tag>();
            if (newTags != null)
            {
                foreach (var t in newTags)
                {
                    var tagFromDB = Database.Tags.GetAll().FirstOrDefault(tag => tag.Name == t);
                    if (tagFromDB != null)
                        tags.Add(tagFromDB);
                    else
                    {
                        Tag newTag = new Tag { Name = t };
                        tags.Add(newTag);
                    }
                }
            }
            else
            {
                tags = null;
            }
            Article art = new Article
            {
                Title = article.Title,
                ArticleText = article.ArticleText,
                CreationDate = DateTime.Now,
                BlogId = article.BlogId,
                Tags = tags
            };
            Database.Articles.Create(art);
            Database.Save();
        }