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 Update(DeudaBancariaMayor10K deudaBancaria)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
string sqlCommand = "UPDATE DeudasBancarias SET InstitucionFinanciera = @InstitucionFinanciera, Tipo = @Tipo , Monto = @Monto WHERE ID = @ID AND DeclaracionID = @DeclaracionID";
DynamicParameters deudaParameters = new DynamicParameters();
deudaParameters.Add("@ID", deudaBancaria.ID);
deudaParameters.Add("@DeclaracionID", deudaBancaria.DeclaracionID);
deudaParameters.Add("@InstitucionFinanciera", deudaBancaria.InstitucionFinanciera, DbType.AnsiString);
deudaParameters.Add("@Tipo", deudaBancaria.Tipo, DbType.AnsiString);
deudaParameters.Add("@Monto", deudaBancaria.Monto, DbType.Decimal);
int rows = await db.ExecuteAsync(sqlCommand, deudaParameters);
}
}
public async Task Add(DeudaBancariaMayor10K deudaBancaria)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
string sqlCommand = "INSERT INTO DeudasBancarias (ID, DeclaracionID, InstitucionFinanciera, Tipo, Monto) VALUES (@ID, @DeclaracionID, @InstitucionFinanciera, @Tipo, @Monto)";
DynamicParameters deudaParameters = new DynamicParameters();
deudaParameters.Add("@ID", deudaBancaria.ID);
deudaParameters.Add("@DeclaracionID", deudaBancaria.DeclaracionID);
deudaParameters.Add("@InstitucionFinanciera", deudaBancaria.InstitucionFinanciera, DbType.AnsiString);
deudaParameters.Add("@Tipo", deudaBancaria.Tipo, DbType.AnsiString);
deudaParameters.Add("@Monto", deudaBancaria.Monto, DbType.Decimal);
int rows = await db.ExecuteAsync(sqlCommand, deudaParameters);
}
}
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);
}
}
public void AddItem(DeudaBancariaMayor10K item)
{
_deudasBancarias.Add(item);
}
