public RegimenFiscal ObtenerRegimenFiscal(int idRegimenFiscal)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_REGIMEN_FISCAL", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_REGIMEN_FISCAL", idRegimenFiscal);
RegimenFiscal regimenFiscal = null;
SqlDataReader rdr = null;
try
{
rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
regimenFiscal = GetRegimenFiscalFromReader(rdr);
}
return(regimenFiscal);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
rdr.Close();
cmd.Dispose();
cnn.Dispose();
}
}
public int ActualizarRegimenFiscal(RegimenFiscal regimenFiscal)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_UP_REGIMEN_FISCAL", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_REGIMEN_FISCAL", regimenFiscal.idRegimenFiscal);
cmd.Parameters.AddWithValue("@PP_DESCRIPCRION", regimenFiscal.descripcion);
cmd.Parameters.AddWithValue("@PP_FISICA", regimenFiscal.personaFisica);
cmd.Parameters.AddWithValue("@PP_MORAL", regimenFiscal.personaMoral);
int total;
try
{
total = cmd.ExecuteNonQuery();
return(total);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
private RegimenFiscal GetRegimenFiscalFromReader(SqlDataReader rdr)
{
var rf = new RegimenFiscal();
rf.idRegimenFiscal = rdr.GetInt32(0);
rf.descripcion = rdr.GetString(1);
rf.personaFisica = rdr.GetBoolean(2);
rf.personaMoral = rdr.GetBoolean(3);
rf.eliminado = rdr.GetBoolean(4);
return(rf);
}
public IActionResult Post(RegimenFiscal regimenFiscal)
{
RegimenFiscalService regimenFiscalService = new RegimenFiscalService();
try
{
regimenFiscalService.InsertarRegimenFiscal(regimenFiscal);
return(Ok());
}
catch (Exception e)
{
return(StatusCode(500, new { Message = "Error en el servidor" }));
}
}
public void ActualizarRegimenFiscal(RegimenFiscal regimenFiscal)
{
RegimenFiscalDAO regimenFiscalDAO = new RegimenFiscalDAO();
int regimenFiscalActualizada = 0;
try
{
regimenFiscalActualizada = regimenFiscalDAO.ActualizarRegimenFiscal(regimenFiscal);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw new ExcepcionInterna("Error en el servidor", e);
}
if (regimenFiscalActualizada < 1)
{
throw new ExcepcionInterna("Error en el servidor");
}
}
public RegimenFiscal ObtenerRegimenFiscal(int idRegimenFiscal)
{
RegimenFiscalDAO regimenFiscalDAO = new RegimenFiscalDAO();
RegimenFiscal regimenFiscal = null;
try
{
regimenFiscal = regimenFiscalDAO.ObtenerRegimenFiscal(idRegimenFiscal);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw new ExcepcionInterna("Error en el servidor", e);
}
if (regimenFiscal == null)
{
throw new NotFoundException("No se ha encontrado el Régimen Fiscal");
}
return(regimenFiscal);
}
public static Comprobante CreateComprobante()
{
var comp = new Comprobante
{
Emisor = new Emisor(),
Receptor = new Receptor()
};
var regimenFiscal = new RegimenFiscal();
var concepto = new Concepto();
var traslado = new Traslado();
comp.Emisor.DomicilioFiscal = new DomicilioFiscal();
comp.Receptor.Domicilio = new Domicilio();
comp.Impuestos = new Impuestos();
comp.Fecha = DateTime.Now;
comp.FormaDePago = "PAGO EN UNA SOLA EXHIBICION";
comp.MetodoDePago = "NO IDENTIFICADO";
comp.LugarExpedicion = "San Luis Potosí";
comp.TipoDeComprobante = TipoDeComprobante.ingreso;
comp.SubTotal = 1.00m;
comp.Total = 1.16m;
comp.Emisor.Rfc = "AAA010101AAA";
comp.Emisor.DomicilioFiscal.Calle = "Himalaya";
comp.Emisor.DomicilioFiscal.Municipio = "San Luis Potosí";
comp.Emisor.DomicilioFiscal.Estado = "San Luis Potosí";
comp.Emisor.DomicilioFiscal.Pais = "México";
comp.Emisor.DomicilioFiscal.CodigoPostal = "78000";
regimenFiscal.Regimen = "Régimen de las Personas Físicas con Actividades Empresariales y Profesionales";
comp.Emisor.RegimenFiscal = new[] { regimenFiscal };
comp.Receptor.Rfc = "AAA010101AAA";
comp.Receptor.Domicilio.Pais = "México";
concepto.Cantidad = 1;
concepto.Unidad = "NO APLICA";
concepto.Descripcion = "SERVICIO X";
concepto.Importe = 1.00m;
concepto.ValorUnitario = 1.00m;
comp.Conceptos = new[] { concepto };
traslado.Impuesto = TrasladoImpuesto.IEPS;
traslado.Importe = 0.16m;
traslado.Tasa = 16m;
comp.Impuestos.Traslados = new[] { traslado };
//opcionales
if (true)
{
comp.Emisor.Nombre = "PANCHO VILLA";
comp.Emisor.DomicilioFiscal.NoExterior = "1005";
comp.Emisor.DomicilioFiscal.NoInterior = "124";
comp.Emisor.DomicilioFiscal.Colonia = "Jose del Cantaro";
comp.Emisor.DomicilioFiscal.Localidad = "San Luis Potosí";
comp.Receptor.Domicilio.Calle = "AV. V. CARRANZA";
comp.Receptor.Domicilio.CodigoPostal = "78000";
comp.Receptor.Domicilio.Colonia = "Centro";
comp.Receptor.Domicilio.NoExterior = "715";
comp.Receptor.Domicilio.NoInterior = "PH";
comp.Receptor.Domicilio.Localidad = "San Luis Potosí";
comp.Receptor.Domicilio.Municipio = "San Luis Potosí";
comp.Receptor.Domicilio.Estado = "San Luis Potosí";
comp.Impuestos.TotalImpuestosTrasladados = 0.16m;
comp.Serie = "U";
comp.Folio = "0001";
}
return(comp);
}
