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() { sSubject = new Subject(); fAverage = 0; for (int i = 0; i < 4; i++) { lScore[i] = new CScore(); } CONNECT = new Connect(); }
public ScoreOfSub(Subject subject, CScore s1, CScore s2, CScore s3, CScore s4) { CONNECT = new Connect(); this.sSubject = subject; lScore[0] = s1; lScore[1] = s2; lScore[2] = s3; lScore[3] = s4; fAverage = ((s1.Value * s1.Weight + s2.Value * s2.Weight + s3.Value * s3.Weight + s4.Value * s4.Weight) / (s1.Weight + s2.Weight + s3.Weight + s4.Weight)); fAverage = Math.Round(fAverage, 1); CONNECT.OpenConnection(); CONNECT.CloseConnection(); }