public TimeslotTag[] GetTimeslotTagsByMovieId(int movid)
{
var parameters = new[]
{
new SqlParameter("@MovieId", movid)
};
return(DatabaseUtil.Execute <TimeslotTag>("GetTimeslotTagsByMovieId", parameters).ToArray());
}
public MovieListItem[] SearchMoviesByTerm(string term)
{
var parameters = new[]
{
new SqlParameter("@Term", term)
};
return(DatabaseUtil.Execute("SearchMoviesByTerm", 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 parameters = 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", parameters);
return(new UnprofitableMoviesReportModel
{
Rows = reportRows
});
}
public MovieListItem[] GetFullMoviesInfo()
{
return(DatabaseUtil.Execute("GetFullMoviesInfo", null, _movieListItemMappingFunc).ToArray());
}
