public List <C_Menu> Lire(string Index)
{
CreerCommande("SelectionnerMenu");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_Menu> res = new List <C_Menu>();
while (dr.Read())
{
C_Menu tmp = new C_Menu();
tmp.ID = int.Parse(dr["ID"].ToString());
tmp.Date = DateTime.Parse(dr["Date"].ToString());
if (dr["IDpotage"] != DBNull.Value)
{
tmp.IDpotage = int.Parse(dr["IDpotage"].ToString());
}
if (dr["IDplat"] != DBNull.Value)
{
tmp.IDplat = int.Parse(dr["IDplat"].ToString());
}
if (dr["IDdessert"] != DBNull.Value)
{
tmp.IDdessert = int.Parse(dr["IDdessert"].ToString());
}
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public C_Menu Lire_ID(int ID)
{
CreerCommande("SelectionnerMenu_ID");
Commande.Parameters.AddWithValue("@ID", ID);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_Menu res = new C_Menu();
while (dr.Read())
{
res.ID = int.Parse(dr["ID"].ToString());
res.Date = DateTime.Parse(dr["Date"].ToString());
if (dr["IDpotage"] != DBNull.Value)
{
res.IDpotage = int.Parse(dr["IDpotage"].ToString());
}
if (dr["IDplat"] != DBNull.Value)
{
res.IDplat = int.Parse(dr["IDplat"].ToString());
}
if (dr["IDdessert"] != DBNull.Value)
{
res.IDdessert = int.Parse(dr["IDdessert"].ToString());
}
}
dr.Close();
Commande.Connection.Close();
return(res);
}
private void dynamicButtonMenu1_Click(Object sender, System.EventArgs e)
{
Button Btn_Menu = sender as Button;
Btn_Menu.Width = 100;
int codigoMenu = Int32.Parse(Btn_Menu.Name.Substring(4, Btn_Menu.Name.Length - 4));
C_Menu objetoMenu = _shalong.MenuMostrar1(codigoMenu);
Assembly asm = Assembly.GetEntryAssembly();
Type formType = asm.GetType("Shalong.Formularios." + objetoMenu.Formulario);
Form formularioDinamico = (Form)Activator.CreateInstance(formType, this, _parametros);
formularioDinamico.ShowDialog();
}
