public DataProvider(Dictionary<string, string> cons) {
//Create movie context
dbConnString = cons["SqlConnString"];
db = new MoviesContext(dbConnString);
Movies = db.Movies;
}
//SEARCH MOVIES BASE ON COMBO CONDITION OF TITLE, YEAR, & TYPE
public List<Movie> Search(SubmitData message){
//get input values from client
string title = (message.Title == null) ? "" : message.Title.Trim();
string year = (message.Year == null) ? "" : message.Year.Trim();
string type = (message.Type == null) ? "" : message.Type.Trim();
List<Movie> retResult = new List<Movie>();
//get movie type
var sType = GetMovieType(type);
//LINQ query to get result
using (var context = new MoviesContext()){
//all matched movies --> query
var query =
from movie in context.Movies
where (title == "" | movie.Title.Contains(title)) &&
(year == "" | movie.Year == year) &&
(type == "" | movie.Type == sType)
select movie;
//add movies to the return list
foreach (var m in query){
retResult.Add(m);
}
}
return retResult;
}
