private DataTable ConsultaUsuariosFiscalia() { try { LogicaNegocio Ln = new LogicaNegocio(); DataTable dt = new DataTable("dt"); dt = Ln.ListarUsuarios(null, 3, ""); return(dt); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "cartera", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(new DataTable()); } }
private bool CrearCarpetaEnRaiz(String nombreCarpeta) { try { //SPFolderCollection spfc = new SPFolderCollection(); SPWeb app = SPContext.Current.Web; SPList docList = app.Lists["Documentos"]; SPFolder newFolder = docList.RootFolder.SubFolders.Add(nombreCarpeta); return(true); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(false); } }
private void CargarEjecutivo() { cbxEjecutivo.Items.Clear(); try { LogicaNegocio Ln = new LogicaNegocio(); DataTable dt = new DataTable("dt"); dt = Ln.ListarUsuarios(null, 1, ""); util.CargaDDLDxx(cbxEjecutivo, dt, "nombreApellido", "idUsuario"); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } }
public byte[] GenerarReporte(string sp, Dictionary <string, string> datos, string id, Resumen objresumen) { System.Text.StringBuilder sDocumento = new System.Text.StringBuilder(); string html = string.Empty; LogicaNegocio Ln = new LogicaNegocio(); try { String xml = String.Empty; string descTipoTransaccion = System.Web.HttpUtility.HtmlDecode(Page.Request.QueryString["idTT"] as string); //IF PARA CADA REPORTE DataSet res1 = new DataSet(); if (sp == "PorFacturacion") { res1 = Ln.ConsultaDatosContabilidadXML(objresumen.idEmpresa.ToString(), objresumen.idOperacion.ToString(), objresumen.idUsuario, objresumen.descCargo, descTipoTransaccion); xml = res1.Tables[0].Rows[0][0].ToString();; //GenerarXMLContratoSubFianza(res1); } XDocument newTree = new XDocument(); XslCompiledTransform xsltt = new XslCompiledTransform(); using (XmlWriter writer = newTree.CreateWriter()) { xsltt.Load(@"C:/inetpub/wwwroot/wss/VirtualDirectories/80/xsl/request/" + sp + ".xslt"); } using (var sw = new StringWriter()) using (var sr = new StringReader(xml)) using (var xr = XmlReader.Create(sr)) { xsltt.Transform(xr, null, sw); html = sw.ToString(); } try { sDocumento.Append(html); return(util.ConvertirAPDF_Control(sDocumento)); } catch { } } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } return(null); }
public byte[] GenerarReporte(string sp, Dictionary <string, string> datos, string id) { LogicaNegocio MTO = new LogicaNegocio(); try { String xml = String.Empty; //IF PARA CADA REPORTE DataSet res1 = new DataSet(); if (sp == "Ficha_Comercial") { res1 = MTO.ConsultaFichaComercial(datos["IdEmpresa"], "ReportePosicionCliente"); for (int i = 0; i <= res1.Tables[0].Rows.Count - 1; i++) { xml = xml + res1.Tables[0].Rows[i][0].ToString(); } } XDocument newTree = new XDocument(); XslCompiledTransform xsltt = new XslCompiledTransform(); using (XmlWriter writer = newTree.CreateWriter()) { xsltt.Load(@"C:/inetpub/wwwroot/wss/VirtualDirectories/80/xsl/request/" + sp + ".xslt"); } using (var sw = new StringWriter()) using (var sr = new StringReader(xml)) using (var xr = XmlReader.Create(sr)) { xsltt.Transform(xr, null, sw); html = sw.ToString(); } try { sDocumento.Append(html); return(util.ConvertirAPDF_Control(sDocumento)); } catch { } } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } return(null); }
void llenargrid() { try { LogicaNegocio Ln = new LogicaNegocio(); DataTable res; res = Ln.ListarRendicionCliente("Keyla Sandoval"); Grid.DataSource = res; Grid.DataBind(); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); Page.Session["Error"] = ex.Source.ToString() + ": " + ex.Message.ToString(); Page.Response.Redirect("Mensaje.aspx"); } }
public Boolean InsertarActualizarPagoFacturacion(string idEmpresa, string idOperacion, string idUsuario, string cargoUser, string Comentario, string NroDocumentoPago, string idBanco, string descBanco, string fechaPago, string idTipoPago, string DescTipoPago, string DescTipoTransaccion) { try { Boolean dt; SqlParameter[] SqlParametros = new SqlParameter[13]; SqlParametros[0] = new SqlParameter("@idEmpresa", SqlDbType.NVarChar); SqlParametros[0].Value = idEmpresa; SqlParametros[1] = new SqlParameter("@idOperacion", SqlDbType.NVarChar); SqlParametros[1].Value = idOperacion; SqlParametros[2] = new SqlParameter("@idUsuario", SqlDbType.NVarChar); SqlParametros[2].Value = idUsuario; SqlParametros[3] = new SqlParameter("@descCargo", SqlDbType.NVarChar); SqlParametros[3].Value = cargoUser; SqlParametros[4] = new SqlParameter("@opcion", SqlDbType.NVarChar); SqlParametros[4].Value = "04"; SqlParametros[5] = new SqlParameter("@Comentario", SqlDbType.NVarChar); SqlParametros[5].Value = Comentario; SqlParametros[6] = new SqlParameter("@NroDocumentoPago", SqlDbType.NVarChar); SqlParametros[6].Value = NroDocumentoPago; SqlParametros[7] = new SqlParameter("@idBanco", SqlDbType.NVarChar); SqlParametros[7].Value = idBanco; SqlParametros[8] = new SqlParameter("@descBanco", SqlDbType.NVarChar); SqlParametros[8].Value = descBanco; SqlParametros[9] = new SqlParameter("@fechaPago", SqlDbType.NVarChar); SqlParametros[9].Value = fechaPago; SqlParametros[10] = new SqlParameter("@idTipoPago", SqlDbType.NVarChar); SqlParametros[10].Value = idTipoPago; SqlParametros[11] = new SqlParameter("@DescTipoPago", SqlDbType.NVarChar); SqlParametros[11].Value = DescTipoPago; SqlParametros[12] = new SqlParameter("@DescTipoTransaccion", SqlDbType.NVarChar); SqlParametros[12].Value = DescTipoTransaccion; dt = AD_Global.ejecutarAccion("GestionFacturacion", SqlParametros); return(dt); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(false); } }
public int CP_VerificarCertificado(string NroCertificado) { try { SqlParameter[] SqlParametros = new SqlParameter[1]; SqlParametros[0] = new SqlParameter("@NroCertificado", SqlDbType.NVarChar); SqlParametros[0].Value = NroCertificado; var resultado = AD_Global.traerPrimeraColumna("VerificarCertificado", SqlParametros); return(int.Parse(resultado)); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(-1); } }
private void CargarGrilla(string empresa, string rut, string certificado, string ejecutivo) { try { LogicaNegocio Ln = new LogicaNegocio(); DataTable dt = new DataTable("dtAdministracion"); dt = Ln.ListarAdministracionFondos(empresa, rut, certificado, ejecutivo); Page.Session["gvAdministracionFondos"] = dt; gvAdministracionFondos.DataSource = dt; gvAdministracionFondos.DataBind(); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } }
protected void btnAgregar_Click(object sender, EventArgs e) { try { asignacionResumen(ref objresumen); LogicaNegocio MTO = new LogicaNegocio(); MTO.GestionResponsableOperacion(objresumen.idOperacion, objresumen.idUsuario, objresumen.descCargo, "02"); guardarArchivo(); buscarArchivos(); validarCriticos(); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); mensajeError("Se ha producido un error al guardar el documento. Por favor validar que en nombre del archivo no contenga caracteres especiales."); } }
public byte[] GenerarReporte(int idEmpresa) { System.Text.StringBuilder sDocumento = new System.Text.StringBuilder(); string html = string.Empty; LogicaNegocio Ln = new LogicaNegocio(); try { String xml = String.Empty; DataSet res1 = new DataSet(); res1 = Ln.ConsultaReporteScoring(idEmpresa, "usuario", "perfil"); for (int i = 0; i < res1.Tables[0].Rows.Count; i++) { xml = xml + res1.Tables[0].Rows[i][0].ToString(); } XDocument newTree = new XDocument(); XslCompiledTransform xsltt = new XslCompiledTransform(); using (XmlWriter writer = newTree.CreateWriter()) { xsltt.Load(@"C:/inetpub/wwwroot/wss/VirtualDirectories/80/xsl/request/" + "Scoring" + ".xslt"); } using (var sw = new StringWriter()) using (var sr = new StringReader(xml)) using (var xr = XmlReader.Create(sr)) { xsltt.Transform(xr, null, sw); html = sw.ToString(); } try { sDocumento.Append(html); return(util.ConvertirAPDF_Control(sDocumento)); } catch { } } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } return(null); }
public DataTable GestionBitacoraPago(string xmlBitacora, string NroCertificado, int?IdMotivo, int?IdCausa, int?IdAcreedor, DateTime?FechaCobro, DateTime?FechaPago, string NroDocumento, int?Monto, string Comentario, int?IdBitacoraPago, string IdUsuario, string RazonSocial, int IdOpcion) { try { DataTable dt = new DataTable(); SqlParameter[] SqlParametros = new SqlParameter[14]; SqlParametros[0] = new SqlParameter("@xmlBitacora", SqlDbType.Xml); SqlParametros[0].Value = xmlBitacora; SqlParametros[1] = new SqlParameter("@NroCertificado", SqlDbType.NVarChar); SqlParametros[1].Value = NroCertificado; SqlParametros[2] = new SqlParameter("@IdMotivo", SqlDbType.Int); SqlParametros[2].Value = IdMotivo; SqlParametros[3] = new SqlParameter("@IdCausa", SqlDbType.Int); SqlParametros[3].Value = IdCausa; SqlParametros[4] = new SqlParameter("@IdAcreedor", SqlDbType.Int); SqlParametros[4].Value = IdAcreedor; SqlParametros[5] = new SqlParameter("@FechaCobro", SqlDbType.DateTime); SqlParametros[5].Value = FechaCobro; SqlParametros[6] = new SqlParameter("@FechaPago", SqlDbType.DateTime); SqlParametros[6].Value = FechaPago; SqlParametros[7] = new SqlParameter("@NroDocumento", SqlDbType.NVarChar); SqlParametros[7].Value = NroDocumento; SqlParametros[8] = new SqlParameter("@Monto", SqlDbType.Int); SqlParametros[8].Value = Monto; SqlParametros[9] = new SqlParameter("@Comentario", SqlDbType.NVarChar); SqlParametros[9].Value = Comentario; SqlParametros[10] = new SqlParameter("@IdBitacoraPago", SqlDbType.Int); SqlParametros[10].Value = IdBitacoraPago; SqlParametros[11] = new SqlParameter("@IdUsuario", SqlDbType.NVarChar); SqlParametros[11].Value = IdUsuario; SqlParametros[12] = new SqlParameter("@RazonSocial", SqlDbType.NVarChar); SqlParametros[12].Value = RazonSocial; SqlParametros[13] = new SqlParameter("@IdOpcion", SqlDbType.Int); SqlParametros[13].Value = IdOpcion; dt = AD_Global.ejecutarConsultas("GestionBitacoraPago", SqlParametros); return(dt); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(new DataTable()); } }
private void llenarGridCompromisos() { asignacionResumen(ref objresumen); LogicaNegocio Ln = new LogicaNegocio(); DataSet res; try { res = Ln.ListarCompromisos(objresumen.idOperacion.ToString()); //Cargar datos de form superior string razonSocial = res.Tables[1].Rows[0]["RazonSocial"].ToString(); string operacion = res.Tables[1].Rows[0]["Operacion"].ToString(); string ejecutivo = res.Tables[1].Rows[0]["Ejecutivo"].ToString(); string etapa = res.Tables[1].Rows[0]["Etapa"].ToString(); string canal = res.Tables[1].Rows[0]["Canal"].ToString(); string fondo = res.Tables[1].Rows[0]["Fondo"].ToString(); string montoOper = res.Tables[1].Rows[0]["MontoOperacion"].ToString(); string montoCom = res.Tables[1].Rows[0]["MontoComision"].ToString(); this.txtRazonSocial.Text = razonSocial; this.txtOperacion.Text = operacion; this.txtEjecutivo.Text = ejecutivo; this.txtEtapa.Text = etapa; this.txtFondo.Text = fondo; this.txtMontoOperacion.Text = montoOper; this.txtMontoComision.Text = montoCom; this.txtCanal.Text = canal; if (res.Tables[0].Rows.Count > 0) { ResultadosBusqueda.DataSource = res.Tables[0]; ResultadosBusqueda.DataBind(); } } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); Page.Session["Error"] = ex.Source.ToString() + ": " + ex.Message.ToString(); Page.Response.Redirect("Mensaje.aspx"); } }
public byte[] GenerarReporte(string sp, Dictionary <string, string> datos, string id, Resumen objresumen) { LogicaNegocio LN = new LogicaNegocio(); try { string xml = string.Empty; DataSet res1 = new DataSet(); if (sp == "Prepago") { res1 = LN.ConsultaReporteBDDevolucion(datos["IdEmpresa"], datos["IdOperacion"], datos["Ncertificado"], "DocumentoCurse", "admin", "ReporteDevoluciones"); xml = res1.Tables[0].Rows[0][0].ToString(); //GenerarXMLContratoSubFianza(res1); } XDocument newTree = new XDocument(); XslCompiledTransform xsltt = new XslCompiledTransform(); using (XmlWriter writer = newTree.CreateWriter()) { xsltt.Load(@"C:/inetpub/wwwroot/wss/VirtualDirectories/80/xsl/request/" + sp + ".xslt"); } using (var sw = new StringWriter()) using (var sr = new StringReader(xml)) using (var xr = XmlReader.Create(sr)) { xsltt.Transform(xr, null, sw); html = sw.ToString(); } try { sDocumento.Append(html); return(util.ConvertirAPDF_Control(sDocumento)); } catch { } } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } return(null); }
private void llenarGridComentarios() { asignacionResumen(ref objresumen); LogicaNegocio Ln = new LogicaNegocio(); DataTable res; try { res = Ln.ListarComentarios(objresumen.idOperacion.ToString()); ResultadosBusqueda.DataSource = res; ResultadosBusqueda.DataBind(); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); Page.Session["Error"] = ex.Source.ToString() + ": " + ex.Message.ToString(); Page.Response.Redirect("Mensaje.aspx"); } }
public DataTable ListarCausas() { try { DataTable dt = new DataTable(); SqlParameter[] SqlParametros = new SqlParameter[0]; //SqlParametros[0] = new SqlParameter("@opcion", SqlDbType.NChar); //SqlParametros[0].Value = Constantes.OPCION.LISTAGENERAL; dt = AD_Global.ejecutarConsultas("ListarCausas", SqlParametros); return(dt); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(new DataTable()); } }
protected DataTable ServiciosGarantia(string Tipo) { try { SPWeb app = SPContext.Current.Web; app.AllowUnsafeUpdates = true; SPList items = app.Lists["ServiciosGarantia"]; SPQuery query = new SPQuery(); query.Query = "<Where><And><Eq><FieldRef Name='Habilitado'/><Value Type='Boolean'>1</Value></Eq><Eq><FieldRef Name='Tipo'/><Value Type='TEXT'>" + Tipo + "</Value></Eq></And></Where>" + "<OrderBy><FieldRef Name='Nombre' Ascending='TRUE' /></OrderBy>"; SPListItemCollection collListItems = items.GetItems(query); return(collListItems.GetDataTable()); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(new DataTable()); } }
private DataTable ActividadEconomica() { try { SPWeb app = SPContext.Current.Web; app.AllowUnsafeUpdates = true; app = SPContext.Current.Web; app.AllowUnsafeUpdates = true; SPList listData = app.Lists["ActividadEconomica"]; SPListItemCollection collListItems = listData.GetItems(); return(collListItems.GetDataTable()); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(new DataTable()); } }
public DataTable ListarRendicionCliente(string Usuario) { try { DataTable dt = new DataTable(); //AD_Global objDatos = new AD_Global(); SqlParameter[] SqlParametros = new SqlParameter[1]; SqlParametros[0] = new SqlParameter("@usuario", SqlDbType.NChar); SqlParametros[0].Value = Usuario; dt = AD_Global.ejecutarConsultas("BuscarRendicionesUsuario", SqlParametros); return(dt); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(new DataTable()); } }
private void CargarEjecutivo(string cargo, string nombreUsuario) { try { LogicaNegocio Ln = new LogicaNegocio(); cbxEjecutivo.Items.Clear(); DataTable dt = new DataTable("dt"); if (cargo == "Sub-Gerente Comercial") { dt = Ln.ListarUsuarios(null, null, nombreUsuario); } else { dt = Ln.ListarUsuarios(null, 1, ""); } util.CargaDDLDxx(cbxEjecutivo, dt, "nombreApellido", "idUsuario"); if (cargo == "Sub-Gerente Comercial") { ListEditItem TipoEjecutivo = cbxEjecutivo.Items.FindByText(nombreUsuario); if (TipoEjecutivo != null) { cbxEjecutivo.Text = nombreUsuario; cbxEjecutivo.ReadOnly = true; } } else { ListEditItem TipoEjecutivo = cbxEjecutivo.Items.FindByText(nombreUsuario); if (TipoEjecutivo != null) { cbxEjecutivo.Text = nombreUsuario; cbxEjecutivo.ReadOnly = false; } } } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } }
protected void gvAcreedores_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { SPWeb app2 = SPContext.Current.Web; bool crear = false; LogicaNegocio LN = new LogicaNegocio(); crear = LN.Acreedores(3, e.NewValues["Rut"].ToString(), 0, e.NewValues["Nombre"].ToString(), e.NewValues["Domicilio"].ToString(), Convert.ToInt32(e.NewValues["IdTipoAcreedor"]), Convert.ToInt32(e.NewValues["IdRegion"]), Convert.ToInt32(e.NewValues["Idprovincia"]), Convert.ToInt32(e.NewValues["IdComuna"]), util.ObtenerValor(app2.CurrentUser.Name)); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } gvAcreedores.CancelEdit(); e.Cancel = true; CargarAcreedores(txtAcreedor.Text.Trim(), txtRutAcreedor.Text.Trim()); }
public DataTable ConsultarOperacion(int IdOperacion) { try { DataTable dt = new DataTable(); SqlParameter[] SqlParametros = new SqlParameter[2]; SqlParametros[0] = new SqlParameter("@idOperacion", SqlDbType.Int); SqlParametros[0].Value = IdOperacion; SqlParametros[1] = new SqlParameter("@accion", SqlDbType.Int); SqlParametros[1].Value = 6; dt = AD_Global.ejecutarConsultas("GestionOperaciones", SqlParametros); return(dt); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); return(new DataTable()); } }
protected void btnAdjuntar_Click1(object sender, EventArgs e) { try { asignacionResumen(ref objresumen); String carpetaEmpresa = util.RemoverSignosAcentos(System.Web.HttpUtility.HtmlDecode(lbEmpresa.Text)); carpetaEmpresa = carpetaEmpresa.Length > 100 ? carpetaEmpresa.Substring(0, 100) : carpetaEmpresa; carpetaEmpresa = lbRut.Text.Split('-')[0] + "_" + carpetaEmpresa; String carpetaArea = objresumen.area.ToUpper(); String idOperacion = objresumen.idOperacion.ToString(); cargarDocumento(carpetaEmpresa, carpetaArea, idOperacion); Page.Session["Resumen"] = objresumen; Page.Session["BUSQUEDA"] = ViewState["BUSQUEDA"]; Page.Response.Redirect("DocumentoCurse.aspx"); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { try { lblTitulo.Text = "Advertencia"; //"oListItem["Titulo"].ToString(); ; lblMensaje.Text = "No se pudo culminar su solicitud, por favor comuniquese con el administrador del sistema. Detalle: "; if (Page.Session["Error"] != null) { lblMensaje.Text = lblMensaje.Text + Page.Session["Error"].ToString(); } } catch (Exception ex) { lblTitulo.Text = "Error"; lblMensaje.Text = ex.Source.ToString() + ex.Message.ToString(); LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } } }
protected void gvBitacora_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { LogicaNegocio Ln = new LogicaNegocio(); SPWeb app2 = SPContext.Current.Web; bool ingresar = false; //ingresar = Ln.Gestion_BitacoraPago(null, e.NewValues["NCF"].ToString(), int.Parse(e.NewValues["IdMotivo"].ToString()), int.Parse(e.NewValues["IdCausa"].ToString()), 0, Convert.ToDateTime(e.NewValues["FechaCobro"]), Convert.ToDateTime(e.NewValues["FechaPago"].ToString()), e.NewValues["NroDocumento"].ToString(), int.Parse(e.NewValues["Monto"].ToString()), e.NewValues["Comentario"].ToString(), null, util.ObtenerValor(app2.CurrentUser.Name), 3); ingresar = Ln.Gestion_BitacoraPago(null, e.NewValues["NCF"].ToString(), int.Parse(e.NewValues["IdMotivo"].ToString()), int.Parse(e.NewValues["IdCausa"].ToString()), int.Parse(e.NewValues["IdBanco"].ToString()), Convert.ToDateTime(e.NewValues["FechaCobro"]), Convert.ToDateTime(e.NewValues["FechaPago"].ToString()), e.NewValues["NroDocumento"].ToString(), int.Parse(e.NewValues["Monto"].ToString()), e.NewValues["Cuota"].ToString(), int.Parse(e.NewValues["IdAcreedor"].ToString()), e.NewValues["Comentario"].ToString(), null, util.ObtenerValor(app2.CurrentUser.Name), 3); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } gvBitacora.CancelEdit(); e.Cancel = true; string[] parametros = new string[] { "buscar", txtCertificado.Text.Trim(), txtRazonSocial.Text.Trim() }; CargarBitacora(parametros); }
protected void inicializacionGrillas() { asignacionResumen(ref objresumen); try { if (ViewState["ServiciosEmpresa"] != null) { tbServiciosOperaciones1.DataSource = (DataTable)ViewState["ServiciosEmpresa"];; tbServiciosOperaciones1.DataBind(); } if (ViewState["ServiciosGarantia"] != null) { tbServiciosGarantia1.DataSource = (DataTable)ViewState["ServiciosGarantia"];; tbServiciosGarantia1.DataBind(); } if (ViewState["ServicioFiscalia"] != null) { DataTable dt1 = new DataTable(); dt1 = (DataTable)ViewState["ServicioFiscalia"]; for (int i = 0; i <= gridFiscalia.Rows.Count - 1; i++) { dt1.Rows[i]["Valor"] = System.Web.HttpUtility.HtmlDecode((gridFiscalia.Rows[i].FindControl("txtValor") as TextBox).Text); } ViewState["ServicioFiscalia"] = dt1; dt1 = null; gridFiscalia.DataSource = (DataTable)ViewState["ServicioFiscalia"]; gridFiscalia.DataBind(); } } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } }
private void CargarGrilla() { LogicaNegocio MTO = new LogicaNegocio(); DataTable res; try { string mes = (ddlMes.SelectedItem != null) ? (ddlMes.SelectedItem.Text.ToLower().Contains("seleccione")) ? "" : ddlMes.SelectedItem.Text : ""; string etapa = (ddlEtapa.SelectedItem != null) ? (ddlEtapa.SelectedItem.Text.ToLower().Contains("seleccione")) ? "" : ddlEtapa.SelectedItem.Text : ""; string ejecutivo = (ddlEjecutivo.SelectedItem != null) ? (ddlEjecutivo.SelectedItem.Text.ToLower().Contains("seleccione")) ? "" : ddlEjecutivo.SelectedItem.Text : ""; string empresa = txtRazonSocial.Text; string canal = (ddlCanal.SelectedItem != null) ? (ddlCanal.SelectedItem.Text.ToLower().Contains("seleccione")) ? "" : ddlCanal.SelectedItem.Text : ""; string fondo = (ddlFondo.SelectedItem != null) ? (ddlFondo.SelectedItem.Text.ToLower().Contains("seleccione")) ? "" : ddlFondo.SelectedItem.Text : ""; if (string.IsNullOrEmpty(mes) && string.IsNullOrEmpty(etapa) && string.IsNullOrEmpty(ejecutivo) && string.IsNullOrEmpty(empresa) && string.IsNullOrEmpty(canal) && string.IsNullOrEmpty(fondo)) { aplicaFiltros = false; } else { aplicaFiltros = true; } res = MTO.ListarSeguimientoCompromisos(mes, etapa, ejecutivo, empresa, canal, fondo); ResultadosBusqueda.DataSource = res; //Page.Session["tabla"] = res; ResultadosBusqueda.DataBind(); } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); Page.Session["Error"] = ex.Source.ToString() + ": " + ex.Message.ToString(); Page.Response.Redirect("Mensaje.aspx"); } }
private void CargarEjecutivo(string cargo, string nombre) { ddlEjecutivo.Items.Clear(); try { LogicaNegocio Ln = new LogicaNegocio(); DataTable dt = new DataTable("dt"); dt = Ln.ListarUsuarios(null, 1, ""); util.CargaDDL(ddlEjecutivo, dt, "nombreApellido", "idUsuario"); if (cargo == "Sub-Gerente Comercial") { ddlEjecutivo.SelectedIndex = ddlEjecutivo.Items.IndexOf(ddlEjecutivo.Items.FindByText(nombre.Trim())); ddlEjecutivo.Enabled = false; //if (ddlEjecutivo != null) //{ // ddlEjecutivo.Text = nombre; // ddlEjecutivo. = true; //} } //else //{ // ListEditItem TipoEjecutivo = ddlEjecutivo.Items.FindByText(nombre); // if (TipoEjecutivo != null) // { // ddlEjecutivo.Text = nombre; // ddlEjecutivo.ReadOnly = true; // } //} } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); } }
public List <LoggingError> getLogErrorToday(string start_date, string end_date) { List <LoggingError> lst_log_error = new List <LoggingError>(); TeraManager tmm = new TeraManager(); DataTable dt = new DataTable(); try { string strQuery = string.Empty; strQuery = " select CAST(CAST(update_ts AS TIMESTAMP(6)) AS VARCHAR(19)) as update_ts "; strQuery += " ,stream_key ,process_name ,auto_analyze_log ,sys_log "; strQuery += " FROM DATALAB_OPER.PSS_TODAY_ERROR_LOG "; strQuery += " where CAST(CAST(update_ts AS date FORMAT 'YYYY-MM-DD') AS VARCHAR(10)) between '" + start_date + "' and "; strQuery += " '" + end_date + "' "; strQuery += " order by update_ts desc "; dt = tmm.GetDataTableTera(strQuery); LoggingError logError; for (int i = 0; i < dt.Rows.Count; i++) { logError = new LoggingError(); logError.Update_ts = dt.Rows[i]["update_ts"].ToString(); logError.Stream_key = dt.Rows[i]["stream_key"].ToString(); logError.Process_name = dt.Rows[i]["process_name"].ToString(); logError.Auto_analyze_log = dt.Rows[i]["auto_analyze_log"].ToString(); logError.Sys_log = dt.Rows[i]["sys_log"].ToString(); lst_log_error.Add(logError); } } catch (Exception e) { System.Console.WriteLine(e.Message.ToString()); } return(lst_log_error); }
public string buscarMensaje(int idmensaje) { string mensaje = string.Empty; try { SPWeb app = SPContext.Current.Web; SPList Lista = app.Lists["Mensajes"]; SPQuery oQuery = new SPQuery(); oQuery.Query = "<Where><Eq><FieldRef Name='ID'/><Value Type='TEXT'>" + idmensaje + "</Value></Eq></Where>"; SPListItemCollection ColecLista = Lista.GetItems(oQuery); foreach (SPListItem oListItem in ColecLista) { mensaje = (oListItem["Mensaje"].ToString()); } } catch (Exception ex) { LoggingError.PostEventRegister(ex, ConfigurationManager.AppSettings["pathLog"].ToString(), "", "", ConfigurationManager.AppSettings["logName"].ToString(), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledLog"].ToString()), Convert.ToBoolean(ConfigurationManager.AppSettings["enabledEventViewer"].ToString()), ConfigurationManager.AppSettings["registerEventsTypes"].ToString(), EventLogEntryType.Error); mensaje = ex.Source.ToString() + ex.Message.ToString(); } return(mensaje.Replace("<p>", "")); }