protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var modal = Request.QueryString.Get("modal"); bool isModal = !string.IsNullOrEmpty(modal) && modal.Equals("true"); (Master as SiteMaster).BackgroundContent(isModal); } string idArc = Request.QueryString.Get("Mensaje"); BasesDatos DB = new BasesDatos(""); DbDataReader DR; string mensaje = ""; string mensajeTecnico = ""; DB = new BasesDatos((Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE")); DB.Conectar(); DB.CrearComando(@"select mensaje, MensajeTecnico from Log_Archivos where id_Archivo = @id_Archivo"); DB.AsignarParametroCadena("@id_Archivo", idArc); DR = DB.EjecutarConsulta(); while (DR.Read()) { mensaje = DR[0].ToString().Trim(); mensajeTecnico = DR[1].ToString().Trim(); } DB.Desconectar(); tbMensaje.Text = mensaje; tbMensajeTecnico.Text = mensajeTecnico; }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { if (Session["errorTimbres"] != null && Convert.ToBoolean(Session["errorTimbres"])) { Response.Redirect("~/CantidadTimbres.aspx", true); return; } else if (Session["errorCertificado"] != null && Convert.ToBoolean(Session["errorCertificado"])) { Response.Redirect("~/LicExpirada.aspx", true); return; } _dbe = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); _dbr = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE", "Recepcion"); _log = new Control.Log(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); if (Session["idUser"] != null) { SqlDataTiposProveedor.ConnectionString = _dbr.CadenaConexion; SqlDataSourceTProveedor.ConnectionString = _dbr.CadenaConexion; SqlDataSourceGValidation.ConnectionString = _dbr.CadenaConexion; SqlDataSourceGroupValidate.ConnectionString = _dbr.CadenaConexion; SqlDataSourceEstructura.ConnectionString = _dbr.CadenaConexion; _idUser = Session["idUser"].ToString(); } } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { if (Session["errorTimbres"] != null && Convert.ToBoolean(Session["errorTimbres"])) { Response.Redirect("~/CantidadTimbres.aspx", true); return; } else if (Session["errorCertificado"] != null && Convert.ToBoolean(Session["errorCertificado"])) { Response.Redirect("~/LicExpirada.aspx", true); return; } _db = new BasesDatos(Session["IDENTEMI"].ToString()); _log = new Log(Session["IDENTEMI"].ToString()); if (Session["idUser"] != null) { _idUser = Session["idUser"].ToString(); if (!Page.IsPostBack) { Session["_bytesCargados"] = null; Session["_dtFacturas"] = null; } } } else { Response.Redirect("~/Cerrar.aspx"); } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { _dbe = new BasesDatos(Session["IDENTEMI"].ToString()); SqlDataRFC.ConnectionString = _dbe.CadenaConexion; SqlDataSourceRfc.ConnectionString = _dbe.CadenaConexion; if (Session["IDENTEMI"] != null) { if (Session["errorTimbres"] != null && Convert.ToBoolean(Session["errorTimbres"])) { Response.Redirect("~/CantidadTimbres.aspx", true); return; } else if (Session["errorCertificado"] != null && Convert.ToBoolean(Session["errorCertificado"])) { Response.Redirect("~/LicExpirada.aspx", true); return; } _dbe = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); _dbr = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE", "Recepcion"); _log = new Log(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); if (Session["idUser"] != null) { _idUser = Session["idUser"].ToString(); } } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { _db = new BasesDatos(Session["IDENTEMI"].ToString()); _log = new Log(Session["IDENTEMI"].ToString()); SqlDataCertificados.ConnectionString = _db.CadenaConexion; SqlDataCertificados.SelectCommand = queryCertificados + (Session["idUser"].ToString().Equals("1") ? "" : " WHERE c.invisible = 'False'"); if (Session["idUser"] != null) { _idUser = Session["idUser"].ToString(); } } if (!IsPostBack) { _postedCer = null; _postedCer = null; _idEditar = null; var sql = @"SELECT dircertificados, dirllaves FROM Par_ParametrosSistema"; _db.Conectar(); _db.CrearComando(sql); var dr = _db.EjecutarConsulta(); while (dr.Read()) { _rutaCertificados = dr["dircertificados"].ToString(); _rutaLlaves = dr["dirllaves"].ToString(); } _db.Desconectar(); } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); SqlDataSourcePtoEmi.ConnectionString = _db.CadenaConexion; SqlDataSourceTipDoc.ConnectionString = _db.CadenaConexion; SqlDataSourceEmisor.ConnectionString = _db.CadenaConexion; SqlDataSourceReceptor.ConnectionString = _db.CadenaConexion; SqlDataSourceRepTickets.ConnectionString = _db.CadenaConexion; if (Session["idUser"] != null) { if (!IsPostBack) { ddlTipDoc.DataBind(); if (Session["IDGIRO"] != null) { if (Session["IDGIRO"].ToString().Contains("1")) { #region Hotel var toRemove = from i in ddlTipDoc.Items.Cast <ListItem>() where (!i.Value.Equals("01") && !i.Value.Equals("04") && !i.Value.Equals("0")) select i; var lista = toRemove.ToList(); foreach (var item in lista) { ddlTipDoc.Items.Remove(item); } #endregion } } } } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); SqlDataSource3.ConnectionString = _db.CadenaConexion; SqlDataTipo.ConnectionString = _db.CadenaConexion; SqlDataImpuesto.ConnectionString = _db.CadenaConexion; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var modal = Request.QueryString.Get("modal"); bool isModal = !string.IsNullOrEmpty(modal) && modal.Equals("true"); (Master as SiteMaster).BackgroundContent(isModal); } string file = Request.QueryString.Get("Trama"); BasesDatos DB = new BasesDatos(""); DbDataReader DR; string trama = ""; DB = new BasesDatos((Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE")); DB.Conectar(); DB.CrearComando(@"select trama from Log_Archivos where id_Archivo = @id_Archivo"); DB.AsignarParametroCadena("@id_Archivo", file); DR = DB.EjecutarConsulta(); while (DR.Read()) { trama = DR[0].ToString().Trim(); } DB.Desconectar(); trama = trama.Replace("/r", "\r"); trama = trama.Replace("/n", "\n"); tbTrama.Text = trama; }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] == null) { Response.Redirect("~/Cerrar.aspx", true); return; } if (!Page.IsPostBack) { _db = new BasesDatos(Session["IDENTEMI"].ToString()); _db.Conectar(); _db.CrearComando("SELECT DISTINCT TOP 1 servidorSMTP,puertoSMTP,sslSMTP,userSMTP,passSMTP,emailEnvio,emailNotificacion,emailOpera,emailRecepcion,emailFmensual,emailBcc,emailAltaUsers,emailRecepBcc FROM Par_ParametrosSistema"); var dr = _db.EjecutarConsulta(); if (dr.Read()) { tbServidor.Text = dr["servidorSMTP"].ToString(); tbPuerto.Text = dr["puertoSMTP"].ToString(); cbSSL.Checked = Convert.ToBoolean(dr["sslSMTP"]); tbUsuario.Text = dr["userSMTP"].ToString(); tbPassword.Text = dr["passSMTP"].ToString(); tbEmailEnvio.Text = dr["emailEnvio"].ToString(); tbEmailNotificacion.Text = dr["emailNotificacion"].ToString(); tbEmailOpera.Text = dr["emailOpera"].ToString(); tbEmailRecepcion.Text = dr["emailRecepcion"].ToString(); tbEmailFolios.Text = dr["emailFmensual"].ToString(); tbBcc.Text = dr["emailBcc"].ToString(); tbEmailUsers.Text = dr["emailAltaUsers"].ToString(); tbEmailRecepBcc.Text = dr["emailRecepBcc"].ToString(); } _db.Desconectar(); } }
private void GuardarBd() { BasesDatos bd = null; var fueExistosa = Status == 3 && !string.IsNullOrEmpty(IdFactura); try { if (fueExistosa) { bd = new BasesDatos(); bd.Conectar(); bd.CrearComando(@"UPDATE RetencionFactura SET estado = @estado WHERE idRetencion = @ID"); bd.AsignarParametroEntero("@estado", Status); bd.AsignarParametroCadena("@ID", IdFactura); bd.EjecutarConsulta1(); } } catch { // ignored } finally { if (bd != null) { bd.Desconectar(); } } }
/// <summary> /// Inicia las validaciones /// </summary> public Validations() { _db = new BasesDatos(); _failRecords = new List <KeyValuePair <OracleRecord, string> >(); _dbRecords = new Dictionary <string, List <string> >(); _reporte = new OutputInterface(); GetDataFromDataBase(); }
/// <summary> /// Inicializa el Timbrado con los valores que se van a agregar en la base de datos /// </summary> /// <param name="db"></param> /// <param name="serie">Serie del emisor</param> /// <param name="rfcEmisor">RFC del emisor</param> /// <param name="rfcReceptor">RFC del receptor</param> public Timbrado(BasesDatos db, string serie, string rfcEmisor, string rfcReceptor) { _db = db; _serie = serie; _rfcEmisor = rfcEmisor; _rfcReceptor = rfcReceptor; Log("Se inicializo con serie=" + serie + ",rfcEmisor=" + _rfcEmisor + ",rfcReceptor=" + _rfcReceptor); }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); SqlDataTramas.ConnectionString = _db.CadenaConexion; SqlDataTipoTramas.ConnectionString = _db.CadenaConexion; if (!IsPostBack) { Buscar(); } }
/// <summary> /// / /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GenerarReporte_Click(object sender, EventArgs e) { var Reporte = new FacturaGlobalWeb.FacturaGlobalWeb(); _fechacreacion = Localization.Now.ToString("yyyyMMddHHmmss"); Ex = null; _db = new BasesDatos((Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE")); var _connectionString = _db.CadenaConexion.ToString(); if (string.IsNullOrEmpty(tbsucursal.Text)) { (Master as SiteMaster).MostrarAlerta(this, "Inserte la serie de la sucursal", 4, null); return; } if (!string.IsNullOrEmpty(tbFecha.Text) || !string.IsNullOrEmpty(FechaFin.Text) || !string.IsNullOrEmpty(tbsucursal.Text)) { var where = ""; var sql = @"SELECT Trama from log_trama"; var fechain = tbFecha.Text + "-" + FechaFin.Text; if (!string.IsNullOrEmpty(tbsucursal.Text)) { where += (!string.IsNullOrEmpty(where) ? " AND " : " WHERE ") + "serie = " + "'" + tbsucursal.Text + "'"; } where += (!string.IsNullOrEmpty(where) ? " AND " : " WHERE ") + " Trama like '%" + fechain.ToString() + "%'" + " AND " + " observaciones = " + "'ExtranetOK'" + " AND " + "tipo= " + "4"; _db.Conectar(); _db.CrearComando(sql + where); var dr = _db.EjecutarConsulta(); var val = new List <string[]>(); while (dr.Read()) { string[] valor = new string[3]; valor[0] = dr[0].ToString(); val.Add(valor); } _db.Desconectar(); var directorio = AppDomain.CurrentDomain.BaseDirectory; var rfc = Session["IDENTEMI"].ToString(); var cfdi = Session["CfdiVersion"].ToString(); if (val.Count > 0) { new System.Threading.Thread(() => { Reporte.GenerarReporteAsync(tbFecha.Text, FechaFin.Text, tbsucursal.Text, rfc.ToString(), cfdi, directorio); }).Start(); } else { (Master as SiteMaster).MostrarAlerta(this, "No se encontraron registros", 4, null); return; } gvFacGlobWeb.DataBind(); (Master as SiteMaster).MostrarAlerta(this, "El reporte se está generando, favor de actualizar los registros nuevamente en unos minutos", 4); } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); SqlDataSource1.ConnectionString = _db.CadenaConexion; } if (!Page.IsPostBack) { } }
//private Boolean bcrearCliente; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var modal = Request.QueryString.Get("modal"); bool isModal = !string.IsNullOrEmpty(modal) && modal.Equals("true"); (Master as SiteMaster).BackgroundContent(isModal); } if (Session["IDENTEMI"] != null) { DB = new BasesDatos((Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE")); } //log = new Log((Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE")); if (!Page.IsPostBack) { if (Session["idUser"] != null) { idRol = Request.QueryString.Get("id"); DB.Conectar(); DB.CrearComandoProcedimiento("PA_consulta_rol"); DB.AsignarParametroProcedimiento("@idRol", System.Data.DbType.String, idRol); DbDataReader DR = DB.EjecutarConsulta(); if (DR.Read()) { tbRol.Text = DR[1].ToString(); cbConsultarPropia.Checked = Convert.ToBoolean(DR[2].ToString()); cbConsultarTodas.Checked = Convert.ToBoolean(DR[3].ToString()); tbComprobantes.Text = Convert.ToString(DR[4].ToString()); tbComprobantesCNS.Text = Convert.ToString(DR[5].ToString()); cbConsultarPropiaPtoEmi.Checked = Convert.ToBoolean(DR[6].ToString()); cbEditComp.Checked = Convert.ToBoolean(DR[9].ToString()); cbReportesGeneral.Checked = Convert.ToBoolean(DR[10].ToString()); cbClientes.Checked = Convert.ToBoolean(DR[11].ToString()); cbEmpleado.Checked = Convert.ToBoolean(DR[12].ToString()); cbRol.Checked = Convert.ToBoolean(DR[13].ToString()); cbEditEmi.Checked = Convert.ToBoolean(DR[14].ToString()); cbEditEstab.Checked = Convert.ToBoolean(DR[15].ToString()); cbEditPtoEmi.Checked = Convert.ToBoolean(DR[16].ToString()); cbEditInfoGeneral.Checked = Convert.ToBoolean(DR[17].ToString()); cbEditSmtp.Checked = Convert.ToBoolean(DR[18].ToString()); cbEditMensaje.Checked = Convert.ToBoolean(DR[19].ToString()); cbEditUserOpera.Checked = Convert.ToBoolean(DR[20].ToString()); cbLimpiarLogs.Checked = Convert.ToBoolean(DR[21].ToString()); cbEditPerfil.Checked = Convert.ToBoolean(DR[22].ToString()); cbEnvioEmail.Checked = Convert.ToBoolean(DR[23].ToString()); tbTOPComp.Text = Convert.ToString(DR[25].ToString()); cbRecepcion.Checked = Convert.ToBoolean(DR[26].ToString()); cbVisible.Checked = Convert.ToBoolean(DR[27].ToString()); //ddlFacturas.SelectedValue = DR[16].ToString(); //cbNC.Checked = Convert.ToBoolean(DR[17].ToString()); } DB.Desconectar(); } } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { _db = new BasesDatos(Session["IDENTEMI"]?.ToString() ?? "CORE"); ScriptManager.RegisterStartupScript(this, GetType(), "_showPerfilesActive", "resaltar('liSeguridad');", true); } SqlDataPerfiles.ConnectionString = _db.CadenaConexion; if (Session["descRol"] != null && Session["descRol"].ToString().Equals("delatam", StringComparison.OrdinalIgnoreCase)) { SqlDataPerfiles.SelectCommand = SqlDataPerfiles.SelectCommand.Replace(" AND visible = 'True'", ""); } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); SqlDataSourceEmpleados.ConnectionString = _db.CadenaConexion; SqlDataReceptores.ConnectionString = _db.CadenaConexion; if (!IsPostBack) { _idEditar = ""; } } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { _db = new BasesDatos((Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE")); SqlDataSource1.ConnectionString = _db.CadenaConexion; } if (!IsPostBack) { DataBindEventos(); gvEventos.Sort("fecha", SortDirection.Descending); } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); _dbr = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE", "Recepcion"); SqlDataSourceTipDoc.ConnectionString = _dbr.CadenaConexion; SqlDataSourceEmisor.ConnectionString = _dbr.CadenaConexion; SqlDataSourceReceptor.ConnectionString = _dbr.CadenaConexion; Session["_isWorkflow"] = IsWorkflow(); //Usage: Convert.ToBoolean(Session["_isWorkflow"]) if (Session["idUser"] != null) { if (!IsPostBack) { ddlTipDoc.DataBind(); if (Session["IDGIRO"] != null) { if (Session["IDGIRO"].ToString().Contains("1")) { #region Hotel var toRemove = from i in ddlTipDoc.Items.Cast <ListItem>() where (!i.Value.Equals("01") && !i.Value.Equals("04") && !i.Value.Equals("0")) select i; var lista = toRemove.ToList(); foreach (var item in lista) { ddlTipDoc.Items.Remove(item); } #endregion } } if (Session["USERNAME"].ToString().StartsWith("PROVE")) { ddlEmisor.DataBind(); try { var rfc = Session["rfcCliente"].ToString(); var item = ddlEmisor.Items.FindByText(rfc); ddlEmisor.SelectedValue = item.Value; ddlEmisor.Enabled = false; } catch { } //ddlReceptor.DataBind(); //try //{ // var rfc = Session["IDENTEMI"].ToString(); // var item = ddlReceptor.Items.FindByText(rfc); // ddlReceptor.SelectedValue = item.Value; // ddlReceptor.Enabled = false; //} //catch { } } } } }
/// <summary> /// Guarda la interfaz en disco y en la base de datos /// </summary> /// <param name="fileName">Nombre del archivo (sin ruta)</param> /// <param name="logFileName">Nombre del archivo log (con ruta)</param> /// <param name="storeDb">Guardar registro en la base de datos</param> /// <returns></returns> public bool Save(string fileName, string logFileName = null, bool storeDb = true) { var saved = true; var db = new BasesDatos(); try { //Close(); var directory = ConfigurationManager.AppSettings.Get("writeDirectory"); Directory.CreateDirectory(directory); var file = new FileInfo(directory + @"\" + fileName); _file = file; var csv = ListToCsv(); File.WriteAllText(file.FullName, csv); //_package.SaveAs(file); saved = file.Exists; if (storeDb) { db.Conectar(); db.CrearComando(@"INSERT INTO interfazOracle(fechaEjecucion,tipo,nombreArc,numRegistros,rutaArcInterfaz,rutaArcLog) OUTPUT inserted.idInterfaz VALUES (@fechaEjecucion,@tipo,@nombreArc,@numRegistros,@rutaArcInterfaz,@rutaArcLog)"); db.AsignarParametroCadena("@fechaEjecucion", DateTime.Now.ToString("s")); db.AsignarParametroCadena("@tipo", "Oracle"); db.AsignarParametroCadena("@nombreArc", file.Name); db.AsignarParametroCadena("@numRegistros", ((_rowNumber.ToString()))); //> 0 ? _rowNumber - 1 : _rowNumber).ToString())); db.AsignarParametroCadena("@rutaArcInterfaz", @"InterfacesOracle\" + file.Name); db.AsignarParametroCadena("@rutaArcLog", !string.IsNullOrEmpty(logFileName) ? (@"InterfacesOracle\log Oracle\" + logFileName) : ""); var dr = db.EjecutarConsulta(); if (dr.Read()) { _idInterface = dr[0].ToString(); } else { throw new Exception("No se pudo guardar en la BD"); } db.Desconectar(); } saved = true; } catch (Exception) { if (db != null) { db.Desconectar(); } saved = false; } return(saved); }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); if (Session["idUser"] != null) { _idUser = Session["idUser"].ToString(); SqlDataReceptores.ConnectionString = _db.CadenaConexion; SqlDataContactos.ConnectionString = _db.CadenaConexion; SqlDataMetodoPago.ConnectionString = _db.CadenaConexion; SqlDataMetodoPago.SelectCommand = SqlDataMetodoPago.SelectCommand.Replace("@tipoCatalogo", Session["CfdiVersion"].ToString().Equals("3.3") ? "MetodoPagoCfdi33" : "MetodoPago"); if (!Page.IsPostBack) { #region Giro Empresarial if (Session["IDGIRO"] != null) { if (Session["IDGIRO"].ToString().Contains("1") || Session["IDGIRO"].ToString().Contains("2")) { trDenom.Visible = false; trCurp.Visible = false; rowDenomBus.Visible = false; } else { trDenom.Visible = true; trCurp.Visible = true; rowDenomBus.Visible = true; } } #endregion _db.Conectar(); _db.CrearComando("DELETE FROM Cat_Mx_Contactos_Temp"); _db.EjecutarConsulta1(); _db.Desconectar(); Buscar(); RequiredFieldValidator14.Enabled = !Session["CfdiVersion"].ToString().Equals("3.3"); RequiredFieldValidator16.Enabled = !Session["CfdiVersion"].ToString().Equals("3.3"); RequiredFieldValidator23.Enabled = !Session["CfdiVersion"].ToString().Equals("3.3"); if (Session["IDENTEMI"].ToString().Equals("OHC070227M80") || Session["IDENTEMI"].ToString().Equals("OPL000131DL3")) { lblTitulo.Text = "CLIENTES"; bNuevo.Text = "Nuevo Cliente"; lblBuscarReceptor.Text = "Buscar Cliente"; lblAgregarReceptor.Text = "Agregar/Editar Cliente"; } } } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["errorTimbres"] != null && Convert.ToBoolean(Session["errorTimbres"])) { Response.Redirect("~/CantidadTimbres.aspx", true); return; } else if (Session["errorCertificado"] != null && Convert.ToBoolean(Session["errorCertificado"])) { Response.Redirect("~/LicExpirada.aspx", true); return; } _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); _log = new Log(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); SqlDataRFC.ConnectionString = _db.CadenaConexion; SqlDataSeries.ConnectionString = _db.CadenaConexion; if (Session["idUser"] != null) { _idUser = Session["idUser"].ToString(); if (!Page.IsPostBack) { SqlDataRFC.DataBind(); ddlRFC.DataBind(); foreach (ListItem item in ddlRFC.Items) { if (item.Text.Equals(Session["rfcSucursal"].ToString())) { item.Selected = true; break; } } ddlSerie.DataBind(); ddlSerie.SelectedIndex = 0; ddlSerie_SelectedIndexChanged(null, null); SqlConnection con = new SqlConnection(_db.CadenaConexion); SqlCommand cmd = new SqlCommand("SELECT clave, descripcion FROM Cat_UsoCfdi", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ddlUsoCFDI.DataTextField = "descripcion"; ddlUsoCFDI.DataValueField = "clave"; ddlUsoCFDI.DataSource = dt; ddlUsoCFDI.DataBind(); ddlUsoCFDI.SelectedValue = "G02"; } } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { if (!IsPostBack) { _db = new BasesDatos(Session["IDENTEMI"].ToString()); } reglasDataSource.ConnectionString = _db.CadenaConexion; } else { Response.Redirect("~/Seguridad.aspx"); } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); if (Session["idUser"] != null) { _idUser = Session["idUser"].ToString(); SqlDataSource3.ConnectionString = _db.CadenaConexion; SqlDataCategorias.ConnectionString = _db.CadenaConexion; } if (!IsPostBack) { BindConceptos(); BindCategorias(); } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); SqlDataSource1.ConnectionString = _db.CadenaConexion; SqlDataAmbiente.ConnectionString = _db.CadenaConexion; SqlDataComprobante.ConnectionString = _db.CadenaConexion; SqlDataTipoRecep.ConnectionString = _db.CadenaConexion; if (!Page.IsPostBack) { LimpiarBusqueda(); } } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] == null) { Response.Redirect("~/Cerrar.aspx", true); } _db = new BasesDatos(Session["IDENTEMI"].ToString()); if (!Page.IsPostBack) { _idUser = Session["idUser"].ToString(); _isCliente = Session["IsCliente"] != null && Convert.ToBoolean(Session["IsCliente"]); _isProveedor = Session["IsProveedor"] != null && Convert.ToBoolean(Session["IsProveedor"]); _isEmpleado = !_isCliente && !_isProveedor; Clean(); } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { if (Session["IDENTEMI"] != null) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); _dbR = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE", "Recepcion"); schemaE = _db.DatabaseSchema + ".dbo"; schemaR = _dbR.DatabaseSchema + ".dbo"; SqlDataSourceEmpleados.ConnectionString = _db.CadenaConexion; //SqlDataReceptores.ConnectionString = _dbR.CadenaConexion; if (!IsPostBack) { _idEditar = ""; } } }
protected void Page_Load(object sender, EventArgs e) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); _log = new Log(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); if (Session["idUser"] != null) { _idUser = Session["idUser"].ToString(); SqlDataSourceBancos.ConnectionString = _db.CadenaConexion; } else { Response.Redirect("~/Cerrar.aspx", false); } if (!IsPostBack) { } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { _db = new BasesDatos(Session["IDENTEMI"] != null ? Session["IDENTEMI"].ToString() : "CORE"); if (Session["idUser"] != null) { _idUser = Session["idUser"].ToString(); SqlDataEmisores.ConnectionString = _db.CadenaConexion; SqlDataSource2.ConnectionString = _db.CadenaConexion; } if (!Page.IsPostBack) { Buscar(); RequiredFieldValidator10.Enabled = !Session["CfdiVersion"].ToString().Equals("3.3"); RequiredFieldValidator17.Enabled = !Session["CfdiVersion"].ToString().Equals("3.3"); RequiredFieldValidator18.Enabled = !Session["CfdiVersion"].ToString().Equals("3.3"); RequiredFieldValidator19.Enabled = !Session["CfdiVersion"].ToString().Equals("3.3"); } }