public void LoadProblemFromDatabase(string pathName) { OleDbConnection dbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathName); dbConnection.Open(); OleDbCommand dbCommand = dbConnection.CreateCommand(); dbCommand.CommandText = "select * from Pitanje"; OleDbDataReader dbReader = dbCommand.ExecuteReader(); while (dbReader.Read()) { int idPitanja = (int)dbReader.GetValue(1); int idPredmeta = (int)dbReader.GetValue(2); ProgrammingProblem newProblem = new ProgrammingProblem(); newProblem.ProblemID = Convert.ToString(idPredmeta) + " - " + Convert.ToString(idPitanja); OleDbCommand solCommand = dbConnection.CreateCommand(); solCommand.CommandText = "select * from StudentskoRjesenje WHERE IDPitanja = " + Convert.ToString(idPitanja) + " AND IDPredmeta = " + Convert.ToString(idPredmeta); OleDbDataReader solReader = solCommand.ExecuteReader(); while (solReader.Read()) { newProblem.addStudentSolution(solReader.GetValue(7).ToString(), solReader.GetValue(1).ToString()); } _listLoadedProblems.Add(newProblem); } // uèitavamo sve fajlove /*DirectoryInfo di = new DirectoryInfo(pathName); * FileInfo[] rgFiles = di.GetFiles("*.txt"); * * foreach (FileInfo fi in rgFiles) * { * newProblem.addStudentSolution(fi); * } * * _listLoadedProblems.Add(newProblem);*/ dbConnection.Close(); }
public void LoadProblemFromDirectory(string pathName, string problemID) { ProgrammingProblem newProblem = new ProgrammingProblem(); newProblem.ProblemID = problemID; // uèitavamo sve fajlove DirectoryInfo di = new DirectoryInfo(pathName); FileInfo[] rgFiles = di.GetFiles("*.txt"); foreach (FileInfo fi in rgFiles) { newProblem.addStudentSolution(fi); } _listLoadedProblems.Add(newProblem); }