private void Remove()
{
if (Index >= 0)
{
ClassCourse.RemoveAt(Index);
}
}
public void LoadClassCourses(Courses course)
{
if (List_Of_ClassCourses == null)
{
List_Of_ClassCourses = new List <ClassCourse>();
}
else
{
foreach (var classCourse in List_Of_ClassCourses)
{
if (classCourse.course.CourseID == course.CourseID && classCourse.course.classID == course.classID)
{
return;
}
}
}
ClassCourse newClassCourse = new ClassCourse();
newClassCourse.course = course;
newClassCourse.students = new List <Students>();
foreach (var student in List_Of_Students)
{
if (student.classID.ClassID == course.classID.ClassID)
{
newClassCourse.students.Add(student);
}
}
List_Of_ClassCourses.Add(newClassCourse);
return;
}
public ClassCourseModel CreateOrUpdate(ClassCourseModel model)
{
Logger.Debug($"{model}");
if (model == null)
{
throw new System.ArgumentNullException("model");
}
ClassCourse course = null;
if (model.Id == null || model.Id == System.Guid.Empty)
{
course = this.UnitOfWork.ClassCourseRepository.CreateCourse(model.ClassRoomId, model.CourseId, model.TeacherId, model.RoomId, model.IsActive);
}
else
{
course = this.UnitOfWork.ClassCourseRepository.UpdateCourse(model.Id, model.ClassRoomId, model.CourseId, model.TeacherId, model.RoomId, model.IsActive);
}
this.UnitOfWork.SaveChanges();
ClassCourseModel courseModel = Mapper.Map <Models.ClassCourse, Models.ClassCourseModel>(course);
return(courseModel);
}
private void Add()
{
var context = new CourseVM(teachers.ToArray(), groups.ToArray(), subjects.ToArray());
var winc = new NewCourse()
{
DataContext = context
};
winc.ShowDialog();
System.Console.WriteLine(context.Course != null);
if (context.Course != null)
{
ClassCourse.Add(context.Course);
}
}
public ClassCourseModel GetClassCourse(ClassCourseModel model)
{
Logger.Debug($"{model}");
if (model == null || model.Id == null || model.Id == System.Guid.Empty)
{
throw new System.ArgumentNullException("model");
}
ClassCourse course = this.UnitOfWork.ClassCourseRepository.GetById(model.Id);
ClassCourseModel courseModel = Mapper.Map <Models.ClassCourse, Models.ClassCourseModel>(course);
return(courseModel);
}
public async Task <int> InsertAsync(ClassCourse model, CancellationToken cancellationToken)
{
var sql = @"INSERT INTO [dbo].[ClassesCourses] ([ClassId], [CourseId], [Modified], [Created])
VALUES (@ClassId, @CourseId, @Modified, @Created)";
var param = new
{
model.ClassId,
model.CourseId,
Modified = model.Modified.Value,
model.Created
};
var definition = new CommandDefinition(sql, param, transaction, cancellationToken: cancellationToken);
return(await connection.ExecuteAsync(definition));
}
private void SELECTED(ComboBox st, ComboBox cs)
{
foreach (var student in List_Student)
{
string[] split = st.SelectedItem.ToString().Split('-');
if (student.StudentID == split[0])
{
St = student;
}
}
foreach (var course in List_Course)
{
string[] split = cs.SelectedItem.ToString().Split('-');
if (course.course.classID.ClassID == split[0] && course.course.CourseID == split[1])
{
Cs = course;
}
}
}
public bool Modify(int CODE, Students AStudent, ClassCourse AClassCourse)
{
DataSetRepo dataSet = new DataSetRepo();
if (CODE == 1)
{
foreach (var course in dataSet.GetList_Of_ClassCourses())
{
if (course.course.CourseID == AClassCourse.course.CourseID && course.course.classID.ClassID == AClassCourse.course.classID.ClassID)
{
foreach (var student in course.students)
{
if (AStudent.StudentID == student.StudentID)
{
return(true);
}
}
return(dataSet.AddStudentToClassCourse(AStudent, AClassCourse));
}
}
return(false);
}
else
{
foreach (var course in dataSet.GetList_Of_ClassCourses())
{
if (course.course.CourseID == AClassCourse.course.CourseID && course.course.classID.ClassID == AClassCourse.course.classID.ClassID)
{
if (!checkSameStudentIDInList(AStudent, course.students))
{
return(true);
}
else
{
return(dataSet.RemoveStudentFromClassCourse(AStudent, AClassCourse));
}
}
}
return(false);
}
}
public bool RemoveStudentFromClassCourse(Students AStudent, ClassCourse AClassCourse)
{
foreach (var course in List_Of_ClassCourses)
{
if (course.course.CourseID == AClassCourse.course.CourseID && course.course.classID.ClassID == AClassCourse.course.classID.ClassID)
{
course.students.Remove(AStudent);
try
{
OleDbConnection connect = new OleDbConnection();
connect.ConnectionString = conn;
connect.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = connect;
cmd.CommandText = "DELETE FROM ClassCourses WHERE CourseID = ? AND StudentID = ?";
OleDbParameter para = cmd.Parameters.Add("", OleDbType.VarChar);
para.Value = course.course.CourseID;
para = cmd.Parameters.Add("", OleDbType.VarChar);
para.Value = AStudent.StudentID;
cmd.ExecuteNonQuery();
connect.Close();
return(true);
}
catch
{
}
}
}
return(false);
}
public bool AddStudentToClassCourse(Students AStudent, ClassCourse AClassCourse)
{
foreach (var course in List_Of_ClassCourses)
{
if (course.course.CourseID == AClassCourse.course.CourseID && course.course.classID.ClassID == AClassCourse.course.classID.ClassID)
{
course.students.Add(AStudent);
try
{
OleDbConnection connect = new OleDbConnection();
connect.ConnectionString = conn;
connect.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = connect;
cmd.CommandText = "INSERT INTO ClassCourses VALUES (?,?)";
OleDbParameter para = cmd.Parameters.Add("", OleDbType.VarChar);
para.Value = course.course.CourseID;
para = cmd.Parameters.Add("", OleDbType.VarChar);
para.Value = AStudent.StudentID;
cmd.ExecuteNonQuery();
connect.Close();
return(true);
}catch
{
//return false;
}
}
}
return(false);
}
private Organization.Models.ClassGroup GetRandomClassGroup(int workingShiftInDay)
{
TrainingProgram.Models.TrainingProgram tp = new TrainingProgram.Models.TrainingProgram()
{
Id = Guid.NewGuid(),
Name = Guid.NewGuid().ToString()
};
Organization.Models.ClassGroup cg = new Organization.Models.ClassGroup()
{
Id = Guid.NewGuid(),
Name = Guid.NewGuid().ToString(),
TrainingProgram = tp,
};
int classCount = 0;
while (classCount == 0)
{
classCount = rand.Next(6);
}
List <Organization.Models.ClassRoom> classRooms = new List <Organization.Models.ClassRoom>();
for (int i = 0; i < classCount; i++)
{
Organization.Models.ClassRoom cr = new Organization.Models.ClassRoom()
{
Id = Guid.NewGuid(),
Name = i.ToString(),
ClassGroup = cg,
};
((HashSet <Organization.Models.ClassRoom>)cg.ClassRooms).Add(cr);
classRooms.Add(cr);
}
int courseCount = 0;
while (courseCount == 0)
{
courseCount = rand.Next(5);
}
List <Account.Models.Teacher> teachers = new List <Account.Models.Teacher>();
List <TrainingProgram.Models.Course> courseSubjects = new List <TrainingProgram.Models.Course>();
for (int i = 0; i < courseCount; i++)
{
int sectionPerWeek = 0;
while (sectionPerWeek == 0)
{
sectionPerWeek = rand.Next(3);
}
// Course Subject
TrainingProgram.Models.Course cs = new TrainingProgram.Models.Course()
{
Id = Guid.NewGuid(),
TrainingProgram = tp,
SectionPerWeek = sectionPerWeek
};
((HashSet <TrainingProgram.Models.Course>)tp.CourseSubjects).Add(cs);
courseSubjects.Add(cs);
// Teachers
Account.Models.Teacher tc = new Account.Models.Teacher()
{
Id = Guid.NewGuid(),
};
teachers.Add(tc);
}
for (int i = 0; i < classCount; i++)
{
for (int j = 0; j < courseCount; j++)
{
Organization.Models.ClassCourse c = new ClassCourse()
{
Id = Guid.NewGuid(),
ClassRoom = classRooms[i],
Teacher = teachers[j],
Course = courseSubjects[j]
};
((HashSet <ClassCourse>)classRooms[i].Courses).Add(c);
}
}
return(cg);
}
public UserControlCheckIn(List <Student> attendingStudents, Teacher theTeacher, ClassCourse currentClassCourse)
{
InitializeComponent();
this.AttendingStudents = attendingStudents;
this.TheTeacher = theTeacher;
this.CurrentClassCourse = currentClassCourse;
this.FullClass = theTeacher.GetFullClass(CurrentClassCourse.Class);
this.QrService = new QRService();
// Code to generate QR code for students in the class as the attendance page opens
// foreach (Student student in FullClass)
// {
// if (QrService.SaveQrImage(QrService.EncodeTextToQr(student.StudentId+"*"+student.Password), student.Name))
// {
//
// }
// else
// {
// MessageBox.Show("Not Saved");
// }
//
// }
Loaded += UserControlCheckIn_Loaded;
}
public bool LoadData()
{
try
{
List_Of_Classes = new List <Classes>();
List_Of_Students = new List <Students>();
List_Of_Courses = new List <Courses>();
List_Of_ClassCourses = new List <ClassCourse>();
List_Of_GradeClassCourses = new List <GradeClassCourse>();
List_Of_Account = new List <AccountLogIn>();
OleDbConnection connect = new OleDbConnection();
connect.ConnectionString = conn;
connect.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = connect;
cmd.CommandText = "SELECT * FROM Classes";
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var Class = new Classes();
Class.ClassID = reader.GetString(0);
List_Of_Classes.Add(Class);
}
reader.Close();
cmd.CommandText = "SELECT * FROM Students";
reader = cmd.ExecuteReader();
while (reader.Read())
{
var student = new Students();
student.StudentID = reader.GetString(0);
student.FullName = reader.GetString(1);
student.Gender = reader.GetString(2);
student.ID = reader.GetString(3);
student.classID = new Classes();
student.classID.ClassID = reader.GetString(4);
List_Of_Students.Add(student);
}
reader.Close();
cmd.CommandText = "SELECT * FROM Courses";
reader = cmd.ExecuteReader();
while (reader.Read())
{
var course = new Courses();
course.CourseID = reader.GetString(0);
course.CourseName = reader.GetString(1);
course.Room = reader.GetString(2);
course.classID = new Classes();
course.classID.ClassID = reader.GetString(3);
List_Of_Courses.Add(course);
}
reader.Close();
cmd.CommandText = "SELECT distinct CourseID FROM ClassCourses";
reader = cmd.ExecuteReader();
while (reader.Read())
{
var classCourse = new ClassCourse();
string temp = reader.GetString(0);
foreach (var course in List_Of_Courses)
{
if (course.CourseID == temp)
{
classCourse.course = course;
classCourse.students = new List <Students>();
OleDbCommand cmd2 = new OleDbCommand();
cmd2.Connection = connect;
cmd2.CommandText = $"SELECT StudentID FROM ClassCourses WHERE CourseID = '{course.CourseID}' ";
OleDbDataReader rd = cmd2.ExecuteReader();
while (rd.Read())
{
string StudentID = rd.GetString(0);
foreach (var stu in List_Of_Students)
{
if (stu.StudentID == StudentID)
{
classCourse.students.Add(stu);
}
}
}
rd.Close();
List_Of_ClassCourses.Add(classCourse);
}
}
}
reader.Close();
cmd.CommandText = "SELECT distinct CourseID FROM GradeCourses";
reader = cmd.ExecuteReader();
while (reader.Read())
{
var gradeClassCourse = new GradeClassCourse();
gradeClassCourse.classCourse = new ClassCourse();
string temp = reader.GetString(0);
foreach (var course in List_Of_Courses)
{
if (course.CourseID == temp)
{
gradeClassCourse.classCourse.course = course;
gradeClassCourse.listGrade = new List <Grade>();
OleDbCommand cmd2 = new OleDbCommand();
cmd2.Connection = connect;
cmd2.CommandText = $"SELECT * FROM GradeCourses WHERE CourseID = '{course.CourseID}' ";
OleDbDataReader rd = cmd2.ExecuteReader();
while (rd.Read())
{
Grade newGrade = new Grade();
newGrade.StudentID = rd.GetString(1);
newGrade.GradeGK = rd.GetDouble(2);
newGrade.GradeCK = rd.GetDouble(3);
newGrade.GradeE = rd.GetDouble(4);
newGrade.TotalGrade = rd.GetDouble(5);
gradeClassCourse.listGrade.Add(newGrade);
}
rd.Close();
List_Of_GradeClassCourses.Add(gradeClassCourse);
}
}
}
reader.Close();
cmd.CommandText = "SELECT * FROM Account";
reader = cmd.ExecuteReader();
while (reader.Read())
{
var account = new AccountLogIn();
account.ID = reader.GetString(0);
account.Password = reader.GetString(1);
List_Of_Account.Add(account);
}
reader.Close();
connect.Close();
return(true);
}
catch { return(false); }
}
