public static void Sil(int ID) { SQLiteCommand cm = DBCon.KomutOlustur("delete from ARIZA where ID=@ID"); cm.Parameters.AddWithValue("@ID", ID); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Guncelle(ARIZA p) { SQLiteCommand cm = DBCon.KomutOlustur("update ARIZA set M_ID=@M_ID,A_ID=@A_ID,TAR=@TAR,ONAY=@ONAY,MSJ=@MSJ where ID=@ID"); cm.Parameters.AddWithValue("@M_ID", p.M_ID); cm.Parameters.AddWithValue("@A_ID", p.A_ID); cm.Parameters.AddWithValue("@TAR", p.TAR); cm.Parameters.AddWithValue("@ONAY", p.ONAY); cm.Parameters.AddWithValue("@MSJ", p.MSJ); cm.Parameters.AddWithValue("@ID", p.ID); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Guncelle(KASA p) { SQLiteCommand cm = DBCon.KomutOlustur("update KASA set TUR=@TUR,MIKTAR=@MIKTAR,ACIKLA=@ACIKLA,TAR=@TAR,A_ID=@A_ID where ID=@ID"); cm.Parameters.AddWithValue("@TUR", p.TUR); cm.Parameters.AddWithValue("@MIKTAR", p.MIKTAR); cm.Parameters.AddWithValue("@ACIKLA", p.ACIKLA); cm.Parameters.AddWithValue("@TAR", p.TAR); cm.Parameters.AddWithValue("@A_ID", p.A_ID); cm.Parameters.AddWithValue("@ID", p.ID); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Kaydet(ARIZA p) { SQLiteCommand cm = DBCon.KomutOlustur("insert into ARIZA(ID,M_ID,A_ID,TAR,ONAY,MSJ)values (@ID,@M_ID,@A_ID,@TAR,@ONAY,@MSJ)"); cm.Parameters.AddWithValue("@ID", null); cm.Parameters.AddWithValue("@M_ID", p.M_ID); cm.Parameters.AddWithValue("@A_ID", p.A_ID); cm.Parameters.AddWithValue("@TAR", p.TAR); cm.Parameters.AddWithValue("@ONAY", p.ONAY); cm.Parameters.AddWithValue("@MSJ", p.MSJ); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Kaydet(KASA p) { SQLiteCommand cm = DBCon.KomutOlustur("insert into KASA(ID,TUR,MIKTAR,ACIKLA,TAR,A_ID)values (@ID,@TUR,@MIKTAR,@ACIKLA,@TAR,@A_ID)"); cm.Parameters.AddWithValue("@ID", null); cm.Parameters.AddWithValue("@TUR", p.TUR); cm.Parameters.AddWithValue("@MIKTAR", p.MIKTAR); cm.Parameters.AddWithValue("@ACIKLA", p.ACIKLA); cm.Parameters.AddWithValue("@TAR", p.TAR); cm.Parameters.AddWithValue("@A_ID", p.A_ID); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Guncelle(ADMIN p) { SQLiteCommand cm = DBCon.KomutOlustur("update ADMIN set K_AD=@K_AD,SFR=@SFR,MAIL=@MAIL,YET=@YET,SON_GRS=@SON_GRS where ID=@ID"); cm.Parameters.AddWithValue("@K_AD", p.K_AD); cm.Parameters.AddWithValue("@SFR", p.SFR); cm.Parameters.AddWithValue("@MAIL", p.MAIL); cm.Parameters.AddWithValue("@YET", p.YET); cm.Parameters.AddWithValue("@SON_GRS", p.SON_GRS); cm.Parameters.AddWithValue("@ID", p.ID); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Kaydet(ADMIN p) { SQLiteCommand cm = DBCon.KomutOlustur("insert into ADMIN(ID,K_AD,SFR,MAIL,YET,SON_GRS)values (@ID,@K_AD,@SFR,@MAIL,@YET,@SON_GRS)"); cm.Parameters.AddWithValue("@ID", null); cm.Parameters.AddWithValue("@K_AD", p.K_AD); cm.Parameters.AddWithValue("@SFR", p.SFR); cm.Parameters.AddWithValue("@MAIL", p.MAIL); cm.Parameters.AddWithValue("@YET", p.YET); cm.Parameters.AddWithValue("@SON_GRS", p.SON_GRS); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Guncelle(MUSTERI p) { SQLiteCommand cm = DBCon.KomutOlustur("update MUSTERI set K_AD=@K_AD,AD=@AD,ADRES=@ADRES,CEP_TEL=@CEP_TEL,TEL=@TEL where ID=@ID"); cm.Parameters.AddWithValue("@K_AD", p.K_AD); cm.Parameters.AddWithValue("@AD", p.AD); cm.Parameters.AddWithValue("@ADRES", p.ADRES); cm.Parameters.AddWithValue("@CEP_TEL", p.CEP_TEL); cm.Parameters.AddWithValue("@TEL", p.TEL); cm.Parameters.AddWithValue("@ID", p.ID); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Kaydet(MUSTERI p) { SQLiteCommand cm = DBCon.KomutOlustur("insert into MUSTERI(ID,K_AD,AD,ADRES,CEP_TEL,TEL)values (@ID,@K_AD,@AD,@ADRES,@CEP_TEL,@TEL)"); cm.Parameters.AddWithValue("@ID", null); cm.Parameters.AddWithValue("@K_AD", p.K_AD); cm.Parameters.AddWithValue("@AD", p.AD); cm.Parameters.AddWithValue("@ADRES", p.ADRES); cm.Parameters.AddWithValue("@CEP_TEL", p.CEP_TEL); cm.Parameters.AddWithValue("@TEL", p.TEL); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Guncelle(BASVURU p) { SQLiteCommand cm = DBCon.KomutOlustur("update BASVURU set AD=@AD,ADRES=@ADRES,CEP_TEL=@CEP_TEL,TEL=@TEL,TARIFE=@TARIFE,A_ID=@A_ID,TAR=@TAR,ONAY=@ONAY where ID=@ID"); cm.Parameters.AddWithValue("@AD", p.AD); cm.Parameters.AddWithValue("@ADRES", p.ADRES); cm.Parameters.AddWithValue("@CEP_TEL", p.CEP_TEL); cm.Parameters.AddWithValue("@TEL", p.TEL); cm.Parameters.AddWithValue("@TARIFE", p.TARIFE); cm.Parameters.AddWithValue("@A_ID", p.A_ID); cm.Parameters.AddWithValue("@TAR", p.TAR); cm.Parameters.AddWithValue("@ONAY", p.ONAY); cm.Parameters.AddWithValue("@ID", p.ID); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }
public static void Kaydet(BASVURU p) { SQLiteCommand cm = DBCon.KomutOlustur("insert into BASVURU(ID,AD,ADRES,CEP_TEL,TEL,TARIFE,A_ID,TAR,ONAY)values (@ID,@AD,@ADRES,@CEP_TEL,@TEL,@TARIFE,@A_ID,@TAR,@ONAY)"); cm.Parameters.AddWithValue("@ID", null); cm.Parameters.AddWithValue("@AD", p.AD); cm.Parameters.AddWithValue("@ADRES", p.ADRES); cm.Parameters.AddWithValue("@CEP_TEL", p.CEP_TEL); cm.Parameters.AddWithValue("@TEL", p.TEL); cm.Parameters.AddWithValue("@TARIFE", p.TARIFE); cm.Parameters.AddWithValue("@A_ID", p.A_ID); cm.Parameters.AddWithValue("@TAR", p.TAR); cm.Parameters.AddWithValue("@ONAY", p.ONAY); cm.Connection.Open(); cm.ExecuteNonQuery(); cm.Connection.Close(); }