public ActionResult CreateFilm()
{
try
{
var film = new Film();
UpdateModel <Film>(film);
var filmEp = new FilmEpisode();
UpdateModel <FilmEpisode>(filmEp);
film.createDate = DateTime.Now;
var user = Session["USER_SESSION"] as Movie_Web.Common.UserSession;
film.createBy = user.UserName;
film.releasedEpisodes = 1;
film.totalEpisodes = 1;
var filmDao = new FilmDAO();
filmDao.insertFilm(film);
filmEp.Episode = 1;
int res = new FilmEpisodeDAO().CreateFilmLe(filmEp);
if (res > 0)
{
return(RedirectToAction("Films"));
}
else
{
ModelState.AddModelError("", "Thêm mới không thành công");
}
return(View("CreateFilmLe"));
}
catch
{
//return View();
//Console.WriteLine("Error");
return(View());
}
}
public int updateEpisode(FilmEpisode filmEp)
{
var filmID = new SqlParameter("@filmID", filmEp.filmID);
var Episode = new SqlParameter("@Episode", filmEp.Episode);
var linkEpisode = new SqlParameter("@linkEpisode", filmEp.linkEpisode);
int res = dbFilmContext.Database.ExecuteSqlCommand("exec UpdateFilmEpisode @filmID , @Episode , @linkEpisode", filmID, Episode, linkEpisode);
return(res);
}
public int CreateFilmLe(FilmEpisode filmepLe)
{
var filmID = new SqlParameter("@filmID", filmepLe.filmID);
var Episode = new SqlParameter("@Episode", filmepLe.Episode);
var linkEpisode = new SqlParameter("@linkEpisode", filmepLe.linkEpisode);
int res = dbFilmContext.Database.ExecuteSqlCommand("exec AddFilmEpisode @filmID , @Episode , @linkEpisode", filmID, Episode, linkEpisode);
return(res);
}
public ActionResult addFilmEpisode(FilmEpisode ep)
{
int res = new FilmEpisodeDAO().CreateTapPhim(ep);
string message = "SUCCESS";
if (res > 0)
{
var filmBoID = ep.filmID;
var filmDao = new FilmDAO();
var inforFilm = filmDao.getFilmByID(filmBoID);
inforFilm.releasedEpisodes = inforFilm.releasedEpisodes + 1;
filmDao.dbFilmContext.SaveChanges();
return(Json(new { Message = message, JsonRequestBehavior.AllowGet }));
}
message = "Failed";
return(Json(new { Message = message }));
}
