public List<MergedLesson> GetMergedLessonsOfWeek(DateTime day)
{
List<MergedLesson> mergedLessons = new List<MergedLesson>();
using (SqlConnection Connection = GetConnection())
{
Connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM GetAllOfWeek(@FirstDayOfWeek, @LastDayOfWeek)", Connection);
DateTime firstDayOfWeek, lastDayOfWeek;
firstDayOfWeek = day.AddDays(CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek - day.DayOfWeek);
lastDayOfWeek = firstDayOfWeek.AddDays(6);
command.Parameters.AddWithValue("@FirstDayOfWeek", firstDayOfWeek);
command.Parameters.AddWithValue("@LastDayOfWeek", lastDayOfWeek);
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
MergedLesson mergedLesson = new MergedLesson()
{
lessonID = (int)dataReader["lessonID"],
cursName = (string)dataReader["cursName"],
cursDescription = (string)dataReader["cursDescription"],
start = (System.DateTime)dataReader["start"],
end = (System.DateTime)dataReader["end"],
building = (Building)((int)dataReader["building"]),
tutor = (string)dataReader["tutorName"],
modul = (string)dataReader["modulName"]
};
mergedLessons.Add(mergedLesson);
}
}
return mergedLessons;
}
private void IsLessonIsOver( DataGridViewCellFormattingEventArgs e, MergedLesson lesson)
{
if (lesson.end < DateTime.Now)
{
e.CellStyle.BackColor = Color.LightGray;
}
if (lesson.end > DateTime.Now && lesson.start <= DateTime.Now)
{
e.CellStyle.BackColor = Color.LightGreen;
}
}
public List<MergedLesson> GetMergedLessonsOfDay(DateTime day)
{
List<MergedLesson> mergedLessons = new List<MergedLesson>();
using (SqlConnection Connection = GetConnection())
{
Connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM GetAllOfDay(@Day)", Connection);
command.Parameters.AddWithValue("@Day", day);
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
MergedLesson mergedLesson = new MergedLesson()
{
lessonID = (int)dataReader["lessonID"],
cursName = (string)dataReader["cursName"],
cursDescription = (string)dataReader["cursDescription"],
start = (System.DateTime)dataReader["start"],
end = (System.DateTime)dataReader["end"],
building = (Building)((int)dataReader["building"]),
tutor = (string)dataReader["tutorName"],
modul = (string)dataReader["modulName"]
};
mergedLessons.Add(mergedLesson);
}
}
return mergedLessons;
}
