public static void ValidateUser(CUser user, string authToken)
{
try
{
using (var db = new RecContext())
{
var teacher = db.Teacher.Where(t => t.Email == user.EmailAddress).FirstOrDefault();
if (teacher == null)
{
user.ExistsOnServer = false;
return;
}
user.ExistsOnServer = true;
user.TeacherId = teacher.TeacherId;
db.Update(teacher);
teacher.AuthorizationToken = authToken;
db.SaveChanges();
}
}
catch (Exception e)
{
var sException = new ServerException(e.Message, e, true);
LogServerException(sException);
}
}
public static void UpdateExistingTeacher(CTeacher teacher, int userId)
{
try
{
using (var db = new RecContext())
{
var dbTeacher = db.Teacher.Where(t => t.TeacherId == teacher.TeacherId).First();
db.Update(dbTeacher);
dbTeacher.FirstName = teacher.FirstName;
dbTeacher.LastName = teacher.LastName;
dbTeacher.Email = teacher.EmailAddress;
var recId = GetRecIdForUser(userId, db);
var recTeacher = db.RecTeacher.Where(rt => rt.TeacherId == teacher.TeacherId && rt.RecId == recId).FirstOrDefault();
db.Update(recTeacher);
recTeacher.IsAdministrator = teacher.IsAdministrator;
if (teacher.IsDisabled)
{
recTeacher.DisableDate = DateTime.Now;
}
foreach (CClassTerm classTerm in teacher.ClassesTaught)
{
var dbClassTerm = db.ClassTermTeacher.Where(ctt => ctt.TeacherId == teacher.TeacherId && ctt.ClassTermId == classTerm.ClassTermId).FirstOrDefault();
if (dbClassTerm == null)
{
db.Add(new ClassTermTeacher
{
ClassTermId = classTerm.ClassTermId,
TeacherId = teacher.TeacherId
});
}
else if (classTerm.Operation == Operation.Deleted)
{
db.Remove(dbClassTerm);
}
}
db.SaveChanges();
}
}
catch (Exception e)
{
var sException = new ServerException(e.Message, e, false);
LogServerException(sException);
}
}
public static void UpdateAttendance(CSession sessionAttendance)
{
List <Attendance> attendanceList = new List <Attendance>();
try
{
using (var db = new RecContext())
{
foreach (CAttendance student in sessionAttendance.Students)
{
var dbObject = db.Attendance.Where(a => a.SessionId == sessionAttendance.SessionId && a.StudentId == student.StudentId).FirstOrDefault();
bool doesNotExist = dbObject == null;
if (doesNotExist)
{
db.Add(new Attendance
{
AttendanceStatusId = (int)student.AttendanceStatusId,
ReasonId = student.ReasonId,
SessionId = sessionAttendance.SessionId,
StudentId = student.StudentId,
CreationDtTm = DateTime.Now
});
}
else
{
db.Update(dbObject);
dbObject.AttendanceStatusId = (int)student.AttendanceStatusId;
dbObject.ReasonId = student.ReasonId;
dbObject.CreationDtTm = DateTime.Now;
}
}
db.SaveChangesAsync();
}
}
catch (Exception e)
{
var sException = new ServerException(e.Message, e, false);
LogServerException(sException);
}
}
public static void SignOut(string authToken)
{
try
{
using (var db = new RecContext())
{
var teacher = db.Teacher.Where(t => t.AuthorizationToken == authToken).FirstOrDefault();
if (teacher == null)
{
return;
}
db.Update(teacher);
teacher.AuthorizationToken = null;
db.SaveChanges();
}
}
catch (Exception e)
{
var sException = new ServerException(e.Message, e, true);
LogServerException(sException);
}
}