public static void CreateUserCred(string id, string username, string password) { try { using (SmacEntities context = new SmacEntities()) { if (DoesUsernameExist(username, id)) { throw new Exception("Username already exists. Please select another."); } UserCredential cred = new UserCredential() { Password = password, UserName = GetSHA256Hash(password), User = UserEntity.GetUser(id) }; context.UserCredentials.Add(cred); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void MarkAllConvosAsRead(string userId, string otherUserId) { try { using (SmacEntities context = new SmacEntities()) { var msgs = (from a in context.PrivateMessages where (a.FromUser == userId && a.ToUser == otherUserId) || (a.FromUser == otherUserId && a.ToUser == userId) select a).ToList(); foreach (var pm in msgs) { if (pm.DateRead == null && pm.FromUser != userId) { pm.DateRead = DateTime.Now; context.Entry(pm).State = EntityState.Modified; } } context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void UpdateUserCred(string id, string username, string password) { try { using (SmacEntities context = new SmacEntities()) { var cred = GetUserCred(id); if (cred == null) { throw new Exception("User Credentials could not be found."); } if (DoesUsernameExist(username, id)) { throw new Exception("Username already exists. Please select another."); } cred.UserName = username; if (password != null) { cred.Password = GetSHA256Hash(password); } context.Entry(cred).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void SendPrivateMessage(string toUserId, string fromUserId, string content) { try { using (SmacEntities context = new SmacEntities()) { PrivateMessage pm = new PrivateMessage() { Content = content, DateSent = DateTime.Now, DateRead = null, UserSentFrom = UserEntity.GetUser(fromUserId, context), UserSentTo = UserEntity.GetUser(toUserId, context), ToUser = toUserId, FromUser = fromUserId }; context.PrivateMessages.Add(pm); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void CreateTimeSlot(int schoolId, TimeSpan start, TimeSpan end) { try { using (SmacEntities context = new SmacEntities()) { if ((from a in context.TimeSlots where a.StartTime == start && a.EndTime == end && a.SchoolId == schoolId select a).FirstOrDefault() != null) { throw new Exception("Time slot already exists. Time slot not created."); } TimeSlot ts = new TimeSlot() { School = (from a in context.Schools where a.SchoolId == schoolId select a).FirstOrDefault(), StartTime = start, EndTime = end }; context.TimeSlots.Add(ts); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void CreateEnrollment(string studentId, int periodId, int sectionId) { try { using (SmacEntities context = new SmacEntities()) { var curEnroll = (from a in context.Enrollments where a.UserId == studentId && a.MarkingPeriodId == periodId && a.SectionId == sectionId select a).FirstOrDefault(); if (curEnroll != null) { throw new Exception("Enrollment already exists for " + curEnroll.Student.User.FirstName + " " + curEnroll.Student.User.LastName); } var enroll = new Enrollment() { Student = (from a in context.Students where a.UserId == studentId select a).FirstOrDefault(), MarkingPeriod = (from a in context.MarkingPeriods where a.MarkingPeriodId == periodId select a).FirstOrDefault(), Section = (from a in context.Sections where a.SectionId == sectionId select a).FirstOrDefault() }; context.Enrollments.Add(enroll); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static List <Gender> GetGenders() { using (SmacEntities context = new SmacEntities()) { return((from a in context.Genders select a).ToList()); } }
public static void PromoteAdmin(string Id) { try { using (SmacEntities context = new SmacEntities()) { if (UserEntity.GetUser(Id) == null) { throw new Exception("User not set as Admin. User ID doesn't exist."); } else { if (IsAdmin(Id)) { throw new Exception("User not set as Admin. User already set as Admin."); } else { Admin admin = new Admin(); admin.UserId = Id; admin.User = UserEntity.GetUser(Id); context.Admins.Add(admin); context.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }
public static void DeleteUser(string Id) { try { using (SmacEntities context = new SmacEntities()) { if ((from a in context.Users where a.UserId == Id select a).FirstOrDefault() == null) { throw new Exception("User was not deleted. User ID not found."); } else { var user = (from a in context.Users where a.UserId == Id select a).FirstOrDefault(); context.Users.Remove(user); context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static void UpdateTimeSlot(int schoolId, TimeSpan start, TimeSpan end, int id) { try { using (SmacEntities context = new SmacEntities()) { if ((from a in context.TimeSlots where a.TimeSlotId == id select a) == null) { throw new Exception("Time slot could not be found"); } if ((from a in context.TimeSlots where a.StartTime == start && a.EndTime == end && a.SchoolId == schoolId && a.TimeSlotId != id select a).FirstOrDefault() != null) { throw new Exception("Time slot already exists. Time slot not updated."); } TimeSlot ts = (from a in context.TimeSlots where a.TimeSlotId == id select a).FirstOrDefault(); ts.StartTime = start; ts.EndTime = end; context.Entry(ts).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static DateTime?GetLastLoggedOut(string Id) { using (SmacEntities context = new SmacEntities()) { return((from a in context.Users where a.UserId == Id select a).FirstOrDefault().LastLoggedOut); } }
public static void AddEndDate(string Id, DateTime endDate) { try { using (SmacEntities context = new SmacEntities()) { if (GetUser(Id) == null) { throw new Exception("User was not edited. User ID not found."); } else { var user = GetUser(Id); user.EndDate = endDate; context.Entry(user).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static List <usp_GetUsersInSchool_Result> GetAllUsersInSchool(int schoolId, string userIdToFilter) { using (SmacEntities context = new SmacEntities()) { return(context.usp_GetUsersInSchool(schoolId, userIdToFilter).OrderBy(t => t.LastName).ToList()); } }
public static Roles GetUserRole(string userId) { using (SmacEntities context = new SmacEntities()) { var user = (from a in context.Users where a.UserId == userId select a).FirstOrDefault(); if (user.Admin != null) { return(Roles.Admin); } else if (user.Student != null) { return(Roles.Student); } else if (user.Staff != null) { return(Roles.Staff); } else if (user.Teacher != null) { return(Roles.Teacher); } else { return(Roles.None); } } }
public static void CreateGrade(string val, int schoolId) { try { using (SmacEntities context = new SmacEntities()) { if ((from a in context.Grades where a.SchoolId == schoolId && a.GradeValue == val select a).FirstOrDefault() != null) { throw new Exception("Grade not created as it already exists."); } Grade grade = new Grade() { GradeValue = val, School = (from a in context.Schools where a.SchoolId == schoolId select a).FirstOrDefault() }; context.Grades.Add(grade); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void RevokeAdmin(string Id) { try { using (SmacEntities context = new SmacEntities()) { if (UserEntity.GetUser(Id) == null) { throw new Exception("User not removed as Admin. User doesn't exist."); } else if (!IsAdmin(Id)) { throw new Exception("User not removed as Admin. User not an Admin."); } else { Admin admin = new Admin(); admin.UserId = Id; admin.User = UserEntity.GetUser(Id); context.Admins.Add(admin); context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static void CreateSchedule(int sectionId, int tsId, string day, int periodId) { try { using (SmacEntities context = new SmacEntities()) { if ((from a in context.SectionSchedules where a.SectionId == sectionId && a.TimeSlotId == tsId && a.DayValue == day && a.MarkingPeriodId == periodId select a).FirstOrDefault() != null) { throw new Exception("Schedule already exists for this section."); } SectionSchedule sch = new SectionSchedule() { Section = (from a in context.Sections where a.SectionId == sectionId select a).FirstOrDefault(), Day = (from a in context.Days where a.DayValue == day select a).FirstOrDefault(), TimeSlot = (from a in context.TimeSlots where a.TimeSlotId == tsId select a).FirstOrDefault(), MarkingPeriod = (from a in context.MarkingPeriods where a.MarkingPeriodId == periodId select a).FirstOrDefault() }; context.SectionSchedules.Add(sch); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static Gender GetGender(string gType) { using (SmacEntities context = new SmacEntities()) { return((from a in context.Genders where a.GenderType == gType select a).FirstOrDefault()); } }
public static void RemoveGrade(string studentId, int schoolId, int subjectId, int classId, int sectionId, int markingPeriodId) { try { using (SmacEntities context = new SmacEntities()) { var enroll = GetEnrollment(studentId, schoolId, subjectId, classId, sectionId, markingPeriodId); if (enroll != null) { enroll.GradeValue = null; context.Entry(enroll).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } else { throw new Exception("Enrollment not found. Grade not set."); } } } catch (Exception ex) { throw ex; } }
public static void SetGrade(string studentId, int sectionId, int markingPeriodId, string grade) { try { using (SmacEntities context = new SmacEntities()) { var enroll = (from a in context.Enrollments where a.UserId == studentId && a.SectionId == sectionId && a.MarkingPeriodId == markingPeriodId select a).FirstOrDefault(); if (enroll != null) { enroll.GradeValue = grade; context.Entry(enroll).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } else { throw new Exception("Enrollment not found. Grade not set."); } } } catch (Exception ex) { throw ex; } }
public static List <usp_GetUsersInSchool_Result> GetAllStudentsInSchool(int schoolId) { using (SmacEntities context = new SmacEntities()) { return(context.usp_GetUsersInSchool(schoolId, string.Empty).OrderBy(t => t.LastName).Where(t => t.Student == true).ToList()); } }
public static void PromoteStudent(string uId) { try { using (SmacEntities context = new SmacEntities()) { if (UserEntity.GetUser(uId) == null) { throw new Exception("User not set as Student. User ID doesn't exist."); } else { if (IsStudent(uId)) { throw new Exception("User not set as Student. User already set as Student."); } else { Student Student = new Student(); Student.UserId = uId; Student.User = UserEntity.GetUser(uId); context.Students.Add(Student); context.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }
public static bool IsStudent(string uId) { using (SmacEntities context = new SmacEntities()) { return((from a in context.Students where a.UserId == uId select a).FirstOrDefault() != null); } }
public static void RevokeStudent(string uId) { try { using (SmacEntities context = new SmacEntities()) { if (UserEntity.GetUser(uId) == null) { throw new Exception("User not removed as Student. User doesn't exist."); } else if (!IsStudent(uId)) { throw new Exception("User not removed as Student. User not an Student."); } else { Student Student = new Student(); Student.UserId = uId; Student.User = UserEntity.GetUser(uId); context.Students.Add(Student); context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static KhanShare CreateKhanShare(string title, string url, string apiId) { try { using (SmacEntities context = new SmacEntities()) { var ks = GetKhanShare(title, url, apiId); if (ks != null) { KhanShare newKs = new KhanShare() { ApiId = apiId, Url = url, Title = title }; context.KhanShares.Add(newKs); context.SaveChanges(); } return(GetKhanShare(title, url, apiId)); } } catch (Exception ex) { throw ex; } }
public static void CreatePost(string userId, string title, int sectionId, string content, int?repliedTo) { try { using (SmacEntities context = new SmacEntities()) { var thread = new Thread() { Section = (from a in context.Sections where a.SectionId == sectionId select a).FirstOrDefault(), RepliedTo = repliedTo, DateTimePosted = DateTime.Now, Content = content, ThreadTitle = title, User = (from a in context.Users where a.UserId == userId select a).FirstOrDefault() }; context.Threads.Add(thread); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void PromoteTeacher(string uId) { try { using (SmacEntities context = new SmacEntities()) { if (UserEntity.GetUser(uId) == null) { throw new Exception("User not set as Teacher. User ID doesn't exist."); } else { if (IsTeacher(uId)) { throw new Exception("User not set as Teacher. User already set as Teacher."); } else { Teacher Teacher = new Teacher(); Teacher.UserId = uId; Teacher.User = UserEntity.GetUser(uId); context.Teachers.Add(Teacher); context.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }
public static void RevokeTeacher(string uId) { try { using (SmacEntities context = new SmacEntities()) { if (UserEntity.GetUser(uId) == null) { throw new Exception("User not removed as Teacher. User doesn't exist."); } else if (!IsTeacher(uId)) { throw new Exception("User not removed as Teacher. User is not a Teacher."); } else { Teacher Teacher = new Teacher(); Teacher.UserId = uId; Teacher.User = UserEntity.GetUser(uId); context.Teachers.Add(Teacher); context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
private static void CreateEditMarkingPeriod(string op, int?markingPeriodId, string period, bool fullYear, int schoolYearId, DateTime start, DateTime end) { try { using (SmacEntities context = new SmacEntities()) { if (op.Equals("ADD")) { if ((from a in context.MarkingPeriods where a.Period == period && a.FullYear == fullYear && a.SchoolYearId == schoolYearId select a).FirstOrDefault() != null) { throw new Exception("Marking period was not created. Marking period already exists for this school year."); } MarkingPeriod MarkingPeriod = new MarkingPeriod() { SchoolYear = (from a in context.SchoolYears where a.SchoolYearId == schoolYearId select a).FirstOrDefault(), Period = fullYear ? null : period, FullYear = fullYear, StartDate = start, EndDate = end }; context.MarkingPeriods.Add(MarkingPeriod); context.SaveChanges(); } else if (op.Equals("EDIT")) { var mPeriod = (from a in context.MarkingPeriods where a.MarkingPeriodId == markingPeriodId.Value select a).FirstOrDefault(); if (mPeriod == null) { throw new Exception("Marking period was not updated. Marking period not found."); } if (GetMarkingPeriod(period, fullYear, schoolYearId, markingPeriodId.Value, context) != null) { throw new Exception("Marking period was not updated. New marking period values already exist."); } mPeriod.Period = fullYear ? null : period; mPeriod.FullYear = fullYear; mPeriod.StartDate = start; mPeriod.EndDate = end; mPeriod.SchoolYear = (from a in context.SchoolYears where a.SchoolYearId == schoolYearId select a).FirstOrDefault(); context.Entry(mPeriod).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
private static void CreateEditSchoolYear(string op, int schoolId, string year, DateTime start, DateTime end, int?schoolYearId) { try { using (SmacEntities context = new SmacEntities()) { if (op.Equals("ADD")) { if ((from a in context.SchoolYears where a.Year == year select a).FirstOrDefault() != null) { throw new Exception("School year was not created. School year already exists for this school."); } else { SchoolYear schoolyear = new SchoolYear() { School = (from a in context.Schools where a.SchoolId == schoolId select a).FirstOrDefault(), Year = year, StartDate = start, EndDate = end }; context.SchoolYears.Add(schoolyear); context.SaveChanges(); } } else if (op.Equals("EDIT")) { if ((from a in context.SchoolYears where a.SchoolYearId == schoolYearId.Value select a).FirstOrDefault() == null) { throw new Exception("Subject was not updated. Subject name not found."); } else if ((from a in context.SchoolYears where a.SchoolYearId != schoolYearId.Value && a.SchoolId == schoolId && a.Year == year select a).FirstOrDefault() != null) { throw new Exception("Subject was not updated. New subject name already exists in database."); } else { var schYear = (from a in context.SchoolYears where a.SchoolYearId == schoolYearId.Value select a).FirstOrDefault(); schYear.Year = year; schYear.StartDate = start; schYear.EndDate = end; context.Entry(schYear).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }