private void buttonAddNewFactory_Click_1(object sender, EventArgs e) { //Create a new factory bool isFilledIn = false; bool sqlCompleted = false; string factoryLocation = textBoxLocation.Text; string amountOfWorkers = textBoxAmountofWorkers.Text; // convert it to int for DB string managerOfFactory = comboBoxFactoryManager.Text; if (string.IsNullOrWhiteSpace(factoryLocation)) { isFilledIn = false; } else if (string.IsNullOrWhiteSpace(amountOfWorkers)) { isFilledIn = false; } else if (string.IsNullOrWhiteSpace(managerOfFactory)) { isFilledIn = false; } else { isFilledIn = true; } if (isFilledIn) { //Get the last factory id int factoryID = DBWIDGET.getDBSize("SELECT count(*) FROM Factory") + 1; // Do an SQL query to add a new factory with connection to a manager - edit 'sqlCompleted' sqlCompleted = DBWIDGET.Insert("INSERT into factory (factory_id, flocation, amount_of_workers) VALUES(" + factoryID + ", '" + factoryLocation + "', " + amountOfWorkers + ")"); //then connect to a management ID sqlCompleted = DBWIDGET.Insert("Insert into owns(manager_id, factory_id) Values(" + managerOfFactory + ", " + factoryID + ")"); if (sqlCompleted) { //Update the form with the new factory loadFactories(); MessageBox.Show("Factory Added"); } else { MessageBox.Show("There was an error completing your request"); } } else { MessageBox.Show("Please complete all textboxes before submitting"); } }
private void buttonBuyItems_Click(object sender, EventArgs e) { // Get the customer id int customerID = DBWIDGET.RetrieveSingleID("SELECT c.customer_id FROM customer c, person p WHERE p.person_id = c.customer_id AND p.fname = '" + username + "'"); foreach (IcecreamItem i in items) { // Get the icecream id int iceCreamID = DBWIDGET.RetrieveSingleID("SELECT i.ice_cream_id FROM ice_cream i WHERE i.flavour = '" + i.flavour + "'"); //Set the date DateTime dateTime = new DateTime(2018, 6, 11, 8, 27, 0); string formattedDate = dateTime.ToString("d"); //? string formattedTime = dateTime.ToString("T"); int amountToMake = i.amount; for (int j = 0; j < amountToMake; j++) { //Do an SQL query to add the items to be delivered, etc (requires a lot of linking with drivers and factories, etc) // 1- Customer to Icecream via orders DBWIDGET.Insert("INSERT into orders(date_ordered, time_ordered, ice_cream_id, customer_id) VALUES(to_date('" + formattedDate + "', 'MM/DD/YYYY'), '" + formattedTime + "', " + iceCreamID + ", " + customerID + ")"); } // 2- Create a delivery truck? // 3- connect delivery truck to this icecream order? } //Tell the user the items will be delivered ... etc MessageBox.Show("Items have been brought. Will be delivered in ** days"); //Close this window this.Close(); }
private void buttonAddProduct_Click(object sender, EventArgs e) { // Add a new product from the DB string flavour = textBoxFlavour.Text; string amountMade = textBoxIcecreamMade.Text; string factoryname = comboBoxSelectFactory.Text; //get the last index value int nextIndex = DBWIDGET.getDBSize("SELECT count(*) FROM ice_cream"); //get the id of the factory int factoryID = DBWIDGET.RetrieveSingleID("SELECT f.factory_id FROM factory f WHERE f.flocation = '" + factoryname + "'"); //Do an SQL insert to add a new icecream to the DB DBWIDGET.Insert("INSERT into ice_cream (ice_cream_id, flavour, amount_made) VALUES(" + nextIndex + ", '" + flavour + "', " + amountMade + ")"); DBWIDGET.Insert("INSERT into makes (factory_id, ice_cream_id) VALUES(" + factoryID + ", " + nextIndex + ")"); this.Close(); }
private void buttonAddUser_Click(object sender, EventArgs e) { string firstname = textBoxFirstname.Text; string lastname = textBoxLastname.Text; string phoneNumber = textBoxPhone.Text; string streetAddress = textBoxStreet.Text; string city = textBoxCity.Text; string postcode = textBoxPostcode.Text; bool isFilledIn = false; bool isUsernameFree = false; bool isSuccessfulAdd = false; //Check all textbox's - only continue if they are filled - otherwise tell the user if (string.IsNullOrWhiteSpace(firstname)) { isFilledIn = false; } else if (string.IsNullOrWhiteSpace(lastname)) { isFilledIn = false; } else if (string.IsNullOrWhiteSpace(phoneNumber)) { isFilledIn = false; } else if (string.IsNullOrWhiteSpace(streetAddress)) { isFilledIn = false; } else if (string.IsNullOrWhiteSpace(city)) { isFilledIn = false; } else if (string.IsNullOrWhiteSpace(postcode)) { isFilledIn = false; } else { isFilledIn = true; } if (isFilledIn) { //Do an SQL check to see if username is free to use - edit "isUsernameFree" isUsernameFree = !DBWIDGET.itemExists("SELECT * FROM Person WHERE fname='" + firstname + "'"); if (isUsernameFree) { //Do an SQL statement to get the last Person ID, then + 1 to it int nextID = DBWIDGET.getDBSize("SELECT count(*) FROM Person") + 1; //Do an SQL insert to add a new user - if successful then edit "isSuccessfulAdd" isSuccessfulAdd = DBWIDGET.Insert("INSERT INTO Person (person_ID, fname, lname, Phone_number, Street_Address, City, Postcode) VALUES (" + nextID + ", '" + firstname + "', '" + lastname + "', '" + phoneNumber + "', '" + streetAddress + "', '" + city + "', '" + postcode + "')"); //and set them as a customer DBWIDGET.Insert("INSERT INTO customer (customer_id) VALUES (" + nextID + ")"); if (isSuccessfulAdd) { //Login the user - by opening User_Product_Page form and hide Form1 form (this) User_Window ProductPage = new User_Window(firstname); this.Hide(); ProductPage.ShowDialog(); this.Close(); } else { //Tell the user there has been an error MessageBox.Show("Error on user profile addition. Contact System Admin"); } } else { //Username is taken MessageBox.Show("Username is taken. Please enter a new first/user name"); textBoxFirstname.Clear(); textBoxFirstname.Focus(); } } else { //Need to fill in all boxes MessageBox.Show("Please fill in all areas."); } }
private void buttonAddUser_Click(object sender, EventArgs e) { string firstname = textBoxFirstname.Text; string lastname = textBoxLastname.Text; string phoneNumber = textBoxPhone.Text; string streetAddress = textBoxStreet.Text; string city = textBoxCity.Text; string postcode = textBoxPostcode.Text; string factoryName = comboBoxFactoryNames.Text; bool isFilledIn = false; bool isUsernameFree = false; bool isSuccessfulAdd = false; //Check all textbox's - only continue if they are filled - otherwise tell the user if (string.IsNullOrWhiteSpace(firstname)) isFilledIn = false; else if (string.IsNullOrWhiteSpace(lastname)) isFilledIn = false; else if (string.IsNullOrWhiteSpace(phoneNumber)) isFilledIn = false; else if (string.IsNullOrWhiteSpace(streetAddress)) isFilledIn = false; else if (string.IsNullOrWhiteSpace(city)) isFilledIn = false; else if (string.IsNullOrWhiteSpace(postcode)) isFilledIn = false; else if (string.IsNullOrWhiteSpace(factoryName)) isFilledIn = false; else isFilledIn = true; if (isFilledIn) { //Do an SQL check to see if username is free to use - edit "isUsernameFree" isUsernameFree = !DBWIDGET.itemExists("SELECT * FROM Person WHERE fname='" + firstname + "'"); if (isUsernameFree) { //Do an SQL statement to get the last Person ID, then + 1 to it int nextID = DBWIDGET.getDBSize("SELECT count(*) FROM Person") + 1; //get the manager ID for the selected factory int managerID = DBWIDGET.RetrieveSingleID("SELECT m.management_id FROM managementi m, owns o, factory f WHERE o.factory_id = f.factory_id AND o.manager_id = m.management_id AND f.flocation = '" + factoryName + "'"); //Do an SQL insert to add a new user - if successful then edit "isSuccessfulAdd" isSuccessfulAdd = DBWIDGET.Insert("INSERT INTO Person (person_ID, fname, lname, Phone_number, Street_Address, City, Postcode) VALUES (" + nextID + ", '" + firstname + "', '" + lastname + "', '" + phoneNumber + "', '" + streetAddress + "', '" + city + "', '" + postcode + "')"); //then add them as a driver DBWIDGET.Insert("INSERT INTO driver (driver_id) VALUES (" + nextID + ")"); //as employed by management who owns factory selected DBWIDGET.Insert("INSERT into employs (manager_id, driver_id) VALUES (" + managerID + ", " + nextID + ")"); if (isSuccessfulAdd) { //close form this.Close(); } else { //Tell the user there has been an error MessageBox.Show("Error on user profile addition. Contact System Admin"); } } else { //Username is taken MessageBox.Show("Username is taken. Please enter a new first/user name"); textBoxFirstname.Clear(); textBoxFirstname.Focus(); } } else { //Need to fill in all boxes MessageBox.Show("Please fill in all areas."); } }