/// <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;
}
}
