public void AddContactNumber(string ContactNumber)
{
DataTable temp = new DataTable();
UserDAO dataAccess = new UserDAO();
Int64? customerID = null;
string query = "use ApteanEdgeBank select * from Customer";
temp = dataAccess.GetData(query, UserDAO.connectionString);
int i = 0;
for (; i < (temp.Rows.Count); i++)
{
if (firstName == (string)temp.Rows[i]["FirstName"] && lastName == (string)temp.Rows[i]["LastName"] && dateOfBirth.ToString() == Convert.ToString(temp.Rows[i]["DateOfBirth"]))
{
customerID = (Int64)temp.Rows[i]["CustomerID"]; break;
}
else
{
continue;
}
}
if (customerID != null)
{
dataAccess.InsertData("use ApteanEdgeBank insert into CustomerContact (CustomerID) values(" + customerID + ")", UserDAO.connectionString);
}
else
{
System.Windows.Forms.MessageBox.Show("Fatal Error: Customer ID not generated ");
}
temp.Clear();
temp = dataAccess.GetData("use ApteanEdgeBank select * from CustomerContact", UserDAO.connectionString);
i = 0;
for (; i < (temp.Rows.Count); i++)
{
if (customerID == (Int64)temp.Rows[i]["CustomerID"])
{
ContactID = temp.Rows[i]["CustomerContactID"].ToString(); break;
}
else
{
continue;
}
}
if (ContactID != null)
{
// System.Windows.Forms.MessageBox.Show(ContactID);
dataAccess.InsertData("use ApteanEdgeBank insert into CustomerContactDetails (CustomerContactID,CustomerContactNumber) values(" + ContactID + "," + ContactNumber + ")", UserDAO.connectionString);
}
else
{
System.Windows.Forms.MessageBox.Show("Fatal Error: Contact ID not generated");
}
}
private void button1_Click(object sender, EventArgs e)
{
int years = DateTime.Now.Year - DateTime.Parse(dateOfBirthBox.Text.ToString()).Year;
if (checkBox1.Checked == true)
{
years = 18;
}
// MessageBox.Show(years.ToString());
if (years < 18)
{
}
else
{
validFlag = true;
}
firstName = firstNameBox.Text;
middleName = midddleNameBox.Text;
lastName = lastNameBox.Text;
dateOfBirth = dateOfBirthBox.Text;
if (validFlag == true)
{
dataAccess.InsertData(@"use ApteanEdgeBank
update Customer
set FirstName='" + firstName + "'," + "MiddleName='" + middleName + "',LastName='" + lastName + "',DateOfBirth='" + dateOfBirth + "'" +
"where CustomerID=" + customerID, UserDAO.connectionString);
MessageBox.Show("Cutomer ID:" + customerID + " updated successfully");
}
else
{
MessageBox.Show("Invalid Date of Birth");
}
}
public void AddContactNumber(string ContactNumber)
{
DataTable temp = new DataTable();
UserDAO dataAccess = new UserDAO();
Int64? customerID=null;
string query = "use ApteanEdgeBank select * from Customer";
temp = dataAccess.GetData(query, UserDAO.connectionString);
int i = 0;
for (; i < (temp.Rows.Count); i++)
{
if (firstName == (string)temp.Rows[i]["FirstName"] && lastName == (string)temp.Rows[i]["LastName"] && middleName == (string)temp.Rows[i]["MiddleName"] && dateOfBirth.ToString() == Convert.ToString(temp.Rows[i]["DateOfBirth"]))
{ customerID = (Int64)temp.Rows[i]["CustomerID"]; break; }
else
continue;
}
if (customerID != null)
{
dataAccess.InsertData("use ApteanEdgeBank insert into CustomerContact (CustomerID) values(" + customerID + ")", UserDAO.connectionString);
}
else
{
System.Windows.Forms.MessageBox.Show("Fatal Error: Customer ID not generated ");
}
temp.Clear();
temp = dataAccess.GetData("use ApteanEdgeBank select * from CustomerContact",UserDAO.connectionString);
i = 0;
for (; i < (temp.Rows.Count); i++)
{
if (customerID == (Int64)temp.Rows[i]["CustomerID"])
{ ContactID = temp.Rows[i]["CustomerContactID"].ToString(); break; }
else
continue;
}
if (ContactID != null)
{
// System.Windows.Forms.MessageBox.Show(ContactID);
dataAccess.InsertData("use ApteanEdgeBank insert into CustomerContactDetails (CustomerContactID,CustomerContactNumber) values(" + ContactID + "," + ContactNumber + ")", UserDAO.connectionString);
}
else
System.Windows.Forms.MessageBox.Show("Fatal Error: Contact ID not generated");
}
private void button2_Click(object sender, EventArgs e)
{
if (CustomerAvailabilityCheck())
{
CustomerID = textBox1.Text;
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"]);
udao.InsertData("use ApteanEdgeBank insert into CustomerAccount values(" + CustomerID + "," + AccountID + ")", UserDAO.connectionString);
}
else
{
MessageBox.Show("Customer Not Fount, Please Create Customer First");
}
}
public void AddContactNumber2(string ContactNumber2)
{
UserDAO dataAccess = new UserDAO();
if (ContactID != null)
{
// System.Windows.Forms.MessageBox.Show(ContactID);
dataAccess.InsertData("use ApteanEdgeBank insert into CustomerContactDetails (CustomerContactID,CustomerContactNumber) values(" + ContactID + "," + ContactNumber2 + ")", UserDAO.connectionString);
}
else
{
System.Windows.Forms.MessageBox.Show("Fatal Error: Contact ID not generated");
}
}
public void AddAccountActivity(int accID, string transType, double amount, DateTime transDate)
{
UserDAO dao = new UserDAO();
string myQuery = "insert into AccountActivityLedger values(" + accID + "," + "'" + transDate + "'" + "," + "'" + transType + "'" + "," + amount + ")";
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
// if (CheckAccountExistence(accID))
//{
dao.InsertData(myQuery, connectionstring);
//}
/* else
{
MessageBox.Show("Account Does not exist!");
}*/
}
public static void Close(int accId)
{
UserDAO dao=new UserDAO();
DataTable dt=new DataTable();
BankGeneralAccount bg = new BankGeneralAccount();
string queryString="Select * from Account where AccountID="+accId;
try
{
/*Balance = 0;
dateClosed = DateTime.Now;
Console.WriteLine("Account closed on {0}", dateClosed.ToShortDateString());*/
dt = dao.GetData(queryString, UserDAO.connectionString);
if (Convert.ToDouble(dt.Rows[0]["AccountBalance"]) != 0.0)
{
DialogResult result= MessageBox.Show("Your account balance is greater than 0! The balance must be 0 to close an account. Would you like to clear your account balance?","Account Balance is not 0!",MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
//set closing date for the account. Deduct the remaining balance from bank general account and set the current balance to 0
dao.InsertData(@"use ApteanEdgeBank update Account
set DateOfClosing= cast(getdate() as date)
where AccountID =" + accId, UserDAO.connectionString);
bg.BgaWithdraw(Convert.ToDouble(dt.Rows[0]["AccountBalance"]));
dao.UpdateData("update Account set AccountBalance=0 where AccountID=" + accId, UserDAO.connectionString);
}
}
else
{
dao.InsertData(@"use ApteanEdgeBank update Account
set DateOfClosing= cast(getdate() as date)
where AccountID =" + accId, UserDAO.connectionString);
}
}
catch (InvalidOperationException e)
{
MessageBox.Show("Account closure failed!");
}
}
//constructor
public void AddNewCutomer(string firstNameP, string lastNameP, DateTime dateOfBirthP)
{
firstName = firstNameP;
//middleName = middleNameP;
lastName = lastNameP;
dateOfBirth = dateOfBirthP.Date;
dateOfJoining = DateTime.Now.Date;
UserDAO dbAccess = new UserDAO();
string myQuery = @"use ApteanEdgeBank insert into Customer (FirstName,LastName,DateOfJoining,DateOfBirth) values('" + firstNameP + "'" + "," + "'" + lastNameP + "'" + "," + "cast(getdate() as date)" + "," + "'" + dateOfBirth.Date.ToShortDateString() + "')";
// System.Windows.Forms.MessageBox.Show(myQuery);
dbAccess.InsertData(myQuery, UserDAO.connectionString);
//System.Windows.Forms.MessageBox.Show(myQuery);
System.Windows.Forms.MessageBox.Show("Customer Added successfully");
}
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 be ReOpened");
}
else
{
dataAccess.InsertData(@"use ApteanEdgeBank update Account
set DateOfClosing=null
where AccountID =" + selectdAccountID, UserDAO.connectionString);
}
listBox1.Items.RemoveAt(listBox1.SelectedIndex);
}
public void AddAccountActivity(int accID, string transType, double amount, DateTime transDate)
{
UserDAO dao = new UserDAO();
string myQuery = "insert into AccountActivityLedger values(" + accID + "," + "'" + transDate + "'" + "," + "'" + transType + "'" + "," + amount + ")";
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
// if (CheckAccountExistence(accID))
//{
dao.InsertData(myQuery, connectionstring);
//}
/* else
* {
* MessageBox.Show("Account Does not exist!");
* }*/
}
public void AddAccountActivity(int accID, string transType, double amount, DateTime transDate)
{
UserDAO dao = new UserDAO();
string queryFetch = "Select * from Account where AccountID=" + accID;
DataTable dt = new DataTable();
dt = dao.GetData(queryFetch, UserDAO.connectionString);
double closingBalance=Convert.ToDouble(dt.Rows[0]["AccountBalance"]);
string myQuery = "insert into AccountActivityLedger values(" + accID + "," + "'" + transDate + "'" + "," + "'" + transType + "'" + "," + amount + ","+closingBalance+")";
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
// if (CheckAccountExistence(accID))
//{
dao.InsertData(myQuery, connectionstring);
//}
/* else
{
MessageBox.Show("Account Does not exist!");
}*/
}
public static void Reopen(int accId,double reopeningBalance)
{
UserDAO dao = new UserDAO();
DataTable dt = new DataTable();
BankGeneralAccount bg = new BankGeneralAccount();
string queryString = "Select * from Account where AccountID=" + accId;
try
{
dao.InsertData(@"use ApteanEdgeBank update Account
set DateOfClosing=null
where AccountID =" + accId, UserDAO.connectionString);
dao.UpdateData("update Account set AccountBalance=" + reopeningBalance + "where AccountID=" + accId, UserDAO.connectionString);
bg.BgaDeposit(reopeningBalance);
}
catch (InvalidOperationException e)
{
MessageBox.Show("Account reopen failed!");
}
}
public override int Create(string accType, DateTime open, double balance)
{
/* accountID=ID;
* dateOpened=open;
* Balance=balance;
* Console.WriteLine("Chequing Acoount:");
* Console.WriteLine("Account ID:{0}\nDate Opened:{1}\nBalance:{2}", accountID, dateOpened, Balance);*/
string myQuery = "insert into Account values(" + accType + "," + balance + "," + "'" + open + "'" + "," + "null" + ")";
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
UserDAO dao = new UserDAO();
dao.InsertData(myQuery, connectionstring);
bg.BgaDeposit(balance);
DataTable dataTable = dao.GetData("use ApteanEdgeBank select max(AccountID) as max from Account", UserDAO.connectionString);
int AccountID = Convert.ToInt32(dataTable.Rows[0]["max"]);
return(AccountID);
//dao.InsertData("use ApteanEdgeBank insert into CustomerAccount values(" + CustomerID + "," + AccountID + ")", UserDAO.connectionString);
}
public override int Create(string accType, DateTime open, double balance)
{
if (balance <= Limit)
{
dateOpened = open;
Balance = balance;
string myQuery = "insert into Account values(" + accType + "," + balance + "," + "'" + open + "'" + "," + "null" + ")";
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
UserDAO dao = new UserDAO();
dao.InsertData(myQuery, connectionstring);
bg.BgaDeposit(balance);
DataTable dataTable = dao.GetData("use ApteanEdgeBank select max(AccountID) as max from Account", UserDAO.connectionString);
int AccountID = Convert.ToInt32(dataTable.Rows[0]["max"]);
return(AccountID);
}
else
{
MessageBox.Show("Balance is greater than limit!");
return(0);
}
}
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");
}
}
//constructor
public void AddNewCutomer(string firstNameP, string middleNameP, string lastNameP,DateTime dateOfBirthP)
{
firstName = firstNameP;
middleName = middleNameP;
lastName = lastNameP;
dateOfBirth = dateOfBirthP.Date;
dateOfJoining = DateTime.Now.Date;
UserDAO dbAccess = new UserDAO();
string myQuery = @"use ApteanEdgeBank insert into Customer (FirstName,MiddleName,LastName,DateOfJoining,DateOfBirth) values('" + firstNameP + "'" + "," + "'" + middleName + "'" + "," + "'" + lastNameP + "'" + "," + "cast(getdate() as date)" + "," + "'" + dateOfBirth.Date.ToShortDateString() + "')" ;
// System.Windows.Forms.MessageBox.Show(myQuery);
dbAccess.InsertData(myQuery, UserDAO.connectionString);
//System.Windows.Forms.MessageBox.Show(myQuery);
System.Windows.Forms.MessageBox.Show("Customer Added successfully");
}
public void AddContactNumber2(string ContactNumber2)
{
UserDAO dataAccess = new UserDAO();
if (ContactID != null)
{
// System.Windows.Forms.MessageBox.Show(ContactID);
dataAccess.InsertData("use ApteanEdgeBank insert into CustomerContactDetails (CustomerContactID,CustomerContactNumber) values(" + ContactID + "," + ContactNumber2 + ")", UserDAO.connectionString);
}
else
System.Windows.Forms.MessageBox.Show("Fatal Error: Contact ID not generated");
}
public override int Create(string accType,DateTime open,double balance)
{
/* accountID=ID;
dateOpened=open;
Balance=balance;
Console.WriteLine("Chequing Acoount:");
Console.WriteLine("Account ID:{0}\nDate Opened:{1}\nBalance:{2}", accountID, dateOpened, Balance);*/
string myQuery = "insert into Account values("+accType+","+balance+","+"'"+open+"'"+","+"null"+")";
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
UserDAO dao = new UserDAO();
dao.InsertData(myQuery, connectionstring);
bg.BgaDeposit(balance);
DataTable dataTable = dao.GetData("use ApteanEdgeBank select max(AccountID) as max from Account", UserDAO.connectionString);
int AccountID = Convert.ToInt32(dataTable.Rows[0]["max"]);
return AccountID;
//dao.InsertData("use ApteanEdgeBank insert into CustomerAccount values(" + CustomerID + "," + AccountID + ")", UserDAO.connectionString);
}
public override int Create(string accType,DateTime open,double balance)
{
if (balance <= Limit)
{
dateOpened = open;
Balance = balance;
string myQuery = "insert into Account values(" + accType + "," + balance + "," + "'" + open + "'" + "," + "null" + ")";
string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123";
BankGeneralAccount bg = new BankGeneralAccount();
UserDAO dao = new UserDAO();
dao.InsertData(myQuery, connectionstring);
bg.BgaDeposit(balance);
DataTable dataTable = dao.GetData("use ApteanEdgeBank select max(AccountID) as max from Account", UserDAO.connectionString);
int AccountID = Convert.ToInt32(dataTable.Rows[0]["max"]);
return AccountID;
}
else
{
MessageBox.Show("Balance is greater than limit!");
return 0;
}
}