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