public override void Sil(IArayuz arayuz) { Oda oda = (Oda)arayuz; Baglan(); komut = new System.Data.SqlClient.SqlCommand("usp_OdaSil", baglanti); komut.CommandType = CommandType.StoredProcedure; komut.Parameters.AddWithValue("@Id", oda.Id); komut.ExecuteNonQuery(); baglanti.Close(); baglanti.Dispose(); }
public override DataTable Listele(IArayuz arayuz) { Oda oda = (Oda)arayuz; string sorgu = "SELECT * FROM tbl_Oda "; Baglan(); komut = new System.Data.SqlClient.SqlCommand(sorgu, baglanti); komut.ExecuteNonQuery(); tablo = new DataTable(); adaptor = new System.Data.SqlClient.SqlDataAdapter(komut); adaptor.Fill(tablo); baglanti.Close(); baglanti.Dispose(); return(tablo); }
public override DataTable Arama(IArayuz arayuz) { Oda oda = (Oda)arayuz; Baglan(); string sorgu = "select * from tbl_Oda where OdaAdi like '%" + oda.OdaAdi + "%' or Id = " + oda.Id.ToString(); komut = new System.Data.SqlClient.SqlCommand(sorgu, baglanti); komut.CommandType = CommandType.Text; komut.ExecuteNonQuery(); adaptor = new System.Data.SqlClient.SqlDataAdapter(komut); tablo = new DataTable(); adaptor.Fill(tablo); baglanti.Close(); baglanti.Dispose(); return(tablo); }