Example #1
0
        public static List <Films> getAllFilmsNowShowing(bool isclose, DateTime dateStart)
        {
            string sql = "SELECT id,name,image,daoDien,dienVien,ngayKhoiChieu,thoiGian,ngonNgu,idRated,idGenres,idCountry,numberXem FROM dbo.Films" +
                         " WHERE isClose = @close AND ngayKhoiChieu < @date ORDER BY numberXem ASC";

            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@close", SqlDbType.Bit),
                new SqlParameter("@date", SqlDbType.DateTime)
            };
            param[0].Value = isclose;
            param[1].Value = dateStart;
            DataTable    dt       = DataAccess.ReadDataBySQLWithParameter(sql, param);
            List <Films> listFilm = new List <Films>();

            foreach (DataRow dr in dt.Rows)
            {
                Films fl = new Films();
                fl.ID          = Convert.ToInt32(dr["id"].ToString());
                fl.Name        = dr["name"].ToString();
                fl.Image       = dr["image"].ToString();
                fl.Directors   = dr["daoDien"].ToString();
                fl.Actor       = dr["dienVien"].ToString();
                fl.ReleaseTime = Convert.ToDateTime(dr["ngayKhoiChieu"].ToString());
                fl.Time        = Convert.ToInt32(dr["thoiGian"].ToString());
                fl.Language    = dr["ngonNgu"].ToString();
                fl.CountRate   = Convert.ToInt32(dr["numberXem"].ToString());
                fl.Ratedx      = RatedDAO.getRatedByID(Convert.ToInt32(dr["idRated"].ToString()));
                fl.Genresx     = GenresDAO.getGenresdByID(Convert.ToInt32(dr["idGenres"].ToString()));
                fl.Countryx    = CountryADO.getCountrydByID(Convert.ToInt32(dr["idCountry"].ToString()));
                listFilm.Add(fl);
            }
            return(listFilm);
        }
        public static Films getDetailFilm(int id)
        {
            string sql = "SELECT id,name,image,daoDien,dienVien,ngayKhoiChieu,thoiGian,ngonNgu,idRated,idGenres,idCountry,numberXem FROM dbo.Films where id  = @id ";

            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@id", SqlDbType.Int)
            };
            param[0].Value = id;
            DataTable dt = DataAccess.ReadDataBySQLWithParameter(sql, param);
            Films     fl = new Films();

            foreach (DataRow dr in dt.Rows)
            {
                fl.ID          = Convert.ToInt32(dr["id"].ToString());
                fl.Name        = dr["name"].ToString();
                fl.Image       = dr["image"].ToString();
                fl.Directors   = dr["daoDien"].ToString();
                fl.Actor       = dr["dienVien"].ToString();
                fl.ReleaseTime = Convert.ToDateTime(dr["ngayKhoiChieu"].ToString());
                fl.Time        = Convert.ToInt32(dr["thoiGian"].ToString());
                fl.Language    = dr["ngonNgu"].ToString();
                fl.CountRate   = Convert.ToInt32(dr["numberXem"].ToString());
                fl.Ratedx      = RatedDAO.getRatedByID(Convert.ToInt32(dr["idRated"].ToString()));
                fl.Genresx     = GenresDAO.getGenresdByID(Convert.ToInt32(dr["idGenres"].ToString()));
                fl.Countryx    = CountryADO.getCountrydByID(Convert.ToInt32(dr["idCountry"].ToString()));
            }
            return(fl);
        }