public static void UpdateGroup(int groupID, int teacherID, string subject, string gradeSection, string description)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
//get gradeID using gradeSection
int gradeID = (from grade in context.Grades where grade.GradeNo + grade.Section == gradeSection select grade.GradeID).FirstOrDefault();
if (gradeID == 0)
{
throw new ArgumentOutOfRangeException("Grade name is invalid!");
}
//get subjectID
int subjID = (from subj in context.Subjects where subj.Title == subject select subj.SubjectID).FirstOrDefault();
if (subjID == 0)
{
throw new ArgumentOutOfRangeException("Subject title is invalid!");
}
Group groupToUpdate = context.Set <Group>().Find(groupID);
groupToUpdate.GroupID = groupID;
groupToUpdate.GradeID = gradeID;
groupToUpdate.SubjectID = subjID;
groupToUpdate.TeacherID = teacherID;
groupToUpdate.Description = description;
context.SaveChanges();
}
}
public static void UpdateUserInfo(UserInfo userInfo)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
User userToUpdate = (User)context.Set <User>().Find(userInfo.UserID);
userToUpdate.UserID = userInfo.UserID;
userToUpdate.LastName = userInfo.LastName;
userToUpdate.FirstName = userInfo.FirstName;
userToUpdate.Patronymic = userInfo.Patronymic;
if (userToUpdate.Password == userInfo.Password) //password supplied is crypted already
{
//do nothing - passwords already the same
}
else
{
userToUpdate.Password = Crypter.Blowfish.Crypt(userInfo.Password);
}
if (!Util.IsValidEmail(userInfo.Email))
{
throw new ArgumentException("Email string is not a valid email!");
}
userToUpdate.Email = userInfo.Email;
userToUpdate.Phone = userInfo.Phone;
userToUpdate.DateOfBirth = userInfo.DoB;
context.SaveChanges();
}
}
/// <summary>
/// Changes user password
/// </summary>
/// <param name="UserID">UserID</param>
/// <param name="oldPass">old plain text password</param>
/// <param name="newPass">new plain text password</param>
public static void ChangeUserPassword(int UserID, string oldPass, string newPass)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
if (newPass.Length > 0)
{
User userToUpdate = (User)context.Set <User>().Find(UserID);
//if (userToUpdate.Password.Equals(oldPass))
if (Crypter.CheckPassword(oldPass, userToUpdate.Password))
{
//userToUpdate.Password = newPass;
userToUpdate.Password = Crypter.Blowfish.Crypt(newPass);
context.SaveChanges();
}
else
{
throw new ArgumentException("Old password is incorrect!");
}
}
else
{
throw new ArgumentOutOfRangeException("New password is empty!");
}
}
}
/// <summary>
/// Updates a user
/// </summary>
/// <param name="u">New passwords supplied should be plain text!</param>
public static void UpdateUser(UserInfo u)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
User userToUpdate = (User)context.Set <User>().Find(u.UserID);
if (userToUpdate == null)
{
throw new ArgumentException("UserID is incorrect!");
}
userToUpdate.FirstName = u.FirstName;
userToUpdate.LastName = u.LastName;
userToUpdate.Patronymic = u.Patronymic;
userToUpdate.DateOfBirth = u.DoB;
if (!Util.IsValidEmail(u.Email))
{
throw new ArgumentException("Email string is not a valid email!");
}
userToUpdate.Email = u.Email;
if (userToUpdate.Password != u.Password) //new password supplied => crypt it!
{
userToUpdate.Password = Crypter.Blowfish.Crypt(u.Password);
}
userToUpdate.Phone = u.Phone;
context.SaveChanges();
}
}
public static void UpdateStudent(StudentInfo si)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Student s = context.Set <Student>().Find(si.StudentID);
if (s == null)
{
throw new ArgumentNullException("StudentID to update cannot be null!");
}
if (!Util.IsValidEmail(si.Email))
{
throw new ArgumentException("Email string is not a valid email!");
}
UsersDAL.UpdateUser(si);
s.DateOfJoin = si.DateOfJoin;
//find grade ID
var gID = (from grade in context.Grades where (grade.GradeNo + grade.Section).Equals(si.GradeName) select grade.GradeID);
if (gID.Count() > 0)
{
s.GradeID = gID.First();
}
else
{
throw new ArgumentException("Invalid grade name!");
}
context.SaveChanges();
}
}
public static void DeleteParent(int parentID)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Parent parentToDelete = context.Set<Parent>().Find(parentID);
context.Parents.Remove(parentToDelete);
context.SaveChanges();
}
}
public static void DeleteParent(int parentID)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Parent parentToDelete = context.Set <Parent>().Find(parentID);
context.Parents.Remove(parentToDelete);
context.SaveChanges();
}
}
public static void UpdateGroup(int groupID, string description)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Group groupToUpdate = context.Set <Group>().Find(groupID);
groupToUpdate.GroupID = groupID;
groupToUpdate.Description = description;
context.SaveChanges();
}
}
public static void UpdateTeacher(TeacherInfo t)
{
if (!Util.IsValidEmail(t.Email))
throw new ArgumentException("Email string is not a valid email!");
UsersDAL.UpdateUser(t);
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Teacher teacherToUpdate = context.Set<Teacher>().Find(t.TeacherID);
teacherToUpdate.Specialization = t.Specialization;
teacherToUpdate.Category = t.Category;
context.SaveChanges();
}
}
public static ParentInfo GetParentInfo(int parentID)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Parent p = context.Set<Parent>().Find(parentID);
if (p != null)
{
ParentInfo info = new ParentInfo(p);
return info;
}
else throw new ArgumentOutOfRangeException("Parent ID was not found in the DB!");
}
}
public static void DeleteUser(int userID)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
User userToDelete = (User)context.Set<User>().Find(userID);
if (userToDelete != null)
{
context.Users.Remove(userToDelete);
context.SaveChanges();
}
else throw new ArgumentOutOfRangeException("Invalid userID!");
}
}
public static int GetStudentGradeID(int studentID)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Student s = context.Set <Student>().Find(studentID);
if (s != null)
{
return(s.GradeID);
}
else
{
throw new ArgumentOutOfRangeException("No such studentID=" + studentID);
}
}
}
public static void UpdateTeacher(TeacherInfo t)
{
if (!Util.IsValidEmail(t.Email))
{
throw new ArgumentException("Email string is not a valid email!");
}
UsersDAL.UpdateUser(t);
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Teacher teacherToUpdate = context.Set <Teacher>().Find(t.TeacherID);
teacherToUpdate.Specialization = t.Specialization;
teacherToUpdate.Category = t.Category;
context.SaveChanges();
}
}
public static StudentInfo GetStudentInfo(int studentID)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Student p = context.Set <Student>().Find(studentID);
if (p != null)
{
StudentInfo info = new StudentInfo(p);
return(info);
}
else
{
throw new ArgumentOutOfRangeException("Student ID was not found in the DB!");
}
}
}
public static void DeleteUser(int userID)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
User userToDelete = (User)context.Set <User>().Find(userID);
if (userToDelete != null)
{
context.Users.Remove(userToDelete);
context.SaveChanges();
}
else
{
throw new ArgumentOutOfRangeException("Invalid userID!");
}
}
}
/// <summary>
/// Changes user password
/// </summary>
/// <param name="UserID">UserID</param>
/// <param name="oldPass">old plain text password</param>
/// <param name="newPass">new plain text password</param>
public static void ChangeUserPassword(int UserID, string oldPass, string newPass)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
if (newPass.Length > 0)
{
User userToUpdate = (User)context.Set<User>().Find(UserID);
//if (userToUpdate.Password.Equals(oldPass))
if(Crypter.CheckPassword(oldPass, userToUpdate.Password))
{
//userToUpdate.Password = newPass;
userToUpdate.Password = Crypter.Blowfish.Crypt(newPass);
context.SaveChanges();
}
else throw new ArgumentException("Old password is incorrect!");
}
else throw new ArgumentOutOfRangeException("New password is empty!");
}
}
public static void UpdateGroup(int groupID, int teacherID, string subject, string gradeSection, string description)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
//get gradeID using gradeSection
int gradeID = (from grade in context.Grades where grade.GradeNo + grade.Section == gradeSection select grade.GradeID).FirstOrDefault();
if (gradeID == 0)
throw new ArgumentOutOfRangeException("Grade name is invalid!");
//get subjectID
int subjID = (from subj in context.Subjects where subj.Title == subject select subj.SubjectID).FirstOrDefault();
if (subjID == 0)
throw new ArgumentOutOfRangeException("Subject title is invalid!");
Group groupToUpdate = context.Set<Group>().Find(groupID);
groupToUpdate.GroupID = groupID;
groupToUpdate.GradeID = gradeID;
groupToUpdate.SubjectID = subjID;
groupToUpdate.TeacherID = teacherID;
groupToUpdate.Description = description;
context.SaveChanges();
}
}
/// <summary>
/// Updates a user
/// </summary>
/// <param name="u">New passwords supplied should be plain text!</param>
public static void UpdateUser(UserInfo u)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
User userToUpdate = (User)context.Set<User>().Find(u.UserID);
if(userToUpdate==null)
throw new ArgumentException("UserID is incorrect!");
userToUpdate.FirstName = u.FirstName;
userToUpdate.LastName = u.LastName;
userToUpdate.Patronymic = u.Patronymic;
userToUpdate.DateOfBirth = u.DoB;
if (!Util.IsValidEmail(u.Email))
throw new ArgumentException("Email string is not a valid email!");
userToUpdate.Email = u.Email;
if (userToUpdate.Password != u.Password) //new password supplied => crypt it!
{
userToUpdate.Password = Crypter.Blowfish.Crypt(u.Password);
}
userToUpdate.Phone = u.Phone;
context.SaveChanges();
}
}
public static void UpdateGroup(int groupID, string description)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Group groupToUpdate = context.Set<Group>().Find(groupID);
groupToUpdate.GroupID = groupID;
groupToUpdate.Description = description;
context.SaveChanges();
}
}
public static void UpdateUserInfo(UserInfo userInfo)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
User userToUpdate = (User)context.Set<User>().Find(userInfo.UserID);
userToUpdate.UserID = userInfo.UserID;
userToUpdate.LastName = userInfo.LastName;
userToUpdate.FirstName = userInfo.FirstName;
userToUpdate.Patronymic = userInfo.Patronymic;
if (userToUpdate.Password == userInfo.Password) //password supplied is crypted already
{
//do nothing - passwords already the same
}
else
{
userToUpdate.Password = Crypter.Blowfish.Crypt(userInfo.Password);
}
if (!Util.IsValidEmail(userInfo.Email))
throw new ArgumentException("Email string is not a valid email!");
userToUpdate.Email = userInfo.Email;
userToUpdate.Phone = userInfo.Phone;
userToUpdate.DateOfBirth = userInfo.DoB;
context.SaveChanges();
}
}
public static void UpdateStudent(StudentInfo si)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Student s = context.Set<Student>().Find(si.StudentID);
if (s == null)
throw new ArgumentNullException("StudentID to update cannot be null!");
if (!Util.IsValidEmail(si.Email))
throw new ArgumentException("Email string is not a valid email!");
UsersDAL.UpdateUser(si);
s.DateOfJoin = si.DateOfJoin;
//find grade ID
var gID = (from grade in context.Grades where (grade.GradeNo+grade.Section).Equals(si.GradeName) select grade.GradeID);
if (gID.Count() > 0)
{
s.GradeID = gID.First();
}
else throw new ArgumentException("Invalid grade name!");
context.SaveChanges();
}
}
public static int GetStudentGradeID(int studentID)
{
using (SchoolJournalEntities context = new SchoolJournalEntities())
{
Student s = context.Set<Student>().Find(studentID);
if (s != null)
{
return s.GradeID;
}
else throw new ArgumentOutOfRangeException("No such studentID=" + studentID);
}
}
