public Courses(int TimeId)
{
DateTime d_today = DateTime.Now;
d_today = d_today.AddDays(-3);
string myDate = d_today.ToString("MM/dd/yyyy");
SqlDataReader reader;
DBConnection connection = new DBConnection();
string sql_command;
int message_id;
int LecturerID;
// Load the course details.
sql_command = "SELECT * FROM Courses A, CourseTimes B WHERE B.id = " + TimeId + " AND A.id = B.courseId;";
reader = connection.queryExecute(sql_command);
reader.Read();
ID = Convert.ToInt32(reader[0].ToString());
Name = (string)reader[1];
Class_Room = (string)reader[12];
LecturerID = Convert.ToInt32(reader[2]);
DateTime first_hour = DateTime.Parse("08:00");
DateTime course_hour = DateTime.Parse((string)reader[10]);
Start_time = course_hour.Subtract(first_hour).Hours;// (string)reader[10];
duration = Convert.ToInt32(reader[11]);
Day = Convert.ToInt32(reader[9]);
if (Convert.ToInt32(reader[4]) == -1)
is_lecture = false;
else
is_lecture = true;
reader.Close();
sql_command = "SELECT fName, lName, degree, email FROM Users WHERE id = " + LecturerID + ";";
reader = connection.queryExecute(sql_command);
reader.Read();
Lecturer = (string)reader["degree"] + " " + (string)reader["lName"] + " " + (string)reader["fName"];
email = (string)reader["email"];
reader.Close();
// Load the message of this course.
sql_command = "SELECT id FROM Messages WHERE " + ID + "= courseID and publishDate >= '" + myDate + "' ORDER BY id DESC;";
reader = connection.queryExecute(sql_command);
if (reader.Read())
{
message_id = Convert.ToInt32(reader["id"]);
_message = new Message(message_id);
}
else
_message = null;
reader.Close();
// Load the exercise of this course.
d_today = DateTime.Now;
int day_today = (int)d_today.DayOfWeek + 1;
day_today = Day - day_today;
d_today = d_today.AddDays(day_today);
myDate = d_today.ToString("MM/dd/yyyy");
_exercise = new Exercise(myDate, ID);
}
public Message(int id)
{
SqlDataReader reader;
DBConnection connection = new DBConnection();
ID = id;
string sql_command = "SELECT * FROM Messages WHERE "+ID+" = id";
reader = connection.queryExecute(sql_command);
reader.Read();
subject = (string)reader["subject"];
Content = (string)reader["_content"];
Date = Convert.ToDateTime(reader["publishDate"]);
reader.Close();
}
public Schedule(long id, int rows)
{
int i,j;
Courses temp;
Student_ID = id;
Student_Name = "אבי מורלי";
SqlDataReader reader;
DBConnection connection = new DBConnection();
string today = DateTime.Today.ToString("MM/dd/yyyy");
string sql_command;
this.int_table = new int[rows][];
this.c_table = new Courses[rows][];
for (i = 0; i < rows; i++)
{
int_table[i] = new int[6];
c_table[i] = new Courses[6];
}
for (i = 0; i < rows; i++)
for (j = 0; j < 6; j++)
int_table[i][j] = 0;
sql_command = "SELECT B.*, C.* FROM Studies A, CourseTimes B, Courses C WHERE A.CourseTimesID = B.id"
+ " AND C.id = B.courseID AND " + Student_ID + " = A.studentID AND '" + today + "' >= C.startDate AND '"
+ today + "' <= C.endDate";
reader = connection.queryExecute(sql_command);
DateTime temp_min = DateTime.Parse("23:00");
DateTime temp_max = DateTime.Parse("00:00");
while (reader.Read())
{
DateTime course_hour = DateTime.Parse((string)reader[3]);
temp = new Courses((int)reader[0]);
if (temp_min.Subtract(course_hour).Hours > 0)
temp_min = course_hour;
if (temp_max.Subtract(course_hour.AddHours(temp.duration)).Hours < 0)
temp_max = course_hour.AddHours(temp.duration);
c_table[temp.Start_time][temp.Day - 1] = temp;
int_table[temp.Start_time][temp.Day - 1] = temp.duration;
for (i=1;i<temp.duration;i++)
int_table[temp.Start_time + i][temp.Day - 1] = -1;
}
start_time = temp_min.Subtract(DateTime.Parse("08:00")).Hours;
end_time = temp_max.Subtract(DateTime.Parse("08:00")).Hours -1;
reader.Close();
}
public Exercise(string due_date, int c_id)
{
SqlDataReader reader;
DBConnection connection = new DBConnection();
string sql_command = "SELECT * FROM Exercises WHERE '" + due_date + "' = dueDate AND courseID = " + c_id + ";";
reader = connection.queryExecute(sql_command);
if (reader.Read())
{
deadline = Convert.ToDateTime(reader["dueDate"]);
ID = (int)reader["id"];
Content = (string)reader["_content"];
subject = (string)reader["subject"];
Date = Convert.ToDateTime(reader["publishDate"]);
reader.Close();
}
else
{
this.ID = -1;
}
}