public void Update(DalArticle entity) { //context.Set<Article>().AddOrUpdate(entity.GetORMEntity()); var article = context.Set <Article>().Where(a => a.Id == entity.Id).FirstOrDefault(); context.Set <Article>().Attach(article); //if (article != null) //{ //context.Set<Article>().AddOrUpdate(); if (entity.Title != null) { article.Title = entity.Title; } if (entity.Text != null) { article.Text = entity.Text; } if (entity.PublicationDate != null) { article.PublicationDate = entity.PublicationDate; } if (entity.CountLikes != null) { article.CountLikes = entity.CountLikes; } //article = entity.GetORMEntity(); // context.Entry(article).State = EntityState.Modified; context.SaveChanges(); //} }
/// <summary> /// Removing article /// </summary> /// <param name="entity">article for removing</param> public void Delete(DalArticle entity) { var article = context.Set <Article>().Where(a => a.Id == entity.Id).FirstOrDefault(); if (article != null) { context.Set <Article>().Remove(article); } var tagArticle = context.Set <TagArticle>().Where(ta => ta.ArticleId == article.Id); if (tagArticle != null) { foreach (var entry in tagArticle) { context.Set <TagArticle>().Remove(entry); } } var comments = context.Set <Comment>().Where(a => a.ArticleId == entity.Id); if (comments != null) { foreach (var comment in comments) { context.Set <Comment>().Remove(comment); } } context.SaveChanges(); }
/// <summary> /// Updates article entity with specified tag string /// </summary> /// <param name="entity">Base entity for updating</param> /// <param name="tags">String that contains tags</param> public void Update(DalArticle entity, string tags = null) { var article = context.Set <Article>().Where(a => a.Id == entity.Id).FirstOrDefault(); context.Set <Article>().Attach(article); if (entity.Title != null) { article.Title = entity.Title; } if (entity.Content != null) { article.Content = entity.Content; } if (entity.PublicationDate != null) { article.PublicationDate = entity.PublicationDate; } article.Tags.Clear(); article.Rating = entity.Rating; if (tags != null) { article.Tags = new List <Tag>(); FromTagStringToTaggs(article, tags); } }
public Article GetArticleEntity(int id) { using (var connection = ProcessConnection.OpenGungnirReadOnly) { var dal = new DalArticle(); return(DalArticle.GetArticleEntity(connection, id)); } }
public void Delete(DalArticle e) { var article = _context.Articles.FirstOrDefault(x => x.Id == e.Id); if (article != null) { _context.Articles.Remove(article); } }
/// <summary> /// Remove the article from the database. /// </summary> /// <param name="article"></param> public void Delete(DalArticle article) { Article ormArticle = context.Set <Article>().Find(article.Id); if (ormArticle != null) { context.Set <Article>().Remove(ormArticle); } }
public List <SeekHotWord> GetSeekKeyWord(string sqlStr, int pageSize, int pageIndex, out int recordCount) { string strConn = ConfigurationManager.ConnectionStrings["Aliyun"].ConnectionString; strConn = SecurityHelp.IsBase64Formatted(strConn) ? SecurityHelp.DecryptAES(strConn) : strConn; SqlConnection conn = new SqlConnection(strConn); return(DalArticle.GetSeekKeyWord(conn, sqlStr, pageSize, pageIndex, out recordCount)); }
/// <summary> /// Deletes article entity /// </summary> /// <param name="entity">Base entity for removing</param> public void Delete(DalArticle e) { var article = context.Set <Article>().Where(a => a.Id == e.Id).Include(a => a.Tags).FirstOrDefault(); if (article != null) { context.Set <Article>().Remove(article); } //context.Set<Article>().Remove(e.ToOrmArticle()); }
public void Add(Article article, out string contentUrl, out int id, string locationAddress) { string _contentUrl = ""; int _id = 0; Action <SqlConnection> action = (connection) => DalArticle.Add(connection, article, out _contentUrl, out _id, locationAddress); dbManager.Execute(action); contentUrl = _contentUrl; id = _id; }
public void Delete(DalArticle e) { var article = context.Set <Article>().Where(a => a.Id == e.Id).FirstOrDefault(); if (article != null) { context.Set <Article>().Remove(article); } context.SaveChanges(); }
public void Update(DalArticle entity) { var article = _context.Articles.FirstOrDefault(x => x.Id == entity.Id); if (article != null) { article.Title = entity.Title; article.Text = entity.Text; article.TitleImage = entity.TitleImage; } }
/// <summary> /// Creates new article entity with specified tag string /// </summary> /// <param name="e">Base entity for new article entity</param> /// <param name="tags">String that contains tags</param> public void Create(DalArticle e, string tags = null) { var article = e.ToOrmArticle(); if (tags != null) { article.Tags = new List <Tag>(); FromTagStringToTaggs(article, tags); } context.Set <Article>().Add(article); }
public void Add(Article article) { try { Action <SqlConnection> action = (connection) => DalArticle.Add(connection, article); dbManager.Execute(action); logger.Log(Level.Info, "Add:" + JsonHelper.Serialize <Article>(article), null); } catch (Exception ex) { logger.Log(Level.Error, "Add 错误:" + ex.ToString() + "参数:" + JsonHelper.Serialize <Article>(article), null); } }
public static ArticleEntity ToBllArticle(this DalArticle article) { return(new ArticleEntity { Id = article.Id, Title = article.Title, CreationTime = article.CreationTime, Text = article.Text, TitleImage = article.TitleImage, UserId = article.UserId, BlogId = article.BlogId }); }
/// <summary> /// Change properties for specified article and set new tags. /// </summary> /// <param name="article"></param> /// <param name="tags"></param> public void Edit(DalArticle article, string[] tags) { if (article == null) { throw new ArgumentNullException(nameof(article)); } if (tags == null) { tags = new string[0]; } Article ormArticle = context.Set <Article>().Find(article.Id); if (article.Content != null) { ormArticle.Content = article.Content; } if (article.Title != null) { ormArticle.Title = article.Title; } DbSet <Tag> tagSet = context.Set <Tag>(); foreach (Tag tag in ormArticle.Tags) { //TODO optimize here //tag.Articles.Remove(ormArticle); var t = tag.Articles.ToList(); t.Remove(ormArticle); tag.Articles = t; } ormArticle.Tags = new List <Tag>(); foreach (string tag in tags) { Tag ormTag = tagSet.FirstOrDefault(x => x.Value == tag); if (ormTag == null) { ormTag = new Tag() { Value = tag }; tagSet.Add(ormTag); } //TODO optimize here var list = ormTag.Articles.ToList(); list.Add(ormArticle); ormTag.Articles = list; //tagSet.Add(ormTag); ormArticle.Tags.Add(ormTag); } }
public static BllArticle ToBllArticle(this DalArticle article) { return(new BllArticle() { ArticleId = article.Id, CreationDate = article.CreationDate, Tag1 = article.Tag1, Tag2 = article.Tag2, Tag3 = article.Tag3, Title = article.Title, Text = article.Text, Author = article.Author?.ToBllUser() }); }
public static Article ToOrmArticle(this DalArticle article) { if (article == null) { throw new ArgumentNullException(nameof(article)); } return(new Article() { AuthorId = article.AuthorId, Content = article.Content, CreationDateTime = article.CreationDateTime, Id = article.Id, Title = article.Title, }); }
/// <summary> /// Adding article to database /// </summary> /// <param name="entity"></param> public void Create(DalArticle entity) { var article = new Article() { Id = entity.Id, Title = entity.Title, Content = entity.Content, CountLikes = entity.CountLikes, CountShows = entity.CountShows, BloggerId = entity.BloggerId, DatePublication = entity.DatePublication, SectionId = entity.SectionId }; context.Set <Article>().Add(article); context.SaveChanges(); }
/// <summary> /// Update information about article /// </summary> /// <param name="entity">article to update</param> public void Update(DalArticle entity) { var article = context.Set <Article>().Where(a => a.Id == entity.Id).FirstOrDefault(); if (article != null) { article.Id = entity.Id; article.Title = entity.Title; article.Content = entity.Content; article.CountLikes = entity.CountLikes; article.CountShows = entity.CountShows; article.BloggerId = entity.BloggerId; article.DatePublication = entity.DatePublication; article.SectionId = entity.SectionId; context.SaveChanges(); } }
public static ArticleEntity ToBllArticle(this DalArticle dalArticle) { if (dalArticle != null) { return(new ArticleEntity() { Id = dalArticle.Id, Title = dalArticle.Title, Content = dalArticle.Content, CountLikes = dalArticle.CountLikes, CountShows = dalArticle.CountShows, BloggerId = dalArticle.BloggerId, DatePublication = dalArticle.DatePublication, SectionId = dalArticle.SectionId }); } return(null); }
public bool EditCategory(List <ArticleCategory> categoryModelList) { StringBuilder strSql = new StringBuilder(); Dictionary <string, object> dicParams = new Dictionary <string, object>(); for (int i = 0; i < categoryModelList.Count; i++) { var data = categoryModelList[i]; //判断ID是否为空(为空则Add 反之则Update) if (!string.IsNullOrEmpty(data.id.ToString()) && data.id > 0) { string sqlSet = string.Format(" CategoryName = @CategoryName_{0},Sort = @Sort_{0},Color = @Color_{0} ", i); string sqlWhere = string.Format(" id = @id_{0} ", i); strSql.AppendFormat(" UPDATE [Marketing].[dbo].[tbl_NewCategoryList] WITH(rowlock) SET {0} WHERE {1} ", sqlSet, sqlWhere); dicParams.Add("@CategoryName_" + i, data.CategoryName); dicParams.Add("@Sort_" + i, data.Sort); dicParams.Add("@id_" + i, data.id); dicParams.Add("@Color_" + i, data.Color); } else { string sqlSet = string.Format("CategoryName,Sort,Color"); string sqlWhere = string.Format("@CategoryName_{0},@Sort_{0},@Color_{0} ", i); strSql.AppendFormat(" INSERT into [Marketing].[dbo].[tbl_NewCategoryList]({0}) VALUES({1}) ", sqlSet, sqlWhere); dicParams.Add("@CategoryName_" + i, data.CategoryName); dicParams.Add("@Sort_" + i, data.Sort); dicParams.Add("@Color_" + i, data.Color); } } SqlParameter[] sqlParams = new SqlParameter[dicParams.Count];//参数值 //修改 for (int i = 0; i < dicParams.Count; i++) { var dicKey = dicParams.ElementAt(i).Key; var dicValue = dicParams.ElementAt(i).Value; sqlParams[i] = new SqlParameter(dicKey, dicValue); } Func <SqlConnection, bool> action = (connection) => DalArticle.EditCategory(connection, strSql.ToString(), sqlParams); return(dbManager.Execute(action)); }
public static Article ToOrmArticle(this DalArticle dalEntity) { //if (dalEntity == null) // return null; return(new Article() { Id = dalEntity.Id, Title = dalEntity.Title, Content = dalEntity.Content, PublicationDate = dalEntity.PublicationDate, UserId = dalEntity.UserId, Rating = dalEntity.Rating, Comments = dalEntity.Comments != null ? dalEntity.Comments.Select(r => r.ToOrmComment()).ToList() : null, Tags = dalEntity.Tags != null ? dalEntity.Tags.Select(r => r.ToOrmTag()).ToList() : null }); }
/// <summary> /// Create new article with specified tags and add it to database. /// </summary> /// <param name="article"></param> /// <param name="tags"></param> public void Create(DalArticle article, string[] tags) { if (article == null) { throw new ArgumentNullException(nameof(article)); } article.Id = 0; article.CreationDateTime = DateTime.Now; Article ormArticle = article.ToOrmArticle(); if (tags != null) { var tagsDbSet = context.Set <Tag>(); foreach (string tag in tags) { Tag tagEntity = tagsDbSet.FirstOrDefault(x => x.Value == tag); if (tagEntity == null)//if tag not in DB -> add it { tagsDbSet.Add(new Tag() { Articles = new Article[] { ormArticle }, Value = tag }); } else { //TODO optimize here var list = tagEntity.Articles.ToList(); list.Add(ormArticle); tagEntity.Articles = list; //tagEntity.Articles.Add(ormArticle); } } //foreach } //if context.Set <Article>().Add(ormArticle); }
public static Article GetORMEntity(this DalArticle dalEntity) { if (dalEntity == null) { return(null); } return(new Article() { Id = dalEntity.Id, Title = dalEntity.Title, Text = dalEntity.Text, PublicationDate = dalEntity.PublicationDate, AuthorId = dalEntity.AuthorId, CountLikes = dalEntity.CountLikes, Comments = dalEntity.Comments != null ? dalEntity.Comments.Select(r => r.GetORMEntity()).ToList() : null, Tags = dalEntity.Tags != null ? dalEntity.Tags.Select(r => r.GetORMEntity()).ToList() : null }); }
public void Delete(int PKID) { Action <SqlConnection> action = (connection) => DalArticle.Delete(connection, PKID); dbManager.Execute(action); }
public List <Article> SelectAll() { Func <SqlConnection, List <Article> > action = (connection) => DalArticle.SelectAll(connection); return(dbManager.Execute(action)); }
public Article GetByUrl(string url) { Func <SqlConnection, Article> action = (connection) => DalArticle.GetByUrl(connection, url); return(dbManager.Execute(action)); }
public int DeleteQuestion(int PKID) { return(dbManager.Execute(conn => DalArticle.DeleteQuestion(conn, PKID))); }
public bool DeleteArticleNewList(int Id) { return(dbManager.Execute(conn => DalArticle.DeleteArticleNewList(conn, Id))); }
public void Delete(DalArticle e) { var article = _context.Articles.FirstOrDefault(x => x.Id == e.Id); if (article != null) _context.Articles.Remove(article); }
public void Update(Article article) { Action <SqlConnection> action = (connection) => DalArticle.Update(connection, article); dbManager.Execute(action); }
public void Create(DalArticle e) { _context.Articles.Add(e.ToOrmArticle()); }