public static List <SpecializationDTO> GetSpecializationList()
{
List <SpecializationDTO> specializations = new List <SpecializationDTO>();
db.Specializations.ToList().ForEach(f => specializations.Add(SpecializationCast.CastToDTO(f)));
return(specializations);
}
public static void RemoveSpecialization(SpecializationDTO specializationDTO)
{
db.Specializations.Remove(SpecializationCast.CastToDAL(specializationDTO));
}
public static void AddSpecialization(SpecializationDTO specializationDTO)
{
db.Specializations.Add(SpecializationCast.CastToDAL(specializationDTO));
}
public static SpecializationDTO GetDetailsSpecialization(int id)
{
return(SpecializationCast.CastToDTO(db.Specializations.Where(i => i.specId == id).FirstOrDefault()));
}
public static List <StudentWithSpecDTO> GetStudentsWithSpecs()
{
List <StudentWithSpecDTO> usersWithSpecs = new List <StudentWithSpecDTO>();
db.Users.ToList().Where(u => UserCast.CastToDTO(u).entityTypeId == DTO.Type.student).ToList().ForEach(u2 =>
{
StudentWithSpecDTO studentWithSpec = new StudentWithSpecDTO()
{
userId = u2.userId,
userTz = u2.userTz,
userName = u2.userName,
balance = getBalanceByUser(UserCast.CastToDTO(u2)),
specs = new List <SpecializationDTO>()
};
db.UserToSpecs.Where(us => us.userId == u2.userId).ToList().ForEach(us2 =>
{
db.Specializations.Where(s => s.specId == us2.specId).ToList().ForEach(s2 => studentWithSpec.specs.Add(SpecializationCast.CastToDTO(s2)));
});
usersWithSpecs.Add(studentWithSpec);
});
return(usersWithSpecs);
}
