public static bool DaireDuzenle(DaireKayitlari dk)
{
OleDbCommand cmd = new OleDbCommand("Update Daire Set DaireDurum = @s1, DaireSahibi = @s2, DaireSakini = @s3, Kat = @s4 Where DaireNo = @s5", BaglantiSinifi.Con);
cmd.Parameters.AddWithValue("@s1", dk.DaireDurum);
cmd.Parameters.AddWithValue("@s2", dk.DaireSahibi);
cmd.Parameters.AddWithValue("@s3", dk.DaireSakini);
cmd.Parameters.AddWithValue("@s4", dk.Kat);
cmd.Parameters.AddWithValue("@s5", dk.DaireNo);
return(Sorgu(cmd));
}
public static bool DaireEkle(DaireKayitlari dk)
{
OleDbCommand cmd = new OleDbCommand("Insert Into Daire values (@s2,@s3,[@s4],[@s5],@s6)", BaglantiSinifi.Con);
cmd.Parameters.AddWithValue("@s2", dk.DaireNo);
cmd.Parameters.AddWithValue("@s3", dk.DaireDurum);
cmd.Parameters.AddWithValue("@s4", dk.DaireSahibi);
cmd.Parameters.AddWithValue("@s5", dk.DaireSakini);
cmd.Parameters.AddWithValue("@s6", dk.Kat);
return(Sorgu(cmd));
}
public bool GirdiKontrol()
{
try
{
dk = new DaireKayitlari();
if (tb_daireNo.Text != "" && cb_DaireDurum.Text != "" && cb_DaireSahibi.Text != "" && cb_DaireSakini.Text != "")
{
dk.DaireNo = Convert.ToInt32(tb_daireNo.Text);
dk.DaireDurum = cb_DaireDurum.Text;
dk.DaireSahibi = cb_DaireSahibi.Text;
dk.DaireSakini = cb_DaireSakini.Text;
dk.Kat = Convert.ToInt32(nud_kat.Value);
return true;
}
}
catch (Exception exp)
{
Console.WriteLine(exp.Message);
}
return false;
}
