public static UserGlobalDetailsDTO GetglobalDetails(string tz) { using (BeitHamoreProjectEntities db = new BeitHamoreProjectEntities()) { UserGlobalDetailsDTO userGlobalDetailsDTO = new UserGlobalDetailsDTO(); List <Route_Tbl> listRoutesTbl = db.Route_Tbl.Where( r => db.RegistrationToRoute_Tbl.FirstOrDefault( rtr => rtr.studentCode == tz && r.routeCode == rtr.RouteCode ).RouteCode == r.routeCode ).ToList(); userGlobalDetailsDTO.ListRoutes = RoutesDTOConverssion.ConvertRoutesTblToDTO(listRoutesTbl); //user userGlobalDetailsDTO.UserDetails = UserDetailsDTOConverssion.GetStatusNamesForUser(db.Users_Tbl.First(s => s.tz == tz)); // userGlobalDetailsDTO.ListSpealitation = SpecializationDTOConverssion.ConvertSpecializationTblToDTO( List <Specialization_Tbl> yy = db.Specialization_Tbl.ToList(); userGlobalDetailsDTO.ListSpealitation = new List <SpealitationDTO>(); foreach (var item in userGlobalDetailsDTO.ListRoutes) { List <Specialization_Tbl> x = db.Specialization_Tbl.Where(s => s.routeCode == item.routeCode).ToList(); if (x.Count > 0) { userGlobalDetailsDTO.ListSpealitation.AddRange(SpecializationDTOConverssion.ConvertSpecializationTblToDTO(x)); } } userGlobalDetailsDTO.ListCourses = new List <CourseDTO>(); foreach (var item in userGlobalDetailsDTO.ListSpealitation) { List <Courses_Tbl> x = db.Courses_Tbl.Where(c => c.specializationCode == item.specializationCode).ToList(); if (x.Count > 0) { userGlobalDetailsDTO.ListCourses.AddRange(CourseDTOConverssion.ConvertCourseTblToDTO(x)); } } //db.Specialization_Tbl.Where( // sp => listRoutesTbl.Any( // route=> // sp.routeCode == route.routeCode // )) // .ToList(); //List< Specialization_Tbl> yy = db.Specialization_Tbl.Where( // sp => // userGlobalDetailsDTO.ListRoutes.ToList().Where( // route => route.routeCode == sp.routeCode // ).FirstOrDefault().routeCode == sp.routeCode // ).ToList(); // ); return(userGlobalDetailsDTO); } }
public static UserDetailsDTO GetStatusNamesForUser(Users_Tbl user) { using (BeitHamoreProjectEntities db = new BeitHamoreProjectEntities()) { if (user != null) { var tt = new UserDetailsDTO { tz = user.tz, userId = user.userId, city = user.city, emailAddress = user.emailAddress, firstName = user.firstName, houseNumber = user.houseNumber, lastName = user.lastName, phone = user.phone, passwordSHA256 = user.passwordSHA256, street = user.street, StatusList = db.StatusesToUsers_Tbl.Include(st => st.Status_Tbl).Where(st => st.userId == user.userId && st.isApproved.Value == 1).ToList().Select(sp => StatusDTOConverssions.GetStatus(sp.Status_Tbl)).ToList() }; return(tt); } return(null); } }
public static List <RouteDTO> GetAllRoutes() { using (BeitHamoreProjectEntities db = new BeitHamoreProjectEntities()) { List <Route_Tbl> routes = db.Route_Tbl.ToList(); return(RoutesDTOConverssion.ConvertRoutesTblToDTO(routes)); } }
public static List <SpealitationDTO> GetAllSpecializations() { using (BeitHamoreProjectEntities db = new BeitHamoreProjectEntities()) { // return db.Specialization_Tbl.Select(s => new { specializationCode = s.specializationCode, specializationName = s.specializationName }); List <Specialization_Tbl> routes = db.Specialization_Tbl.ToList(); return(SpecializationDTOConverssion.ConvertSpecializationTblToDTO(routes)); } }
public static Object GetCourseById(int id) { using (BeitHamoreProjectEntities db1 = new BeitHamoreProjectEntities()) { var course = (db1.Courses_Tbl.Where(h => h.courseId == id) // .Select(c => new {name = c.courseName }) .FirstOrDefault()); return(course); } }
public static UserDetailsDTO GetUserByTZAndPw(string tz, string passw) { using (BeitHamoreProjectEntities db = new BeitHamoreProjectEntities()) { var user = db.Users_Tbl.Where(u => u.tz == tz && u.passwordSHA256 == passw).FirstOrDefault(); if (user != null) { return(Converssins.UserDetailsDTOConverssion.GetStatusNamesForUser(user)); } return(null); } }
public static bool Register(Users_Tbl user) { try { using (BeitHamoreProjectEntities db1 = new BeitHamoreProjectEntities()) { db1.Users_Tbl.Add(user); db1.SaveChanges(); } return(true); } catch (Exception e) { return(false); } }
public static bool AddCourse(Courses_Tbl newCourse) { try { using (BeitHamoreProjectEntities db = new BeitHamoreProjectEntities()) { db.Courses_Tbl.Add(newCourse); db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public static List <StatusesToUsers_Tbl> Login(Users_Tbl user) { try { List <StatusesToUsers_Tbl> list = new List <StatusesToUsers_Tbl>(); using (BeitHamoreProjectEntities db1 = new BeitHamoreProjectEntities()) { Users_Tbl currentUser = db1.Users_Tbl.FirstOrDefault(u => u.passwordSHA256 == user.passwordSHA256 && u.tz == user.tz); if (currentUser == null) { return(list.ToList()); } else { list = db1.StatusesToUsers_Tbl.Where(stu => stu.userId == currentUser.userId).ToList(); return(list.ToList()); } } } catch (Exception e) { return(null); } }