//--------------------- Employee Methods --------------------------------------------- public string addEmployee(string firstName, string lastName, string PIN) { //string insertString = "INSERT INTO Employee (First_Name, Last_Name, PIN) VALUES ('" + firstName + "', '" + lastName + "', " + PIN + ")"; string[] attributeNames = { "First_Name", "Last_Name", "PIN" }; string[] attributeValues = { firstName, lastName, PIN }; dc.insert("Employee", attributeNames, attributeValues); return(dc.getLastInsertId(INVOICE_TABLE_STRING)); }
public static ICashDrawer createCashDrawer(IEmployee emp, string bank, DatabaseClass dc) { string[] attributeNames = { "Employee_Id", "Bank" }; string[] attributeValues = { emp.getIdAsString(), bank }; dc.insert("Cash_Drawer", attributeNames, attributeValues); return(new CashDrawer(Convert.ToInt32(dc.getLastInsertId("Cash_Drawer")), Convert.ToInt32(emp.getIdAsString()), Convert.ToInt32(bank))); }
public static IInvoice createInvoice(IEmployee emp, ICashDrawer drawer, DatabaseClass dc) { //Console.WriteLine("Creating invoice with employee name = " + emp.getName()); string[] attributeNames = { "Employee_Id", "Invoice_Create_Time", "Cash_Drawer_Id" }; string[] attributeValues = { emp.getIdAsString(), "CURRENT_TIMESTAMP", drawer.getId().ToString() }; dc.insert("Invoice", attributeNames, attributeValues); return(new Invoice(emp, Convert.ToInt16(dc.getLastInsertId(INVOICE_TABLE_STRING)), drawer.getId())); }