public async Task <DeudaBancariaOutput> Execute(Guid deudaID, Guid declaracionID, string institucionFinanciera, decimal monto, string tipo) { if (deudaID == null || deudaID == Guid.Empty) { await _deudaBancariaWriteOnlyRepository.Add(new DeudaBancariaMayor10K(declaracionID, institucionFinanciera, monto, tipo)); } else { await _deudaBancariaWriteOnlyRepository.Update(DeudaBancariaMayor10K.Load(deudaID, declaracionID, institucionFinanciera, monto, tipo)); } return(new DeudaBancariaOutput(deudaID, declaracionID, institucionFinanciera, monto, tipo)); }
private static async Task <DeudaBancariaCollection> ReadDeudasCollection(Guid declaracionID, IDbConnection db) { var deudasCollection = new DeudaBancariaCollection(); var deudaBancariaSQL = "SELECT * FROM DeudasBancarias WHERE DeclaracionID = @declaracionID"; var deudas = await db.QueryAsync <Entities.DeudaBancaria>(deudaBancariaSQL, new { declaracionID }); foreach (var item in deudas.ToList()) { deudasCollection.AddItem(DeudaBancariaMayor10K.Load(item.ID, item.DeclaracionID, item.InstitucionFinanciera, item.Monto, item.Tipo)); } return(deudasCollection); }
public async Task <DeudaBancariaMayor10K> Get(Guid deudaBancariaID) { using (IDbConnection db = new SqlConnection(connectionString)) { string sqlCommand = "SELECT * FROM DeudasBancarias WHERE ID = @deudaBancariaID"; var deuda = await db.QueryFirstOrDefaultAsync <Entities.DeudaBancaria>(sqlCommand, new { deudaBancariaID }); if (deuda == null) { return(null); } return(DeudaBancariaMayor10K.Load(deuda.ID, deuda.DeclaracionID, deuda.InstitucionFinanciera, deuda.Monto, deuda.Tipo)); } }
public async Task <ICollection <DeudaBancariaMayor10K> > GetByDeclaracion(Guid declaracionID) { using (IDbConnection db = new SqlConnection(connectionString)) { string sqlCommand = "SELECT * FROM DeudasBancarias WHERE DeclaracionID = @declaracionID"; var deudas = await db.QueryAsync <Entities.DeudaBancaria>(sqlCommand, new { declaracionID }); var outputResult = new List <DeudaBancariaMayor10K>(); if (deudas == null) { return(outputResult); } foreach (var deuda in deudas) { outputResult.Add(DeudaBancariaMayor10K.Load(deuda.ID, deuda.DeclaracionID, deuda.InstitucionFinanciera, deuda.Monto, deuda.Tipo)); } return(outputResult); } }