/// <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); }
/// <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")); }