public ClassHour GetConflictingHour(ClassHour hour)
{
String sql = "SELECT * FROM hours WHERE semster = @semster AND room = @room AND day = @day AND " +
"( (start_time > TIME(@start_time) AND start_time < TIME(@end_time) ) " +
"or (end_time > TIME(@start_time) AND end_time < TIME(@end_time) ) )";
MySqlCommand cmd = new MySqlCommand(sql, Connection);
cmd.Parameters.AddWithValue("@semster", hour.Semster);
cmd.Parameters.AddWithValue("@room", hour.Room);
cmd.Parameters.AddWithValue("@day", hour.Day);
cmd.Parameters.AddWithValue("@start_time", hour.StartTime);
cmd.Parameters.AddWithValue("@end_time", hour.EndTime);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ClassHour chour = new ClassHour();
chour.CourseId = rdr["c_id"].ToString();
chour.StartTime = ConvertDateFromDatabae(rdr["start_time"]);
chour.EndTime = ConvertDateFromDatabae(rdr["end_time"]);
chour.Day = rdr["day"].ToString();
chour.Room = rdr["room"].ToString();
chour.Semster = rdr["semster"].ToString();
rdr.Close();
return(chour);
}
rdr.Close();
return(null);
}
public List <ClassHour> GetHours()
{
List <ClassHour> classHours = new List <ClassHour>();
String sql = "SELECT * FROM hours";
MySqlCommand cmd = new MySqlCommand(sql, Connection);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ClassHour hour = new ClassHour();
hour.CourseId = rdr["c_id"].ToString();
hour.StartTime = ConvertDateFromDatabae(rdr["start_time"]);
hour.EndTime = ConvertDateFromDatabae(rdr["end_time"]);
hour.Day = rdr["day"].ToString();
hour.Room = rdr["room"].ToString();
hour.Semster = rdr["semster"].ToString();
classHours.Add(hour);
}
rdr.Close();
return(classHours);
}
public bool DeleteClassHour(ClassHour hour)
{
string sql = "DELETE FROM hours WHERE semster = @semster AND room = @room AND day = @day AND start_time = TIME(@start_time)";
MySqlCommand cmd = new MySqlCommand(sql, Connection);
cmd.Parameters.AddWithValue("@semster", hour.Semster);
cmd.Parameters.AddWithValue("@room", hour.Room);
cmd.Parameters.AddWithValue("@day", hour.Day);
cmd.Parameters.AddWithValue("@start_time", hour.StartTime);
return(cmd.ExecuteNonQuery() == 1);
}
public bool UpdateClassHour(ClassHour hour, ClassHour selector)
{
string sql = "UPDATE hours set room = @nroom, day = @nday,start_time = TIME(@nstart_time),end_time = TIME(@nendtime) WHERE semster = @semster AND room = @room AND day = @day AND start_time = TIME(@start_time)";
MySqlCommand cmd = new MySqlCommand(sql, Connection);
cmd.Parameters.AddWithValue("@nroom", hour.Room);
cmd.Parameters.AddWithValue("@nday", hour.Day);
cmd.Parameters.AddWithValue("@nstart_time", hour.StartTime);
cmd.Parameters.AddWithValue("@nendtime", hour.EndTime);
cmd.Parameters.AddWithValue("@semster", selector.Semster);
cmd.Parameters.AddWithValue("@room", selector.Room);
cmd.Parameters.AddWithValue("@day", selector.Day);
cmd.Parameters.AddWithValue("@start_time", selector.StartTime);
return(cmd.ExecuteNonQuery() == 1);
}
public bool AddClassHour(ClassHour hour)
{
string sql =
"INSERT INTO hours (c_id, semster,room,day,start_time,end_time) VALUES (@c_id,@semster,@room,@day,TIME(@start_time),TIME(@end_time));";
MySqlCommand cmd = new MySqlCommand(sql, Connection);
cmd.Parameters.AddWithValue("@c_id", hour.CourseId);
cmd.Parameters.AddWithValue("@semster", hour.Semster);
cmd.Parameters.AddWithValue("@room", hour.Room);
cmd.Parameters.AddWithValue("@day", hour.Day);
cmd.Parameters.AddWithValue("@start_time", hour.StartTime);
cmd.Parameters.AddWithValue("@end_time", hour.EndTime);
return(cmd.ExecuteNonQuery() == 1);
}
public async Task <bool> Handle(CreateClassHourCommand request, CancellationToken cancellationToken)
{
var CurriculumModel = await _CurriculumRepository.GetCurriculumByIDAsync(request.CurriculumID);
if (CurriculumModel == null && CurriculumModel.Lecturer.TeacherID != request.TeacherID)
{
throw new CurriculumExecption("This Curriculum does not belong to you and you cannot edit it");
}
//var ClassHourModel = _Mapper.Map<ClassHour>(request);
var ClassHourModel = new ClassHour()
{
ClassHourTitle = request.ClassHourTitle,
ClassHourType = request.ClassHourType,
IsExperience = request.IsExperience,
IsFree = request.IsFree,
VedioDuration = request.VedioDuration,
VedioUrl = request.VedioUrl,
SectionID = request.SectionID
};
CurriculumModel.AddClassHour(request.SectionID, ClassHourModel);
return(await _CurriculumRepository._Unitwork.DomianSaveChangesAnsyc());
}
public CreateClassHourDomainEvent(ClassHour _ClassHour)
{
GetClassHour = _ClassHour;
}
private void CancelClasHourForm(object sender, RoutedEventArgs e)
{
FormClassHour = new ClassHour();
}
