public ActionResult Reply(int Id) { /// 檢查? Guestbooks Data = guestbookDBService.getDataById(Id); return(View(Data)); }
//刪除資料 public void DeletGuestbooks(Guid id) { Guestbooks DeletData = db.Guestbooks.Find(id); db.Guestbooks.Remove(DeletData); db.SaveChanges(); }
[HttpPost] //設定此Action只接受頁面POST資料傳入 //使用Bind的Include來定義只接受的欄位,用來避免傳入其他不相干值 public ActionResult Add([Bind(Include = "Name,Content")] Guestbooks Data) { //使用Service來新增一筆資料 guestbookService.InsertGuestbooks(Data); //重新導向頁面至開始頁面 return(RedirectToAction("Index")); }
public void InsertGuestbooks(Guestbooks newData) { newData.CreateTime = DateTime.Now; newData.LastUpdated = DateTime.Now; db.Guestbooks.Add(newData); db.SaveChanges(); }
public void RelpyGuestbook(Guestbooks RelpyData) { Guestbooks oleData = db.Guestbooks.Find(RelpyData.Id); oleData.Reply = RelpyData.Reply; oleData.ReplyTime = DateTime.Now; db.SaveChanges(); }
public void UpdateGuesbook(Guestbooks UpdateData) { Guestbooks oleData = db.Guestbooks.Find(UpdateData.Id); oleData.Name = UpdateData.Name; oleData.Content = UpdateData.Content; db.SaveChanges(); }
//修改留言方法 public void UpdateGuestbooks(Guestbooks UpdateData) { Guestbooks OldData = db.Guestbooks.Find(UpdateData.Id); OldData.Acount = UpdateData.Acount; OldData.Contents = UpdateData.Contents; db.SaveChanges(); }
//回覆留言方法 public void ReplyGuestbooks(Guestbooks ReplyData) { Guestbooks OldData = db.Guestbooks.Find(ReplyData.Id); OldData.Reply = ReplyData.Reply; OldData.ReplyTime = DateTime.Now; db.SaveChanges(); }
//修改資料判斷的方法 public bool CheckUpdate(int Id) { //取得要修改的資料 Guestbooks Data = GetDataById(Id); //判斷是否有資料及是否有回覆 return(Data != null && Data.ReplyTime == null); }
//修改資料判斷的方法 public bool CheckUpdate(int Id) { //根據Id取得要修改的資料 Guestbooks Data = db.Guestbooks.Find(Id); //判斷並回傳(判斷是否有資料以及是否有回覆) return(Data != null && Data.ReplyTime == null); }
//修改留言頁面要根據傳入編號來決定要修改的資料 public ActionResult Edit(int Id) { //取得頁面所需資料,藉由Service取得 Guestbooks Data = guestbookService.GetDataById(Id); //將資料傳入View中 return(View(Data)); }
public ActionResult Reply(int id, Guestbooks guestbooks) { if (guestbookDBService.CheckUpdate(id)) { guestbooks.Id = id; guestbookDBService.ReplyGuestbooks(guestbooks); } return(RedirectToAction("Index")); }
public ActionResult EditMessage(int id, [Bind(Include = "Name,Content")] Guestbooks guestbooks) { if (guestbookDBService.CheckUpdate(id)) { guestbooks.Id = id; guestbookDBService.UpdateGuestbook(guestbooks); } return(RedirectToAction("Index")); }
public void ReplyGuestbooks(Guestbooks ReplayData) { Guestbooks oldDate = db.Guestbooks.Find(ReplayData.Id); // 增加驗證嗎????? oldDate.Reply = ReplayData.Reply; oldDate.ReplyTime = DateTime.Now; db.SaveChanges(); }
[HttpPost] //設定此Action只接受頁面POST資料傳入 //使用Bind的Inculde來定義只接受的欄位,用來避免傳入其他不相干值 public ActionResult Add([Bind(Include = "Content")] Guestbooks Data) { //設定新增留言的留言者為登入者 Data.Account = User.Identity.Name; //使用Service來新增一筆資料 guestbookService.InsertGuestbooks(Data); //重新導向頁面至開始頁面 return(RedirectToAction("Index")); }
//新增資料方法 public void InsertGuestbooks(Guestbooks newData) { //設定新增時間為現在 newData.CreateTime = DateTime.Now; //將資料加入資料庫實體 db.Guestbooks.Add(newData); //儲存資料庫變更 db.SaveChanges(); }
//刪除資料方法 public void DeleteGuestbooks(int Id) { //根據Id取得要刪除的資料 Guestbooks DeleteData = db.Guestbooks.Find(Id); //從資料庫實體中刪除資料 db.Guestbooks.Remove(DeleteData); //儲存資料庫變更 db.SaveChanges(); }
public void Delete(int id) { Guestbooks Data = Find(id); if (Data != null) { db.Guestbooks.Remove(Data); db.SaveChanges(); } }
//修改留言方法 public void UpdateGuestbooks(Guestbooks UpdateData) { //取得要修改的資料 Guestbooks OldData = db.Guestbooks.Find(UpdateData.Id); //修改資料庫裡的值 OldData.Account = UpdateData.Account; OldData.Content = UpdateData.Content; //儲存資料庫變更 db.SaveChanges(); }
public void Update(Guestbooks updateData) { Guestbooks OldData = Find(updateData.Id); if (OldData != null) { OldData.Account = updateData.Account; OldData.Content = updateData.Content; db.SaveChanges(); } }
public void UpdateGuestbooks(Guestbooks UpdateData) { //取得修改資料的實體 Guestbooks oldDate = db.Guestbooks.Find(UpdateData.Id); // 增加驗證嗎????? oldDate.Name = UpdateData.Name; oldDate.Content = UpdateData.Content; oldDate.LastUpdated = DateTime.Now; db.SaveChanges(); }
public void ReplyGuestbooks(Guestbooks replyData) { Guestbooks OldData = Find(replyData.Id); if (OldData != null) { OldData.Reply = replyData.Reply; OldData.ReplyTime = DateTime.Now; db.SaveChanges(); } }
//回覆留言方法 public void ReplyGuestbooks(Guestbooks ReplyData) { //取得要修改的資料 Guestbooks OldData = db.Guestbooks.Find(ReplyData.Id); //設定回覆內容 OldData.Reply = ReplyData.Reply; //設定回覆時間為現在 OldData.ReplyTime = DateTime.Now; //儲存資料庫變更 db.SaveChanges(); }
public ActionResult Reply(int Id, [Bind(Include = "Reply,ReplyTime")] Guestbooks ReplyData) { if (guestbookService.CheckUpdate(Id)) { ReplyData.Id = Id; guestbookService.RelpyGuestbook(ReplyData); return(RedirectToAction("Index")); } else { return(RedirectToAction("Index")); } }
public ActionResult Edit(int Id, [Bind(Include = "Name,Contetn")] Guestbooks UpdateData) { if (guestbookService.CheckUpdate(Id)) { UpdateData.Id = Id; guestbookService.UpdateGuesbook(UpdateData); return(RedirectToAction("Index")); } else { return(RedirectToAction("Index")); } }
public void InsertGuestbooks(Guestbooks newData) { try { newData.CreateTime = DateTime.Now.AddHours(8); db.Guestbooks.Add(newData); db.SaveChanges(); } catch (Exception ex) { logger.Error(LogUtility.GetExceptionDetails(ex)); } }
public bool CheckUpdate(int id) { try { Guestbooks Data = db.Guestbooks.Find(id); return(Data != null && Data.ReplyTime == null); } catch (System.IO.IOException e) { logger.Error(LogUtility.GetExceptionDetails(e)); return(false); } }
public ActionResult Reply(int id, [Bind(Include = "Reply")] Guestbooks replyData) { if (guestbooksService.CheckUpdate(id)) { replyData.Id = id; guestbooksService.ReplyGuestbooks(replyData); } else { ModelState.AddModelError("", "有回覆的留言不可編輯"); } return(RedirectToAction("Index")); }
//有搜尋值的搜尋資料方法 public List <Guestbooks> GetAllDataList(ForPaging paging, string Search) { List <Guestbooks> DataList = new List <Guestbooks>(); string sql = $@"select m.*,d.Name,d.IsAdmin from (select row_number() over(order by Id) as sort,* from Guestbooks where Content like '%{Search}%' or Reply like '%{Search}%') m inner join Members d on m.Account=d.Account where m.sort Between {(paging.NowPage - 1) * paging.ItemNum + 1} and {paging.NowPage * paging.ItemNum}"; try { //開啟資料庫連線 conn.Open(); //執行Sql指令 SqlCommand cmd = new SqlCommand(sql, conn); //取得Sql資料 SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) //獲得下一筆資料直到沒有資料 { Guestbooks Data = new Guestbooks { Id = Convert.ToInt32(dr["Id"]), Account = dr["Account"].ToString(), Content = dr["Content"].ToString(), CreateTime = Convert.ToDateTime(dr["CreateTime"]) }; //確定此則留言是否回覆,且不允許空白 //因C#是強型別語言,所以轉換時Datetime型態不允許存取null if (!dr["ReplyTime"].Equals(DBNull.Value)) { Data.Reply = dr["Reply"].ToString(); Data.ReplyTime = Convert.ToDateTime(dr["ReplyTime"]); } //會員資料 Data.Member.Name = dr["Name"].ToString(); DataList.Add(Data); } } catch (Exception e) { //丟出錯誤 throw new Exception(e.Message.ToString()); } finally { //關閉資料庫連線 conn.Close(); } //回傳搜尋資料 return(DataList); }
public ActionResult Edit(int id, [Bind(Include = "Content")] Guestbooks updateData) { if (guestbooksService.CheckUpdate(id)) { updateData.Id = id; updateData.Account = User.Identity.Name; guestbooksService.Update(updateData); } else { ModelState.AddModelError("", "有回覆的留言不可編輯"); } return(RedirectToAction("Index")); }
public void UpdateGuestbooks(Guestbooks updatedEntry) { Guestbooks DataInDB = db.Guestbooks.Find(updatedEntry.Id); DataInDB.Account = updatedEntry.Account; DataInDB.Content = updatedEntry.Content; db.SaveChanges(); }
public void InsertGuestbooks(Guestbooks newEntry) { newEntry.CreateTime=DateTime.Now; db.Guestbooks.Add(newEntry); db.SaveChanges(); }
public void ReplyGuestbooks(Guestbooks replyEntry) { Guestbooks DataInDB = db.Guestbooks.Find(replyEntry.Id); DataInDB.Reply = replyEntry.Reply; DataInDB.ReplyTime = DateTime.Now; db.SaveChanges(); }