public void RadioButtonFilter(string comboBoxText, string level, DataGridView firstDGV) { SQLConnectionQueries sqlConnectionQueries = new SQLConnectionQueries(); string major, query; major = "= '" + comboBoxText + "'"; query = ("Select Code, Name, Major, Level, Cost from js_CourseInfo where (Level = '" + level + "') and Major " + major + ""); if (comboBoxText == "All") { major = "is not null"; query = ("Select Code, Name, Major, Level, Cost from js_CourseInfo where (Level = '" + level + "') and Major " + major + ""); sqlConnectionQueries.DisplayTable(firstDGV, query); } else { sqlConnectionQueries.DisplayTable(firstDGV, query); } }
private void LoginBtn_Click(object sender, EventArgs e) { string getLoginInfoQuery, getLoginInfoValidationQuery, getAllCoursesQuery, getOnlyEnrolledCoursesQuery, getCourseCartQuery; getLoginInfoQuery = ("Select * From js_LoginInfo where Username = '******'"); getLoginInfoValidationQuery = ("Select Count(*) From js_LoginInfo where Username = '******' and Password = '******'"); getAllCoursesQuery = ("Select Code, Name, Major, Level , Cost from js_CourseInfo"); getOnlyEnrolledCoursesQuery = ("Select Code, Name, Major, Level, PurchaseTime from js_CourseEnrolled where Username = '******'"); getCourseCartQuery = ("Select Code, Name, Major, Level, Cost from js_CourseCart where Username = '******'"); if (sqlConnectionQueries.DoesRecordExist(getLoginInfoValidationQuery).Rows[0][0].ToString() == "1") { totalCostLabel.Text = "$" + Convert.ToString(sqlConnectionQueries.CartTotal()); coursesComboBox.SelectedIndex = 4; loginPagePanel.Visible = false; signUpPagePanel.Visible = false; enrollmentPanel.Visible = true; allCoursesRB.Checked = true; sNumberLabel.Text = sqlConnectionQueries.ReadTableAndColumnOnce(getLoginInfoQuery)["StudentNumber"].ToString(); fullNameLabel.Text = sqlConnectionQueries.ReadTableAndColumnOnce(getLoginInfoQuery)["FirstName"].ToString() + " " + sqlConnectionQueries.ReadTableAndColumnOnce(getLoginInfoQuery)["LastName"].ToString(); majorLabel.Text = sqlConnectionQueries.ReadTableAndColumnOnce(getLoginInfoQuery)["Major"].ToString(); sqlConnectionQueries.DisplayTable(availCourseDGV, getAllCoursesQuery); sqlConnectionQueries.DisplayTable(courseEnrollDGV, getOnlyEnrolledCoursesQuery); sqlConnectionQueries.DisplayTable(courseCartDGV, getCourseCartQuery); cleanUp.UnsortableColumn(availCourseDGV); cleanUp.UnsortableColumn(courseCartDGV); cleanUp.UnsortableColumn(courseEnrollDGV); cleanUp.SetColumnWidth(availCourseDGV); cleanUp.SetColumnWidth(courseCartDGV); try { availCourseDGV.Rows[0].Selected = false; } catch { } try { courseCartDGV.Rows[0].Selected = false; } catch { } try { courseEnrollDGV.Rows[0].Selected = false; } catch { } } else { MessageBox.Show("Please check your Username and Password"); } }