/// <summary> /// This method handles the event that the sign in button on the left side is pressed. /// We will check to see if the user can sign in. If they can, lets notify them that /// their connection was successful and load the combobox with the database list on the left. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Signin_1_Click(object sender, EventArgs e) { // Check that user 1 can successfully connect. If he can, lets prompt the result lbl_Error_User_1.Show(); string connectionString = SignInChecker(USER_ONE); if (connectionString != "Failed") { LabelChanger.ChangeText("Successfully Logged in.", lbl_Error_User_1); LabelChanger.ChangeColor("Green", lbl_Error_User_1); SQLLaptop.LoadSchemaList(connectionString, cb_DataBase_1); connectionString1 = connectionString; if (assignmentRequirement) { connectionString2 = connectionString1; SQLLaptop.LoadSchemaList(connectionString, cb_DataBase_2); } } else { LabelChanger.ChangeText("Invalid Credentials.", lbl_Error_User_1); LabelChanger.ChangeColor("Red", lbl_Error_User_1); connectionString1 = "Failed"; } }
/// <summary> /// This method handles the assignment requirement checkbox. If the requirement button is toggled on or /// off, it will show/hide the correct information. /// </summary> private void HandleAssignmentRequirements() { // If we are following the assignment requirements, we need to disable a few buttons // text fields, and data that is linked to those // Otherwise lets duplicate all info if (assignmentRequirement == true) { HideSecondUserLogin(); btn_Second_Account.Hide(); lbl_Or.Hide(); btn_Copy.Hide(); lbl_Error_User_2.Hide(); cb_DataBase_2.Items.Clear(); cb_Table_2.Items.Clear(); connectionString2 = connectionString1; connectionString2Database = connectionString1Database; selectedCombo2Database = selectedCombo1Database; selectedCombo2Table = selectedCombo1Table; lbl_Error_Copy.Hide(); if (connectionString2 != null && connectionString2Database != null) { SQLLaptop.LoadSchemaList(connectionString2, cb_DataBase_2); SQLLaptop.LoadSchemaList(connectionString2Database, cb_Table_2); } } else { btn_Second_Account.Show(); lbl_Or.Show(); btn_Copy.Show(); lbl_Error_Copy.Hide(); connectionString2 = null; connectionString2Database = null; selectedCombo2Database = null; selectedCombo2Table = null; cb_DataBase_2.Items.Clear(); cb_Table_2.Items.Clear(); } }
/// <summary> /// This method handles the sign in button on the right side. Its pretty identicle to the above /// method, but handles the right side fields and right side combo box. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Signin_2_Click(object sender, EventArgs e) { lbl_Error_User_2.Show(); // Find the provider. If none is selected, loop through them all string connectionString = SignInChecker(USER_TWO); if (connectionString != "Failed") { LabelChanger.ChangeText("Successfully Logged in.", lbl_Error_User_2); LabelChanger.ChangeColor("Green", lbl_Error_User_2); SQLLaptop.LoadSchemaList(connectionString, cb_DataBase_2); connectionString2 = connectionString; } else { LabelChanger.ChangeText("Invalid Credentials.", lbl_User_2); LabelChanger.ChangeColor("Red", lbl_Error_User_2); connectionString2 = "Failed"; } }
/// <summary> /// This method is support in non-assignment mode. Is just duplicates the first account /// into the second account /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Same_Account(object sender, EventArgs e) { HideSecondUserLogin(); // Retrieve information from the first sign in form string connectionString = SignInChecker(USER_ONE); lbl_Error_User_2.Show(); // If successfully logged in, display success if (connectionString != "Failed") { SQLLaptop.LoadSchemaList(connectionString, cb_DataBase_2); LabelChanger.ChangeText("Successfully Logged in.", lbl_Error_User_2); LabelChanger.ChangeColor("Green", lbl_Error_User_2); connectionString2 = connectionString; } else { LabelChanger.ChangeText("Invalid Credentials.", lbl_User_2); LabelChanger.ChangeColor("Red", lbl_Error_User_2); } // else if failed to log in, display error }