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