public bool RegisterAdmin(UserModel model, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { if (!context.Users.Where(x => x.Login == model.Login).Any()) { using (var transaction = context.Database.BeginTransaction()) { Users user = new Users { Login = model.Login, Password = SecurityService.GetSHA256Hash(model.Password), Firstname = model.FirstName, Lastname = model.LastName, Pesel = model.PESEL, City = model.City, Address = model.Address, Dateofbirth = model.DateOfBirth, Usertype = (int)UserTypes.Admin }; try { context.Add(user); context.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); errorMessage = PortalMessages.InsertDBError; } } return(true); } errorMessage = ValidationMessages.UsedLogin; return(false); } }
public bool AddSubject(SubjectModel model, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { if (!context.Subjects.Where(x => x.Name == model.Name).AnyLazy()) { Subjects subject = new Subjects() { Name = model.Name, Description = model.Description, Leaderid = model.LeaderId.Value }; Subjectssemesters subSem = new Subjectssemesters(); using (var transaction = context.Database.BeginTransaction()) { try { context.Add(subject); context.SaveChanges(); int id = context.Subjects.Where(x => x.Name == subject.Name).Select(x => x.Id).First(); subSem.Subjectid = id; subSem.Semesterid = model.SemesterId.Value; context.Add(subSem); context.SaveChanges(); transaction.Commit(); return(true); } catch (Exception) { transaction.Rollback(); errorMessage = PortalMessages.InvalidData; } } } else { errorMessage = PortalMessages.SubjectExist; } return(false); } }
public void AddSemester(SemesterModel model) { using (SZPNUWContext context = new SZPNUWContext()) { Semesters semester = new Semesters() { Fieldofstudy = model.Department, Academicyear = model.Year, Semesternumber = model.SemesterNumber }; context.Add(semester); context.SaveChanges(); } }
public bool AddSubjectSemester(SubjectSemesterModel model, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { if (!context.Subjectssemesters.Where(x => x.Subjectid == model.SubjectId && x.Semesterid == model.SemesterId).AnyLazy()) { Subjectssemesters subSem = new Subjectssemesters(); subSem.Subjectid = model.SubjectId; subSem.Semesterid = model.SemesterId; context.Add(subSem); context.SaveChanges(); return(true); } else { errorMessage = PortalMessages.ObjectExist; } return(false); } }
public bool RegisterStudent(StudentModel model, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { if (!context.Users.Where(x => x.Login == model.Login).Any()) { if (!context.Students.Where(x => x.Albumnumber == model.AlbumNumber).Any()) { using (var transaction = context.Database.BeginTransaction()) { Users user = new Users { Login = model.Login, Password = SecurityService.GetSHA256Hash(model.Password), Firstname = model.FirstName, Lastname = model.LastName, Pesel = model.PESEL, City = model.City, Address = model.Address, Dateofbirth = model.DateOfBirth, Usertype = (int)UserTypes.Student }; Students student = new Students { Albumnumber = model.AlbumNumber, }; user.Students = student; try { Semesters semester = context.Semesters.First(x => x.Id == model.Semester.Id); student.Studentsemester.Add(new Studentsemester { Semester = semester }); context.Add(user); context.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); throw new Exception(PortalMessages.InsertDBError); } } return(true); } } errorMessage = ValidationMessages.UsedLogin; return(false); } }