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");
}
}
