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