public ActionResult SearchAuto(MovyEntity movie)
{
List <SelectListItem> genreList = GenreBL.ViewAllGenreBL().Select(n => new SelectListItem {
Value = n.GenreId.ToString(), Text = n.GenreName
}).ToList();;
var genreTip = new SelectListItem()
{
Value = null,
Text = "-- genre --"
};
genreList.Insert(0, genreTip);
ViewBag.generList = new SelectList(genreList, "Value", "Text");
List <SelectListItem> languageList = LanguageBL.ViewAllLanguageBL().Select(n => new SelectListItem {
Value = n.LanguageId.ToString(), Text = n.LanguageName
}).ToList();;
var languageTip = new SelectListItem()
{
Value = null,
Text = "-- Language --"
};
languageList.Insert(0, languageTip);
ViewBag.langList = new SelectList(languageList, "Value", "Text");
////Note : you can bind same list from database
List <MovyEntityNew> ObjList = new List <MovyEntityNew>();
ObjList = MovieBL.GetAllMoviesBL();
////Searching records from list using LINQ query
//var movieList = (from N in ObjList
// where N.MovieName.StartsWith(Prefix) || N.MovieName.StartsWith(Prefix.ElementAt(0).ToString().ToUpper())
// select new { N.MovieName });
//return Json(movieList, JsonRequestBehavior.AllowGet);
var movieList = (from N in ObjList
where N.MovieName.ToLower().Equals(movie.MovieName.ToLower())
select N);
MovyEntityNew movieResult = movieList.FirstOrDefault();
if (movieResult != null)
{
string url = string.Format("/Movies/MovieDetails/" + movieResult.MovieId);
return(Redirect(url));
}
else
{
string url = string.Format("/Movies/ListAllMovies");
return(Redirect(url));
}
}
// GET: Movies
public ActionResult ListAllMovies(MovyEntityNew movie, MovyEntity movieFilter)
{
List <SelectListItem> genreList = GenreBL.ViewAllGenreBL().Select(n => new SelectListItem {
Value = n.GenreId.ToString(), Text = n.GenreName
}).ToList();;
var genreTip = new SelectListItem()
{
Value = null,
Text = "-- genre --"
};
genreList.Insert(0, genreTip);
ViewBag.generList = new SelectList(genreList, "Value", "Text");
List <SelectListItem> languageList = LanguageBL.ViewAllLanguageBL().Select(n => new SelectListItem {
Value = n.LanguageId.ToString(), Text = n.LanguageName
}).ToList();;
var languageTip = new SelectListItem()
{
Value = null,
Text = "-- Language --"
};
languageList.Insert(0, languageTip);
ViewBag.langList = new SelectList(languageList, "Value", "Text");
string username = Request.QueryString["username"];
string genrename = GenreBL.SearchGenreBL(movieFilter.GenreId).GenreName;
string languagename = LanguageBL.SearchLanguageBL(movieFilter.LanguageId).LanguageName;
List <MovyEntityNew> listMovies = MovieBL.GetAllMoviesBL();
var query = from item in listMovies
where item.Genre.Equals(genrename) || movieFilter.GenreId == 0
where item.Language.Equals(languagename) || movieFilter.LanguageId == 0
select item;
if (Session["Username"] != null && Session["ViewerId"] != null)
{
ViewBag.ViewerId = Session["ViewerId"];
return(View(query));
}
else
{
string url = string.Format("/Users/LogIn");
return(Redirect(url));
}
}
public List <MovyEntityNew> GetAllMoviesDAL()
{
List <MovyEntityNew> result = new List <MovyEntityNew>();
CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
var ObjMovieList = from Movie in ObjContext.Movies
join Genre in ObjContext.Genres
on Movie.GenreId equals Genre.GenreId
join Language in ObjContext.Languages
on Movie.LanguageId equals Language.LanguageId
select new MovyEntityNew {
Genre = Genre.GenreName,
Language = Language.LanguageName,
MovieDescription = Movie.MovieDescription,
MovieId = Movie.MovieId,
MovieName = Movie.MovieName,
MovieUrl = Movie.MovieUrl,
ReleaseDate = Movie.ReleaseDate
};
foreach (var item in ObjMovieList)
{
MovyEntityNew entity = new MovyEntityNew();
entity.Genre = item.Genre;
entity.Language = item.Language;
entity.MovieDescription = item.MovieDescription;
entity.MovieId = item.MovieId;
entity.MovieName = item.MovieName;
entity.MovieUrl = item.MovieUrl;
entity.ReleaseDate = item.ReleaseDate;
result.Add(entity);
}
return(result);
}