/// <summary> /// Method to update a post /// </summary> /// <param name="objPost">Element with all data to save</param> /// <param name="strProfile">Profile of user. 1= writer, 2=editor</param> /// <param name="strName">User name</param> public void Update(Models.Post objPost, string strProfile, string strName) { using (var context = new Entity.blog_dbEntities()) { //elemento a actualizar var update = context.posts.FirstOrDefault(t => t.post_id == objPost.IdPost); //Se actualiza if (strProfile == "1") { //writer profile update.post_title = objPost.strTitle.Trim(); update.post_text = objPost.strText.Trim(); update.post_author = objPost.strAuthor.Trim(); update.post_change = DateTime.Now; update.post_status_published = objPost.blnStatusToPublish == true ? 1 : 0; } else { //editor profile update.post_status_published = objPost.blnStatusToPublish == true ? 2 : 0; if (objPost.blnStatusToPublish == true) { update.post_approval = DateTime.Now; update.post_approval_name = strName; } } context.SaveChanges(); } }
/// <summary> /// Return a list of comments for a post /// </summary> /// <param name="intIdPost">Id of post</param> /// <returns></returns> public void Insert(Comments objComment) { using (var context = new Entity.blog_dbEntities()) { //create model and save to data base var model = new Entity.comments(); model.comment_email = objComment.strEmail; model.comment_text = objComment.strText; model.comment_author = objComment.strAuthor; model.comment_timestamp = DateTime.Now; model.comment_post_id = objComment.intPostId; context.comments.Add(model); context.SaveChanges(); } }
/// <summary> /// Method to insert new posts /// </summary> /// <param name="objPost">Element with all data to save</param> public void Insert(Models.Post objPost) { using (var context = new Entity.blog_dbEntities()) { //create model and save to data base var model = new Entity.posts(); model.post_title = objPost.strTitle; model.post_text = objPost.strText; model.post_author = objPost.strAuthor; model.post_change = DateTime.Now; model.post_status_published = objPost.blnStatusToPublish == true ? 1 : 0; context.posts.Add(model); context.SaveChanges(); } }
/// <summary> /// delete method for posts /// </summary> /// <param name="strId"></param> public void Delete(string strId) { using (var context = new Entity.blog_dbEntities()) { int idElemento = int.Parse(strId); var objPost = context.posts.FirstOrDefault(p => p.post_id == idElemento); if (objPost == null) { return; } context.posts.Remove(objPost); context.SaveChanges(); } }