private void PsoBack_Click(object sender, EventArgs e) // Method for the action when a user clicks on the Back button on the Sign Out panel { FNameSO.Clear(); // Clears text fields LNameSO.Clear(); PSignout.Visible = false; // Shows main screen PSignin.Visible = false; }
private void SOContinue() // method to add a Sign Out time to a student { string SOFName = FNameSO.Text; // Takes user's data enterted into the text box, and adds it as a string string SOLName = LNameSO.Text; string Date = DateTime.Now.ToString("MM.dd.yyy"); // Create strings needed to add data to a database string Time = DateTime.Now.ToString("h:mm:ss"); OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data source= C:\CheckIn\CheckIn.accdb"; try { conn.Open(); // Opens database connection String SOTime = "Update Table1 set [Time out] = '" + Time + "' Where [First Name] = '" + SOFName + "' and [Last Name] = '" + SOLName + "' and [Date] = '" + Date + "'"; // Adds the current time to the Time out field on the database OleDbCommand cmd = new OleDbCommand(SOTime, conn); cmd.ExecuteNonQuery(); } catch (Exception ex) // I mainly used this for debugging, however, if Faculty at South sees this message, they now to switch to paper until the problem is resolved { MessageBox.Show("Failed due to" + ex.Message); } finally { conn.Close(); FNameSO.Clear(); // Clears Text fields so other users cannot see what the previous user inputted LNameSO.Clear(); PSignedIn.Visible = true; PSignout.Visible = true; PSignin.Visible = true; PSignedOut.Visible = true; SOWait5.Interval = 5000; // Show the Signed Out message for 5 seconds SOWait5.Start(); } }