public async Task <Tuple <bool, string> > UpdateWithdrawFunds(WithdrawFundsViewModel withdrawFundsViewModel) { int requestStatus = -1; Tuple <bool, string> result = null; try { using (SqlConnection con = new SqlConnection(_dcDb)) { con.Open(); var parameters = new DynamicParameters(); parameters.Add("@ID", withdrawFundsViewModel.ID, DbType.Int32); parameters.Add("@TransferStatusID", withdrawFundsViewModel.TransferStatusID, DbType.Int32); parameters.Add("@WithdrawAmount", withdrawFundsViewModel.WithdrawAmount, DbType.Decimal); requestStatus = await con.ExecuteScalarAsync <int>("[dbo].[Update_WithdrawFunds]", parameters, commandType : CommandType.StoredProcedure, commandTimeout : 300); if (requestStatus == 0) { result = Tuple.Create(true, "Your widthdrawal processed successfully."); } else { result = Tuple.Create(false, "Your withdrawal request failed."); } con.Close(); } } catch (Exception ex) { ErrorLog.Write(ex); result = Tuple.Create(false, "Oops! Your withdrawal request failed."); } return(result); }
public async Task <Tuple <bool, string> > UpdateWithdrawFunds(WithdrawFundsViewModel withdrawFundsViewModel) { Tuple <bool, string> result = null; try { result = await _repo.UpdateWithdrawFunds(withdrawFundsViewModel); } catch (Exception ex) { ErrorLog.Write(ex); } return(result); }