private void DoChangePassword(string oldPassword, string newPassword, string retryPassword) { if (newPassword == retryPassword) { using (var context = new Classmaister5000Entities()) { var user = context.Users.Find(UIRepository.Instance.CurrentClientId); if (oldPassword == user.Password) { if (newPassword != user.Password) { user.Password = newPassword; context.Entry(user).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); MessageBox.Show("Password changed successfully!"); Application.Current.Windows[1].Close(); } else { MessageBox.Show("The new password cannot be the old password!"); } } else { MessageBox.Show("Your old password doesn't match!"); } } } else { MessageBox.Show("The two passwords doesn't match!"); } }
public static bool AddToTimetable(int courseId) { using (var context = new Classmaister5000Entities()) { var course = context.Courses.Find(courseId); ICollection <Timetable> records = context.Timetables.ToList(); ICollection <Course> courses = new List <Course>(); foreach (var item in records) { courses.Add(context.Courses.Where(c => c.Id == item.Course_Id).First()); } bool exists = false; Course changeThis = null; foreach (var item in courses) { if (item.Subject_Id == course.Subject_Id) { exists = true; changeThis = item; } } if (!exists) { int?id = context.Timetables.Max(i => (int?)i.Id) + 1; if (id == null) { id = 0; } TimetableModel record = new TimetableModel(); record.UserId = GetUserId; record.CourseId = courseId; record.Id = (int)id + 1; context.Timetables.Add(TimetableMapper.ModelToEntity(record)); context.SaveChanges(); } else { var changeThisPlease = context.Timetables.Where(t => t.Course_Id == changeThis.Id).First(); changeThisPlease.Course_Id = courseId; context.Entry(changeThisPlease).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } return(true); }
public static void DeleteCourse(int id) { using (var context = new Classmaister5000Entities()) { var deleteThis = context.Courses.Where(c => c.Id == id).First(); TimetableActions.RemoveFromTimetableByCourseId(id); context.Courses.Remove(deleteThis); context.SaveChanges(); } }
public static void UserLogout() { using (var context = new Classmaister5000Entities()) { var CurrentUser = context.Users.Where(u => u.Id == UIRepository.Instance.CurrentClientId).First(); CurrentUser.LastLogin = DateTime.Now; context.Entry(CurrentUser).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } UIRepository.Instance.CurrentClientId = 0; }
public static bool RemoveFromTimetableByCourseId(int courseId) { using (var context = new Classmaister5000Entities()) { ICollection <Timetable> removeThese = context.Timetables.Where(c => c.Course_Id == courseId).ToList(); context.Timetables.RemoveRange(removeThese); context.SaveChanges(); } return(true); }
public static bool RemoveFromTimetable(int id) { using (var context = new Classmaister5000Entities()) { Timetable removeThis = context.Timetables.Find(id); context.Timetables.Remove(removeThis); context.SaveChanges(); } return(true); }
public static bool CourseAdd(string name, string teacher, string room, int dayId, DateTime from, DateTime to, int subjectId) { if (!HasCourse(name, subjectId)) { if (from.Hour < to.Hour) { if (!IsTeacherBusy(teacher, dayId, from, to)) { using (var context = new Classmaister5000Entities()) { //CourseModel newCourse = new CourseModel(); //newCourse.Name = name; //newCourse.Teacher = teacher; //newCourse.Room = room; //newCourse.Day_Id = dayId; //newCourse.From = from; //newCourse.To = to; //newCourse.Subject_Id = subjectId; //context.Courses.Add(CourseMapper.ModelToEntity(newCourse)); Course newCourse = new Course(); newCourse.Day_Id = dayId; newCourse.Room = room; newCourse.Teacher = teacher; newCourse.Name = name; newCourse.Subject_Id = subjectId; newCourse.From = from; newCourse.To = to; context.Courses.Add(newCourse); context.SaveChanges(); return(true); } } else { throw new TeacherBusyException(); } } else { throw new InvalidTimeException(); } } else { throw new CourseAlreadyExistsException(); } }
public static bool SubjectAdd(string Name, bool IsLecture) { if (!HasSubjectName(Name)) { using (var context = new Classmaister5000Entities()) { SubjectModel newSubject = new SubjectModel(); newSubject.SubjectName = Name; newSubject.IsLecture = IsLecture; newSubject.User_Id = GetUserId; context.Subjects.Add(SubjectMapper.ModelToEntity(newSubject)); context.SaveChanges(); return(true); } } else { throw new SubjectAlreadyExistsException(); } }
public static void RegisterUser(string username, string password, string RetryPassword, string FirstName, string LastName) { using (var context = new Classmaister5000Entities()) { if (HasUserName(username)) { throw new UsernameAlreadyExistsException(); } else if (password == RetryPassword) { UserModel NewUser = new UserModel(FirstName, LastName, username, password); context.Users.Add(UserMapper.ModelToEntity(NewUser)); context.SaveChanges(); } else { throw new PasswordsNotEqualsException(); } } }
public static bool SubjectRemove(string Name) { if (HasSubjectName(Name)) { using (var context = new Classmaister5000Entities()) { Subject removeThis = context.Subjects.Where(s => s.SubjectName.ToLower() == Name.ToLower()).First(); ICollection <Course> removeTheseCourses = removeThis.Courses; foreach (var item in removeTheseCourses) { TimetableActions.RemoveFromTimetableByCourseId(item.Id); } context.Courses.RemoveRange(removeTheseCourses); context.Subjects.Remove(removeThis); context.SaveChanges(); return(true); } } else { throw new SubjectNotExistsException(); } }