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