public string AddTeacherToSubject(int sub_id, Guid tea_id)
{
Subject subject = db.SubjectsRepository.GetByID(sub_id);
if (subject == null)
{
return("There is no subjects with this id.");
}
Teacher teacher = db.TeachersRepository.GetByID(tea_id.ToString());
if (teacher == null)
{
return("There is no teachers with this id.");
}
TeachesSubjects ts = new TeachesSubjects();
ts.IdSubject = subject.IdSubject;
ts.Subject = subject;
ts.IdTeacher = Guid.Parse(teacher.Id);
ts.Teacher = teacher;
subject.Teachers.Add(ts);
teacher.Subjects.Add(ts);
db.teach_subj_repo.Insert(ts);
db.SubjectsRepository.Update(subject);
db.TeachersRepository.Update(teacher);
db.Save();
return("Teacher added successfully");
}
public IEnumerable <MarkDto> GetStudentMarks(Guid student_id)
{
Student student = db.StudentsRepository.GetByID(student_id.ToString());
if (student == null)
{
return(null);
}
List <Mark> marks = student.Marks.ToList();
List <MarkDto> markss = new List <MarkDto>();
if (marks.Count != 0)
{
foreach (var mark in marks)
{
MarkDto dto = new MarkDto();
int tsId = Convert.ToInt32(mark.IdTeachesSubject);
TeachesSubjects ts = db.teach_subj_repo.GetByID(tsId);
Teacher teach = db.TeachersRepository.GetByID(ts.IdTeacher.ToString());
dto.TeachersName = teach.FirstName + " " + teach.LastName;
dto.Subject = mark.TeacherAndSubject.Subject.Name;
dto.Mark = mark.Marks.ToString();
markss.Add(dto);
}
return(markss);
}
return(null);
}
public string UpdateSubject(int id, SubjectDto subjectDto)
{
Subject subject = db.SubjectsRepository.GetByID(id);
TeachesSubjects ts = new TeachesSubjects();
if (subject == null)
{
return(null);
}
if (subjectDto.Teachers != null)
{
foreach (var teacher in subjectDto.Teachers)
{
ApplicationUser user = db.AuthRepository.FindUserByUsername(teacher.Username);
if (user != null)
{
return("There is a user with this (" + teacher.Username + ") username.");
}
Teacher teacherr = new Teacher()
{
FirstName = teacher.Name,
LastName = teacher.Surname,
UserName = teacher.Username,
Email = teacher.Email
};
ts.Teacher = teacherr;
ts.Subject = subject;
teacherr.Subjects.Add(ts);
subject.Teachers.Add(ts);
db.teach_subj_repo.Insert(ts);
db.TeachersRepository.Update(teacherr);
//db.SubjectsRepository.Update(subject);
db.Save();
}
}
subject.Name = subjectDto.SubjectName;
subject.WeeklyClassNo = subjectDto.WeeklyClassNo;
db.SubjectsRepository.Update(subject);
db.Save();
return("Subject updated successfully");
}
public Teacher TeacherDtoToTeacher(TeacherDto teacherDto)
{
//if (teacherDto == null)
//{
// return null;
//}
Teacher teacher = db.TeachersRepository.TeacherDtoToTeacher(teacherDto);
TeachesSubjects ts = new TeachesSubjects();
if (teacherDto.Subjects != null)
{
foreach (var subject in teacherDto.Subjects)
{
Subject subjectt = db.SubjectsRepository.DtoToSubject(subject);
ts.Teacher = teacher;
ts.Subject = subjectt;
teacher.Subjects.Add(ts);
}
}
return(teacher);
}
public Subject DtoToSubject(SubjectDto subject_dto)
{
TeachesSubjects ts = new TeachesSubjects();
List <TeachesSubjects> tss = new List <TeachesSubjects>();
Subject subject = db.SubjectsRepository.DtoToSubject(subject_dto);
if (subject != null)
{
if (subject.Teachers.Count() != 0)
{
foreach (var teacher in subject_dto.Teachers)
{
ts.Teacher = db.TeachersRepository.TeacherDtoToTeacher(teacher);
ts.Subject = subject;
tss.Add(ts);
}
subject.Teachers = tss;
}
return(subject);
}
return(null);
}
public Mark PostMark(string teacher_id, string student_id, int subject_id, int mark)
{
Teacher teacher = db.TeachersRepository.GetByID(teacher_id);
Student student = db.StudentsRepository.GetByID(student_id);
Subject subject = db.SubjectsRepository.GetByID(subject_id);
TeachesSubjects ts = new TeachesSubjects();
Mark markk = new Mark();
if (teacher == null || student == null || subject == null)
{
return(null);
}
List <Parent> parents = student.Parents.ToList();
ts.IdSubject = subject_id;
ts.IdTeacher = Guid.Parse(teacher_id);
if (mark > 0 && mark < 6)
{
markk.Student = student;
markk.TeacherAndSubject = ts;
markk.IdStudent = student_id;
markk.Marks = (Marks)mark;
student.Marks.Add(markk);
db.StudentsRepository.Update(student);
db.MarksRepository.Insert(markk);
db.Save();
}
if (parents.Count() != 0)
{
foreach (var item in parents)
{
PostSendMail("*****@*****.**", item.FirstName, markk);
}
}
return(markk);
}
