public List <C_ViewMenuDuJour> Lire(string Index)
{
CreerCommande("SelectionnerViewMenuDuJour");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_ViewMenuDuJour> res = new List <C_ViewMenuDuJour>();
while (dr.Read())
{
C_ViewMenuDuJour tmp = new C_ViewMenuDuJour();
tmp.ID = int.Parse(dr["ID"].ToString());
tmp.Date = DateTime.Parse(dr["Date"].ToString());
tmp.eNom = dr["eNom"].ToString();
tmp.ePhoto = dr["ePhoto"].ToString();
tmp.pNom = dr["pNom"].ToString();
tmp.pPhoto = dr["pPhoto"].ToString();
tmp.dNom = dr["dNom"].ToString();
tmp.dPhoto = dr["dPhoto"].ToString();
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public C_ViewMenuDuJour Lire_Date(DateTime date)
{
CreerCommande("SelectionnerViewMenuDuJour_Date");
Commande.Parameters.AddWithValue("@Date", date);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_ViewMenuDuJour res = new C_ViewMenuDuJour();
while (dr.Read())
{
res.ID = int.Parse(dr["ID"].ToString());
res.Date = DateTime.Parse(dr["Date"].ToString());
res.eNom = dr["eNom"].ToString();
res.ePhoto = dr["ePhoto"].ToString();
res.pNom = dr["pNom"].ToString();
res.pPhoto = dr["pPhoto"].ToString();
res.dNom = dr["dNom"].ToString();
res.dPhoto = dr["dPhoto"].ToString();
}
dr.Close();
Commande.Connection.Close();
return(res);
}
