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();
}
