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