public void CreateSavingAccount(int client_id, decimal amount, decimal ceiling) { DateTime openingDate = DateTime.Now; if (amount <= ceiling) { string queryString = $"INSERT INTO SavingAccounts (client_id, amount, rate, ceiling, openingDate) " + $"VALUES ({client_id}, {amount}, {Interest}, {ceiling},'{openingDate}');"; ConnectionDB.NonQuerySQL(queryString); string queryStringID = $"SELECT id FROM CurrentAccounts WHERE client_id={client_id};"; int currentAccountId = ConnectionDB.ReturnID(queryStringID); string queryStringAddInDonator = $"Declare @ClientId int " + $"SELECT @ClientId = client_id FROM Donator WHERE client_id = {client_id} " + $"IF(@ClientId IS NULL) " + $"BEGIN " + $"INSERT INTO Donator(client_id, donatorCA_id) VALUES({client_id}, {currentAccountId}) " + $"END ;"; ConnectionDB.NonQuerySQL(queryStringAddInDonator); } else { Console.WriteLine("You can' t create a savign account when the amount is bigger than the ceiling"); } }
public static void ModifyPassword() { int ID = Person.ID; Console.WriteLine("Enter your password : "******"SELECT id FROM Person WHERE id = '{ID}' AND password ='******';"; int id = ConnectionDB.ReturnID(queryString); if (ID == id) { Console.WriteLine("Enter your new password : "******"UPDATE Person SET password = '******' WHERE id = '{ID}';"; ConnectionDB.NonQuerySQL(newqueryString); } else { Console.WriteLine("password is wrong"); } }
public void WithdrawMoney(double amount) { int client_id = ID; string queryString1 = $"SELECT amount FROM CurrentAccounts WHERE client_id={ client_id};"; decimal currentAmount = ConnectionDB.ReturnDecimal(queryString1); string queryString2 = $"SELECT overdraft FROM CurrentAccounts WHERE client_id={ client_id};"; decimal overdraft = ConnectionDB.ReturnDecimal(queryString2); string queryString3 = $"SELECT id FROM CurrentAccounts WHERE client_id={ client_id};"; int currentAccountID = ConnectionDB.ReturnID(queryString3); if (Convert.ToDouble(currentAmount - overdraft) >= amount) { DateTime dateOp = DateTime.Now; string queryString = $"UPDATE CurrentAccounts SET amount = (amount - {amount}) WHERE client_id = { client_id }; " + $"INSERT INTO \"Transaction\" (currentAccount_id, transactionType, amount, executionDate, \"status\") " + $"VALUES({currentAccountID}, 'withdraw', {amount}, '{dateOp}', \'done\')"; ConnectionDB.NonQuerySQL(queryString); } else { Console.WriteLine("Not enough money on current account."); } }
public void EmptyCurrentAccount(int client_id, int destinaryAccount) { string queryString = $"SELECT amount FROM CurrentAccounts WHERE client_id = {client_id};"; double amount = (double)ConnectionDB.ReturnDecimal(queryString); string queryStringGetCurrentAccountId = $"SELECT id FROM CurrentAccounts WHERE client_id = {client_id};"; int currentAccountId = ConnectionDB.ReturnID(queryStringGetCurrentAccountId); InstantTransfer instant = new InstantTransfer(); instant.RecordTransferFromCurrentToCurrent(currentAccountId, destinaryAccount, amount); }
public void EmptySavingAccount(int client_id) { List <int> idSavingAccount = ConnectionDB.GetSavingAccountIds(client_id); string queryStringGetCurrentAccountId = $"SELECT id FROM CurrentAccounts WHERE client_id = {client_id}"; int currentAccountId = ConnectionDB.ReturnID(queryStringGetCurrentAccountId); foreach (int id in idSavingAccount) { string queryString = $"SELECT amount FROM SavingAccounts WHERE id = {id};"; double amount = (double)ConnectionDB.ReturnDecimal(queryString); InstantTransfer instant = new InstantTransfer(); instant.RecordTransferFromSavingToCurrent(id, currentAccountId, amount); } }
public static void Login(String userName) { Console.Write("Enter your password : "******"SELECT id FROM Person WHERE name = '{userName}' AND password ='******';"; int id = ConnectionDB.ReturnID(queryString); Person.ID = id; }
public void CreateClient(string name, double amount, decimal overdraft) { PasswordGenerator(); string password = CryptPassword(Password); string queryString = $"INSERT INTO Person (name, password) VALUES ('{name}', '{password}');"; ConnectionDB.NonQuerySQL(queryString); queryString = $"SELECT id FROM Person WHERE name = '{name}' AND password = '******';"; int client_id = ConnectionDB.ReturnID(queryString); CurrentAccount currentAccount = new CurrentAccount(); currentAccount.CreateCurrentAccount(client_id, amount, overdraft); }
public static bool AddFromBeneficiary(int emitterId, int beneficiaryId) { string queryString1 = $"SELECT client_id FROM SavingAccounts WHERE id={beneficiaryId};"; int client_id = ConnectionDB.ReturnID(queryString1); string queryString = $"SELECT id FROM Donator WHERE client_id={client_id} and donatorCA_id={emitterId} ;"; try { int id = ConnectionDB.ReturnID(queryString); return(true); } catch { throw new ArgumentException("Selected Account is invalid"); } }
public static int GetAccountOwnerId(int currentAccountId, AccountType type) { String tableName; if (type == AccountType.Current) { tableName = "CurrentAccounts"; } else if (type == AccountType.Saving) { tableName = "SavingAccounts"; } else { throw new ArgumentException("Account type not valid"); } string queryString = $"SELECT client_id FROM {tableName} WHERE id=" + currentAccountId; int accountOwnerId = ConnectionDB.ReturnID(queryString); return(accountOwnerId); }