/// <summary>
/// Handles the Click event of the bAgregar 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 bAgregar_Click(object sender, EventArgs e)
{
if (Session["CfdiVersion"].ToString().Equals("3.3") && !ValidarCodigoPostal(tbCpEmi.Text))
{
(Master as SiteMaster).MostrarAlerta(this, $"El codigo postal { tbCpEmi.Text } no se encuentra en el catálogo del SAT", 4, null);
}
var sql = "";
if (string.IsNullOrEmpty(_idEditar))
{
sql = @"INSERT INTO Cat_Emisor
(RFCEMI, NOMEMI, dirMatriz, EmpresaTipo, noExterior, noInterior, colonia, localidad, referencia, municipio, estado, pais, codigoPostal, curp, telefono, email, regimenFiscal, pdfColor01, pdfColor04, pdfColor06, pdfColor07, pdfColor08, pdfColor09" + (_fileBytes != null ? ", logo" : "") + @")
VALUES
(@RFCEMI,@NOMEMI,@CALLE,@EmpresaTipo,@NOEXT,@NOINT,@COL,@LOC,@REF,
@MUN,@EST,@PAIS,@CP,@CURP,@TEL,@EMAIL,@REGIMEN, @pdfColor01, @pdfColor04, @pdfColor06, @pdfColor07, @pdfColor08, @pdfColor09" + (_fileBytes != null ? ",@LOGO" : "") + @")";
}
else
{
sql = @"UPDATE Cat_Emisor SET RFCEMI = @RFCEMI, NOMEMI = @NOMEMI, curp=@CURP, telefono=@TEL, email=@EMAIL, regimenFiscal=@REGIMEN, dirMatriz=@CALLE, EmpresaTipo=@EmpresaTipo, noExterior=@NOEXT, noInterior=@NOINT, colonia=@COL, localidad=@LOC, referencia=@REF, municipio=@MUN, estado=@EST, pais=@PAIS, codigoPostal=@CP, pdfColor01=@pdfColor01, pdfColor04=@pdfColor04, pdfColor06=@pdfColor06, pdfColor07=@pdfColor07, pdfColor08=@pdfColor08, pdfColor09=@pdfColor09" + (_fileBytes != null ? ", logo = @LOGO" : "") + @" WHERE IDEEMI=@IDEEMI";
}
try
{
_db.Conectar();
_db.CrearComando(sql);
if (!string.IsNullOrEmpty(_idEditar))
{
_db.AsignarParametroCadena("@IDEEMI", _idEditar);
}
_db.AsignarParametroCadena("@RFCEMI", tbRfcEmi.Text);
_db.AsignarParametroCadena("@NOMEMI", tbNomEmi.Text);
_db.AsignarParametroCadena("@CALLE", tbCalleEmi.Text);
_db.AsignarParametroCadena("@NOEXT", tbNoExtEmi.Text);
_db.AsignarParametroCadena("@NOINT", tbNoIntEmi.Text);
_db.AsignarParametroCadena("@COL", tbColoniaEmi.Text);
_db.AsignarParametroCadena("@LOC", tbLocEmi.Text);
_db.AsignarParametroCadena("@REF", tbRfcEmi.Text);
_db.AsignarParametroCadena("@MUN", tbMunicipioEmi.Text);
_db.AsignarParametroCadena("@EST", tbEstadoEmi.Text);
_db.AsignarParametroCadena("@PAIS", tbPaisEmi.Text);
_db.AsignarParametroCadena("@CP", tbCpEmi.Text);
_db.AsignarParametroCadena("@EmpresaTipo", Session["IDGIRO"].ToString());
_db.AsignarParametroCadena("@CURP", tbCURPE.Text);
_db.AsignarParametroCadena("@TEL", tbTelEmi.Text);
_db.AsignarParametroCadena("@EMAIL", tbMailEmi.Text);
_db.AsignarParametroCadena("@REGIMEN", tbRegimenFiscal.Text);
_db.AsignarParametroCadena("@pdfColor01", tbColorPdf01.Text.Replace("rgb(", "").Replace(")", "").Replace(" ", ""));
_db.AsignarParametroCadena("@pdfColor04", tbColorPdf04.Text.Replace("rgb(", "").Replace(")", "").Replace(" ", ""));
_db.AsignarParametroCadena("@pdfColor06", tbColorPdf06.Text.Replace("rgb(", "").Replace(")", "").Replace(" ", ""));
_db.AsignarParametroCadena("@pdfColor07", tbColorPdf07.Text.Replace("rgb(", "").Replace(")", "").Replace(" ", ""));
_db.AsignarParametroCadena("@pdfColor08", tbColorPdf08.Text.Replace("rgb(", "").Replace(")", "").Replace(" ", ""));
_db.AsignarParametroCadena("@pdfColor09", tbColorPdf09.Text.Replace("rgb(", "").Replace(")", "").Replace(" ", ""));
//_db.AsignarParametroCadena("@OBLIG", ddlObligado.SelectedItem.Text);
if (_fileBytes != null)
{
_db.AsignarParametroByteArray("@LOGO", _fileBytes);
}
_db.EjecutarConsulta1();
tbRfcEmi.Text = "";
tbNomEmi.Text = "";
tbCURPE.Text = "";
tbMailEmi.Text = "";
tbTelEmi.Text = "";
tbRegimenFiscal.Text = "";
tbCalleEmi.Text = "";
tbNoExtEmi.Text = "";
tbNoIntEmi.Text = "";
tbColoniaEmi.Text = "";
tbLocEmi.Text = "";
tbRefEmi.Text = "";
tbMunicipioEmi.Text = "";
tbEstadoEmi.Text = "";
tbPaisEmi.Text = "";
tbCpEmi.Text = "";
//ddlTEmp.Text = "";
//ddlObligado.Text = "";
tbColorPdf01.Text = "";
tbColorPdf04.Text = "";
tbColorPdf06.Text = "";
tbColorPdf07.Text = "";
tbColorPdf08.Text = "";
tbColorPdf09.Text = "";
Image1.ImageUrl = "data:image/jpg;base64,";
bLimpiarBus_Click(null, null);
var updatePanelMenuMaster = ((Master as SiteMaster).FindControl("UpdatePanelMenuMaster") as UpdatePanel);
updatePanelMenuMaster.Update();
(Master as SiteMaster).MostrarAlerta(this, "El emisor se " + (!string.IsNullOrEmpty(_idEditar) ? "modificó" : "agregó") + " correctamente.", 2, null, "$('#divNuevo').modal('hide');");
_idEditar = "";
}
catch (Exception ex)
{
(Master as SiteMaster).MostrarAlerta(this, "El emisor no se pudo agregar/modificar. Intentelo nuevamente.<br>" + ex.Message, 4, null);
}
_db.Desconectar();
}
/// <summary>
/// Handles the Click event of the bAgregar 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 bAgregar_Click(object sender, EventArgs e)
{
var sql = "";
DbDataReader dr;
if (string.IsNullOrEmpty(_idEditar))
{
sql = @"INSERT INTO [Cat_SucursalesEmisor]
([clave]
,[sucursal]
,[eliminado]
,[telefono]
,[RFC]
,[calle]
,[noExterior]
,[noInterior]
,[colonia]
,[localidad]
,[referencia]
,[municipio]
,[estado]
,[pais]
,[codigoPostal]" + (_fileBytes != null ? ", logo" : "") + @")
VALUES
(@clave
,@sucursal
,@eliminado
,@telefono
,@RFC
,@calle
,@noExterior
,@noInterior
,@colonia
,@localidad
,@referencia
,@municipio
,@estado
,@pais
,@codigoPostal" + (_fileBytes != null ? ",@logo" : "") + @")";
}
else
{
sql = @"UPDATE [Cat_SucursalesEmisor]
SET [clave] = @clave
,[sucursal] = @sucursal
,[eliminado] = @eliminado
,[telefono] = @telefono
,[RFC] = @RFC
,[calle] = @calle
,[noExterior] = @noExterior
,[noInterior] = @noInterior
,[colonia] = @colonia
,[localidad] = @localidad
,[referencia] = @referencia
,[municipio] = @municipio
,[estado] = @estado
,[pais] = @pais
,[codigoPostal] = @codigoPostal" + (_fileBytes != null ? ", logo = @logo" : "") + @"
WHERE idSucursal = @ID";
}
try
{
_db.Conectar();
_db.CrearComando(sql);
if (!string.IsNullOrEmpty(_idEditar))
{
_db.AsignarParametroCadena("@ID", _idEditar);
}
_db.AsignarParametroCadena("@clave", tbClaveNuevo.Text);
_db.AsignarParametroCadena("@sucursal", tbSucursalNuevo.Text);
_db.AsignarParametroCadena("@eliminado", "0");
_db.AsignarParametroCadena("@telefono", tbTelNuevo.Text);
_db.AsignarParametroCadena("@RFC", tbRfcRecNuevo.Text);
_db.AsignarParametroCadena("@calle", tbCalleRec.Text);
_db.AsignarParametroCadena("@noExterior", tbNoExtRec.Text);
_db.AsignarParametroCadena("@noInterior", tbNoIntRec.Text);
_db.AsignarParametroCadena("@colonia", tbColoniaRec.Text);
_db.AsignarParametroCadena("@localidad", tbLocRec.Text);
_db.AsignarParametroCadena("@referencia", tbRefRec.Text);
_db.AsignarParametroCadena("@municipio", tbMunicipioRec.Text);
_db.AsignarParametroCadena("@estado", tbEstadoRec.Text);
_db.AsignarParametroCadena("@pais", tbPaisRec.Text);
_db.AsignarParametroCadena("@codigoPostal", tbCpRec.Text);
if (_fileBytes != null)
{
_db.AsignarParametroByteArray("@logo", _fileBytes);
}
dr = _db.EjecutarConsulta();
if (dr.RecordsAffected > 0)
{
tbRfcRecNuevo.Text = "";
tbClaveNuevo.Text = "";
tbSucursalNuevo.Text = "";
tbTelNuevo.Text = "";
tbRfcRec.Text = "";
tbCalleRec.Text = "";
tbNoExtRec.Text = "";
tbNoIntRec.Text = "";
tbColoniaRec.Text = "";
tbLocRec.Text = "";
tbRefRec.Text = "";
tbMunicipioRec.Text = "";
tbEstadoRec.Text = "";
tbPaisRec.Text = "";
tbCpRec.Text = "";
Image1.ImageUrl = "data:image/jpg;base64,";
bActualizar_Click(null, null);
(Master as SiteMaster).MostrarAlerta(this, "La sucursal se " + (!string.IsNullOrEmpty(_idEditar) ? "modificó" : "agregó") + " correctamente.", 2, null, "$('#divNuevo').modal('hide');");
}
else
{
(Master as SiteMaster).MostrarAlerta(this, "La sucursal no se pudo agregar/modificar. Intentelo nuevamente", 4, null);
}
}
catch
{
}
}
