public async Task SetClasses(string identification, string user)
{
var classes = await _db.Classes.FirstOrDefaultAsync(x => x.Identification == identification);
var student = await _db.Students.FirstOrDefaultAsync(x => x.Mail == user);
student.Class = classes;
await _db.SaveChangesAsync();
}
public async Task AddMark(int subjectCardId, int grade)
{
var mark = new Mark
{
SubjectCardID = subjectCardId,
Grade = grade,
InsertionDate = DateTime.Now
};
await _db.Marks.AddAsync(mark);
await _db.SaveChangesAsync();
}
public async Task AddTeacherSubject(string subjectName, string user)
{
var subject = await _db.Subjects.FirstOrDefaultAsync(x => x.Name == subjectName);
var teacher = await _db.Teachers.FirstOrDefaultAsync(x => x.Mail == user);
await _db.TeacherSubjects.AddAsync(new TeacherSubject
{
SubjectID = subject.SubjectID,
TeacherID = teacher.TeacherID,
});
await _db.SaveChangesAsync();
}
public async Task SetTeacherSubjectClasses(TeacherClassesViewModel teacherClasses, string user)
{
var subject = await _db.Subjects.FirstOrDefaultAsync(x => x.Name == teacherClasses.Subject);
var classes = await _db.Classes.FirstOrDefaultAsync(x => x.Identification == teacherClasses.Class);
var teacher = await _db.Teachers.FirstOrDefaultAsync(x => x.Mail == user);
var teacherSubjectsClasses = await _db.TeacherSubjectClasses.FirstOrDefaultAsync(x => x.ClassID == classes.ClassID &&
x.SubjectID == subject.SubjectID);
teacherSubjectsClasses.TeacherID = teacher.TeacherID;
await _db.SaveChangesAsync();
}