// GET: Admin/Genre_film/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Genre_film genre_film = db.Genre_film.Find(id); if (genre_film == null) { return(HttpNotFound()); } return(View(genre_film)); }
// PUT: api/Genre_film/5 public int Put(int id, [FromBody] Genre_film value) { string query = "UPDATE dbo.Genre_film SET GenreFilmName = N'" + value.GenreFilmName + "' WHERE GenreFilmID = " + id; try { int res = DataProvider.Instace.ExecuteNonQuery(query); } catch (SqlException) { return(0); } return(1); }
// POST: api/Genre_film public int Post([FromBody] Genre_film value) { string query = "INSERT dbo.Genre_film(GenreFilmName)VALUES(N'" + value.GenreFilmName + "')"; try { int res = DataProvider.Instace.ExecuteNonQuery(query); } catch (SqlException) { return(0); } return(1); }
// GET: api/Genre_film public IEnumerable <Genre_film> Get() { List <Genre_film> genre_Films = new List <Genre_film>(); string query = "SELECT * FROM dbo.Genre_film"; DataTable table = DataProvider.Instace.ExecuteQuery(query); foreach (DataRow row in table.Rows) { Genre_film item = new Genre_film(); item.GenreFilmID = int.Parse(row["GenreFilmID"].ToString()); item.GenreFilmName = row["GenreFilmName"].ToString(); genre_Films.Add(item); } return(genre_Films); }
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); }