/// <summary> /// Handles the Click event of the bAgregarRFC 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 bAgregarRFC_Click(object sender, EventArgs e) { var existe = false; var rfc = ""; _dbe.Conectar(); var sql = ""; sql = @"select id FROM Cat_Aerolinea where rfc = @rfc"; _dbe.Conectar(); _dbe.CrearComando(sql); _dbe.AsignarParametroCadena("@rfc", DropDownListRFC.SelectedItem.Text); var dr = _dbe.EjecutarConsulta(); if (dr.Read()) { existe = true; } _dbe.Desconectar(); if (!existe) { _dbe.Conectar(); _dbe.CrearComando(@"INSERT INTO Cat_Aerolinea VALUES ( @rfc, @tiempo)"); _dbe.AsignarParametroCadena("@rfc", DropDownListRFC.SelectedValue); _dbe.AsignarParametroCadena("@tiempo", DropDownListPeriodo.SelectedValue); _dbe.EjecutarConsulta1(); _dbe.Desconectar(); SqlDataSourceRfc.DataBind(); gvRFC.DataBind(); } else { (Master as SiteMaster).MostrarAlerta(this, "El RFC ya se encuentra registrado", 4); } }
/// <summary> /// Handles the RowUpdating event of the gvConceptos control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="GridViewUpdateEventArgs"/> instance containing the event data.</param> protected void gvConceptos_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { var tiempo = gvRFC.DataKeys[e.RowIndex].Value.ToString(); var row = gvRFC.Rows[e.RowIndex]; var tiempos = (DropDownList)row.FindControl("DropDownListPeriodo2"); SqlDataSourceRfc.UpdateParameters["tiempo"].DefaultValue = tiempos.SelectedValue.ToString(); SqlDataSourceRfc.UpdateParameters["id"].DefaultValue = tiempo; SqlDataSourceRfc.Update(); } catch (Exception ex) { (Master as SiteMaster).MostrarAlerta(this, "El concepto no se pudo editar, inténtelo nuevamente.<br/><br/>" + ex.Message, 4); } finally { gvRFC.EditIndex = -1; } }