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(); }