///
/// <param name="year"></param>
/// <param name="form"></param>
public void ShowPlanOfAdmission(int year, FormOfEducation form)
{
try
{
string sqlQuery = "SELECT SNAME,AMOUNT FROM 'PLANOFADMISSION'" +
" INNER JOIN 'SPECIALITY' ON SPECIID=SPECID " +
" WHERE PLAN_YEAR = " + year + " AND FORMID = " + (int)form + ";";
SQLiteDataReader reader = GetInfo.ExecuteSql(sqlQuery);
if (reader.HasRows)
{
while (reader.Read())
{
dataGridPlan.Rows.Add(new object[] {
reader.GetValue(0).ToString(),
reader.GetValue(1).ToString(),
});
}
}
else
{
dataGridPlan.Visible = false;
label2.Text = "Such information is not found!";
}
}
catch (SQLiteException ex)
{
MessageBox.Show("Oops...Something went wrong:(" + ex.ToString());
}
}
///
/// <param name="year"></param>
public void ShowSpecialityMaxScore(int year)
{
try
{
string sqlQuery = "SELECT SNAME FROM 'SUBJECT' INNER JOIN 'SPECIALITY' " +
"ON SPECIALID=SPECID WHERE PASSINGSCORE = " +
"(SELECT max(PASSINGSCORE) FROM 'SUBJECT' WHERE SUBJNAME=\"mathematics\" AND YEAR = " + year +
") AND YEAR = " + year + ";";
SQLiteDataReader reader = GetInfo.ExecuteSql(sqlQuery);
if (reader.HasRows)
{
while (reader.Read())
{
labelSpec.Text = reader.GetValue(0).ToString();
}
}
else
{
labelSpec.Text = "No such speciality";
}
}
catch (SQLiteException ex)
{
MessageBox.Show("Oops...Something went wrong:(" + ex.ToString());
}
}
///
/// <param name="year"></param>
public void ShowListOfLeaders(int year)
{
try
{
string sqlQuery = "SELECT NAME,SCDEGREE,SCRANK,STARTDATE,SNAME,FACNAME,DEPNAME FROM 'LEADER'" +
" INNER JOIN 'SPECIALITY' ON SID=SPECID INNER JOIN 'FACULTY' ON FAID=FACID " +
"INNER JOIN 'DEPARTMENT' ON DEPRID=DEPID" +
" WHERE STARTDATE <= " + year + " AND SCDEGREE = \"doctor\" AND SCRANK=\"professor\";";
SQLiteDataReader reader = GetInfo.ExecuteSql(sqlQuery);
if (reader.HasRows)
{
while (reader.Read())
{
dataGridLeaders.Rows.Add(new object[] {
reader.GetValue(0).ToString(),
reader.GetValue(1).ToString(),
reader.GetValue(2).ToString(),
reader.GetValue(3).ToString(),
reader.GetValue(4).ToString(),
reader.GetValue(5).ToString(),
reader.GetValue(6).ToString()
});
}
}
else
{
dataGridLeaders.Visible = false;
label2.Text = "Such information is not found!";
}
}
catch (SQLiteException ex)
{
MessageBox.Show("Oops...Something went wrong:(" + ex.ToString());
}
}
