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