/// /// <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()); } }