public async Task <ActionResult <IEnumerable <BankFees> > > GetMGR(MGRRequest mgrRequest)
        {
            List <BankFees> bankfees = new List <BankFees>();

            try
            {
                bankfees = await _context.BankFees.FromSql("dbo.SP_GetMGR " +
                                                           "@requestid = {0} ", mgrRequest.RequestID).ToListAsync();
            }
            catch (Exception Ex)
            {
                throw;
            }
            return(bankfees);
        }
        public async Task <bool> UpdateMGR(MGRRequest mgrRequest)
        {
            List <Agent> agent = new List <Agent>();

            try
            {
                await _context.Database.ExecuteSqlCommandAsync("dbo.SP_UpdateMGR " +
                                                               "@requestid = {0}, @mgr = {1} ", mgrRequest.RequestID, mgrRequest.MGR);

                return(true);
            }
            catch (Exception Ex)
            {
                throw;
            }
        }
        public async Task <ActionResult <IEnumerable <BankFees> > > GetMGR([FromBody] MGRRequest mgrRequest)
        {
            var agentResponse = await _agentRepository.GetMGR(mgrRequest);

            return(agentResponse);
        }
        public async Task <bool> UpdateMGR([FromBody] MGRRequest mgrRequest)
        {
            var agentResponse = await _agentRepository.UpdateMGR(mgrRequest);

            return(agentResponse);
        }