// GET: api/Film_GenreFilm/?FilmID=5
public Film_GenreFilm Get(int FilmID, int GenreFilmID)
{
Film_GenreFilm film_GenreFilms = new Film_GenreFilm();
string query = "SELECT * FROM dbo.Film_GenreFilm WHERE FilmID = " + FilmID + " AND GenreFilmID = " + GenreFilmID;
DataTable table = DataProvider.Instace.ExecuteQuery(query);
Film_GenreFilm item = new Film_GenreFilm();
item.GenreFilmID = int.Parse(table.Rows[0]["GenreFilmID"].ToString());
item.FilmID = int.Parse(table.Rows[0]["FilmID"].ToString());
return(film_GenreFilms);
}
public IEnumerable <Film_GenreFilm> GetByGenreFilm(int GenreFilmID)
{
List <Film_GenreFilm> film_GenreFilms = new List <Film_GenreFilm>();
string query = "SELECT f.*,g.GenreFilmName FROM dbo.Film_GenreFilm f JOIN Genre_film g ON f.GenreFilmID = g.GenreFilmID WHERE f.GenreFilmID = " + GenreFilmID;
DataTable table = DataProvider.Instace.ExecuteQuery(query);
foreach (DataRow row in table.Rows)
{
Film_GenreFilm item = new Film_GenreFilm();
item.GenreFilmID = int.Parse(row["GenreFilmID"].ToString());
item.FilmID = int.Parse(row["FilmID"].ToString());
Genre_film genre_Film = new Genre_film();
genre_Film.GenreFilmName = row["GenreFilmName"].ToString();
genre_Film.GenreFilmID = int.Parse(row["GenreFilmID"].ToString());
item.Genre_film = genre_Film;
film_GenreFilms.Add(item);
}
return(film_GenreFilms);
}
// GET: api/Film/5
public Film Get(int id)
{
string query = "SELECT * FROM dbo.Film WHERE FilmID = " + id;
DataTable table = DataProvider.Instace.ExecuteQuery(query);
Film film = new Film();
film.FilmID = int.Parse(table.Rows[0]["FilmID"].ToString());
film.FilmName = table.Rows[0]["FilmName"].ToString();
film.Author = table.Rows[0]["Author"].ToString();
film.Producer = table.Rows[0]["Producer"].ToString();
film.ReleaseDate = DateTime.Parse(table.Rows[0]["ReleaseDate"].ToString());
film.Nation = table.Rows[0]["Nation"].ToString();
film.Description = table.Rows[0]["Description"].ToString();
film.Rated = float.Parse(table.Rows[0]["Rated"].ToString());
film.Actor = table.Rows[0]["Actor"].ToString();
film.Status = byte.Parse(table.Rows[0]["Status"].ToString());
string query1 = "SELECT fg.*,g.GenreFilmName FROM dbo.Film_GenreFilm fg JOIN dbo.Genre_film g ON g.GenreFilmID = fg.GenreFilmID WHERE FilmID =" + id;
DataTable table1 = DataProvider.Instace.ExecuteQuery(query1);
List <Film_GenreFilm> film_GenreFilms = new List <Film_GenreFilm>();
foreach (DataRow row in table1.Rows)
{
Film_GenreFilm item = new Film_GenreFilm();
item.FilmID = int.Parse(row["FilmID"].ToString());
item.GenreFilmID = int.Parse(row["GenreFilmID"].ToString());
item.ID = int.Parse(row["ID"].ToString());
Genre_film genre_Film = new Genre_film();
genre_Film.GenreFilmID = int.Parse(row["GenreFilmID"].ToString());
genre_Film.GenreFilmName = row["GenreFilmName"].ToString();
item.Genre_film = genre_Film;
film_GenreFilms.Add(item);
}
film.Film_GenreFilm = film_GenreFilms;
return(film);
}
