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();
}
