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