public static void Main()
{
var ran = new Random();
var repo = new SchoolRepository();
var query = repo.Courses.All().First(c => c.Name == "HTML").Students.Select(st => st.Name).OrderBy(name => name);
Console.WriteLine("Find all students in the HTML Course:");
Console.WriteLine(string.Join(Environment.NewLine, query));
}
public ClasseAttribMatierePageViewModel(SchoolRepository db) : base(db)
{
}
public TeachersController()
{
repo = new SchoolRepository();
}
/// <summary>
/// Constrói uma lista de Unidades administrativas (escolas) filhas baseadas na(s) DRE(s) passada(s) por parâmetro.
/// Caso venha nulo, busca todas que o usuário logado tenha permissão.
/// </summary>
/// <param name="userId">id usuário logado</param>
/// <param name="groupId">ig grupo usuário logado</param>
/// <param name="ltSchoolSuperior">Lista de DRE's</param>
/// <returns></returns>
/////
//[System.Obsolete("Método obsoleto, devido à function do coresso. Utilizar GetAUBySuperior") ]
//public static IEnumerable<Guid> GetAUBySuperior(Guid userId, Guid groupId, IEnumerable<Guid> ltSchoolSuperior)
//{
// var repository = new SchoolRepository();
// return repository.GetAUBySuperior(userId, groupId, ltSchoolSuperior);
//}
/// <summary>
/// Constrói uma lista de Unidades administrativas (escolas) filhas baseadas na(s) DRE(s) passada(s) por parâmetro.
/// Caso venha nulo, busca todas que o usuário logado tenha permissão.
/// </summary>
/// <param name="userId">id usuário logado</param>
/// <param name="groupId">ig grupo usuário logado</param>
/// <param name="ltSchoolSuperior">Lista de DRE's</param>
/// <param name="ltSchool">Lista de UAD's (escolas)</param>
/// <returns></returns>
public static IEnumerable <Guid> GetAUByPermission(Guid userId, Guid groupId, IEnumerable <Guid> ltSchoolSuperior = null, IEnumerable <int> ltSchoolID = null, IEnumerable <Guid> ltSchoolUA = null)
{
var repository = new SchoolRepository();
return(repository.GetAUByPermission(userId, groupId, ltSchoolSuperior, ltSchoolID, ltSchoolUA));
}
public List <School> AllSchoolsOnly([Service] SchoolRepository schoolRepository) => schoolRepository.GetAllSchoolOnly();
public BlogPostSchoolRepositoryDecorator(SchoolRepository <BlogPost> blogPostSchoolRepository)
{
this._schoolRepository = blogPostSchoolRepository;
}
public ClasseAttribElevePageViewModel(
IPageDialogService pageDialogService,
SchoolRepository db) : base(db)
{
_pageDialogService = pageDialogService;
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public SchoolModel GetSchool(int id)
{
var item = SchoolRepository.GetItem(id);
return(item.ToModel());
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Save(SchoolModel model)
{
return(SchoolRepository.Save(model.ToPO()));
}
public SchoolController(SchoolRepository repository)
{
_repo = repository;
}
public GestionAnneePageViewModel(
SchoolRepository db)
: base(db)
{
}
public BSchool()
{
SchoolRepository = new SchoolRepository();
}
public SchoolController()
{
schoolRepository = new SchoolRepository();
}
public List <School> AllSchoolsWithStudent([Service] SchoolRepository schoolRepository) => schoolRepository.GetAllSchoolsWithStudent();
public IEnumerable <School> GetSchools()
{
var repo = new SchoolRepository();
return(repo.GetSchools());
}
public ActionResult CapNhatThuyenChuyen(string id, string cmnd)
{
using (var _thuyenchuyenService = new ThuyenChuyenNgoaiTinhService())
{
ThuyenChuyenNgoaiTinh thuyenChuyen = _thuyenchuyenService.CheckThuyenChuyenExistedByIdAndCMND(id.Trim(), cmnd.Trim());
if (thuyenChuyen == null || (thuyenChuyen.StatusId != 5 && thuyenChuyen.StatusId != null))
{
return(RedirectToRoute("thuyenchuyenkiemtramatruong"));
}
using (var _districtService = new DistrictRepository())
{
ViewBag.DistrictsNoiSinh = _districtService.GetDistrictByProvinceId(thuyenChuyen.Ward.District.ProvinceId);
ViewBag.DistrictsHKTT = _districtService.GetDistrictByProvinceId(thuyenChuyen.Ward.District.ProvinceId);
ViewBag.Districts = _districtService.GetDistrictByProvinceId(79);
}
using (var _wardService = new WardRepository())
{
ViewBag.WardsNoiSinh = _wardService.GetWardByDistrictId(thuyenChuyen.Ward.DistrictID);
ViewBag.WardsHKTT = _wardService.GetWardByDistrictId(thuyenChuyen.Ward.DistrictID);
}
using (var _provinceService = new ProvinceRepository())
{
ViewBag.Provinces = _provinceService.GetProvinceByCountryId(237);
}
using (var _CapTruongService = new CapTruongRepository())
{
ViewBag.CapTruongs = _CapTruongService.GetCapTruongs();
}
using (var _monDuTuyen = new MonDuTuyenRepository())
{
ViewBag.MonDays = _monDuTuyen.GetMonDuTuyens();
}
using (var _hinhThucDaoTao = new HinhThucDaoTaoRepository())
{
ViewBag.HinhThucDaoTaos = _hinhThucDaoTao.GetHinhThucDaoTaos();
}
using (var _xepLoaiHocLuc = new XepLoaiHocLucRepository())
{
ViewBag.XepLoaiHocLucs = _xepLoaiHocLuc.GetXepLoaiHocLucs();
}
using (var _chuyenNghanhDaoTao = new ChuyenNganhDaoTaoRepository())
{
ViewBag.ChuyenNganhDaoTaos = _chuyenNghanhDaoTao.GetChuyenNganhDaoTaos();
}
using (var _bangTotNghiep = new BangTotNghiepRepository())
{
ViewBag.BangTotNghieps = _bangTotNghiep.GetBangTotNghieps();
}
using (var _schoolService = new SchoolRepository())
{
ViewBag.SchoolsCD = _schoolService.GetSchoolsByDistrictAndCapHoc(thuyenChuyen.School.Ward.DistrictID, thuyenChuyen.School.CapTruongId);
}
using (var _trinhdoDaoTao = new TrinhDoCaoNhatRepository())
{
ViewBag.TrinhDoCaoNhats = _trinhdoDaoTao.GetTrinhDoCaoNhats();
}
ViewBag.ThuyenChuyen = thuyenChuyen;
return(View());
}
}
public SchoolRepositoryUtility(SchoolRepository SchoolRepository)
{
this.schoolRepository = SchoolRepository;
}
public MemoryStream GenerateCSV()
{
MemoryStream outStream = new MemoryStream();
StreamWriter writer = new StreamWriter(outStream);
// Headings
writer.Write("School_id" + delimiter);
writer.Write("School_name" + delimiter);
writer.Write("School_number" + delimiter);
writer.Write("State_id" + delimiter);
writer.Write("Low_grade" + delimiter);
writer.Write("High_grade" + delimiter);
writer.Write("Principal" + delimiter);
writer.Write("Principal_email" + delimiter);
writer.Write("School_address" + delimiter);
writer.Write("School_city" + delimiter);
writer.Write("School_state" + delimiter);
writer.Write("School_zip" + delimiter);
writer.Write("School_phone" + delimiter);
writer.Write(Environment.NewLine);
SchoolRepository _schoolRepo = new SchoolRepository(_dbConnectionString);
List <School> schools = _schoolRepo.GetAll();
foreach (School school in schools.Where(x => x.isFake == false))
{
writer.Write(stringContainer + school.DAN + stringContainer + delimiter);
writer.Write(stringContainer + school.Name + stringContainer + delimiter);
writer.Write(stringContainer + school.DAN + stringContainer + delimiter);
writer.Write(stringContainer + "" + stringContainer + delimiter); // State ID
// Parse K and PreK into what Clever expects
string lowGrade = school.LowGrade;
if (lowGrade.ToLower() == "pk")
{
lowGrade = "PreKindergarten";
}
if ((lowGrade.ToLower() == "0k") || (lowGrade.ToLower() == "k"))
{
lowGrade = "Kindergarten";
}
if (string.IsNullOrEmpty(lowGrade))
{
lowGrade = "Ungraded";
}
string highGrade = school.HighGrade;
if (highGrade.ToLower() == "pk")
{
highGrade = "PreKindergarten";
}
if ((highGrade.ToLower() == "0k") || (highGrade.ToLower() == "k"))
{
highGrade = "Kindergarten";
}
if (string.IsNullOrEmpty(highGrade))
{
highGrade = "Ungraded";
}
writer.Write(stringContainer + lowGrade + stringContainer + delimiter); // Low grade
writer.Write(stringContainer + highGrade + stringContainer + delimiter); // High greade
writer.Write(stringContainer + "" + stringContainer + delimiter); // Principal
writer.Write(stringContainer + "" + stringContainer + delimiter); // Principal email
writer.Write(stringContainer + "" + stringContainer + delimiter); // School address
writer.Write(stringContainer + "" + stringContainer + delimiter); // School city
writer.Write(stringContainer + school.Region + stringContainer + delimiter); // School state
writer.Write(stringContainer + "" + stringContainer + delimiter); // School ZIP
writer.Write(stringContainer + "" + stringContainer + delimiter); // School phone
writer.Write(Environment.NewLine);
}
writer.Flush();
outStream.Flush();
return(outStream);
}
public EducationalInstitutionController(UniversityRepository universityRepository, SchoolRepository schoolRepository, IMapper mapper)
{
UniversityRepository = universityRepository;
SchoolRepository = schoolRepository;
Mapper = mapper;
}
public static IEnumerable <School> Get(Guid userId, Guid groupId, IEnumerable <Guid> listSchoolSuperior, IEnumerable <int> listClassificationTypeSchool)
{
var repository = new SchoolRepository();
return(repository.Get(userId, groupId, listSchoolSuperior, listClassificationTypeSchool));
}
public StudentController(SchoolRepository schoolrepo)
{
repo = schoolrepo;
}
public static IEnumerable <School> Get(Guid userId, Guid groupId, Guid schoolSuperiorId)
{
var repository = new SchoolRepository();
return(repository.GetBySuperior(userId, groupId, schoolSuperiorId));
}
public void GetSchools()
{
IRepositoryContext uow = new EntityFrameworkRepositoryContext();
var repo = new SchoolRepository(uow);
var result = repo.GetAll();
Assert.IsTrue(result.Count() > 0);
}
public SchoolRepositoryUtility(SchoolRepository SchoolRepository)
{
this.schoolRepository = SchoolRepository;
}
