public async Task <IActionResult> statement([FromBody] StatementRequest request)
        {
            List <StatementResponseDTO> r = new List <StatementResponseDTO>();

            try
            {
                if (!ModelState.IsValid)
                {
                    return(BadRequest(Commons.Helpers.Utility.GetResponse(ModelState)));
                }

                int gs = await _orclRepo.GenerateStatement(request);

                if (gs == 0)
                {
                    r = await _orclRepo.FilterStatement(request);

                    if (request.noOfRecords > 0)
                    {
                        r = r.Take(request.noOfRecords).ToList();
                    }
                }
                else
                {
                    return(StatusCode((int)HttpStatusCode.ExpectationFailed,
                                      new Response()
                    {
                        message = "Staement Generation Failed", status = false
                    }));
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
                _logger.LogError($"{request.accountNumber} ::- {ex.ToString()}");
                return(StatusCode((int)HttpStatusCode.InternalServerError, Commons.Helpers.Utility.GetResponse(ex)));
            }

            return(CreatedAtAction("statement", r));
        }