private byte[] GenerateReviewerCommentsExcel(byte[] template, int currentRow, ref int currentColumn) { List <ReviewCommentObject> reviewercomments = new List <ReviewCommentObject>(); foreach (var c in Mains) { reviewercomments.AddRange(ReviewCommentObject.GetReviewComments(c.MainId.Value)); } bool newSheet = SheetSelection.Contains("Reviewers"); int row = 2; int column = 1; if (!newSheet) { row = currentRow; column = currentColumn; currentColumn += ReviewerCommentsRowCount; } else { column += ReviewersRowCount; } var data = Talon.Excel(reviewercomments) .Template(template) .StartAt(column, row) .Sheet(newSheet ? ReviewersSheetName : DefaultSheetName) .Name("ReviewerCommentsTable") .Columns(c => { c.Bound(x => x.MainTitle).Title("STI Number and Rev"); c.Bound(x => x.ReviewerName).Title("Reviewer"); c.Bound(x => x.EntryDateStr).Title("Comment Date"); c.Bound(x => x.Comment).Title("Comment"); }); if (newSheet) { data.SetValue(column, 1, "Comments"); } return(data.Export()); }
/// <summary> /// /// </summary> /// <param name="id">Comment Id</param> /// <returns></returns> public ActionResult DeleteComment(int?id) { int mid = 0; if (id.HasValue) { var c = ReviewCommentObject.GetReviewComment(id.Value); if (c != null) { mid = c.MainId; if (c.EmployeeId == Current.User.EmployeeId || Current.IsAdmin) { c.Delete(); } } } return(RedirectToAction("Index", new { id = mid })); }
public JsonResult GetReviewComment(int?id) { if (id.HasValue) { var cmt = ReviewCommentObject.GetReviewComment(id.Value); if (cmt != null) { var data = new { id = cmt.ReviewCommentId, reviewId = cmt.ReviewId, comment = cmt.Comment }; return(Json(data)); } } return(null); }
public void Save() { if (CommentId.HasValue) { var c = ReviewCommentObject.GetReviewComment(CommentId.Value); if (c != null) { c.Comment = Comment; c.Save(); } } else { var c = new ReviewCommentObject(); c.MainId = MainId; c.ReviewId = CommentReviewId.Value; c.Comment = Comment; c.EmployeeId = Current.User.EmployeeId; c.Save(); } }