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