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);
}
