private void buttonLoginUser_Click(object sender, EventArgs e) { string username = textBoxFirstname.Text; bool isCorrect = false; //Do an SQL check for user - edit "isCorrect" isCorrect = DBWIDGET.itemExists("SELECT * FROM Person WHERE fname='" + username + "'"); // << if (isCorrect) { //Login the user - by opening User_Product_Page form and hide Form1 form (this) User_Window ProductPage = new User_Window(username); this.Hide(); ProductPage.ShowDialog(); this.Show(); // This is run once the User form is closed } else { //Show a dialogue box to reenter data, clear password field MessageBox.Show("Firstname is incorrect. Please re-enter"); textBoxFirstname.Clear(); textBoxFirstname.Focus(); } }
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."); } }