public RemainingBalance Edit(RemainingBalance remainingBalance)
{
var query = $"EXEC Edit '{remainingBalance.RemainingBalanceId}'; ";
remainingBalance = _context.RemainingBalance.FromSql(query).FirstOrDefault();
return(remainingBalance);
}
public RemainingBalance Create(RemainingBalance remainingBalance)
{
var query = $"EXEC CreateRemainingBalance '{remainingBalance.UserId}', '{remainingBalance.BalanceAmount}', '{remainingBalance.UserId}', '{remainingBalance.IsDelete}', '{DateTime.UtcNow}'; ";
remainingBalance = _context.RemainingBalance.FromSql(query).FirstOrDefault();
return(remainingBalance);
}
public RemainingBalance GetByUserId(string userId)
{
RemainingBalance remainingBalance = new RemainingBalance();
var query = $"EXEC GetBalanceByUserId '{userId}'; ";
remainingBalance = _context.RemainingBalance.FromSql(query).FirstOrDefault();
return(remainingBalance);
}
public RemainingBalance Delete(int id)
{
RemainingBalance remainingBalance = new RemainingBalance();
var query = $"EXEC Delete '{id}'; ";
remainingBalance = _context.RemainingBalance.FromSql(query).FirstOrDefault();
return(remainingBalance);
}
public async Task <object> Create([FromBody] RemainingBalance remainingBalance)
{
try
{
remainingBalance = _remainingBalanceRepository.Create(remainingBalance);
}
catch (Exception ex)
{
result = false;
error = ex.Message;
}
return(new SingleResponse <RemainingBalance>
{
Message = "Balance created successfully",
DidError = false,
ErrorMessage = string.Empty,
Token = string.Empty,
Model = remainingBalance
});
}
public async Task <object> GetById(int id)
{
RemainingBalance remainingBalance = new RemainingBalance();
try
{
remainingBalance = _remainingBalanceRepository.GetById(id);
}
catch (Exception ex)
{
result = false;
error = ex.Message;
}
return(new SingleResponse <RemainingBalance>
{
Message = "Get by id remainingBalance execute successfully",
DidError = false,
ErrorMessage = string.Empty,
Token = string.Empty,
Model = remainingBalance
});
}
