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