// 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.");
}
}
