private void button2_Click(object sender, EventArgs e)
{
var selectdAccountID = Convert.ToString(listBox1.SelectedItem);
if (listBox1.SelectedItem == null)
{
MessageBox.Show("Please select the account to withdraw from");
}
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.Withdraw(Convert.ToDouble(textBox2.Text), Convert.ToInt32(selectdAccountID));
//MessageBox.Show("Amount withdraw successfull!");
}
else if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "TFS")
{
Account A = new TaxFreeSavingsAccount();
A.Withdraw(Convert.ToDouble(textBox2.Text), Convert.ToInt32(selectdAccountID));
//MessageBox.Show("Amount withdraw successfull!");
}
else
{
MessageBox.Show("Amount could not be withdrawn!");
}
}
textBox2.Clear();
}
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 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 button2_Click(object sender, EventArgs e)
{
var selectdAccountID = Convert.ToString(listBox1.SelectedItem);
if (listBox1.SelectedItem == null)
{
MessageBox.Show("Please select the account to withdraw from");
}
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.Withdraw(Convert.ToDouble(textBox2.Text), Convert.ToInt32(selectdAccountID));
//MessageBox.Show("Amount withdraw successfull!");
}
else if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "TFS")
{
Account A = new TaxFreeSavingsAccount();
A.Withdraw(Convert.ToDouble(textBox2.Text), Convert.ToInt32(selectdAccountID));
//MessageBox.Show("Amount withdraw successfull!");
}
else
{
MessageBox.Show("Amount could not be withdrawn!");
}
}
textBox2.Clear();
}
private void button2_Click(object sender, EventArgs e)
{
if (CustomerAvailabilityCheck())
{
CustomerID = Convert.ToInt32(textBox1.Text);
//AccountID=0;
if (AccountType == "'CA'")
{
try
{
ChequingAccount A = new ChequingAccount();
bool flag = A.DoesChequingAccountExist(CustomerID);
if (flag == false)
{
AccountID = A.Create(AccountType, DateTime.Now, Convert.ToDouble(textBox2.Text));
UserDAO udao = new UserDAO();
udao.InsertData("use ApteanEdgeBank insert into CustomerAccount values(" + CustomerID + "," + AccountID + ")", UserDAO.connectionString);
MessageBox.Show("Account added successfully!");
}
else
{
MessageBox.Show("Chequing account for this cutomer already exists!");
}
}
catch(Exception ex)
{
MessageBox.Show("Check if the fields are filled properly!");
}
}
else if (AccountType == "'TFS'")
{
try
{
TaxFreeSavingsAccount A = new TaxFreeSavingsAccount();
bool flag = A.DoesTFSAccountExist(CustomerID);
if (flag == false)
{
AccountID = A.Create(AccountType, DateTime.Now, Convert.ToDouble(textBox2.Text));
UserDAO udao = new UserDAO();
udao.InsertData("use ApteanEdgeBank insert into CustomerAccount values(" + CustomerID + "," + AccountID + ")", UserDAO.connectionString);
MessageBox.Show("Account added successfully!");
}
else
{
MessageBox.Show("TFS account for this customer already exists!");
}
}
catch (Exception ex)
{
MessageBox.Show("Check if the fields are filled properly!"+ex);
}
}
else
{
MessageBox.Show("Not a Valid account Type");
}
/*initialBalance = textBox2.Text;
MessageBox.Show("Account Type is " + AccountType + "For Customer ID " + CustomerID + " With initial Balance " + initialBalance);
UserDAO udao = new UserDAO();
DataTable dataTable = new DataTable();
udao.InsertData("use ApteanEdgeBank insert into Account (AccountType,AccountBalance,DateOfOpening,DateOfClosing) values(" + AccountType + "," + initialBalance + "," + "cast(getdate() as date),null)", UserDAO.connectionString);
dataTable = udao.GetData("use ApteanEdgeBank select max(AccountID) as max from Account", UserDAO.connectionString);
AccountID = Convert.ToString(dataTable.Rows[0]["max"]);*/
}
else
{
MessageBox.Show("Customer Not Fount, Please Create Customer First");
}
}
private void button2_Click(object sender, EventArgs e)
{
if (CustomerAvailabilityCheck())
{
CustomerID = Convert.ToInt32(textBox1.Text);
//AccountID=0;
if (AccountType == "'CA'")
{
try
{
ChequingAccount A = new ChequingAccount();
bool flag = A.DoesChequingAccountExist(CustomerID);
if (flag == false)
{
AccountID = A.Create(AccountType, DateTime.Now, Convert.ToDouble(textBox2.Text));
UserDAO udao = new UserDAO();
udao.InsertData("use ApteanEdgeBank insert into CustomerAccount values(" + CustomerID + "," + AccountID + ")", UserDAO.connectionString);
MessageBox.Show("Account added successfully!");
}
else
{
MessageBox.Show("Chequing account for this cutomer already exists!");
}
}
catch (Exception ex)
{
MessageBox.Show("Check if the fields are filled properly!");
}
}
else if (AccountType == "'TFS'")
{
try
{
TaxFreeSavingsAccount A = new TaxFreeSavingsAccount();
bool flag = A.DoesTFSAccountExist(CustomerID);
if (flag == false)
{
AccountID = A.Create(AccountType, DateTime.Now, Convert.ToDouble(textBox2.Text));
UserDAO udao = new UserDAO();
udao.InsertData("use ApteanEdgeBank insert into CustomerAccount values(" + CustomerID + "," + AccountID + ")", UserDAO.connectionString);
MessageBox.Show("Account added successfully!");
}
else
{
MessageBox.Show("TFS account for this customer already exists!");
}
}
catch (Exception ex)
{
MessageBox.Show("Check if the fields are filled properly!" + ex);
}
}
else
{
MessageBox.Show("Not a Valid account Type");
}
/*initialBalance = textBox2.Text;
*
* MessageBox.Show("Account Type is " + AccountType + "For Customer ID " + CustomerID + " With initial Balance " + initialBalance);
* UserDAO udao = new UserDAO();
* DataTable dataTable = new DataTable();
* udao.InsertData("use ApteanEdgeBank insert into Account (AccountType,AccountBalance,DateOfOpening,DateOfClosing) values(" + AccountType + "," + initialBalance + "," + "cast(getdate() as date),null)", UserDAO.connectionString);
* dataTable = udao.GetData("use ApteanEdgeBank select max(AccountID) as max from Account", UserDAO.connectionString);
* AccountID = Convert.ToString(dataTable.Rows[0]["max"]);*/
}
else
{
MessageBox.Show("Customer Not Fount, Please Create Customer First");
}
}