// GET: Movies/Details/5 public ActionResult Details(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } string sql = "Select Id,Title,ReleaseDate,Genre,Price,Rate from Movies where Id = " + id.ToString(); var movielist = DataBaseUtility.GetMovies(sql); if (movielist.Count == 0) { return HttpNotFound(); } return View(movielist[0]); }
// GET: Movies /* public ActionResult Index() { return View(db.Movies.ToList()); }*/ public ActionResult Index(string movieGenre, string searchstring) { string sql = "Select Id,Title,ReleaseDate,Genre,Price,Rate from Movies"; var movielist = DataBaseUtility.GetMovies(sql); var GenreLst = new List<string>(); foreach (var item in movielist) { GenreLst.Add(item.Genre); } ViewBag.movieGenre = new SelectList(GenreLst); bool addgenre = false; var querymovie = new Movie(); if (!string.IsNullOrEmpty(movieGenre)) { querymovie.Genre = movieGenre; sql = sql + " where Genre = '"+ querymovie.dbGenre + "'"; addgenre = true; } if(!string.IsNullOrEmpty(searchstring)) { querymovie.Title = searchstring; if (addgenre) { sql = sql + " and Title like '%"+ querymovie.dbTitle + "%'"; } else { sql = sql + " where Title like '%" + querymovie.dbTitle + "%'"; } } movielist = DataBaseUtility.GetMovies(sql); return View(movielist); }