public void ListaMenu()
{
MenuItem menu = new MenuItem();
BEMenu eMenu = new BEMenu();
BERolMenu eRolMenu = new BERolMenu();
DataTable dt = new DataTable();
eRolUsuario.Cod_Personal = Session["IDPERSONAL"].ToString();
try
{
eRolMenu.Id_Rol = Convert.ToInt32(Session["RolElegido"].ToString());
eMenu.Id_Padre = 0;
dt = objMenu.ConsultarMenu(eMenu, eRolMenu);
if (dt.Rows.Count > 0)
{
Session["NewRol"] = Convert.ToInt32(Session["RolElegido"].ToString());
CargaMenu(dt);
}
}
catch (Exception ex)
{
NetAjax.JsMensajeAlert(this.Page, ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
BEMenu BE = new BEMenu();
IUsers Interface = new IUsers();
BEUser BEUser = new BEUser();
BEUser = (BEUser)Session["LoginUser"];
BE.codUser = BEUser.UserCod;
lblLoginFullName.Text = BEUser.UserName;
AddTopMenuItems(Interface.IGetMenuTop(BE));
}
public DataTable ConsultarMenu(BEMenu eMenu, BERolMenu eRolMenu)
{
DataTable dt = new DataTable();
MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin");
MySqlCommand command = new MySqlCommand("`mecanicsweb`.`ConsultarMenu`", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(ObjSqlParameter("N_IDRol", eRolMenu.Id_Rol, ParameterDirection.Input, System.Data.DbType.Int32));
command.Parameters.Add(ObjSqlParameter("N_IDPadre", eMenu.Id_Padre, ParameterDirection.Input, System.Data.DbType.Int32));
conn.Open();
IDataReader dr = command.ExecuteReader();
dt.Load(dr);
conn.Close();
return(dt);
}
public void CargaMenu(DataTable dt)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
MenuItem menuItem = new MenuItem();
menuItem.Value = dt.Rows[i]["ID"].ToString();
menuItem.Text = dt.Rows[i]["Nombre"].ToString();
menuItem.NavigateUrl = dt.Rows[i]["Pagina"].ToString();
menuItem.Selectable = false;
DataTable dt2 = new DataTable();
BEMenu eMenu = new BEMenu();
BERolMenu eRolMenu = new BERolMenu();
eRolMenu.Id_Rol = Convert.ToInt32(Session["NewRol"]);
eMenu.Id_Padre = Convert.ToInt32(dt.Rows[i].ItemArray[0].ToString());
dt2 = objMenu.ConsultarMenu(eMenu, eRolMenu);
NavigationMenu.Items.Add(menuItem);
AddMenuItem(menuItem, dt2);
}
}
/*Menus*/
public List <BEMenu> GetMenuTop(BEMenu BE)
{
List <BEMenu> Menus = new List <BEMenu>();
try
{
using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_GET_MENU_TOP"))
{
dbSQL.AddInParameter(dbCmd, "@codUser", DbType.String, BE.codUser);
using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd))
{
int SiteMapID = dataReader.GetOrdinal("SiteMapID");
int Title = dataReader.GetOrdinal("Title");
//int Description = dataReader.GetOrdinal("Description");
int Url = dataReader.GetOrdinal("Url");
int ParentID = dataReader.GetOrdinal("ParentID");
object[] values = new object[dataReader.FieldCount];
while (dataReader.Read())
{
dataReader.GetValues(values);
BE = new BEMenu();
BE.ID = values[SiteMapID] == DBNull.Value ? 0 : Convert.ToInt32(values[SiteMapID]);
BE.Text = values[Title] == DBNull.Value ? string.Empty : values[Title].ToString();
BE.Url = values[Url] == DBNull.Value ? string.Empty : values[Url].ToString();
BE.ParentID = values[ParentID] == DBNull.Value ? 0 : Convert.ToInt32(values[ParentID]);
Menus.Add(BE);
}
}
return(Menus);
}
}
catch (Exception ex)
{
ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false);
return(null);
}
finally
{
}
}
/*Menus*/
public List <BEMenu> GetMenuTopBL(BEMenu BE)
{
return(DA.GetMenuTop(BE));
}
/*Menu*/
public List <BEMenu> IGetMenuTop(BEMenu BE)
{
return(BL.GetMenuTopBL(BE));
}
public DataTable ConsultarMenu(BEMenu objEMEnu, BERolMenu eRolMenu)
{
return(objMenu.ConsultarMenu(objEMEnu, eRolMenu));
}
