// 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); }