public static int InserirMenuCircular(MenuCircular pobjMenuCircular) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_I_MENU_CIRCULAR"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@grupoId", SqlDbType.Int).Value = pobjMenuCircular.IdGrupo; objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pobjMenuCircular.IdIdioma; objComando.Parameters.Add("@titulo", SqlDbType.VarChar, 200).Value = pobjMenuCircular.Titulo; if (!String.IsNullOrWhiteSpace(pobjMenuCircular.Target)) { objComando.Parameters.Add("@target", SqlDbType.VarChar, 20).Value = pobjMenuCircular.Target; } if (!String.IsNullOrWhiteSpace(pobjMenuCircular.Tooltip)) { objComando.Parameters.Add("@tooltip", SqlDbType.VarChar, 200).Value = pobjMenuCircular.Tooltip; } if (!String.IsNullOrWhiteSpace(pobjMenuCircular.Url)) { objComando.Parameters.Add("@url", SqlDbType.VarChar, 1000).Value = pobjMenuCircular.Url; } try { //Abre conexão com o banco de dados objConexao.Open(); IDataReader idrReader = objComando.ExecuteReader(); if (idrReader.Read()) { return(Convert.ToInt32(idrReader["Identity"])); } else { return(-1); } } catch (Exception ex) { throw ex; } finally { //Fecha a conexao se aberta if (objConexao.State != ConnectionState.Closed) { objConexao.Close(); } } }
public static int AtualizarMenuCircular(MenuCircular pobjMenuCircular) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_U_MENU_CIRCULAR"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@menuCircularId", SqlDbType.Int).Value = pobjMenuCircular.IdMenuCircular; objComando.Parameters.Add("@grupoId", SqlDbType.Int).Value = pobjMenuCircular.IdGrupo; objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pobjMenuCircular.IdIdioma; objComando.Parameters.Add("@titulo", SqlDbType.VarChar, 200).Value = pobjMenuCircular.Titulo; objComando.Parameters.Add("@arquivo", SqlDbType.VarChar, 200).Value = pobjMenuCircular.Arquivo; if (!String.IsNullOrWhiteSpace(pobjMenuCircular.Target)) { objComando.Parameters.Add("@target", SqlDbType.VarChar, 20).Value = pobjMenuCircular.Target; } if (!String.IsNullOrWhiteSpace(pobjMenuCircular.Tooltip)) { objComando.Parameters.Add("@tooltip", SqlDbType.VarChar, 200).Value = pobjMenuCircular.Tooltip; } if (!String.IsNullOrWhiteSpace(pobjMenuCircular.Url)) { objComando.Parameters.Add("@url", SqlDbType.VarChar, 1000).Value = pobjMenuCircular.Url; } 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(); } } }
public static List <MenuCircular> ListarMenuCircular(int pintIdGrupo, int pintIdIdioma = 0) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_L_MENU_CIRCULAR"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@grupoId", SqlDbType.Int).Value = pintIdGrupo; if (pintIdIdioma > 0) { objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pintIdIdioma; } try { //Abre Conexao objConexao.Open(); //Declara variavel de retorno List <MenuCircular> objList = new List <MenuCircular>(); MenuCircular obj = default(MenuCircular); IDataReader idrReader = default(IDataReader); idrReader = objComando.ExecuteReader(); while ((idrReader.Read())) { obj = new MenuCircular(); 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(); } } }
protected void rptMenuCircular_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { MenuCircular item = (MenuCircular)e.Item.DataItem; Image imgImagem = (Image)e.Item.FindControl("imgImagem"); imgImagem.ImageUrl = String.Format("{0}/{1}/{2}", ConfigurationManager.AppSettings["BradescoRI.Path.Imagens.ModMenuCircular"], item.IdMenuCircular, item.Arquivo); if (!string.IsNullOrWhiteSpace(item.Tooltip)) { imgImagem.ToolTip = item.Tooltip; } } }
public static MenuCircular ObterMenuCircular(int pintIdMenuCircular, int pintIdGrupo, int pintIdIdioma) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_L_MENU_CIRCULAR_ID"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; objComando.Parameters.Add("@menuCircularId", SqlDbType.Int).Value = pintIdMenuCircular; objComando.Parameters.Add("@grupoId", SqlDbType.Int).Value = pintIdGrupo; objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pintIdIdioma; try { objConexao.Open(); MenuCircular obj = new MenuCircular(); IDataReader idrReader = default(IDataReader); idrReader = objComando.ExecuteReader(); while ((idrReader.Read())) { obj.FromIDataReader(idrReader); } return(obj); } catch (Exception ex) { throw ex; } finally { //Fecha a conexao se aberta if (objConexao.State != ConnectionState.Closed) { objConexao.Close(); } } }
public static int InserirArquivo(MenuCircular pobjMenuCircular) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_I_MENU_CIRCULAR_ARQUIVO"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@menuCircularId", SqlDbType.Int).Value = pobjMenuCircular.IdMenuCircular; objComando.Parameters.Add("@grupoId", SqlDbType.Int).Value = pobjMenuCircular.IdGrupo; objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pobjMenuCircular.IdIdioma; objComando.Parameters.Add("@arquivo", SqlDbType.VarChar, 200).Value = pobjMenuCircular.Arquivo; 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(); } } }
private void CarregarObjetos(Utilitarios.TipoTransacao objTipoTransacao) { switch (objTipoTransacao) { case Utilitarios.TipoTransacao.Limpar: ddlIdioma.SelectedIndex = 0; ddlPaginas.SelectedIndex = 0; ddlTarget.SelectedIndex = 0; txtTitulo.Text = string.Empty; txtTooltip.Text = string.Empty; txtUrl.Text = string.Empty; break; case Utilitarios.TipoTransacao.Salvar: if (gobjMenuCircular == null) { gobjMenuCircular = new MenuCircular(); } gobjMenuCircular.IdMenuCircular = codigo; gobjMenuCircular.IdGrupo = grupo; gobjMenuCircular.Titulo = txtTitulo.Text; gobjMenuCircular.IdIdioma = Convert.ToInt32(ddlIdioma.SelectedValue); if (ddlTarget.SelectedValue != "0") { gobjMenuCircular.Target = ddlTarget.SelectedValue; } gobjMenuCircular.Tooltip = txtTooltip.Text; gobjMenuCircular.Url = txtUrl.Text; if (codigo > 0 && divUpload.Visible) { gobjMenuCircular.Arquivo = String.Format("{0}_{1}_{2}_{3}", codigo, grupo, ddlIdioma.SelectedValue, fupArquivo.PostedFile.FileName); } break; case Utilitarios.TipoTransacao.Carregar: ddlIdioma.SelectedValue = gobjMenuCircular.IdIdioma.ToString(); ddlIdioma.Enabled = false; if (!String.IsNullOrWhiteSpace(gobjMenuCircular.Target)) { ddlTarget.SelectedValue = gobjMenuCircular.Target; } txtTitulo.Text = gobjMenuCircular.Titulo; txtTooltip.Text = gobjMenuCircular.Tooltip; txtUrl.Text = gobjMenuCircular.Url; if (String.IsNullOrWhiteSpace(gobjMenuCircular.Arquivo)) { divUpload.Visible = true; divImagem.Visible = false; } else { imgImagem.ImageUrl = String.Format("{0}/{1}/{2}", ConfigurationManager.AppSettings["BradescoRI.Path.Imagens.ModMenuCircular"], gobjMenuCircular.IdMenuCircular, gobjMenuCircular.Arquivo); divUpload.Visible = false; divImagem.Visible = true; } break; } }