public async Task <IActionResult> PayCredit(PayCredit payCredit)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    GetAtributes(payCredit);
                    Credits credits = await _creditRepository.GetCredit(payCredit.CreditNumber);

                    if (credits == null)
                    {
                        return(DisplayError("Not Successful", "This Credit Not Exist"));
                    }
                    Accounts acc = _accountRepository.GetAccount(payCredit.AccountNumber);
                    if (acc == null)
                    {
                        return(DisplayError("Not Successful", "This Account Not Exist"));
                    }
                    if (await _transactionRepository.PayCredit(payCredit) != null)
                    {
                        return(RedirectToAction("ConfirmTransaction"));
                    }
                }
                return(DisplayError("Not Successful", "This Account Not Exist"));
            }
            catch (Exception ex)
            {
                return(DisplayError("Not Successful", ex.Message));
            }
        }
 public async Task <PayCredit> PayCredit(PayCredit payCredit)
 {
     try
     {
         int value = 0;
         using (var con = await DataConnection.Connection())
         {
             var cmd = DataConnection.Command(con, "sp_PayCredit", CommandType.StoredProcedure);
             cmd.Parameters.AddWithValue("@FullName", payCredit.FullName);
             cmd.Parameters.AddWithValue("@ClientID", payCredit.ClientID);
             cmd.Parameters.AddWithValue("@CardNumber", payCredit.CardNumber);
             cmd.Parameters.AddWithValue("@AccountNumber", payCredit.AccountNumber);
             cmd.Parameters.AddWithValue("@CreditNumber", payCredit.CreditNumber);
             cmd.Parameters.AddWithValue("@Amount", payCredit.Amount);
             cmd.Parameters.AddWithValue("@Description", payCredit.Description);
             value = await DataConnection.GetValue(cmd);
         }
         return(await DataConnection.Result(value, payCredit));
     }
     catch (Exception)
     {
         throw;
     }
 }