public int TopupCredit(string loginid, decimal TopupAmount, bool IsReset) { try { int result; var UserAccount = _db.MstUserAccount.Where(x => x.LoginId == loginid).FirstOrDefault(); if (UserAccount != null) { var CurrentUserWallet = _db.MstUserWallet.Where(x => x.MemberSrno == UserAccount.MemberSrno).FirstOrDefault(); var CurrentSettings = _db.MstSettings.Where(x => x.SettingName == "TwelveTurnover").FirstOrDefault(); var user_topup_request_tracking = new LogUserTrackingWallet { MemberSrno = UserAccount.MemberSrno, WalletFrom = "TWELVE SYSTEM", WalletTo = "CASH WALLET", TransactionType = 8, PreviousAmount = CurrentUserWallet.CashCredit, TransactionAmount = TopupAmount, CurrentTotalAmount = CurrentUserWallet.CashCredit + TopupAmount, IsDeduct = false, Description = string.Format("TWELVE SYSTEM TOPUP CREDIT TO THIS USER AT {0}", DateTime.Now), CreatedDateTime = DateTime.Now, }; var log_topup = new LogTopup { MemberSrno = UserAccount.MemberSrno, WalletFrom = "TWELVE SYSTEM", WalletTo = "CASH WALLET", TransactionType = 8, PreviousAmount = CurrentUserWallet.CashCredit, TransactionAmount = TopupAmount, CurrentTotalAmount = CurrentUserWallet.CashCredit + TopupAmount, Description = string.Format("TWELVE SYSTEM TOPUP CREDIT TO THIS USER AT {0}", DateTime.Now), CreatedDateTime = DateTime.Now, }; _db.LogUserTrackingWallet.Add(user_topup_request_tracking); _db.LogTopup.Add(log_topup); result = Models_General.SUCC_TOPUP; decimal finalturnover = TopupAmount * int.Parse(CurrentSettings.SettingValue); CurrentUserWallet.CashCredit += TopupAmount; CurrentUserWallet.TurnoverAmount += finalturnover; if (IsReset == true) { CurrentUserWallet.TwelveTurnoverAmount = TopupAmount; } _db.SaveChanges(); return(result); } else { return(Models_General.ERR_USER_NOT_FOUND); } } catch (Exception ex) { var new_error = new LogErrorSystem { Title = "Twelve Topup 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 BackResponseDepositPaymentGateway(string Merchant, string Reference, string Currency, string Amount, string Language, string Customer, string Datetime, string Note, string Key, string Status, string ID) { try { int result; var UserAccount = _db.MstUserAccount.Where(x => x.LoginId == Customer).FirstOrDefault(); var UserWallet = _db.MstUserWallet.Where(x => x.MemberSrno == UserAccount.MemberSrno).FirstOrDefault(); var CurrentSettings = _db.MstSettings.Where(x => x.SettingName == "NormalTurnover").FirstOrDefault(); var PaymentGatewayResponse = new LogResponsePaymentGateway { Merchant = Merchant, Reference = Reference, Currency = Currency, Amount = Convert.ToDecimal(Amount), Language = Language, Customer = Customer, Datetime = Datetime, Note = Note, Key = Key, Status = Status, Id = ID, CreatedDateTime = DateTime.Now, }; _db.LogResponsePaymentGateway.Add(PaymentGatewayResponse); if (Status == "000") { var user_topup_request_tracking = new LogUserTrackingWallet { MemberSrno = UserWallet.MemberSrno, WalletFrom = "PAYLAH88", WalletTo = "CASH WALLET", TransactionType = 12, PreviousAmount = UserWallet.CashCredit, TransactionAmount = Convert.ToDecimal(Amount), CurrentTotalAmount = UserWallet.CashCredit + Convert.ToDecimal(Amount), IsDeduct = false, Description = string.Format("User:{0} HAS TOPUP AMOUNT:{1} WITH {2} USING PAYLAH88 PAYMENT GATEWAY AT:{3}", Customer, Convert.ToDecimal(Amount), ID, DateTime.Now), CreatedDateTime = DateTime.Now, }; var log_topup = new LogTopup { MemberSrno = UserWallet.MemberSrno, WalletFrom = "PAYLAH88", WalletTo = "CASH WALLET", TransactionType = 12, PreviousAmount = UserWallet.CashCredit, TransactionAmount = Convert.ToDecimal(Amount), CurrentTotalAmount = UserWallet.CashCredit + Convert.ToDecimal(Amount), Description = string.Format("User:{0} HAS TOPUP AMOUNT:{1} USING PAYLAH88 PAYMENT GATEWAY AT:{2}", Customer, Convert.ToDecimal(Amount), DateTime.Now), CreatedDateTime = DateTime.Now, }; var TopupRequest = new MstTopUp { MemberSrno = UserWallet.MemberSrno, WalletType = "CASH WALLET", TopupAmount = Convert.ToDecimal(Amount), Currency = Currency, Status = 1, RequestDate = DateTime.Now, TransactionReferenceNumber = ID, TransactionType = 2, }; _db.LogUserTrackingWallet.Add(user_topup_request_tracking); _db.LogTopup.Add(log_topup); _db.MstTopUp.Add(TopupRequest); decimal finalturnover = Convert.ToDecimal(Amount) * int.Parse(CurrentSettings.SettingValue); UserWallet.CashCredit += Convert.ToDecimal(Amount); UserWallet.TurnoverAmount += finalturnover; result = Models_General.SUCC_PAYMENT; } else { result = Models_General.ERR_PAYMENT; } _db.SaveChanges(); return(result); } catch (Exception ex) { var new_error = new LogErrorSystem { Title = "Back Response Deposit Payment Gateway", 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 AdminTopupApproval(string AdminID, long TopupSrno, bool ApproveStatus, string Remarks) { try { int result; var CurrentUserTopup = _db.MstTopUp.Where(x => x.Srno == TopupSrno && x.Status == 0).FirstOrDefault(); if (CurrentUserTopup != null) { var CurrentUserWallet = _db.MstUserWallet.Where(x => x.MemberSrno == CurrentUserTopup.MemberSrno).FirstOrDefault(); if (ApproveStatus) { var CurrentSettings = _db.MstSettings.Where(x => x.SettingName == "NormalTurnover").FirstOrDefault(); if (CurrentUserTopup.TransactionType == 0) { var user_topup_request_tracking = new LogUserTrackingWallet { MemberSrno = CurrentUserTopup.MemberSrno, WalletFrom = CurrentUserTopup.BankName + " " + CurrentUserTopup.BankAccountNumber + " " + CurrentUserTopup.BankAccountHolder + " with reference number " + CurrentUserTopup.TransactionReferenceNumber, WalletTo = "CASH WALLET", TransactionType = 0, PreviousAmount = CurrentUserWallet.CashCredit, TransactionAmount = (decimal)CurrentUserTopup.TopupAmount, CurrentTotalAmount = CurrentUserWallet.CashCredit + (decimal)CurrentUserTopup.TopupAmount, IsDeduct = false, Description = string.Format("ADMIN:{0} APPROVED THIS TOPUP SERIAL NUMBER:{1} AT:{2}", AdminID, CurrentUserTopup.Srno, DateTime.Now), CreatedDateTime = DateTime.Now, }; var log_topup = new LogTopup { MemberSrno = CurrentUserTopup.MemberSrno, WalletFrom = CurrentUserTopup.BankName + " " + CurrentUserTopup.BankAccountNumber + " " + CurrentUserTopup.BankAccountHolder + " with reference number " + CurrentUserTopup.TransactionReferenceNumber, WalletTo = "CASH WALLET", TransactionType = 0, PreviousAmount = CurrentUserWallet.CashCredit, TransactionAmount = (decimal)CurrentUserTopup.TopupAmount, CurrentTotalAmount = CurrentUserWallet.CashCredit + (decimal)CurrentUserTopup.TopupAmount, Description = string.Format("ADMIN:{0} APPROVED THIS TOPUP SERIAL NUMBER:{1} AT:{2}", AdminID, CurrentUserTopup.Srno, DateTime.Now), CreatedDateTime = DateTime.Now, }; _db.LogUserTrackingWallet.Add(user_topup_request_tracking); _db.LogTopup.Add(log_topup); result = Models_General.SUCC_ADMIN_APPROVE_TOPUP; } else if (CurrentUserTopup.TransactionType == 1) { var user_topup_request_tracking = new LogUserTrackingWallet { MemberSrno = CurrentUserTopup.MemberSrno, WalletFrom = "CRYPTO CURRENCY WITH TRANSACTION HASH" + CurrentUserTopup.TransactionHash, WalletTo = "CASH WALLET", TransactionType = 2, PreviousAmount = CurrentUserWallet.CashCredit, TransactionAmount = (decimal)CurrentUserTopup.TopupAmount, CurrentTotalAmount = CurrentUserWallet.CashCredit + (decimal)CurrentUserTopup.TopupAmount, IsDeduct = false, Description = string.Format("ADMIN:{0} APPROVED THIS TOPUP SERIAL NUMBER:{1} AT:{2}", AdminID, CurrentUserTopup.Srno, DateTime.Now), CreatedDateTime = DateTime.Now, }; var log_topup = new LogTopup { MemberSrno = CurrentUserTopup.MemberSrno, WalletFrom = "CRYPTO CURRENCY WITH TRANSACTION HASH" + CurrentUserTopup.TransactionHash, WalletTo = "CASH WALLET", TransactionType = 2, PreviousAmount = CurrentUserWallet.CashCredit, TransactionAmount = (decimal)CurrentUserTopup.TopupAmount, CurrentTotalAmount = CurrentUserWallet.CashCredit + (decimal)CurrentUserTopup.TopupAmount, Description = string.Format("ADMIN:{0} APPROVED THIS TOPUP SERIAL NUMBER:{1} AT:{2}", AdminID, CurrentUserTopup.Srno, DateTime.Now), CreatedDateTime = DateTime.Now, }; _db.LogUserTrackingWallet.Add(user_topup_request_tracking); _db.LogTopup.Add(log_topup); result = Models_General.SUCC_ADMIN_APPROVE_TOPUP; } else { result = Models_General.ERR_SERVER_BUSY_INTERNAL_ERROR; } decimal finalturnover = CurrentUserTopup.TopupAmount * int.Parse(CurrentSettings.SettingValue); CurrentUserTopup.Status = 1; CurrentUserTopup.ApproveBy = AdminID; CurrentUserTopup.ApproveDate = DateTime.Now; CurrentUserTopup.ApproveRemark = Remarks; CurrentUserWallet.CashCredit += CurrentUserTopup.TopupAmount; CurrentUserWallet.TurnoverAmount += finalturnover; } else { CurrentUserTopup.Status = 2; CurrentUserTopup.ApproveBy = AdminID; CurrentUserTopup.ApproveDate = DateTime.Now; CurrentUserTopup.ApproveRemark = Remarks; result = Models_General.SUCC_ADMIN_REJECT_TOPUP; } _db.SaveChanges(); return(result); } else { return(Models_General.ERR_SERVER_BUSY_INTERNAL_ERROR); } } catch (Exception ex) { var new_error = new LogErrorSystem { Title = "Admin Approve Topup", 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 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); } }