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