public List <Films> getFilmByCinemaAndDate(int id_C, DateTime date) { List <Films> Flist = new List <Films>(); ScheduleDAO scheDAO = new ScheduleDAO(); using (conn) { string sql = "SELECT DISTINCT Films.id_F, F_Name, id_P, ReleaseDate, Description, Rating, LimitAge, AirDate, EndDate, Films.Status FROM Films INNER JOIN Schedule ON Films.id_F = Schedule.id_F where Schedule.id_C=@id_C and Schedule.Sche_Date= @Sche_Date and Films.Status > 0"; MySqlCommand com = new MySqlCommand(sql); com.Connection = conn; com.Parameters.AddWithValue("@id_C", id_C); com.Parameters.AddWithValue("@Sche_Date", date); conn.Open(); MySqlDataReader dr = com.ExecuteReader(); GraphicsDAO gDAO = new GraphicsDAO(); while (dr.Read()) { int id_F = Convert.ToInt32(dr["id_F"]); Graphics g = gDAO.getLastPosterInFilm(Convert.ToInt32(dr["id_F"])); Flist.Add(new Films { id_F = id_F, F_Name = dr["F_Name"].ToString(), id_P = Convert.ToInt32(dr["id_P"]), ReleaseDate = Convert.ToDateTime(dr["ReleaseDate"]), Description = dr["Description"].ToString(), Rating = Convert.ToDouble(dr["Rating"]), LimitAge = Convert.ToInt32(dr["LimitAge"]), AirDate = Convert.ToDateTime(dr["AirDate"]), EndDate = Convert.ToDateTime(dr["EndDate"]), Status = Convert.ToInt32(dr["status"]), Poster = (g != null) ? g.Path : "empty.jpg", }); } //đóng db sau khi dùng xong nhe conn.Close(); Flist.ForEach(item => { item.Schedules = scheDAO.getSchedulesByCinemaFilmTime(id_C, item.id_F, date); }); } return(Flist); }
public List <Films> getAllFilm() { List <Films> Flist = new List <Films>(); using (conn) { string sql = "select * from Films INNER JOIN `Producers` ON Films.id_P=Producers.id_P where Films.Status > 0"; MySqlCommand com = new MySqlCommand(sql); com.Connection = conn; conn.Open(); MySqlDataReader dr = com.ExecuteReader(); GraphicsDAO gDAO = new GraphicsDAO(); while (dr.Read()) { int id_F = Convert.ToInt32(dr["id_F"]); Graphics g = gDAO.getLastPosterInFilm(Convert.ToInt32(dr["id_F"])); Flist.Add(new Films { id_F = id_F, F_Name = dr["F_Name"].ToString(), id_P = Convert.ToInt32(dr["id_P"]), ReleaseDate = Convert.ToDateTime(dr["ReleaseDate"]), Description = dr["Description"].ToString(), Rating = Convert.ToDouble(dr["Rating"]), LimitAge = Convert.ToInt32(dr["LimitAge"]), AirDate = Convert.ToDateTime(dr["AirDate"]), EndDate = Convert.ToDateTime(dr["EndDate"]), Status = Convert.ToInt32(dr["status"]), Poster = (g != null) ? g.Path : "empty.jpg", F_Trailer = dr["F_Trailer"].ToString(), F_Time = Convert.ToInt32(dr["F_Time"]) }); } //đóng db sau khi dùng xong nhe conn.Close(); Flist.ForEach(item => { item.Categories = new CategoryDAO().ListCategoryInFilm(item.id_F); }); } return(Flist); }