public MovieListItem[] SerchMoviesByTerm(string term)
{
var parameters = new[]
{
new SqlParameter("@Term", term)
};
return(DataBaseUtil.Execute("GetFullMovieByTerm", parameters, _movieListItemMappingFunc).ToArray());
}
protected override PotentialRealProfitReportModel GetDataModel()
{
var parameters = new[]
{
new SqlParameter("@DateFrom", (DateTime)Parameters["DateFrom"]),
new SqlParameter("@DateTo", (DateTime)Parameters["DateTo"])
};
var reportRows = DataBaseUtil.Execute <PotentialRealProfitReportRow>("PotentialRealProfit", parameters);
return(new PotentialRealProfitReportModel
{
Rows = reportRows
});
}
protected override UnprofitableMoviesReportModel GetDataModel()
{
var parametr = new[]
{
new SqlParameter("@DateFrom", (DateTime)Parameters["DateFrom"]),
new SqlParameter("@DateTo", (DateTime)Parameters["DateTo"]),
new SqlParameter("@Threshold", (float)Parameters["Threshold"])
};
var reportRows = DataBaseUtil.Execute <UnprofitableMoviesReportRow>("UnprofitableMovies", parametr);
return(new UnprofitableMoviesReportModel
{
Rows = reportRows
});
}