Beispiel #1
0
        public static void Sil(Arac a)
        {
            string sorgu = "delete from Arac where Plaka=@p";
            Dictionary <string, object> param = new Dictionary <string, object>();

            param.Add("@p", a.Plaka);
            DB.ExecuteCommand(sorgu, param);
        }
Beispiel #2
0
        public static void Ekle(Arac a)
        {
            string sorgu = "insert into Arac(Plaka,Aciklama,Sofor) values(@p,@a,@s)";
            Dictionary <string, object> param = new Dictionary <string, object>();

            param.Add("@p", a.Plaka);
            param.Add("@a", a.Aciklama);
            param.Add("@s", a.Sofor);
            DB.ExecuteCommand(sorgu, param);
        }
Beispiel #3
0
        public static void Guncelle(Arac a, string eskiplaka)
        {
            string sorgu = "update Arac set Plaka=@p,Aciklama=@a,Sofor=@s where Plaka=@ep";
            Dictionary <string, object> param = new Dictionary <string, object>();

            param.Add("@p", a.Plaka);
            param.Add("@a", a.Aciklama);
            param.Add("@s", a.Sofor);
            param.Add("@ep", eskiplaka);
            DB.ExecuteCommand(sorgu, param);
        }