private void button1_Click(object sender, EventArgs e)
{
AccountActivityLedger Ledger = new AccountActivityLedger();
double accountBalance = Ledger.CalculateAccountBalance(Convert.ToInt32(textBox1.Text));
label2.Text = label2.Text + Convert.ToString(accountBalance);
}
public void Withdraw(double amount,int accID)
{
UserDAO dao=new UserDAO();
DataTable dt=new DataTable();
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
dt=dao.GetData("Select AccountBalance from Account where AccountID="+accID,connectionstring);
Balance=Convert.ToDouble(dt.Rows[0]["AccountBalance"]);
Balance = Balance - amount;
if (Balance > 0)
{
string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID="+accID;
//UserDAO dao = new UserDAO();
bg.BgaWithdraw(amount);
dao.UpdateData(myQuery, connectionstring);
AccountActivityLedger Ledger = new AccountActivityLedger();
Ledger.AddAccountActivity(accID, "Withdraw",amount, DateTime.Now);
MessageBox.Show("Amount withdraw Successful!");
}
//string myQuery="up
else
MessageBox.Show("Your balance is too low!");
}
public void Withdraw(double amount, int accID)
{
UserDAO dao = new UserDAO();
DataTable dt = new DataTable();
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
dt = dao.GetData("Select AccountBalance from Account where AccountID=" + accID, connectionstring);
Balance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]);
Balance = Balance - amount;
if (Balance > 0)
{
string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID=" + accID;
//UserDAO dao = new UserDAO();
bg.BgaWithdraw(amount);
dao.UpdateData(myQuery, connectionstring);
AccountActivityLedger Ledger = new AccountActivityLedger();
Ledger.AddAccountActivity(accID, "Withdraw", amount, DateTime.Now);
MessageBox.Show("Amount withdraw Successful!");
}
//string myQuery="up
else
{
MessageBox.Show("Your balance is too low!");
}
}
public override void Deposit(double amount, int accID)
{
UserDAO dao = new UserDAO();
DataTable dt = new DataTable();
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
dt = dao.GetData("Select AccountBalance from Account where AccountID=" + accID, connectionstring);
Balance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]);
if ((Balance + amount) <= 5000)
{
Balance = Balance + amount;
string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID=" + accID;
//UserDAO dao = new UserDAO();
dao.UpdateData(myQuery, connectionstring);
bg.BgaDeposit(amount);
AccountActivityLedger Ledger = new AccountActivityLedger();
Ledger.AddAccountActivity(accID, "Deposit", amount, DateTime.Now);
MessageBox.Show("Amount deposited successfully!");
}
else
{
MessageBox.Show("Balance greater than limit!");
}
}
private void button2_Click(object sender, EventArgs e)
{
var selectdAccountID = Convert.ToString(listBox1.SelectedItem);
if (listBox1.SelectedItem == null)
{
MessageBox.Show("Please select the account in which to be Deposited");
}
else
{
/*dataAccess.InsertData(@"use ApteanEdgeBank update Account
* set AccountBalance=AccountBalance+"+Convert.ToString(textBox1.Text)+@"where AccountID =" + selectdAccountID, UserDAO.connectionString);*/
if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "CA")
{
Account A = new ChequingAccount();
A.Deposit(Convert.ToDouble(textBox1.Text), Convert.ToInt32(selectdAccountID));
AccountActivityLedger Ledger = new AccountActivityLedger();
double newBalance = Ledger.CalculateAccountBalance(Convert.ToInt32(selectdAccountID));
label4.Text = "Balance: $" + Convert.ToString(newBalance);
MessageBox.Show("Amount deposited successfully!");
}
else if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "TFS")
{
Account A = new TaxFreeSavingsAccount();
A.Deposit(Convert.ToDouble(textBox1.Text), Convert.ToInt32(selectdAccountID));
//MessageBox.Show("Amount deposited successfully!");
}
else
{
MessageBox.Show("Amount could not be deposited");
}
}
textBox1.Clear();
}
private void button1_Click(object sender, EventArgs e)
{
AccountActivityLedger Ledger = new AccountActivityLedger();
DataTable activityLog = new DataTable();
activityLog = Ledger.ReadAccountActivity(Convert.ToInt32(textBox1.Text));
dataGridView1.DataSource = bindingSource1;
bindingSource1.DataSource = activityLog;
if (activityLog.Rows.Count <= 0)
{
MessageBox.Show("No Records found!");
}
}
private void button1_Click(object sender, EventArgs e)
{
AccountActivityLedger Ledger = new AccountActivityLedger();
DataTable activityLog = new DataTable();
activityLog = Ledger.ReadAccountActivity(Convert.ToInt32(textBox1.Text));
dataGridView1.DataSource = bindingSource1;
bindingSource1.DataSource = activityLog;
if (activityLog.Rows.Count <= 0)
{
MessageBox.Show("No Records found!");
}
}
public override void Deposit(double amount, int accId)
{
UserDAO dao = new UserDAO();
DataTable dt = new DataTable();
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
dt = dao.GetData("Select AccountBalance from Account where AccountID=" + accId, connectionstring);
Balance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]);
Balance = Balance + amount;
string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID=" + accId;
//UserDAO dao = new UserDAO();
dao.UpdateData(myQuery, connectionstring);
bg.BgaDeposit(amount);
AccountActivityLedger Ledger = new AccountActivityLedger();
Ledger.AddAccountActivity(accId, "Deposit", amount, DateTime.Now);
}
private void button1_Click(object sender, EventArgs e)
{
AccountActivityLedger Ledger = new AccountActivityLedger();
double accountBalance = Ledger.CalculateAccountBalance(Convert.ToInt32(textBox1.Text));
label2.Text = label2.Text + Convert.ToString(accountBalance);
}
private void button2_Click(object sender, EventArgs e)
{
var selectdAccountID = Convert.ToString(listBox1.SelectedItem);
if (listBox1.SelectedItem == null)
{
MessageBox.Show("Please select the account in which to be Deposited");
}
else
{
/*dataAccess.InsertData(@"use ApteanEdgeBank update Account
set AccountBalance=AccountBalance+"+Convert.ToString(textBox1.Text)+@"where AccountID =" + selectdAccountID, UserDAO.connectionString);*/
if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "CA")
{
Account A = new ChequingAccount();
A.Deposit(Convert.ToDouble(textBox1.Text), Convert.ToInt32(selectdAccountID));
AccountActivityLedger Ledger = new AccountActivityLedger();
double newBalance = Ledger.CalculateAccountBalance(Convert.ToInt32(selectdAccountID));
label4.Text = "Balance: $" + Convert.ToString(newBalance);
MessageBox.Show("Amount deposited successfully!");
}
else if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "TFS")
{
Account A = new TaxFreeSavingsAccount();
A.Deposit(Convert.ToDouble(textBox1.Text), Convert.ToInt32(selectdAccountID));
//MessageBox.Show("Amount deposited successfully!");
}
else
{
MessageBox.Show("Amount could not be deposited");
}
}
textBox1.Clear();
}
public override void Deposit(double amount,int accID)
{
UserDAO dao = new UserDAO();
DataTable dt = new DataTable();
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
dt = dao.GetData("Select AccountBalance from Account where AccountID=" + accID, connectionstring);
Balance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]);
if ((Balance + amount) <= 5000)
{
Balance = Balance + amount;
string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID="+accID;
//UserDAO dao = new UserDAO();
dao.UpdateData(myQuery, connectionstring);
bg.BgaDeposit(amount);
AccountActivityLedger Ledger = new AccountActivityLedger();
Ledger.AddAccountActivity(accID, "Deposit", amount, DateTime.Now);
MessageBox.Show("Amount deposited successfully!");
}
else
{
MessageBox.Show("Balance greater than limit!");
}
}
public override void Deposit(double amount,int accId)
{
UserDAO dao=new UserDAO();
DataTable dt=new DataTable();
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
dt=dao.GetData("Select AccountBalance from Account where AccountID="+accId,connectionstring);
Balance=Convert.ToDouble(dt.Rows[0]["AccountBalance"]);
Balance=Balance+amount;
string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID="+accId;
//UserDAO dao = new UserDAO();
dao.UpdateData(myQuery, connectionstring);
bg.BgaDeposit(amount);
AccountActivityLedger Ledger = new AccountActivityLedger();
Ledger.AddAccountActivity(accId, "Deposit", amount, DateTime.Now);
}
