private void confirm_Click(object sender, EventArgs e) { DBconnect chckOut = new DBconnect(); chckOut.DBConnect(); chckOut.checkoutConfirm(userName, gameTitle); this.Close(); }
private void submit_Click(object sender, EventArgs e) { checkOutUPCIn = CheckOutUPC.Text; if (checkOutUPCIn == "") { MessageBox.Show("Please scan a game before hitting enter"); } else { DBconnect chkout = new DBconnect(); chkout.DBConnect(); Tuple<string,string,string,string> output = chkout.checkoutQuery(username, checkOutUPCIn); if (output.Item1 != "") { qname = output.Item1; qConsole = output.Item2; qDescr = output.Item3; qImage = output.Item4; //MessageBox.Show(qname+"\n"+qConsole); confirmCheckout confirm = new confirmCheckout(); confirm.Show(); CheckOutUPC.Clear(); this.Visible = false; } else { MessageBox.Show("The item you scanned is not in our database\nYou must scan a game currently available in the locker"); } } }
//Function called when yes is selected, begins the process of private void button1_Click(object sender, EventArgs e) { //Admin must choose a genre from a drop down menu as genre is not provided by Walmart, will deny if genre hasn't been selected string genre = genreBox.Text; if(genre == "Choose Here") { MessageBox.Show("Please select a genre from the drop-down menu"); } else { //genre is selected, begin the DB insertion process DBconnect insert = new DBconnect(); insert.DBConnect(); bool isOpen = insert.OpenConnection(); if (isOpen == false) { //Ensure DB coneection is still available MessageBox.Show("Failed to establish database connection"); } else { //See DBconnect.cs for implementation, pass all variables in the correct order insert.populateDB(AdminAddGame.gameName, genre, AdminAddGame.console, AdminAddGame.description, AdminAddGame.UPC, AdminAddGame.imageLink); } //always close this.Close(); } }
//Submit button, initiates login when clicked private void button1_Click(object sender, EventArgs e) { //Assigns username and password variables to their repsective text fields userName = UserNameField.Text; string password = PasswordField.Text; UserNameField.Focus(); //Creates DBconnect object that will handle DB work DBconnect data = new DBconnect(); data.DBConnect(); bool isOpen = data.OpenConnection(); if(isOpen == false) { MessageBox.Show("Failed to establish database connection"); } else { //See DBconnect.cs for implementation, if function returns false, user credentials were denied if (data.Validate(userName, password) == false) { MessageBox.Show("Invalid user name or password, please try again."); } else { //Credentials are legitimate, must check if it was a user or admin if(data.isAdmin(userName) == true) { //user was admin, open the admin form //MessageBox.Show("Welcome Admin"); AdminWindow ad = new AdminWindow(); //create reference to admin form window in order to recal this form after it is hidden ad.RefToLogin = this; //hide this form and display admin window this.Visible = false; ad.Show(); } else { //User was plain user, open the user form //MessageBox.Show("Welcome User"); UserWindow us = new UserWindow(); //Same process as the admin us.RefToLogin = this; this.Visible = false; us.Show(); } //Clear all text fields and rehighlight the username so when the form is called again //everything is blank and the username is ready for another UserNameField.Text = string.Empty; PasswordField.Text = string.Empty; } } }
private void checkIn_Click(object sender, EventArgs e) { DBconnect inchk = new DBconnect(); inchk.DBConnect(); if (inchk.checkinEligible(name) == true) { checkIn1.Visible = true; checkIn1.CheckInUPC.Focus(); this.AcceptButton = checkIn1.button1; } else { MessageBox.Show("You cannot check-in a game if you have not checked one out.\nPlease hit the Check-Out button to select a game to rent."); } }
private void ViewInventory_Load(object sender, EventArgs e) { //open dbconnect object to take connectionString and use here to connect to DB DBconnect grid = new DBconnect(); grid.DBConnect(); MySqlConnection conn = new MySqlConnection(grid.connectionString); //Close DBconnect object to avoid collision grid.CloseConnection(); //Start working with the local MySql connection conn.Open(); //Exclude games that have no records da = new MySqlDataAdapter("SELECT * FROM Games WHERE count > 0", conn); //Fill the DataAdapter with current state of the DB ds = new DataSet(); da.Fill(ds, sTable); conn.Close(); //Show the datagridview of the current DB dataGridView1.Refresh(); dataGridView1.DataSource = ds; dataGridView1.DataMember = sTable; }
private void button1_Click(object sender, EventArgs e) { if(CheckInUPC.Text == "") { MessageBox.Show("You must scan a game before hitting enter"); } else { DialogResult confirmation = MessageBox.Show("Are you sure you want to return this game?", "Check In", MessageBoxButtons.YesNo); if (confirmation == DialogResult.Yes) { string chkinUPC = CheckInUPC.Text; DBconnect chkin = new DBconnect(); chkin.DBConnect(); chkin.checkInConfirm(username, chkinUPC); CheckInUPC.Clear(); this.Visible = false; } else if (confirmation == DialogResult.No) { //do nothing } } }
private void checkOut_Click(object sender, EventArgs e) { DBconnect outchk = new DBconnect(); outchk.DBConnect(); if (outchk.checkoutEligible(name) == true) { checkOut1.Visible = true; checkOut1.CheckOutUPC.Focus(); this.AcceptButton = checkOut1.submit; } else { MessageBox.Show("You already have a game checked out!\nYou can only have one game checked out at a time.\nPlease check in the game you previously rented before renting another."); } }