public static List <Assignment> ExtractAssignments(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <Assignment> assignments = new List <Assignment>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
uint assignmentdescriptionID = reader.GetUInt32(reader.GetOrdinal("AssignmentDescriptionID"));
uint studentid = reader.GetUInt32(reader.GetOrdinal("StudentID"));
string comment = reader.GetString(reader.GetOrdinal("Comment"));
DateTime date = reader.GetDateTime(reader.GetOrdinal("DateTime"));
if (Commands.CheckNull("Assignment", id, "GradeID"))
{
assignments.Add(new Assignment(id, assignmentdescriptionID, studentid, comment, date));
}
else
{
uint gradeid = reader.GetUInt32(reader.GetOrdinal("GradeID"));
assignments.Add(new Assignment(id, assignmentdescriptionID, studentid, comment, gradeid, date));
}
}
connectionReader.Connection.Close();
return(assignments);
}
public static List <Person> ExtractPersons(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <Person> persons = new List <Person>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
string name = reader.GetString(reader.GetOrdinal("Name"));
string type = reader.GetString(reader.GetOrdinal("Type"));
switch (type)
{
case "Student":
persons.Add(new Student(id, name));
break;
case "Teacher":
persons.Add(new Teacher(id, name));
break;
case "Secretary":
persons.Add(new Secretary(id, name));
break;
default:
throw new InvalidPersonTypeException();
}
}
connectionReader.Connection.Close();
return(persons);
}
public static List <string> ExtractFilepaths(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <string> filepaths = new List <string>();
while (reader.HasRows && reader.Read())
{
filepaths.Add(reader.GetString(reader.GetOrdinal("Filepath")));
}
connectionReader.Connection.Close();
return(filepaths);
}
public static uint[] ExtractIDs(MySqlConnectionReader connectionReader, string field)
{
MySqlDataReader reader = connectionReader.Reader;
List <uint> ids = new List <uint>();
while (reader.HasRows && reader.Read())
{
ids.Add(reader.GetUInt32(reader.GetOrdinal(field)));
}
connectionReader.Connection.Close();
return(ids.ToArray());
}
public void ExecuteNonReader()
{
MySqlConnectionReader connectionReader = new MySqlConnectionReader(new MySqlConnection(ConnectionString));
using (MySqlCommand command = connectionReader.Connection.CreateCommand())
{
connectionReader.Connection.Open();
command.CommandText = QueryString;
command.ExecuteNonQuery();
connectionReader.Connection.Close();
}
}
public MySqlConnectionReader Execute()
{
MySqlConnectionReader connectionReader = new MySqlConnectionReader(new MySqlConnection(ConnectionString));
using (MySqlCommand command = connectionReader.Connection.CreateCommand())
{
connectionReader.Connection.Open();
command.CommandText = QueryString;
connectionReader.Reader = command.ExecuteReader();
}
return(connectionReader);
}
public static List <Room> ExtractRooms(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <Room> rooms = new List <Room>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
string name = reader.GetString(reader.GetOrdinal("Name"));
rooms.Add(new Room(id, name));
}
connectionReader.Connection.Close();
return(rooms);
}
public static List <Course> ExtractCourses(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <Course> courses = new List <Course>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
string name = reader.GetString(reader.GetOrdinal("Name"));
string description = reader.GetString(reader.GetOrdinal("Description"));
courses.Add(new Course(id, name, description));
}
connectionReader.Connection.Close();
return(courses);
}
public static List <AssignmentGrade> ExtractAssignmentGrades(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <AssignmentGrade> assignmentgrades = new List <AssignmentGrade>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
uint assignmentID = reader.GetUInt32(reader.GetOrdinal("AssignmentID"));
string grade = reader.GetString(reader.GetOrdinal("Grade"));
string comment = reader.GetString(reader.GetOrdinal("Comment"));
assignmentgrades.Add(new AssignmentGrade(id, assignmentID, grade, comment));
}
connectionReader.Connection.Close();
return(assignmentgrades);
}
public static bool CheckNull(string tableName, uint id, string variable)
{
Common.EnsureNotNull(tableName, variable);
Query query = new Query("SELECT * FROM " + tableName + " WHERE ID='" + id + "';");
MySqlConnectionReader connectionReader = query.Execute();
MySqlDataReader reader = connectionReader.Reader;
if (reader.HasRows && reader.Read())
{
bool isNull = reader.IsDBNull(reader.GetOrdinal(variable));
connectionReader.Connection.Close();
return(isNull);
}
connectionReader.Connection.Close();
throw new InvalidIDException();
}
public static List <CourseGrade> ExtractCourseGrades(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <CourseGrade> coursegrades = new List <CourseGrade>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
uint courseID = reader.GetUInt32(reader.GetOrdinal("CourseID"));
uint studentID = reader.GetUInt32(reader.GetOrdinal("StudentID"));
string grade = reader.GetString(reader.GetOrdinal("Grade"));
string comment = reader.GetString(reader.GetOrdinal("Comment"));
coursegrades.Add(new CourseGrade(id, courseID, studentID, grade, comment));
}
connectionReader.Connection.Close();
return(coursegrades);
}
public static List <Message> ExtractMessages(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <Message> messages = new List <Message>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
uint senderID = reader.GetUInt32(reader.GetOrdinal("SenderID"));
string title = reader.GetString(reader.GetOrdinal("Title"));
string text = reader.GetString(reader.GetOrdinal("Text"));
DateTime dateTime = reader.GetDateTime(reader.GetOrdinal("DateTime"));
messages.Add(new Message(id, senderID, title, text, dateTime));
}
connectionReader.Connection.Close();
return(messages);
}
public static List <News> ExtractNews(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <News> news = new List <News>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
uint authorID = reader.GetUInt32(reader.GetOrdinal("AuthorID"));
string title = reader.GetString(reader.GetOrdinal("Title"));
string text = reader.GetString(reader.GetOrdinal("Text"));
DateTime dateTime = reader.GetDateTime(reader.GetOrdinal("DateTime"));
news.Add(new News(id, authorID, title, text, dateTime));
}
connectionReader.Connection.Close();
return(news);
}
public static List <Lesson> ExtractLessons(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <Lesson> lessons = new List <Lesson>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
uint courseID = reader.GetUInt32("CourseID");
string description = reader.GetString(reader.GetOrdinal("Description"));
bool online = reader.GetBoolean(reader.GetOrdinal("Online"));
bool cancelled = reader.GetBoolean(reader.GetOrdinal("Cancelled"));
DateTime dateTime = reader.GetDateTime(reader.GetOrdinal("DateTime"));
lessons.Add(new Lesson(id, courseID, description, online, cancelled, dateTime));
}
connectionReader.Connection.Close();
return(lessons);
}
public static List <AssignmentDescription> ExtractAssignmentDescriptions(MySqlConnectionReader connectionReader)
{
MySqlDataReader reader = connectionReader.Reader;
List <AssignmentDescription> assignmentdescriptions = new List <AssignmentDescription>();
while (reader.HasRows && reader.Read())
{
uint id = reader.GetUInt32(reader.GetOrdinal("ID"));
uint courseID = reader.GetUInt32(reader.GetOrdinal("CourseID"));
string title = reader.GetString(reader.GetOrdinal("Title"));
string description = reader.GetString(reader.GetOrdinal("Description"));
bool cancelled = reader.GetBoolean(reader.GetOrdinal("Cancelled"));
DateTime deadline = reader.GetDateTime(reader.GetOrdinal("Deadline"));
assignmentdescriptions.Add(new AssignmentDescription(id, courseID, title, description, cancelled, deadline));
}
connectionReader.Connection.Close();
return(assignmentdescriptions);
}
public static List <Secretary> ExtractSecretaries(MySqlConnectionReader connectionReader) => ExtractPersons(connectionReader).Cast <Secretary>().ToList();
public static List <Teacher> ExtractTeachers(MySqlConnectionReader connectionReader) => ExtractPersons(connectionReader).Cast <Teacher>().ToList();
public static List <Student> ExtractStudents(MySqlConnectionReader connectionReader) => ExtractPersons(connectionReader).Cast <Student>().ToList();
