/// <summary> /// Deletes the specified Publication Comment. /// </summary> /// <param name="publicationComment">The publication comment.</param> public void Delete(tbl_PublicationComment publicationComment) { var publicationCommentMarks = _dataContext.tbl_PublicationMark.Where(pm => pm.PublicationCommentID == publicationComment.ID); foreach (var publicationCommentMark in publicationCommentMarks) { _dataContext.DeleteObject(publicationCommentMark); } _dataContext.DeleteObject(publicationComment); _dataContext.SaveChanges(); }
/// <summary> /// Updates the specified publication comment. /// </summary> /// <param name="publicationComment">The publication comment.</param> public void Update(tbl_PublicationComment publicationComment) { var updatesitePublicationComment = SelectById(publicationComment.ID); updatesitePublicationComment.PublicationID = publicationComment.PublicationID; updatesitePublicationComment.UserID = publicationComment.UserID; updatesitePublicationComment.isOfficialAnswer = publicationComment.isOfficialAnswer; updatesitePublicationComment.Comment = publicationComment.Comment; updatesitePublicationComment.CreatedAt = publicationComment.CreatedAt; updatesitePublicationComment.FileName = publicationComment.FileName; _dataContext.SaveChanges(); }
public void Save(Guid PublicationID) { var publicationCommentValues = new List <PublicationCommentStructure>(); if (ViewState["PublicationComment"] != null) { var publicationCommentValuesOld = dataManager.PublicationComment.SelectByPublicationId(PublicationID).ToList(); publicationCommentValues = (List <PublicationCommentStructure>)ViewState["PublicationComment"]; foreach (var publicationCommentValue in publicationCommentValues) { publicationCommentValue.PublicationID = PublicationID; var updatesitePublicationComment = new tbl_PublicationComment(); updatesitePublicationComment.ID = publicationCommentValue.ID; updatesitePublicationComment.PublicationID = PublicationID; updatesitePublicationComment.UserID = publicationCommentValue.UserID; updatesitePublicationComment.isOfficialAnswer = publicationCommentValue.isOfficialAnswer; updatesitePublicationComment.Comment = publicationCommentValue.Comment; updatesitePublicationComment.CreatedAt = publicationCommentValue.Date; updatesitePublicationComment.FileName = publicationCommentValue.FileName ?? ""; var removePublicationCommentValue = publicationCommentValuesOld.SingleOrDefault(a => a.ID == publicationCommentValue.ID); if (removePublicationCommentValue != null) { dataManager.PublicationComment.Update(updatesitePublicationComment); publicationCommentValuesOld.Remove(removePublicationCommentValue); } else { dataManager.PublicationComment.Add(updatesitePublicationComment); } } if (publicationCommentValuesOld != null && publicationCommentValuesOld.Count() > 0) { foreach (var item in publicationCommentValuesOld) { try { dataManager.PublicationComment.Delete(item); } catch { } } } } }
/// <summary> /// Adds the specified site id. /// </summary> /// <param name="siteId">The site id.</param> /// <param name="contactId">The contact id.</param> /// <param name="publicationId">The publication id.</param> /// <param name="comment">The comment.</param> /// <param name="fileName">Name of the file.</param> /// <returns></returns> public ActivityCommentMap Add(Guid siteId, Guid contactId, Guid publicationId, string comment, string fileName) { var publicationComment = new tbl_PublicationComment { ID = Guid.NewGuid(), CreatedAt = DateTime.Now, PublicationID = publicationId, UserID = contactId, Comment = comment, isOfficialAnswer = false, FileName = fileName }; Add(publicationComment); var publicationCommentMap = new ActivityCommentMap { ID = publicationComment.ID, PublicationID = publicationComment.PublicationID, CreatedAt = publicationComment.CreatedAt, UserFullName = publicationComment.tbl_Contact.UserFullName, Comment = publicationComment.Comment.ToHtml(), isOfficialAnswer = publicationComment.isOfficialAnswer, FormattedDate = ((DateTime)publicationComment.CreatedAt).ToString("d MMMM в HH:mm"), FileName = publicationComment.FileName }; var fsp = new FileSystemProvider(); if (!string.IsNullOrEmpty(publicationCommentMap.FileName)) { publicationCommentMap.VirtualFileName = fsp.GetLink(siteId, "PublicationComments", publicationCommentMap.FileName, FileType.Attachment); } return(publicationCommentMap); }
/// <summary> /// Add the specified Publication Comment. /// </summary> /// <param name="publicationComment">The publication comment.</param> /// <returns></returns> public tbl_PublicationComment Add(tbl_PublicationComment publicationComment) { _dataContext.tbl_PublicationComment.AddObject(publicationComment); _dataContext.SaveChanges(); return(publicationComment); }