public static bool AidatDuzenle(AidatKayitlari ak)
{
OleDbCommand cmd = new OleDbCommand("Update Aidat Set DaireNo = @s1, Tarih = @s2, AidatTutar = @s3, OrtakTutar = @s4, Demirbas = @s5, ToplamTutar = @s6 Where AidatNo = @s7", BaglantiSinifi.Con);
cmd.Parameters.AddWithValue("@s1", ak.DaireNo);
cmd.Parameters.AddWithValue("@s2", ak.Tarih);
cmd.Parameters.AddWithValue("@s3", ak.AidatTutar);
cmd.Parameters.AddWithValue("@s4", ak.OrtakTutar);
cmd.Parameters.AddWithValue("@s5", ak.Demirbas);
cmd.Parameters.AddWithValue("@s6", ak.ToplamTutar);
cmd.Parameters.AddWithValue("@s7", ak.AidatNo);
return(Sorgu(cmd));
}
public static bool AidatEkle(AidatKayitlari ak)
{
OleDbCommand cmd = new OleDbCommand("Insert Into Aidat values (@s1,@s2,@s3,@s4,@s5,@s6,@s7)", BaglantiSinifi.Con);
cmd.Parameters.AddWithValue("@s1", ak.AidatNo);
cmd.Parameters.AddWithValue("@s2", ak.DaireNo);
cmd.Parameters.AddWithValue("@s3", ak.Tarih);
cmd.Parameters.AddWithValue("@s4", ak.AidatTutar);
cmd.Parameters.AddWithValue("@s5", ak.OrtakTutar);
cmd.Parameters.AddWithValue("@s6", ak.Demirbas);
cmd.Parameters.AddWithValue("@s7", ak.ToplamTutar);
return(Sorgu(cmd));
}
public bool GirdiKontrol()
{
try
{
ak = new AidatKayitlari();
if (tb_aidatNo.Text != "" && cb_daireNo.Text != "" && tb_tutar.Text != "" && tb_ortakTutar.Text != "")
{
ak.AidatNo = Convert.ToInt32(tb_aidatNo.Text);
ak.DaireNo = Convert.ToInt32(cb_daireNo.Text);
ak.Tarih = dtp_tarih.Value.ToString();
ak.AidatTutar = Convert.ToInt32(tb_tutar.Text);
ak.OrtakTutar = Convert.ToInt32(tb_ortakTutar.Text);
ak.Demirbas = Convert.ToInt32(tb_demirbas.Text);
ak.ToplamTutar = Convert.ToInt32(tb_toplam.Text);
return(true);
}
}
catch (Exception exp)
{
Console.WriteLine(exp.Message);
}
return(false);
}
