protected void grdDados_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "excluir") { try { lblMensagem.Text = string.Empty; DOModCaixa.ExcluirCaixa(Convert.ToInt32(e.CommandArgument)); LerDados(); } catch (Exception ex) { DOLog.Inserir(string.Concat("Erro Sistema: ", ex), Utilitarios.TipoLog.Sistema, (UserContext.Logado ? UserContext.UsuarioLogado.Id : 0)); lblMensagem.Text = String.Format(Resources.Modulos.Mensagem_Erro_Excluir, ex.Message); } } else if (e.CommandName == "editar") { try { lblMensagem.Text = string.Empty; codigo = Convert.ToInt32(e.CommandArgument); gobjMenuCircularHome = DOModMenuCircularHome.ObterMenuCircularHome(codigo); CarregarObjetos(Utilitarios.TipoTransacao.Carregar); } catch (Exception ex) { DOLog.Inserir(string.Concat("Erro Sistema: ", ex), Utilitarios.TipoLog.Sistema, (UserContext.Logado ? UserContext.UsuarioLogado.Id : 0)); lblMensagem.Text = String.Format(Resources.Modulos.Mensagem_Erro_Excluir, ex.Message); } } }
public static int AtualizarMenuCircularHome(MenuCircularHome pobjMenuCircularHome) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_U_MENU_CIRCULAR_HOME"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@menuCircularHomeId", SqlDbType.Int).Value = pobjMenuCircularHome.IdMenuCircularHome; objComando.Parameters.Add("@titulo", SqlDbType.VarChar, 200).Value = pobjMenuCircularHome.Titulo; objComando.Parameters.Add("@arquivo", SqlDbType.VarChar, 200).Value = pobjMenuCircularHome.Arquivo; if (!String.IsNullOrWhiteSpace(pobjMenuCircularHome.Target)) { objComando.Parameters.Add("@target", SqlDbType.VarChar, 20).Value = pobjMenuCircularHome.Target; } if (!String.IsNullOrWhiteSpace(pobjMenuCircularHome.Tooltip)) { objComando.Parameters.Add("@tooltip", SqlDbType.VarChar, 200).Value = pobjMenuCircularHome.Tooltip; } if (!String.IsNullOrWhiteSpace(pobjMenuCircularHome.Url)) { objComando.Parameters.Add("@url", SqlDbType.VarChar, 1000).Value = pobjMenuCircularHome.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 int InserirMenuCircularHome(MenuCircularHome pobjMenuCircularHome) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_I_MENU_CIRCULAR_HOME"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@titulo", SqlDbType.VarChar, 200).Value = pobjMenuCircularHome.Titulo; objComando.Parameters.Add("@arquivo", SqlDbType.VarChar, 200).Value = pobjMenuCircularHome.Arquivo; if (!String.IsNullOrWhiteSpace(pobjMenuCircularHome.Target)) { objComando.Parameters.Add("@target", SqlDbType.VarChar, 20).Value = pobjMenuCircularHome.Target; } if (!String.IsNullOrWhiteSpace(pobjMenuCircularHome.Tooltip)) { objComando.Parameters.Add("@tooltip", SqlDbType.VarChar, 200).Value = pobjMenuCircularHome.Tooltip; } objComando.Parameters.Add("@url", SqlDbType.VarChar, 1000).Value = pobjMenuCircularHome.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 List <MenuCircularHome> Listar(int pintId, int pintIdIdioma) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_L_MENU_CIRCULAR_HOME"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@conteudoId", SqlDbType.Int).Value = pintId; objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pintIdIdioma; try { //Abre Conexao objConexao.Open(); //Declara variavel de retorno List <MenuCircularHome> objList = new List <MenuCircularHome>(); MenuCircularHome obj = default(MenuCircularHome); IDataReader idrReader = default(IDataReader); idrReader = objComando.ExecuteReader(); while ((idrReader.Read())) { obj = new MenuCircularHome(); 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 rptMenuCircularHome_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { MenuCircularHome item = (MenuCircularHome)e.Item.DataItem; Image imgImagem = (Image)e.Item.FindControl("imgImagem"); imgImagem.ImageUrl = String.Format("{0}/{1}/{2}", ConfigurationManager.AppSettings["BradescoRI.Path.Imagens.ModMenuCircularHome"], this.Parent.ID.Replace("CTT_", string.Empty), item.Arquivo); if (!string.IsNullOrWhiteSpace(item.Tooltip)) { imgImagem.ToolTip = item.Tooltip; } } }
public static MenuCircularHome ObterMenuCircularHome(int pintIdMenuCircularHome) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_L_MENU_CIRCULAR_HOME_ID"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; objComando.Parameters.Add("@menuCircularHomeId", SqlDbType.Int).Value = pintIdMenuCircularHome; try { objConexao.Open(); MenuCircularHome obj = new MenuCircularHome(); 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(); } } }
private void CarregarObjetos(Utilitarios.TipoTransacao objTipoTransacao) { switch (objTipoTransacao) { case Utilitarios.TipoTransacao.Limpar: codigo = 0; divImagem.Visible = false; divUpload.Visible = true; lblMensagem.Text = string.Empty; ddlPaginas.SelectedIndex = 0; ddlTarget.SelectedIndex = 0; txtTitulo.Text = string.Empty; txtTooltip.Text = string.Empty; txtUrl.Text = string.Empty; break; case Utilitarios.TipoTransacao.Salvar: if (gobjMenuCircularHome == null) { gobjMenuCircularHome = new MenuCircularHome(); } gobjMenuCircularHome.IdMenuCircularHome = codigo; gobjMenuCircularHome.Titulo = txtTitulo.Text; gobjMenuCircularHome.Tooltip = txtTooltip.Text; gobjMenuCircularHome.Url = txtUrl.Text; if (ddlTarget.SelectedValue != "0") { gobjMenuCircularHome.Target = ddlTarget.SelectedValue; } if (fupArquivo.HasFile) { gobjMenuCircularHome.Arquivo = String.Format("{0}_{1}_{2}", IdConteudo, ddlIdioma.SelectedValue, fupArquivo.PostedFile.FileName); } break; case Utilitarios.TipoTransacao.Carregar: if (!String.IsNullOrWhiteSpace(gobjMenuCircularHome.Target)) { ddlTarget.SelectedValue = gobjMenuCircularHome.Target; } txtTitulo.Text = gobjMenuCircularHome.Titulo; txtTooltip.Text = gobjMenuCircularHome.Tooltip; txtUrl.Text = gobjMenuCircularHome.Url; if (String.IsNullOrWhiteSpace(gobjMenuCircularHome.Arquivo)) { divUpload.Visible = true; divImagem.Visible = false; } else { imgImagem.ImageUrl = String.Format("{0}/{1}/{2}", ConfigurationManager.AppSettings["BradescoRI.Path.Imagens.ModMenuCircularHome"], IdConteudo, gobjMenuCircularHome.Arquivo); divUpload.Visible = false; divImagem.Visible = true; } break; } }