// GET: Opera
// GET: Opera/Index?operaId=111&title=xx&year=1923&composer=John
//public ActionResult Index(Opera opera)
//{
// //var test = ModelState.IsValid;
// //Opera o = new Opera()
// //{
// // OperaID = opera.OperaID,
// // Title = opera.Title,
// // Year = opera.Year,
// // Composer = opera.Composer
// //};
// return View(opera);
//}
// Lab2_4
// GET: Opera/Index
// [LoginActionFilter]
public ActionResult Index()
{
Debug.WriteLine("Opera.Index");
OperaContext context = new OperaContext();
return(View(context.Operas.ToList()));
}
public ActionResult FilterData(int number)
{
OperaContext context = new OperaContext();
var query = (from o in context.Operas
orderby o.Year descending
select o).Take(number).ToList();
return(View("Index", query));
}
// GET: Opera
//public ActionResult Index(Opera opera)
//{
// //var test = ModelState.IsValid;
// //Opera o = new Opera()
// //{
// // OperaID = opera.OperaID,
// // Title = opera.Title,
// // Year = opera.Year,
// // Composer = opera.Composer
// //};
// return View(opera);
//} Lab2_4
// GET:Opera/Index
//Lab3_9 增加LogActionFilter。在實作的LogActionFilter class中寫好override，然後在這裡用attribute套用
public ActionResult Index()
{
//輸出在output window
//'iisexpress.exe' (CLR v4.0.30319: /LM/W3SVC/2/ROOT-1-131394069974227962): Loaded 'Anonymously Hosted DynamicMethods Assembly'.
//Opera.Index
Debug.WriteLine("Opera.Index");
OperaContext context = new OperaContext();
return(View(context.Operas.ToList()));
}
public ActionResult Create(Opera opera)
{
if (ModelState.IsValid)
{
OperaContext contex = new OperaContext();
contex.Operas.Add(opera);
contex.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(opera));
}
[Route("Opera/Title/{title?}")] //title? can null or title=Wozzeck
// [Route("Opera/Title/{title=Wozzeck}")]
public ActionResult DetailsByTitle(string title)
{
OperaContext context = new OperaContext();
Opera opera = context.Operas.FirstOrDefault <Opera>(o => o.Title == title);
if (opera == null)
{
return(HttpNotFound());
}
return(View("Details", opera));
}
public ActionResult DetailsByTitle(string title)
{
ViewBag.mycontroller = RouteData.Values["controller"];
ViewBag.myaction = RouteData.Values["action"];
ViewBag.mytitle = RouteData.Values["title"];
OperaContext context = new OperaContext();
Opera opera = context.Operas.FirstOrDefault <Opera>(o => o.Title == title);
if (opera == null)
{
return(HttpNotFound());
}
return(View("Details", opera));
}
public ActionResult Edit(Opera opera)
{
if (ModelState.IsValid)
{
OperaContext contex = new OperaContext();
contex.Entry(opera).State = EntityState.Modified;
//Opera o = contex.Operas.Find(opera.OperaID);
//o.Title = opera.Title;
//o.Year = opera.Year;
//o.Composer = opera.Composer;
contex.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(opera));
}
//LAB 3-6 修改時先顯示要修改那一筆
//GET: Opera/Edit/1
//GET: Opera/Edit?id=1
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OperaContext context = new OperaContext();
Opera o = context.Operas.Find(id);
if (o == null)
{
return(HttpNotFound());
}
return(View(o));
}
//LAB3_8
//GET: Opera/Delete/1
//GET: Opera/Delete?id=1
//public ActionResult Delete(int? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// OperaContext context = new OperaContext();
// Opera o = context.Operas.Find(id);
// if (o == null)
// return HttpNotFound();
// return View(o);
//}
//POST: Opera/Delete/1
//POST: Opera/Delete?id=1
//[HttpPost, ActionName("Delete")] //POST時的Delete函式，可用以替代DeleteConfirmed
//public ActionResult DeleteConfirmed(int id)
//{
// OperaContext context = new OperaContext();
// Opera o = context.Operas.Find(id);
// context.Operas.Remove(o);
// context.SaveChanges();
// return RedirectToAction("Index");
//}
//GET: Opera/Delete/1
//GET: Opera/Delete?id=1
//如果不要做確認直接刪除的話
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OperaContext context = new OperaContext();
Opera o = context.Operas.Find(id);
if (o == null)
{
return(HttpNotFound());
}
context.Operas.Remove(o);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(Opera opera)
{
if (ModelState.IsValid)
{
OperaContext context = new OperaContext();
//context.Entry(opera).State = EntityState.Modified;
//上面這一行等於下面這一串，但是欄位太多不好用
Opera o = context.Operas.Find(opera.OperaID);
o.Title = opera.Title;
o.Year = opera.Year;
o.Composer = opera.Composer;
context.SaveChanges();
return(RedirectToAction("Index"));
}
//Edit.cshtml
return(View(opera));
}
public VideoRepository(OperaContext operaContext)
{
_operaContext = operaContext;
}
// GET: Opera
// GET: Opera/Index?operaId=111&title=xx&year=1923&composer=John
//public ActionResult Index(Opera opera)
//{
// //var test = ModelState.IsValid;
// //Opera o = new Opera()
// //{
// // OperaID = opera.OperaID,
// // Title = opera.Title,
// // Year = opera.Year,
// // Composer = opera.Composer
// //};
// return View(opera);
//}
// Lab2_4
// GET: Opera/Index
public ActionResult Index()
{
OperaContext context = new OperaContext();
return(View(context.Operas.ToList()));
}
public UserRepository(OperaContext operaContext)
{
_operaContext = operaContext;
}
