public async Task <decimal> GetTotalRecebido(EStatusParcela status)
{
using (var db = await _dB.GetConAsync())
{
var query = "SELECT ISNULL(SUM(P.Valor),0) FROM [dbo].[Parcela] AS P WHERE P.[Status] = 1;";
return(await db.QueryFirstOrDefaultAsync <decimal>(query, new { Status = status }));
}
}
public async Task <Parcela> GetByStatus(EStatusParcela status)
{
using (var db = await _dB.GetConAsync())
{
var query = " SELECT [Id] "+
" ,[IdLoan] "+
" ,[Valor] "+
" ,[JuroAtraso] "+
" ,[Status] "+
" ,[DataVencimento] "+
" FROM [dbo].[Parcela] "+
" WHERE Status = @Status ";
return(await db.QueryFirstOrDefaultAsync <Parcela>(query, new { Status = status }));
}
}
private void UpdateStatus(EStatusParcela status)
{
Status = status;
}
