Example #1
0
        /// <summary>
        /// 新增主留言資料
        /// </summary>
        /// <param name="addData"></param>
        /// <returns></returns>
        public bool AddMainMessage(AddMainGuestbook addData)
        {
            bool IsAddSuccess = false;

            int effectCount = guestbookRepository.AddMainMessage(addData);

            if (effectCount == 1)
            {
                IsAddSuccess = true;
            }

            return(IsAddSuccess);
        }
Example #2
0
        /// <summary>
        /// 新增主留言資料
        /// </summary>
        /// <param name="addData"></param>
        /// <returns></returns>
        public int AddMainMessage(AddMainGuestbook addData)
        {
            int addcount = 0;

            using (var conn = new SqlConnection(connection))
            {
                try
                {
                    addcount = conn.Execute(CommontSPName.InsertMainMessage,
                                            new { MemberID = addData.MemberID, Content = addData.Content, MemberIP = addData.IP },
                                            commandType: System.Data.CommandType.StoredProcedure);
                }
                catch (Exception ex)
                {
                }
            }

            return(addcount);
        }
        public ActionResult CreateMessage(string AddMessage)
        {
            if (!string.IsNullOrWhiteSpace(AddMessage))
            {
                //使用者登入資料
                string           login     = SessionLogin();
                MemberLoginModel loginData = new MemberLoginModel();

                //取得會員登入資料
                if (!string.IsNullOrWhiteSpace(login))
                {
                    loginData = _guestbookService.GetMember(login);
                }

                //使用者IP 位址
                string IP = _guestbookService.IPAddress();


                //組合新增留言
                AddMainGuestbook addMessage = new AddMainGuestbook()
                {
                    MemberID = loginData.Member_ID,
                    Content  = AddMessage,
                    IP       = IP
                };

                //新增留言
                bool IsAddSuccess = _guestbookService.AddMainMessage(addMessage);

                //主留言資料
                var mainMessage = _guestbookService.GetMainMessage(loginData.Role, loginData.Member_ID);

                var displayMessage = mainMessage.ToPagedList(1, 5);

                return(PartialView("_GetMainMessagePartialView", displayMessage));
            }

            return(RedirectToAction("GetMessage", "GuestBook"));
        }