public SqlDataReader YemekMenusuGetir(DateTime menu)
{
VeritabaniKatmani.vertitabaniKatmani katman = new VeritabaniKatmani.vertitabaniKatmani();
katman.InputParametreEkle("@durum", 5);
katman.InputParametreEkle("@tarih", menu);
SqlDataReader sonuc = katman.DrVeriCek("spYemekMenusu", System.Data.CommandType.StoredProcedure);
return(sonuc);
}
public List <Ders> Getir()
{
SqlDataReader rd = veri.DrVeriCek("DersleriGetir", CommandType.StoredProcedure);
if (rd.HasRows)
{
while (rd.Read())
{
Ders d = new Ders {
id = Convert.ToInt32(rd[0].ToString()),
Adi = rd[1].ToString()
};
de.Add(d);
}
return(de);
}
return(null);
}