예제 #1
0
        public List <Bioskop> GetDataBioskop()
        {
            List <Bioskop> Listbskp = new List <Bioskop>();
            string         query    = String.Format("SELECT * FROM Bioskop");
            SqlCommand     com      = new SqlCommand(query, con);

            try
            {
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    Bioskop bio = new Bioskop();
                    bio.IDB           = reader.GetInt32(0);
                    bio.IDBioskop     = reader.GetString(1);
                    bio.NamaBioskop   = reader.GetString(2);
                    bio.AlamatBioskop = reader.GetString(3);
                    bio.Jumlah_Kursi  = reader.GetInt32(4);
                    Listbskp.Add(bio);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
            }
            con.Close();
            return(Listbskp);
        }
예제 #2
0
        public List <Bioskop> showKursi(string IDBioskop, string JudulFilm, string Tanggal, string Jam)
        {
            List <Bioskop> kursi = new List <Bioskop>();
            string         query = String.Format("SELECT IDBioskop, JudulFilm, Nomor_Kursi, Ketersediaan from InputData where IDBioskop = '{0}' AND JudulFilm = '{1}' AND Tanggal = '{2}' AND Jam = '{3}'", IDBioskop, JudulFilm, Tanggal, Jam);
            SqlCommand     com   = new SqlCommand(query, con);

            try
            {
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    Bioskop data = new Bioskop();
                    data.IDBioskop    = reader.GetString(0);
                    data.JudulFilm    = reader.GetString(1);
                    data.Nomor_Kursi  = reader.GetString(2);
                    data.Ketersediaan = reader.GetString(3);
                    kursi.Add(data);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
            }
            con.Close();
            return(kursi);
        }
예제 #3
0
        public List <Bioskop> showJadwal(string IDBioskop, string JudulFilm)
        {
            List <Bioskop> Jadwal = new List <Bioskop>();
            string         query  = String.Format("Select DISTINCT IDBioskop, JudulFilm, Tanggal, Jam FROM InputData where IDBioskop = '{0}' AND JudulFilm = '{1}'", IDBioskop, JudulFilm);
            SqlCommand     com    = new SqlCommand(query, con);

            try
            {
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    Bioskop data = new Bioskop();
                    data.IDBioskop = reader.GetString(0);
                    data.JudulFilm = reader.GetString(1);
                    data.Tanggal   = reader.GetString(2);
                    data.Jam       = reader.GetString(3);
                    Jadwal.Add(data);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
            }
            con.Close();
            return(Jadwal);
        }
예제 #4
0
        public List <Bioskop> GetTanggalBy(string IDBioskop, string JudulFilm)
        {
            List <Bioskop> TanggaByID = new List <Bioskop>();
            string         query      = String.Format("SELECT DISTINCT Tanggal from InputData where IDBioskop = '{0}' AND JudulFilm = '{1}'", IDBioskop, JudulFilm);
            SqlCommand     com        = new SqlCommand(query, con);

            try
            {
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    Bioskop tanggal = new Bioskop();
                    tanggal.Tanggal = reader.GetString(0);
                    TanggaByID.Add(tanggal);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
            }
            con.Close();
            return(TanggaByID);
        }
예제 #5
0
        public List <Bioskop> GetJamBy(string IDBioskop, string JudulFilm, string Tanggal)
        {
            List <Bioskop> JamBy = new List <Bioskop>();
            string         query = String.Format("SELECT DISTINCT Jam from InputData where IDBioskop = '{0}' AND JudulFilm = '{1}' AND Tanggal = '{2}'", IDBioskop, JudulFilm, Tanggal);
            SqlCommand     com   = new SqlCommand(query, con);

            try
            {
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    Bioskop jam = new Bioskop();
                    jam.Jam = reader.GetString(0);
                    JamBy.Add(jam);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
            }
            con.Close();
            return(JamBy);
        }
예제 #6
0
        public List <Bioskop> GetDataFIlm()
        {
            List <Bioskop> Listbskp = new List <Bioskop>();
            string         query    = String.Format("SELECT * FROM Film");
            SqlCommand     com      = new SqlCommand(query, con);

            try
            {
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    Bioskop bio = new Bioskop();
                    bio.IDFilm    = reader.GetInt32(0);
                    bio.JudulFilm = reader.GetString(1);
                    bio.Ratting   = reader.GetString(2);
                    bio.Aktor     = reader.GetString(3);
                    bio.Harga     = reader.GetInt32(4);
                    bio.Poster    = reader.GetString(5);
                    Listbskp.Add(bio);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
            }
            con.Close();
            return(Listbskp);
        }
예제 #7
0
        public List <Bioskop> GetJudulByBioskop(string IDBioskop)
        {
            List <Bioskop> JudulByID = new List <Bioskop>();
            string         query     = String.Format("SELECT DISTINCT JudulFilm from InputData where IDBioskop = '{0}'", IDBioskop);
            SqlCommand     com       = new SqlCommand(query, con);

            try
            {
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    Bioskop jdl = new Bioskop();
                    jdl.JudulFilm = reader.GetString(0);
                    JudulByID.Add(jdl);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
            }
            con.Close();
            return(JudulByID);
        }
