/// <summary> /// Atualiza um link extra do menu /// </summary> /// <param name="pobjMenuLinkExtra">MenuLinkExtra</param> /// <returns></returns> public static int Atualizar(MenuLinkExtra pobjMenuLinkExtra) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_U_MENU_LINK_EXTRA"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@menuLinkId", SqlDbType.Int).Value = pobjMenuLinkExtra.ID; if (!String.IsNullOrWhiteSpace(pobjMenuLinkExtra.Nome)) { objComando.Parameters.Add("@nomeMenu", SqlDbType.VarChar, 100).Value = pobjMenuLinkExtra.Nome; } if (!String.IsNullOrWhiteSpace(pobjMenuLinkExtra.Url)) { objComando.Parameters.Add("@url", SqlDbType.VarChar, 1000).Value = pobjMenuLinkExtra.Url; } if (!String.IsNullOrWhiteSpace(pobjMenuLinkExtra.Target)) { objComando.Parameters.Add("@target", SqlDbType.VarChar, 20).Value = pobjMenuLinkExtra.Target; } if (pobjMenuLinkExtra.IdiomaId > 0) { objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pobjMenuLinkExtra.IdiomaId; } if (!String.IsNullOrWhiteSpace(pobjMenuLinkExtra.ChaveNome)) { objComando.Parameters.Add("@chaveNome", SqlDbType.VarChar, 50).Value = pobjMenuLinkExtra.ChaveNome; } try { //Abre conexão com o banco de dados objConexao.Open(); //Declara variavel de retorno int intRetorno = 0; //Executa comando no banco de dados intRetorno = objComando.ExecuteNonQuery(); return(intRetorno); } catch (Exception ex) { throw ex; } finally { //Fecha a conexao se aberta if (objConexao.State != ConnectionState.Closed) { objConexao.Close(); } } }
/// <summary> /// Obter Todos os menus principais /// </summary> /// <returns></returns> public static List <MenuLinkExtra> Listar(int pintId = 0, int pintIdiomaId = 0) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_L_MENU_LINK_EXTRA"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; if (pintId > 0) { objComando.Parameters.Add("@menuLinkId", SqlDbType.Int).Value = pintId; } if (pintIdiomaId > 0) { objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pintIdiomaId; } try { //Abre Conexao objConexao.Open(); //Declara variavel de retorno List <MenuLinkExtra> objList = new List <MenuLinkExtra>(); MenuLinkExtra obj = default(MenuLinkExtra); IDataReader idrReader = default(IDataReader); idrReader = objComando.ExecuteReader(); while ((idrReader.Read())) { obj = new MenuLinkExtra(); obj.FromIDataReader(idrReader); objList.Add(obj); } return(objList); } catch (Exception ex) { throw ex; } finally { //Fecha a conexao se aberta if (objConexao.State != ConnectionState.Closed) { objConexao.Close(); } } }
private void CarregarObjetos(Utilitarios.TipoTransacao objTipoTransacao) { switch (objTipoTransacao) { //Novo Grupo case Utilitarios.TipoTransacao.Limpar: ddlNome.SelectedValue = "1"; ddlIdioma.SelectedIndex = 0; ddlPaginas.SelectedIndex = 0; ddlTarget.SelectedIndex = 0; txtChave.Text = string.Empty; txtUrl.Text = string.Empty; txtTexto.Text = string.Empty; break; //Carregar Dados do Link case Utilitarios.TipoTransacao.Salvar: if (gobjMenuLinkExtra == null) { gobjMenuLinkExtra = new MenuLinkExtra(); } gobjMenuLinkExtra.ID = Convert.ToInt32(ddlNome.SelectedValue); gobjMenuLinkExtra.Nome = txtTexto.Text; gobjMenuLinkExtra.IdiomaId = Convert.ToInt32(ddlIdioma.SelectedValue); gobjMenuLinkExtra.Target = ddlTarget.SelectedValue; gobjMenuLinkExtra.Url = txtUrl.Text; if (!String.IsNullOrWhiteSpace(txtChave.Text)) { gobjMenuLinkExtra.ChaveNome = txtChave.Text; } break; //Carregar Dados do Link case Utilitarios.TipoTransacao.Carregar: ddlNome.SelectedValue = gobjMenuLinkExtra.ID.ToString(); txtTexto.Text = gobjMenuLinkExtra.Nome; ddlIdioma.SelectedValue = gobjMenuLinkExtra.IdiomaId.ToString(); ddlTarget.SelectedValue = gobjMenuLinkExtra.Target; txtUrl.Text = gobjMenuLinkExtra.Url; txtChave.Text = gobjMenuLinkExtra.ChaveNome; break; } }
protected void ddlNome_SelectedIndexChanged(object sender, EventArgs e) { gobjMenuLinkExtra = DOMenuLinkExtra.Listar(Convert.ToInt32(ddlNome.SelectedValue)).FirstOrDefault(); CarregarObjetos(Utilitarios.TipoTransacao.Carregar); }