public static object Login(string name, string password) { using (Entities e = new Entities()) { try { user user = e.users.FirstOrDefault(u => u.user_name == name && u.user_password == password); if (user != null) { if (user.status == 1) { var te = e.teachers.FirstOrDefault(t => t.userId == user.user_id); return(TeacherCasting.TeacherToDTO(te)); } if (user.status == 2) { return(StudentCasting.StudentToDTO(e.students.FirstOrDefault(s => s.userId == user.user_id))); } } throw new Exception("UserName or Password are not correct"); } catch (Exception ex) { throw ex; } } }
public void UpdateTeacher(TeacherDTO t) { using (Entities e = new Entities()) { teacher teacher = e.teachers.FirstOrDefault(te => te.userId == t.userId); //todo updete teacher = TeacherCasting.TeacherToDAL(t); e.SaveChanges(); } }
//public List<TeacherDTO> GetTeachers() //{ // var teachers = e.users.OfType<teacher>().ToList(); // return TeacherCasting.TeachersToDTO(teachers); //} //public TeacherDTO GetTeacher(string name, string password) //{ // var teachers = e.users.OfType<teacher>().ToList(); // return TeacherCasting.TeacherToDTO(teachers.FirstOrDefault(t => t.user_name == name && t.user_password == password)); //} public static TeacherDTO GetTeacherByUserId(int userId) { using (Entities e = new Entities()) { try { var teacher = e.teachers.FirstOrDefault(t => t.userId == userId); if (teacher != null) { return(TeacherCasting.TeacherToDTO(teacher)); } throw new Exception("UserId is not exists"); } catch (Exception ex) { throw ex; } } }
public static Object AddUser <T>(T user) { using (Entities e = new Entities()) { try { if (user is TeacherDTO teacher) { if (e.users.FirstOrDefault(t => t.user_name == teacher.user.user_name || t.user_id_number == teacher.user.user_id_number) != null) { throw new Exception("user name is unique"); } else { e.users.Add(UserCasting.UserToDAL(teacher.user)); var t = e.teachers.Add(TeacherCasting.TeacherToDAL(teacher)); e.SaveChanges(); return(TeacherCasting.TeacherToDTO(t)); } } else if (user is StudentDTO student) { if (e.users.FirstOrDefault(t => t.user_name == student.user.user_name || t.user_id_number == student.user.user_id_number) != null) { throw new Exception("user name is unique"); } else { e.users.Add(UserCasting.UserToDAL(student.user)); var s = e.students.Add(StudentCasting.StudentToDAL(student)); e.SaveChanges(); return(StudentCasting.StudentToDTO(s)); } } return(null); } catch (Exception ex) { throw ex; } } }