public static void Deposit(ref Transaction T)
{
string[] Transaction = { "transactionid ", "Transaction" };
OracleConnection conn = new OracleConnection(DBConnect.oradb);
conn.Open();
T.TransactionID = Reusable.GetNextId(Transaction).ToString("D14");
T.timestamp = DateTime.Now.ToString("dd/MM/yyyy/HH:mm:ss");
String CustSQL = "INSERT INTO Transaction(transactionid,accountid,Type,amount,note,timestamp) " +
"VALUES('" + T.TransactionID + "', '" + T.account + "', '" + T.type + "', '" + T.amount + "', '" + T.note + "', TO_DATE('" + T.timestamp + "', 'DD/MM/YYYY HH24:MI:SS'))";
OracleCommand Custcmd = new OracleCommand(CustSQL, conn);
Custcmd.ExecuteNonQuery();
string[] findbalance = { "balance", "account where accountid = " + T.account };
string balance = Reusable.stringfromDB(findbalance);
decimal d1 = decimal.Parse(balance);
decimal d2 = decimal.Parse(T.amount);
string newbalance = (d1 + d2).ToString("F2");
String LogSQL = "UPDATE Account SET BALANCE = '" + newbalance + "' where accountid = " + T.account;
OracleCommand Logcmd = new OracleCommand(LogSQL, conn);
Logcmd.ExecuteNonQuery();
conn.Close();
}
public static void AddUser()
{
string[] Cust = { "Customerid", "Customer" };
string[] Log = { "Loginid", "Login" };
OracleConnection conn = new OracleConnection(DBConnect.oradb);
conn.Open();
Customer.CustomerId = Reusable.GetNextId(Cust).ToString("D8");
String CustSQL = "INSERT INTO Customer(Customerid,first_name,last_name,pps_number,country_code,phone_number,date_of_birth,address_line_1,address_line_2,address_line_3,town,county,eircode,date_created) " +
"VALUES('" + Customer.CustomerId + "', '" + Customer.Fname + "', '" + Customer.Lname + "', '" + Customer.PPSNo + "', '" + Customer.CountryCode + "', '" + Customer.PhoneNo + "', TO_DATE('" + Customer.DOB + "', 'DD/MM/YYYY'), '" + Customer.AddressL1 + "', '" + Customer.AddressL2 + "', '" + Customer.AddressL3 + "', '" + Customer.Town + "', '" + Customer.County + "', '" + Customer.Eir + "', TO_DATE('" + Customer.DateCreated + "', 'DD/MM/YYYY'))";
OracleCommand Custcmd = new OracleCommand(CustSQL, conn);
Custcmd.ExecuteNonQuery();
string LogId = Reusable.GetNextId(Log).ToString("D8");
String LogSQL = "INSERT INTO Login(Loginid,Customerid,pac) " +
"VALUES('" + LogId + "', '" + Customer.CustomerId + "', '" + Customer.PAC + "')";
OracleCommand Logcmd = new OracleCommand(LogSQL, conn);
Logcmd.ExecuteNonQuery();
conn.Close();
}
public static void AddAccount(ref Account A)
{
string[] Acc = { "Accountid", "Account" };
OracleConnection conn = new OracleConnection(DBConnect.oradb);
conn.Open();
A.AccountId = Reusable.GetNextId(Acc).ToString("D9");
String CustSQL = "INSERT INTO Account(AccountID,Customerid,name,type,Date_created) " +
"VALUES('" + A.AccountId + "', '" + Customer.CustomerId + "', '" + A.Name + "', '" + A.Type + "', TO_DATE('" + A.Creation + "', 'DD/MM/YYYY'))";
OracleCommand Custcmd = new OracleCommand(CustSQL, conn);
Custcmd.ExecuteNonQuery();
conn.Close();
}
public static void Transfer(ref Transaction T)
{
string[] Transaction = { "transactionid ", "Transaction" };
OracleConnection conn = new OracleConnection(DBConnect.oradb);
conn.Open();
T.TransactionID = Reusable.GetNextId(Transaction).ToString("D14");
T.timestamp = DateTime.Now.ToString("dd/MM/yyyy/HH:mm:ss");
String transferSQL = "INSERT INTO Transaction(transactionid,accountid,Type,amount,note,timestamp) " +
"VALUES('" + T.TransactionID + "', '" + T.account + "', '" + T.type + "', '" + T.amount + "', '" + T.note + "', TO_DATE('" + T.timestamp + "', 'DD/MM/YYYY HH24:MI:SS'))";
OracleCommand Transfercmd = new OracleCommand(transferSQL, conn);
Transfercmd.ExecuteNonQuery();
string[] creditorarr = { "balance", "account where accountid = " + T.account };
string[] debtorarr = { "balance", "account where accountid = " + T.debtor };
string creditorbal = Reusable.stringfromDB(creditorarr);
string debtorbal = Reusable.stringfromDB(debtorarr);
decimal Cbal = decimal.Parse(creditorbal);
decimal amount = decimal.Parse(T.amount);
decimal Dbal = decimal.Parse(debtorbal);
string newCreditorbal = (Cbal - amount).ToString("F2");
string newDebtorbal = (Dbal + amount).ToString("F2");
String removebal = "UPDATE Account SET BALANCE = '" + newCreditorbal + "' where accountid = " + T.account;
String addbal = "UPDATE Account SET BALANCE = '" + newDebtorbal + "' where accountid = " + T.debtor;
OracleCommand removebalance = new OracleCommand(removebal, conn);
removebalance.ExecuteNonQuery();
OracleCommand addbalance = new OracleCommand(addbal, conn);
addbalance.ExecuteNonQuery();
conn.Close();
}
