// 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; }