public async Task <AddDeductWallet> UpdateWalletAddDeduct(AddDeductWallet withdrawalWalletModel)
{
Console.WriteLine("Connect to SQL Server and demo Create, Read, Update and Delete operations.");
Console.Write("Connecting to SQL Server ... ");
using (SqlConnection connection = new SqlConnection(this._connectionString))
{
connection.Open();
Console.WriteLine("Done.");
using (SqlCommand command = new SqlCommand("wallet_add_deduct_update", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@balance_request_id", SqlDbType.Int).Value = withdrawalWalletModel.addwalletid;
command.Parameters.Add("@is_approve", SqlDbType.Bit).Value = withdrawalWalletModel.approved;
command.Parameters.Add("@is_rejected", SqlDbType.Bit).Value = withdrawalWalletModel.rejected;
command.Parameters.Add("@approver_comment", SqlDbType.NVarChar).Value = withdrawalWalletModel.admin_comment;
command.Parameters.Add("@mode_of_operation", SqlDbType.NVarChar).Value = withdrawalWalletModel.balance_request_type;
command.Parameters.Add("@return_message", SqlDbType.NVarChar, 1233232);
command.Parameters["@return_message"].Direction = ParameterDirection.Output;
try
{
await command.ExecuteNonQueryAsync();
{
var message = (string)command.Parameters["@return_message"].Value;
}
}
catch (Exception ex)
{
throw ex;
}
}
}
Console.WriteLine("All done. Press any key to finish...");
return(withdrawalWalletModel);
}
public async Task <List <AddDeductWallet> > UpdateWalletAddDeduct(List <AddDeductWallet> withdrawalWalletModels)
{
foreach (AddDeductWallet withdrawalWalletModel in withdrawalWalletModels)
{
AddDeductWallet response = await _common.UpdateWalletAddDeduct(withdrawalWalletModel);
}
return(withdrawalWalletModels);
}
public async Task <AdminWalletAddDeductApprovalNotificationModel> AdminAddDeductWalletApprovalNotification(int userId)
{
AdminWalletAddDeductApprovalNotificationModel adminApprovalNotificationModel = new AdminWalletAddDeductApprovalNotificationModel();
Console.WriteLine("Connect to SQL Server and demo Create, Read, Update and Delete operations.");
Console.Write("Connecting to SQL Server ... ");
using (SqlConnection connection = new SqlConnection(this._connectionString))
{
connection.Open();
Console.WriteLine("Done.");
using (SqlCommand command = new SqlCommand("admin_wallet_add_deduct_approval_notification", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@user_id", SqlDbType.Int).Value = userId;
try
{
using (SqlDataReader reader = await command.ExecuteReaderAsync())
{
List <AddDeductWallet> withdrawals = new List <AddDeductWallet>();
while (reader.Read())
{
adminApprovalNotificationModel.addRequestCount = Convert.ToInt32(reader["withdrawal_request_count"]);
}
;
if (reader.NextResult())
{
while (reader.Read())
{
AddDeductWallet pp = new AddDeductWallet();
pp.addwalletid = Convert.ToInt32(reader["balance_request_id"]);
pp.firstname = Convert.ToString(reader["first_name"]);
pp.middlename = Convert.ToString(reader["middle_name"]);
pp.lastname = Convert.ToString(reader["last_name"]);
pp.comment = Convert.ToString(reader["comment"]);
pp.createdon = Convert.ToDateTime(reader["created_on"]);
pp.request_initiator_id = Convert.ToInt32(reader["request_initiator_id"]);
pp.wallet_balance = Convert.ToDecimal(reader["amount"]);
pp.balance_request_type = Convert.ToString(reader["balance_request_type"]);
withdrawals.Add(pp);
}
}
adminApprovalNotificationModel.addDeductWalletModels = withdrawals;
adminApprovalNotificationModel.message = "success";
}
}
catch (Exception ex)
{
throw ex;
}
}
}
Console.WriteLine("All done. Press any key to finish...");
return(adminApprovalNotificationModel);
}
