public ActionResult Index(FormCollection form)//回傳到view model
{
using (SimpleProjectStudentEntities content = new SimpleProjectStudentEntities())
{
List <Student> StuList1 = content.Student.OrderBy(m => m.fStudentID).ToList();
List <Student> StuList2 = content.Student.OrderByDescending(m => m.fStudentID).ToList();
List <Student> StuList3 = content.Student.OrderBy(m => m.fScore).ToList();
List <Student> StuList4 = content.Student.OrderByDescending(m => m.fScore).ToList();
if (form["IdOrder"] == "1")
{
return(View(StuList1));
return(RedirectToAction("Index", "Home", "IdOrder=1"));
}
if (form["IdOrder"] == "2")
{
return(View(StuList2));
return(RedirectToAction("Index", "Home", "IdOrder=2"));
}
if (form["ScoreOrder"] == "1")
{
return(View(StuList3));
}
if (form["ScoreOrder"] == "2")
{
return(View(StuList4));
return(RedirectToAction("Index", "Home", "ScoreOrder=2"));
}
}
return(View());
}
public ActionResult Edit(int id)
{
using (SimpleProjectStudentEntities content = new SimpleProjectStudentEntities())
{
Student StuList = content.Student.FirstOrDefault(m => m.fStudentID == id);
return(View(StuList));
}
}
public ActionResult Delete(int iddelete)
{
using (SimpleProjectStudentEntities content = new SimpleProjectStudentEntities())
{
Student StuList = content.Student.Where(m => m.fStudentID == iddelete).FirstOrDefault();
content.Student.Remove(StuList);
content.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Create(Student StuList)
{
using (SimpleProjectStudentEntities content = new SimpleProjectStudentEntities())
{
if (ModelState.IsValid)
{
content.Student.Add(StuList);
content.SaveChanges();
return(RedirectToAction("Index"));//這個加在using內或外有差嗎<=========
}
//return RedirectToAction("Index"); 放在這邊會導致下面的return View(Stulist)出現警告 CS0162 偵測到不會執行的程式碼
//但是VIEW Home//Index一樣可以顯示，資料庫有寫入
}
return(View(StuList)); //為什麼一定要加這個，這個加在using內或外有差嗎=>一定要加，加在using沒有用
//沒有加的話會出現CS0161 不是所有路徑都有回傳值，實際上StuList不可能全部都有數值，當這個時候沒有辦法回傳
//所以要加上return View 強迫StudList有沒有值都要回傳
}
public ActionResult Edit(Student StuList)
{
var urlid = Url.RequestContext.RouteData.Values["id"].ToString();//取出URL上的id
int id = Int32.Parse(urlid);
using (SimpleProjectStudentEntities content = new SimpleProjectStudentEntities())
{
if (ModelState.IsValid)
{
Student stuRemoveList = content.Student.FirstOrDefault(m => m.fStudentID == id);
content.Student.Remove(stuRemoveList); //這樣只有remove掉Dbset的資料，可以看成移動掉Entity Framework的資料
content.SaveChanges(); //要加上savechanges讓Dbset被更改的資料可以寫入SQL server這樣才有更新資料庫，view就會顯示被更改的資料庫
content.Student.Add(StuList);
content.SaveChanges();
}
}
return(View("Edit", StuList));
}
public ActionResult Index()
{
//take form view model and display the model ,but how to set the default?
/*
* SimpleProjectStudentEntities content = new SimpleProjectStudentEntities();
* List<Student> StuList1 = content.Student.OrderBy(m => m.fStudentID).ToList();
* List<Student> StuList2 = content.Student.OrderByDescending(m => m.fStudentID).ToList();
* FromDBViewModel vmViewModelFromDB = new FromDBViewModel();
* FromDBvmViewModel.FirstOrder = StuList1;
* FromDBvmViewModel.SecondOrder = StuList2;
* return View(StuList1);
*/
using (SimpleProjectStudentEntities content = new SimpleProjectStudentEntities()) //為何要用using
{
List <Student> vStuList = content.Student.OrderBy(m => m.fStudentID).ToList();
return(View(vStuList)); //reutrn view 放在using裡面才對
}
}
