public ActionResult UpdateConfirm(tToDo oToDo)
{
if (oToDo != null && ModelState.IsValid)
{
_ToDoOperation.Update(oToDo);
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Create(string fTitle, string fImage, DateTime fDate)
{
tToDo todo = new tToDo();
todo.fTitle = fTitle;
todo.fImage = fImage;
todo.fDate = fDate;
db.tToDo.Add(todo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit
(int id, string title, string image, DateTime date)
{
tToDo toDo = db.tToDo.Where(m => m.Id == id).FirstOrDefault();
toDo.Title = title;
toDo.Image = image;
toDo.Date = date;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(tToDo oToDo)
{
if (oToDo != null && ModelState.IsValid)
{
bool CreateResult = _ToDoOperation.Create(oToDo);
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public ActionResult Create
(string title, string image, DateTime date)
{
tToDo toDo = new tToDo();
toDo.Title = title;
toDo.Image = image;
toDo.Date = date;
db.tToDo.Add(toDo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Update(int?Id)
{
if (Id == null)
{
return(new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest));
}
tToDo oToDo = _ToDoOperation.ReadById(Id);
if (oToDo == null)
{
return(HttpNotFound());
}
return(View(oToDo));
}
public ActionResult Create(string fTitle, string fImage, DateTime fDate)
{
// 建立tToDo待辦資料型別todo物件
tToDo todo = new tToDo();
// 將表單fTitle、fImage、fDate欄位的資料逐一指定給todo物件的fTitle、fImage、fDate屬性
// 此處未指定fId欄位資料是因為tToDo資料表已設定fId欄位為自動編號(識別規格)，因此fId欄位會採取自動編號模式由1開始新增
todo.fTitle = fTitle;
todo.fImage = fImage;
todo.fDate = fDate;
// 將todo待辦事項物件放入tToDo資料表內
db.tToDo.Add(todo);
// 執行SaveChanges()方法進行異動資料庫，必須執行此方法todo待辦事項物件才可寫入tToDo資料表內
db.SaveChanges();
// 重新執行Home/Index()方法，將todos待辦事項結果傳給Index.cshtml的View檢視頁面
return(RedirectToAction("Index"));
}
public ActionResult ReadByKeywordResult(tToDo oToDo)
{
var Title = oToDo.fTitle;
var Image = oToDo.fImage;
var Weights = "";
switch (Image)
{
case "1.png":
Weights = "普通";
break;
case "0.png":
Weights = "重要";
break;
}
StringBuilder sb = new StringBuilder();
sb.Append("搜尋條件:");
if (!string.IsNullOrWhiteSpace(Title))
{
sb.Append(Title);
sb.Append(" ");
}
if (!string.IsNullOrWhiteSpace(Image))
{
sb.Append(Weights);
}
IQueryable <tToDo> ToDoList = _ToDoOperation.ReadByKeyword(oToDo);
if (ToDoList.ToList().Count == 0)
{
sb.Append(" 查無資料");
ViewBag.SearchResult = sb.ToString();
return(View("ReadByKeyword"));
}
sb.Append(" 結果如下");
ViewBag.SearchResult = sb.ToString();
return(View("ReadByKeywordResult", ToDoList.ToList()));
}
public ActionResult Delete(int Id)
{
tToDo oToDo = _ToDoOperation.ReadById(Id);
return(View(oToDo));
}
public ActionResult ReadByID(int Id = 1)
{
tToDo oToDo = _ToDoOperation.ReadById(Id);
return(View(oToDo));
}
