public void Read(string x) { try { this.SEMESTERS.Clear(); CONNECT.OpenConnection(); SqlCommand command = CONNECT.CreateSQLCmd(@"select distinct SEM_NAME from SEMESTER where ID = '" + x + "'"); SqlDataReader reader = command.ExecuteReader(); while (reader.HasRows) { if (reader.Read() == false) { break; } Semester sem = new Semester(reader.GetString(0)); listSem.Add(sem); } CONNECT.CloseConnection(); CONNECT.OpenConnection(); command = CONNECT.CreateSQLCmd(@"select * from TABLESCORE where ID_USER = '******'"); reader = command.ExecuteReader(); while (reader.HasRows) { if (reader.Read() == false) { break; } string sNameOfSem = reader.GetString(1); string sID = reader.GetString(2); string sName = reader.GetString(3); int iCredit = reader.GetByte(4); Subject sub = new Subject(sID, sName, iCredit); CScore s1 = new CScore((float)reader.GetSqlDouble(5), (float)reader.GetSqlDouble(9)); CScore s2 = new CScore((float)reader.GetSqlDouble(6), (float)reader.GetSqlDouble(10)); CScore s3 = new CScore((float)reader.GetSqlDouble(7), (float)reader.GetSqlDouble(11)); CScore s4 = new CScore((float)reader.GetSqlDouble(8), (float)reader.GetSqlDouble(12)); ScoreOfSub score = new ScoreOfSub(sub, s1, s2, s3, s4); foreach (var sem in listSem) { if (sem.Name == sNameOfSem) { sem.SCORETABLE.Add(score); } } } CONNECT.CloseConnection(); } catch (Exception e) { MessageBox.Show(e.Message); } }
public ScoreOfSub(ScoreOfSub l) { this.fAverage = l.fAverage; this.lScore = l.lScore; this.sSubject = l.sSubject; }
public void Add(ScoreOfSub x) { lSub.Add(x); }