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);
}
}
