public int TransferWalletCredit(long Srno, string RefCode, decimal TransferAmount)
{
try
{
var OwnerExist = _db.MstUser.Where(x => x.MemberSrno == Srno).FirstOrDefault();
var ReceiverExist = _db.MstUser.Where(x => x.RefCode == RefCode).FirstOrDefault();
if (OwnerExist != null)
{
var OwnerWallet = _db.MstUserWallet.Where(x => x.MemberSrno == OwnerExist.MemberSrno).FirstOrDefault();
if (OwnerWallet.CashCredit < TransferAmount)
{
return(Models_General.ERR_INSUFFICIENT_CASH_BALANCE);
}
else
{
if (ReceiverExist != null)
{
if (OwnerExist.Country != ReceiverExist.Country)
{
return(Models_General.ERR_CURRENCY_NOT_SAME);
}
var ReceiverWallet = _db.MstUserWallet.Where(x => x.MemberSrno == ReceiverExist.MemberSrno).FirstOrDefault();
var owner_topup_request_tracking = new LogUserTrackingWallet
{
MemberSrno = OwnerExist.MemberSrno,
WalletFrom = "CASH WALLET",
WalletTo = "OTHER USER CASH WALLET",
TransactionType = 10,
PreviousAmount = OwnerWallet.CashCredit,
TransactionAmount = TransferAmount,
CurrentTotalAmount = OwnerWallet.CashCredit - TransferAmount,
IsDeduct = true,
Description = string.Format("USER:{0} TRANSFER AMOUNT:{1} TO USER:{2} AT:{3}", OwnerExist.MemberSrno, TransferAmount, ReceiverExist.MemberSrno, DateTime.Now),
CreatedDateTime = DateTime.Now,
Sender = OwnerExist.MemberSrno,
Receiver = ReceiverExist.MemberSrno
};
var receiver_topup_request_tracking = new LogUserTrackingWallet
{
MemberSrno = ReceiverExist.MemberSrno,
WalletFrom = "OTHER USER CASH WALLET",
WalletTo = "CASH WALLET",
TransactionType = 11,
PreviousAmount = ReceiverWallet.CashCredit,
TransactionAmount = TransferAmount,
CurrentTotalAmount = ReceiverWallet.CashCredit + TransferAmount,
IsDeduct = false,
Description = string.Format("USER:{0} TRANSFER AMOUNT:{1} TO USER:{2} AT:{3}", OwnerExist.MemberSrno, TransferAmount, ReceiverExist.MemberSrno, DateTime.Now),
CreatedDateTime = DateTime.Now,
Sender = OwnerExist.MemberSrno,
Receiver = ReceiverExist.MemberSrno
};
var receiver_log_topup = new LogTopup
{
MemberSrno = ReceiverExist.MemberSrno,
WalletFrom = "OTHER USER CASH WALLET",
WalletTo = "CASH WALLET",
TransactionType = 11,
PreviousAmount = ReceiverWallet.CashCredit,
TransactionAmount = TransferAmount,
CurrentTotalAmount = ReceiverWallet.CashCredit + TransferAmount,
Description = string.Format("USER:{0} TRANSFER AMOUNT:{1} TO USER:{2} AT:{3}", OwnerExist.MemberSrno, TransferAmount, ReceiverExist.MemberSrno, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
var owner_log_withdraw = new LogWithdraw
{
MemberSrno = OwnerExist.MemberSrno,
WalletFrom = "CASH WALLET",
WalletTo = "OTHER USER CASH WALLET",
TransactionType = 10,
PreviousAmount = OwnerWallet.CashCredit,
TransactionAmount = TransferAmount,
CurrentTotalAmount = OwnerWallet.CashCredit - TransferAmount,
Description = string.Format("USER:{0} TRANSFER AMOUNT:{1} TO USER:{2} AT:{3}", OwnerExist.MemberSrno, TransferAmount, ReceiverExist.MemberSrno, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
_db.LogUserTrackingWallet.Add(owner_topup_request_tracking);
_db.LogUserTrackingWallet.Add(receiver_topup_request_tracking);
_db.LogTopup.Add(receiver_log_topup);
_db.LogWithdraw.Add(owner_log_withdraw);
OwnerWallet.CashCredit -= TransferAmount;
ReceiverWallet.CashCredit += TransferAmount;
ReceiverWallet.TurnoverAmount += TransferAmount;
_db.SaveChanges();
return(Models_General.SUCC_TRANSFER_CREDIT);
}
else
{
return(Models_General.ERR_TRANSFER_USER_NOT_FOUND);
}
}
}
else
{
return(Models_General.ERR_USER_NOT_FOUND);
}
}
catch (Exception ex)
{
var new_error = new LogErrorSystem
{
Title = "Transfer Wallet Credit",
Details = ex.Message + "/" + ex.StackTrace,
Context = _accessor.ActionContext.HttpContext.Connection.RemoteIpAddress.ToString(),
CreatedDateTime = DateTime.Now,
};
_db.LogErrorSystem.Add(new_error);
_db.SaveChanges();
return(Models_General.ERR_SERVER_BUSY_INTERNAL_ERROR);
}
}
public int EditMainWalletCredit(string AdminID, long MemberSrno, int ManipulateType, decimal ManipulateAmount, decimal TurnoverAmount)
{
try
{
int result;
var CurrentUserWallet = _db.MstUserWallet.Where(x => x.MemberSrno == MemberSrno).FirstOrDefault();
if (CurrentUserWallet != null)
{
if (ManipulateType == 0)
{
var user_topup_request_tracking = new LogUserTrackingWallet
{
MemberSrno = MemberSrno,
WalletFrom = "EGG SYSTEM",
WalletTo = "CASH WALLET",
TransactionType = 6,
PreviousAmount = CurrentUserWallet.CashCredit,
TransactionAmount = ManipulateAmount,
CurrentTotalAmount = CurrentUserWallet.CashCredit + ManipulateAmount,
IsDeduct = false,
Description = string.Format("ADMIN:{0} MANUALLY TOPUP TO {1} WITH TURNOVER AMOUNT {2} AT:{3}", AdminID, MemberSrno, TurnoverAmount, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
var log_topup = new LogTopup
{
MemberSrno = MemberSrno,
WalletFrom = "EGG SYSTEM",
WalletTo = "CASH WALLET",
TransactionType = 6,
PreviousAmount = CurrentUserWallet.CashCredit,
TransactionAmount = ManipulateAmount,
CurrentTotalAmount = CurrentUserWallet.CashCredit + ManipulateAmount,
Description = string.Format("ADMIN:{0} MANUALLY TOPUP TO {1} WITH TURNOVER AMOUNT {2} AT:{3}", AdminID, MemberSrno, TurnoverAmount, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
_db.LogUserTrackingWallet.Add(user_topup_request_tracking);
_db.LogTopup.Add(log_topup);
CurrentUserWallet.CashCredit += ManipulateAmount;
CurrentUserWallet.TurnoverAmount += TurnoverAmount;
_db.SaveChanges();
result = Models_General.SUCC_EDIT_CASH_WALLET;
}
else if (ManipulateType == 1)
{
var user_topup_request_tracking = new LogUserTrackingWallet
{
MemberSrno = MemberSrno,
WalletFrom = "CASH WALLET",
WalletTo = "EGG SYSTEM",
TransactionType = 7,
PreviousAmount = CurrentUserWallet.CashCredit,
TransactionAmount = ManipulateAmount,
CurrentTotalAmount = CurrentUserWallet.CashCredit - ManipulateAmount,
IsDeduct = true,
Description = string.Format("ADMIN:{0} MANUALLY WITHDRAWAL TO {1} WITH TURNOVER AMOUNT {2} AT:{3}", AdminID, MemberSrno, TurnoverAmount, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
var log_withdraw = new LogWithdraw
{
MemberSrno = MemberSrno,
WalletFrom = "CASH WALLET",
WalletTo = "EGG SYSTEM",
TransactionType = 7,
PreviousAmount = CurrentUserWallet.CashCredit,
TransactionAmount = ManipulateAmount,
CurrentTotalAmount = CurrentUserWallet.CashCredit - ManipulateAmount,
Description = string.Format("ADMIN:{0} MANUALLY WITHDRAWAL TO {1} WITH TURNOVER AMOUNT {2} AT:{3}", AdminID, MemberSrno, TurnoverAmount, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
_db.LogUserTrackingWallet.Add(user_topup_request_tracking);
_db.LogWithdraw.Add(log_withdraw);
if (CurrentUserWallet.CashCredit > 0)
{
if (ManipulateAmount > CurrentUserWallet.CashCredit)
{
CurrentUserWallet.CashCredit = 0;
}
else
{
CurrentUserWallet.CashCredit -= ManipulateAmount;
}
}
if (CurrentUserWallet.TurnoverAmount > 0)
{
if (TurnoverAmount > CurrentUserWallet.TurnoverAmount)
{
CurrentUserWallet.TurnoverAmount = 0;
}
else
{
CurrentUserWallet.TurnoverAmount -= TurnoverAmount;
}
}
_db.SaveChanges();
result = Models_General.SUCC_EDIT_CASH_WALLET;
}
else
{
result = Models_General.ERR_SERVER_BUSY_INTERNAL_ERROR;
}
}
else
{
result = Models_General.ERR_USER_WALLET_NOT_FOUND;
}
return(result);
}
catch (Exception ex)
{
var new_error = new LogErrorSystem
{
Title = "Manipulate Main Wallet Credit",
Details = ex.Message + "/" + ex.StackTrace,
Context = _accessor.ActionContext.HttpContext.Connection.RemoteIpAddress.ToString(),
CreatedDateTime = DateTime.Now,
};
_db.LogErrorSystem.Add(new_error);
_db.SaveChanges();
return(Models_General.ERR_SERVER_BUSY_INTERNAL_ERROR);
}
}
public int AdminApproveWithdrawal(string AdminID, long withdrawalsrno, bool approvestatus, string remarks)
{
try
{
//Retrieve The Following Withdrawal Details And Check Is it Valid
var WithdrawalDetails = _db.MstWithdraw.Where(x => x.Srno == withdrawalsrno && x.Status == 0).FirstOrDefault();
//Declare a default result;
int result;
if (WithdrawalDetails != null)
{
// Check The Approval Staus For The Withdrawal
if (approvestatus)
{
if (WithdrawalDetails.TransactionType == 0)
{
WithdrawalDetails.ApproveBy = AdminID;
WithdrawalDetails.ApproveDate = DateTime.Now;
WithdrawalDetails.ApproveRemark = remarks;
WithdrawalDetails.Status = 1;
//UPDATE MEMBER WALLET PENDING WITHDRAWAL AMOUNT TO ZERO
var UserWalletDetails = _db.MstUserWallet.Where(x => x.MemberSrno == WithdrawalDetails.MemberSrno).FirstOrDefault();
//LOG_USER_TRAKCING_WALLET - LOG USER TRANSACTION ACTIVITY ONLY WHEN TRANSACTION COMPLETED : LIKE WITHDRAWAL APPROVED, TOPUP APPROVED, TRANSFER GAME CREDIT SUCCESS
var log_user_tracking_wallet = new LogUserTrackingWallet
{
MemberSrno = WithdrawalDetails.MemberSrno,
WalletFrom = "CASH WALLET",
WalletTo = WithdrawalDetails.BankName + " " + WithdrawalDetails.BankCardNo + " " + WithdrawalDetails.BankAccountHolder,
TransactionType = 1,
PreviousAmount = UserWalletDetails.CashCredit + UserWalletDetails.PendingWithdrawAmount,
TransactionAmount = WithdrawalDetails.WithdrawAmount,
CurrentTotalAmount = UserWalletDetails.CashCredit + UserWalletDetails.PendingWithdrawAmount - WithdrawalDetails.WithdrawAmount,
IsDeduct = true,
Description = string.Format("ADMIN:{0} APPROVED THIS WITHDRAWAL SERIAL NUMBER:{1} AT:{2}", AdminID, WithdrawalDetails.Srno, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
var log_topup = new LogWithdraw
{
MemberSrno = WithdrawalDetails.MemberSrno,
WalletFrom = "CASH WALLET",
WalletTo = WithdrawalDetails.BankName + " " + WithdrawalDetails.BankCardNo + " " + WithdrawalDetails.BankAccountHolder,
TransactionType = 1,
PreviousAmount = UserWalletDetails.CashCredit + UserWalletDetails.PendingWithdrawAmount,
TransactionAmount = WithdrawalDetails.WithdrawAmount,
CurrentTotalAmount = UserWalletDetails.CashCredit + UserWalletDetails.PendingWithdrawAmount - WithdrawalDetails.WithdrawAmount,
Description = string.Format("ADMIN:{0} APPROVED THIS TOPUP SERIAL NUMBER:{1} AT:{2}", AdminID, WithdrawalDetails.Srno, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
UserWalletDetails.PendingWithdrawAmount -= WithdrawalDetails.WithdrawAmount;
_db.LogUserTrackingWallet.Add(log_user_tracking_wallet);
result = Models_General.SUCC_ADMIN_APPROVE_WITHDRAWAL;
}
else if (WithdrawalDetails.TransactionType == 1)
{
WithdrawalDetails.ApproveBy = AdminID;
WithdrawalDetails.ApproveDate = DateTime.Now;
WithdrawalDetails.ApproveRemark = remarks;
WithdrawalDetails.Status = 1;
//UPDATE MEMBER WALLET PENDING WITHDRAWAL AMOUNT TO ZERO
var UserWalletDetails = _db.MstUserWallet.Where(x => x.MemberSrno == WithdrawalDetails.MemberSrno).FirstOrDefault();
UserWalletDetails.PendingWithdrawAmount -= WithdrawalDetails.WithdrawAmount;
//LOG_USER_TRAKCING_WALLET - LOG USER TRANSACTION ACTIVITY ONLY WHEN TRANSACTION COMPLETED : LIKE WITHDRAWAL APPROVED, TOPUP APPROVED, TRANSFER GAME CREDIT SUCCESS
var log_user_tracking_wallet = new LogUserTrackingWallet
{
MemberSrno = WithdrawalDetails.MemberSrno,
WalletFrom = "CASH WALLET",
WalletTo = "WALLET ADDRESS " + WithdrawalDetails.ToAddress,
TransactionType = 3,
PreviousAmount = UserWalletDetails.CashCredit + UserWalletDetails.PendingWithdrawAmount,
TransactionAmount = WithdrawalDetails.WithdrawAmount,
CurrentTotalAmount = UserWalletDetails.CashCredit + UserWalletDetails.PendingWithdrawAmount - WithdrawalDetails.WithdrawAmount,
IsDeduct = true,
Description = string.Format("ADMIN:{0} APPROVED THIS WITHDRAWAL SERIAL NUMBER:{1} AT:{2}", AdminID, WithdrawalDetails.Srno, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
var log_withdraw = new LogWithdraw
{
MemberSrno = WithdrawalDetails.MemberSrno,
WalletFrom = "CASH WALLET",
WalletTo = "WALLET ADDRESS " + WithdrawalDetails.ToAddress,
TransactionType = 3,
PreviousAmount = UserWalletDetails.CashCredit + UserWalletDetails.PendingWithdrawAmount,
TransactionAmount = WithdrawalDetails.WithdrawAmount,
CurrentTotalAmount = UserWalletDetails.CashCredit + UserWalletDetails.PendingWithdrawAmount - WithdrawalDetails.WithdrawAmount,
Description = string.Format("ADMIN:{0} APPROVED THIS TOPUP SERIAL NUMBER:{1} AT:{2}", AdminID, WithdrawalDetails.Srno, DateTime.Now),
CreatedDateTime = DateTime.Now,
};
UserWalletDetails.PendingWithdrawAmount -= WithdrawalDetails.WithdrawAmount;
_db.LogUserTrackingWallet.Add(log_user_tracking_wallet);
_db.LogWithdraw.Add(log_withdraw);
result = Models_General.SUCC_ADMIN_APPROVE_WITHDRAWAL;
}
else
{
result = Models_General.ERR_SERVER_BUSY_INTERNAL_ERROR;
}
//Update The Withdrawal Details and Set Status to APPROVED
}
else
{
//Update The Withdrawal Details and Set Status to REJECTED
WithdrawalDetails.RejectBy = AdminID;
WithdrawalDetails.RejectDate = DateTime.Now;
WithdrawalDetails.RejectRemark = remarks;
WithdrawalDetails.Status = 2;
//UPDATE MEMBER WALLET PENDING WITHDRAWAL AMOUNT TO ZERO AND TRANSFER BACK TO CASH CREDIT
var UserWalletDetails = _db.MstUserWallet.Where(x => x.MemberSrno == WithdrawalDetails.MemberSrno).FirstOrDefault();
UserWalletDetails.CashCredit = UserWalletDetails.CashCredit + WithdrawalDetails.WithdrawAmount;
UserWalletDetails.PendingWithdrawAmount -= WithdrawalDetails.WithdrawAmount;
result = Models_General.SUCC_ADMIN_REJECT_WITHDRAWAL;
}
_db.SaveChanges();
return(result);
}
return(Models_General.ERR_WITHDRAWAL_NOT_FOUND);
}
catch (Exception ex)
{
var new_error = new LogErrorSystem
{
Title = "Admin Approve Withdrawal",
Details = ex.Message + "/" + ex.StackTrace,
Context = _accessor.ActionContext.HttpContext.Connection.RemoteIpAddress.ToString(),
CreatedDateTime = DateTime.Now,
};
_db.LogErrorSystem.Add(new_error);
_db.SaveChanges();
return(Models_General.ERR_SERVER_BUSY_INTERNAL_ERROR);
}
}
