// Lấy về l public List <YYTransactionHistory> queryHistory(String anumber) { List <YYTransactionHistory> list = new List <YYTransactionHistory>(); DbConnection.Instance().OpenConnection(); var query = "select * from `thistory` where accountNumber = @accountNumber"; MySqlCommand cmd = new MySqlCommand(query, DbConnection.Instance().Connection); cmd.Parameters.AddWithValue("@accountNumber", anumber); var reader = cmd.ExecuteReader(); while (reader.Read()) { YYTransactionHistory th = new YYTransactionHistory(); th.Id = reader.GetInt16(reader.GetOrdinal("id")); th.AccountNumber = reader.GetString(reader.GetOrdinal("accountNumber")); th.Type = reader.GetInt16(reader.GetOrdinal("type")); th.Amount = reader.GetDecimal(reader.GetOrdinal("amount")); th.TradingAcountNumber = reader.GetString(reader.GetOrdinal("tradingAcountNumber")); th.CreatedDate = reader.GetString(reader.GetOrdinal("createdDate")); list.Add(th); } return(list); }
public void WithdrawalBalance(String anumber) { int limit = 50000; var amountTotal = _model.GetByAccountNumber(anumber); if (amountTotal.Balance <= limit) { Console.WriteLine("The amount in the account must be over 50000 (VNĐ)"); } else { YYTransactionHistory h = new YYTransactionHistory(); Console.WriteLine("Please enter the amount you need to withdraw"); decimal amount = Decimal.Parse(Console.ReadLine()); if ((amountTotal.Balance - amount) < limit) { Console.WriteLine("The amount you can withdraw is currently: " + (amountTotal.Balance - 60000) + "\nPlease retype"); } else { _model.WithdrawalBalance(amount, anumber); h.AccountNumber = anumber; h.Type = 1; h.Amount = amount; h.TradingAcountNumber = "1"; _history.HinsertBalance(h); Console.WriteLine("The amount you have withdrawn is " + amount + " (VNĐ)"); } } }
// Thêm vào lịch sử giáo dịch public Boolean HinsertBalance(YYTransactionHistory h) { DbConnection.Instance().OpenConnection(); var hinsertBalance = "insert into `thistory`(accountNumber,type,amount,tradingAcountNumber) values (" + "@accountNumber,@type,@amount,@tradingAcountNumber)"; MySqlCommand cmd = new MySqlCommand(hinsertBalance, DbConnection.Instance().Connection); cmd.Parameters.AddWithValue("@accountNumber", h.AccountNumber); cmd.Parameters.AddWithValue("@type", h.Type); cmd.Parameters.AddWithValue("@amount", h.Amount); cmd.Parameters.AddWithValue("@tradingAcountNumber", h.TradingAcountNumber); cmd.ExecuteNonQuery(); DbConnection.Instance().CloseConnection(); return(true); }
public void DepositBalance(String anumber) { YYTransactionHistory h = new YYTransactionHistory(); Console.WriteLine("Please enter input amount to send account."); decimal amount = Decimal.Parse(Console.ReadLine()); _model.DepositBalance(amount, anumber); h.AccountNumber = anumber; h.Type = 2; h.Amount = amount; h.TradingAcountNumber = "1"; _history.HinsertBalance(h); Console.WriteLine("You just load your account with the amount " + amount + " (VNĐ)"); }
public void Trasaction(String anumber) { YYTransaction tr = new YYTransaction(); YYTransactionHistory th1 = new YYTransactionHistory(); YYTransactionHistory th2 = new YYTransactionHistory(); Console.WriteLine("Please enter import amount to transfer: "); tr.Amount = Decimal.Parse(Console.ReadLine()); Console.WriteLine("Please enter content: "); tr.Content = Console.ReadLine(); tr.SenderAccountNumber = anumber; Console.WriteLine("Please enter receiver account number"); tr.ReceiverAccountNumber = Console.ReadLine(); var checkAc = _model.GetByAccountNumber(tr.ReceiverAccountNumber); String rac = checkAc.AccountNumber; if (rac.Equals(tr.ReceiverAccountNumber)) { Console.WriteLine("Please enter type: "); tr.Type = Int32.Parse(Console.ReadLine()); Console.WriteLine("Please enter status: "); tr.Status = Int32.Parse(Console.ReadLine()); _tras.SaveTransaction(tr); _model.WithdrawalBalance(tr.Amount, anumber); _model.DepositBalance(tr.Amount, tr.ReceiverAccountNumber); th1.AccountNumber = anumber; th1.Type = 3; th1.Amount = tr.Amount; th1.TradingAcountNumber = tr.ReceiverAccountNumber; th2.AccountNumber = tr.ReceiverAccountNumber; th2.Type = 3; th2.Amount = tr.Amount; th2.TradingAcountNumber = anumber; _history.HinsertBalance(th1); _history.HinsertBalance(th2); } else { Console.WriteLine("This account does not exist."); } }