예제 #8
0
        public string DeleteBioskop(Bioskop bioskop)
        {
            string     msg   = "GAGAl";
            string     query = String.Format("DELETE FROM Bioskop WHERE IDB={0}", bioskop.IDBioskop);
            SqlCommand com   = new SqlCommand(query, con);

            try
            {
                con.Open();
                Console.WriteLine(query);
                com.ExecuteNonQuery();
                msg = "SUKSES";
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
                msg = "GAGAL";
            }
            con.Close();
            return(msg);
        }
예제 #9
0
        public string CreateBioskop(Bioskop bioskop)
        {
            string     msg   = "GAGAl Create Bioskop";
            string     query = String.Format("INSERT INTO Bioskop (IDBioskop, NamaBioskop, AlamatBioskop, Jumlah_Kursi) VALUES ('{0}','{1}','{2}',{3})", bioskop.IDBioskop, bioskop.NamaBioskop, bioskop.AlamatBioskop, bioskop.Jumlah_Kursi);
            SqlCommand com   = new SqlCommand(query, con); //Comand

            try
            {
                con.Open();
                Console.WriteLine(query);
                com.ExecuteNonQuery();
                msg = "SUKSES Create Bioskkop";
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
                msg = "GAGAL Create Bioskop";
            }
            con.Close();
            return(msg);
        }
예제 #10
0
        public string EditBioskop(Bioskop bioskop)
        {
            string msg   = "GAGAl";
            string query = String.Format("UPDATE Bioskop SET IDBioskop = '{0}', NamaBioskop = '{1}', AlamatBioskop = '{2}', Jumlah_Kursi = {3} WHERE IDBioskop = '{0}'",
                                         bioskop.IDBioskop, bioskop.NamaBioskop, bioskop.AlamatBioskop, bioskop.Jumlah_Kursi);
            SqlCommand com = new SqlCommand(query, con);

            try
            {
                con.Open();
                Console.WriteLine(query);
                com.ExecuteNonQuery();
                msg = "SUKSES";
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
                msg = "GAGAL";
            }
            con.Close();
            return(msg);
        }
예제 #11
0
        public Bioskop GetKursiBioskop(string IDBioskop)
        {
            Bioskop    kursiBioskop = new Bioskop();
            string     query        = String.Format("SELECT Jumlah_Kursi from Bioskop where IDBioskop = '{0}'", IDBioskop);
            SqlCommand com          = new SqlCommand(query, con);

            try
            {
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    kursiBioskop.Jumlah_Kursi = reader.GetInt32(0);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
            }
            con.Close();
            return(kursiBioskop);
        }
예제 #12
0
        public string EditFilm(Bioskop bioskop)
        {
            string msg   = "GAGAl";
            string query = String.Format("UPDATE Film set JudulFilm = '{0}', Ratting = '{1}', Aktor = '{2}', Harga = {3}, Poster ='{4}' where IDFilm ={5}",
                                         bioskop.JudulFilm, bioskop.Ratting, bioskop.Aktor, bioskop.Harga, bioskop.Poster, bioskop.IDFilm);
            SqlCommand com = new SqlCommand(query, con);

            try
            {
                con.Open();
                Console.WriteLine(query);
                com.ExecuteNonQuery();
                msg = "SUKSES";
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
                msg = "GAGAL";
            }
            con.Close();
            return(msg);
        }
예제 #13
0
        public string CreateKursi(Bioskop bioskop)
        {
            string msg   = "GAGAl Create Kursi";
            string query = String.Format("INSERT INTO InputData (Nomor_Kursi, Ketersediaan, IDBioskop, JudulFilm, Tanggal, Jam) Values ('{0}','{1}','{2}','{3}','{4}','{5}')",
                                         bioskop.Nomor_Kursi, bioskop.Ketersediaan, bioskop.IDBioskop, bioskop.JudulFilm, bioskop.Tanggal, bioskop.Jam);
            SqlCommand com = new SqlCommand(query, con);  //Comand

            try
            {
                con.Open();
                Console.WriteLine(query);
                com.ExecuteNonQuery();
                msg = "SUKSES Create Kursi";
            }

            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
                msg = "GAGAL Create Kursi";
            }
            con.Close();
            return(msg);
        }
예제 #14
0
        public string CreateFilm(Bioskop bioskop)
        {
            string msg   = "GAGAl Create Film";
            string query = String.Format("INSERT INTO Film (JudulFilm, Ratting, Aktor, Harga, Poster) VALUES ('{0}','{1}','{2}',{3},'{4}')",
                                         bioskop.JudulFilm, bioskop.Ratting, bioskop.Aktor, bioskop.Harga, bioskop.Poster);
            SqlCommand com = new SqlCommand(query, con);  //Comand

            try
            {
                con.Open();
                Console.WriteLine(query);
                com.ExecuteNonQuery();
                msg = "SUKSES Create Film";
            }

            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(query);
                msg = "GAGAL Create Film";
            }
            con.Close();
            return(msg);
        }