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