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