public MovieModel GetMovieById(int id)
{
_genreServices = new GenreServices();
var model = new MovieModel();
using (SqlConnection con = new SqlConnection(connect))
{
con.Open();
SqlCommand cmd = new SqlCommand("GetMovieById", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", id);
_adapter = new SqlDataAdapter(cmd);
_ds = new DataSet();
_adapter.Fill(_ds);
if (_ds.Tables.Count > 0 && _ds.Tables[0].Rows.Count > 0)
{
model.Id = Convert.ToInt32(_ds.Tables[0].Rows[0]["Id"]);
model.Title = Convert.ToString(_ds.Tables[0].Rows[0]["Title"]);
model.AgeBracket = Convert.ToString(_ds.Tables[0].Rows[0]["Age_bracket"]);
model.Duration = Convert.ToInt32(_ds.Tables[0].Rows[0]["Duration"]);
model.FirstDay = Convert.ToDateTime(_ds.Tables[0].Rows[0]["First_day_of_rental"]);
model.LastDay = Convert.ToDateTime(_ds.Tables[0].Rows[0]["Last_day_of_rental"]);
model.Genres = _genreServices.ListGenreByMovieId(model.Id);
}
}
return(model);
}
public IList <MovieModel> GetMovieList()
{
_genreServices = new GenreServices();
IList <MovieModel> movieList = new List <MovieModel>();
_ds = new DataSet();
using (SqlConnection con = new SqlConnection(connect))
{
con.Open();
SqlCommand cmd = new SqlCommand("GetAllMovies", con);
cmd.CommandType = CommandType.StoredProcedure;
_adapter = new SqlDataAdapter(cmd);
_adapter.Fill(_ds);
if (_ds.Tables.Count > 0)
{
for (int i = 0; i < _ds.Tables[0].Rows.Count; i++)
{
MovieModel obj = new MovieModel();
obj.Id = Convert.ToInt32(_ds.Tables[0].Rows[i]["Id"]);
obj.Title = Convert.ToString(_ds.Tables[0].Rows[i]["Title"]);
obj.AgeBracket = Convert.ToString(_ds.Tables[0].Rows[i]["Age_bracket"]);
obj.Duration = Convert.ToInt32(_ds.Tables[0].Rows[i]["Duration"]);
obj.FirstDay = Convert.ToDateTime(_ds.Tables[0].Rows[i]["First_day_of_rental"]);
obj.LastDay = Convert.ToDateTime(_ds.Tables[0].Rows[i]["Last_day_of_rental"]);
obj.Genres = _genreServices.ListGenreByMovieId(obj.Id);
movieList.Add(obj);
}
}
}
return(movieList);
}