public ActionResult BoardCommentUpdate(int iBoardCommentID) { // Instantiate objects BoardCommentBLL lBoardCommentBLL = new BoardCommentBLL(); BoardCommentMapper lBoardCommentMapper = new BoardCommentMapper(); // Find the BoardComment by boardCommentIDPK BoardCommentDBO lBoardCommentDBO = lBoardCommentBLL.FindBoardCommentByBoardCommentID(iBoardCommentID); BoardComment lBoardComment = new BoardComment(); if (lBoardCommentDBO != null) { // Map DB object to Model and pre-populate the comment lBoardComment = lBoardCommentMapper.MapBoardCommentDBOToBoardComment(lBoardCommentDBO); } else { // redirect to the post with error message TempData["msg"] = "<script> alert('Error occured while processing your request.') </script>"; return(RedirectToAction("BoardView", "Board", new { @id = iBoardCommentID })); } return(PartialView("BoardCommentUpdate", lBoardComment)); }
/// <summary> /// Description: This method maps list of database objects to list of Model /// </summary> /// <param name="iBoardCommentDBOList">List of BoardComment database objects to be mapped</param> /// <returns>List of BoardComment Model</returns> public List <BoardComment> MapBoardCommentDBOToBoardComment(List <BoardCommentDBO> iBoardCommentDBOList) { // list to be returned List <BoardComment> lBoardCommentList = new List <BoardComment>(); // loop through the input list and map each item to Model.BoardComment foreach (BoardCommentDBO lEachComment in iBoardCommentDBOList) { // Object to be added to the list BoardComment lBoardComment = new BoardComment(); // set values lBoardComment.BoardCommentIDPK = lEachComment.BoardCommentIDPK; lBoardComment.UserIDFK = lEachComment.UserIDFK; lBoardComment.UserName = lEachComment.UserName; lBoardComment.UserRoleName = lEachComment.UserRoleName; lBoardComment.BoardIDFK = lEachComment.BoardIDFK; lBoardComment.Content = lEachComment.Content; lBoardComment.DateCreated = lEachComment.DateCreated; lBoardComment.DateModified = lEachComment.DateModified; lBoardCommentList.Add(lBoardComment); } return(lBoardCommentList); }
public int SaveComment(BoardComment commntInfo) { if (string.IsNullOrEmpty(commntInfo.CommetId.ToString()) || commntInfo.CommetId == 0) { commntInfo.UpdateDt = DateTime.Now; commntInfo.CreateDt = DateTime.Now; commntInfo.CreateId = System.Web.HttpContext.Current.User.Identity.GetUserId(); commntInfo.UpdateId = System.Web.HttpContext.Current.User.Identity.GetUserId(); context.BoardComments.Add(commntInfo); context.SaveChanges(); } else { var updateRow = (from bcomm in context.BoardComments where bcomm.CommetId == commntInfo.CommetId select bcomm).Single(); updateRow.CommentContent = commntInfo.CommentContent; updateRow.UpdateDt = DateTime.Now; updateRow.UpdateId = System.Web.HttpContext.Current.User.Identity.GetUserId(); } return(commntInfo.CommetId);; }
/// <summary> /// Description: This method maps Model object to database object /// </summary> /// <param name="iBoardComment">Object to be mapped</param> /// <returns>BoardCommentDBO object</returns> public BoardCommentDBO MapBoardCommentToBoardCommentDBO(BoardComment iBoardComment) { // Instantiate BoardCommentDBO object BoardCommentDBO lBoardCommentDBO = new BoardCommentDBO(); // set values lBoardCommentDBO.BoardCommentIDPK = iBoardComment.BoardCommentIDPK; lBoardCommentDBO.Content = iBoardComment.Content; return(lBoardCommentDBO); }
public ActionResult SaveComment(BoardComment commntInfo) { if (ModelState.IsValid) { int commentId = dbPost.SaveComment(commntInfo); return(Json(dbPost.ViewComment(commentId), JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, SaveError = "Not Saved" }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Description: This method maps database object to Model object /// </summary> /// <param name="iBoardCommentDBO">Object to be mapped</param> /// <returns>BoardComment object</returns> public BoardComment MapBoardCommentDBOToBoardComment(BoardCommentDBO iBoardCommentDBO) { // Instantiate BoardComment object BoardComment lBoardComment = new BoardComment(); // set values lBoardComment.BoardCommentIDPK = iBoardCommentDBO.BoardCommentIDPK; lBoardComment.UserIDFK = iBoardCommentDBO.UserIDFK; lBoardComment.UserName = iBoardCommentDBO.UserName; lBoardComment.UserRoleName = iBoardCommentDBO.UserRoleName; lBoardComment.DateCreated = iBoardCommentDBO.DateCreated; lBoardComment.Content = iBoardCommentDBO.Content; lBoardComment.DateModified = iBoardCommentDBO.DateModified; lBoardComment.BoardIDFK = iBoardCommentDBO.BoardIDFK; return(lBoardComment); }
public BoardComment ViewComment(int?commentId) { var results = (from brd in context.BoardComments join urs in context.UserProfiles on brd.CreateId equals urs.UserId into bru from uid in bru.DefaultIfEmpty() join att in context.AttachFiles on uid.UserPic equals att.FileId into upic from userpic in upic.DefaultIfEmpty() where brd.CommetId == commentId && userpic.FileType == "USER_PROFILE" select new { brd.PostId, brd.CommetId, brd.CommentContent, brd.CommentLevel, brd.ParentId, brd.CreateDt, brd.CreateId, brd.UpdateDt, brd.UpdateId, FullName = uid.FirstName + " " + uid.LastName, userpic = userpic.SaveAsFileName }).FirstOrDefault(); var viweModel = new BoardComment { CommetId = results.CommetId, PostId = results.PostId, CommentLevel = results.CommentLevel, ParentId = results.ParentId, CommentContent = results.CommentContent, CreateDt = results.CreateDt, CreateId = results.CreateId, UpdateDt = results.UpdateDt, UpdateId = results.UpdateId, FullName = results.FullName, UserPic = results.userpic }; return(viweModel); }
public ActionResult BoardCommentUpdate(BoardComment iBoardComment) { // instantiate objects BoardCommentBLL lBoardCommentBLL = new BoardCommentBLL(); BoardCommentMapper lBoardCommentMapper = new BoardCommentMapper(); // Map Model to DB objects BoardCommentDBO lBoardCommentDBO = lBoardCommentMapper.MapBoardCommentToBoardCommentDBO(iBoardComment); // Get bool result for updating comment bool lResult = lBoardCommentBLL.UpdateBoardCommentByBoardCommentID(lBoardCommentDBO); if (lResult) { TempData["msg"] = "<script> alert('Successfully Updated!') </script>"; // redirect to the board view return(RedirectToAction("BoardView", "Board", new { id = iBoardComment.BoardIDFK })); } else { return(Json(new { success = false })); } }
public ActionResult BoardComment_action(BoardComment doc, string BD_idx, string cate, string mode_type, int?c_idx) { int idx = 0; string msg = ""; #region 기본 사용자 정보 string user_id = User.Identity.Name; int department_idx = Convert.ToInt32(UserData.user_get(user_id, "department_idx")); int company_idx = Convert.ToInt32(UserData.user_get(user_id, "company_idx")); int auth = Convert.ToInt32(UserData.user_get(user_id, "auth")); #endregion if (c_idx == null) { #region 저장 doc.write_date = DateTime.Now; doc.writer = User.Identity.Name; doc.edit_date = DateTime.Now; doc.use_yn = "Y"; db.BoardComment.Add(doc); db.SaveChanges(); // 실제로 저장 msg = admin_basic.Util.msg.msg_insert; #endregion } else { if (mode_type == "D") { #region 삭제 BoardComment doc_del = db.BoardComment.Single(x => x.idx == c_idx); db.BoardComment.Remove(doc_del); db.SaveChanges(); msg = admin_basic.Util.msg.msg_del; #endregion } else if (mode_type == "E") { #region 임시 삭제 / 상태 변환 업데이트 BoardComment _update = (from a in db.BoardComment where a.idx == c_idx select a).Single(); _update.edit_date = DateTime.Now; _update.use_yn = "D"; _update.writer = User.Identity.Name; db.SaveChanges(); // 실제로 저장 msg = admin_basic.Util.msg.msg_disable; #endregion } else { #region 수정 BoardComment _update = (from a in db.BoardComment where a.idx == idx select a).Single(); _update.edit_date = DateTime.Now; _update.memo = doc.memo; db.SaveChanges(); // 실제로 저장 msg = admin_basic.Util.msg.msg_edit; #endregion } } string url = "/board/boardview?idx=" + BD_idx + "&cate=" + cate; return(Redirect(url)); }