예제 #1
0
            public static List <Masa> MasalariGuncelle()
            {
                baglanti();
                OleDbCommand    komut   = new OleDbCommand("SELECT * FROM Masalar", con);
                OleDbDataReader oku     = komut.ExecuteReader();
                List <Masa>     masalar = new List <Masa>();

                while (oku.Read())
                {
                    Masa masa = new Masa(Convert.ToInt32(oku["Masa_No"]), Convert.ToBoolean(oku["Masa_Durum"]));
                    masalar.Add(masa);
                }
                bitir();
                return(masalar);
            }
예제 #2
0
            public static List <Masa> BosMasaListele()
            {
                List <Masa> bosMasalar = new List <Masa>();

                baglanti();
                OleDbCommand    komut = new OleDbCommand("SELECT * FROM Masalar WHERE Masa_Durum=false", con);
                OleDbDataReader oku   = komut.ExecuteReader();

                while (oku.Read())
                {
                    Masa masa = new Masa(Convert.ToInt32(oku["Masa_No"]), Convert.ToBoolean(oku["Masa_Durum"]));
                    bosMasalar.Add(masa);
                }
                bitir();
                return(bosMasalar);
            }
예제 #3
0
            public static Masa MasaAl(int masaNo)
            {
                Masa masa = new Masa(0, false);

                baglanti();
                OleDbCommand komut = new OleDbCommand("SELECT * FROM Masalar WHERE Masa_No=@no", con);

                komut.Parameters.AddWithValue("@no", masaNo);
                OleDbDataReader oku = komut.ExecuteReader();

                while (oku.Read())
                {
                    masa.MasaNo    = Convert.ToInt32(oku["Masa_No"]);
                    masa.MasaDurum = Convert.ToBoolean(oku["Masa_Durum"]);
                }
                bitir();
                return(masa);
            }