public PupilRepositoryRelationshipsTests(QuestedContextFactory questedContextFactory, ITestOutputHelper testOutputHelper)
{
_testOutputHelper = testOutputHelper;
_context = questedContextFactory.ContextInstance;
_pupilRep = new PupilRepository(_context);
_classRep = new EntityFrameworkRepository <Class>(_context);
}
public IActionResult PupilFullInfo(string IINPupil)
{
var pupil = PupilRepository.GetPupilByIIN(IINPupil);
var pupilViewModel = Mapper.Map <PupilViewModel>(pupil);
return(View(pupilViewModel));
}
public static void Import(string filename)
{
var forms = FormRepository.GetInstance();
var pupils = PupilRepository.GetInstance();
var reader = new StreamReader(filename);
var fileInfo = new FileInfo(filename);
int bytesRead = reader.ReadLine().Length + 2;
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
bytesRead += line.Length + 2;
var data = line.Split(';');
var form = new Form {
Name = data[0]
};
var pupil = new Pupil {
Class = data[0], Lastname = data[1], Firstname = data[2], Sex = data[3], Birthday = DateTime.Parse(data[4])
};
if (forms.GetForms().All(f => f.Name != form.Name))
{
forms.AddForm(form);
}
pupils.AddPupil(pupil);
Progress?.Invoke(100 * bytesRead / (int)fileInfo.Length);
}
}
public ActionResult AddOrUpdate(PupilModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
var isCreated = model.Id == Guid.Empty;
var pupil = new Pupils();
if (!isCreated)
{
pupil = PupilRepository.GetById(model.Id);
}
pupil.BirthdayDate = model.BirthdayDate;
pupil.Classrooms = ClassroomRepository.GetById(pupil.Classroom_Id);
pupil.Classroom_Id = model.ClassroomId;
pupil.FirstName = model.FirstName;
pupil.LastName = model.LastName;
pupil.Level_Id = model.LevelId;
pupil.Levels = LevelRepository.GetById(pupil.Level_Id);
pupil.Sex = (short)model.Sex;
pupil.State = model.State;
pupil.Tutor_Id = model.TutorId;
pupil.Tutors = TutorRepository.GetById(pupil.Tutor_Id);
if (isCreated)
{
PupilRepository.Add(pupil);
}
PupilRepository.Save();
return(Redirect(Url.Action("Get", "Pupil", new { id = pupil.Id })));
}
public TutorController()
{
var entities = new Entities.Entities();
PupilRepository = new PupilRepository(entities);
TutorRepository = new TutorRepository(entities);
}
public async Task <IActionResult> PupilListAndSearch(string searchBy, string searchPupil)
{
ViewData["GetStudentDetails"] = searchPupil;
var query = from x in PupilRepository.GetAll() select x;
if (!String.IsNullOrEmpty(searchPupil))
{
if (searchBy == "iin")
{
query = query.Where(x => x.IIN.Equals(searchPupil));
}
else if (searchBy == "name")
{
query = query.Where(x => x.Name.Contains(searchPupil));
}
else if (searchBy == "classYear")
{
query = query.Where(x => x.ClassYear == int.Parse(searchPupil)).OrderBy(s => s.SchoolId);
}
else if (searchBy == "schoolID")
{
query = query.Where(x => x.SchoolId == int.Parse(searchPupil)).OrderBy(s => s.ClassYear);
}
}
List <PupilViewModel> pupilViewModel = new List <PupilViewModel>();
foreach (var item in query)
{
pupilViewModel.Add(Mapper.Map <PupilViewModel>(item));
}
return(View(pupilViewModel));
}
public ResultController()
{
var entities = new Entities.Entities();
ResultRepository = new ResultRepository(entities);
EvaluationRepository = new EvaluationRepository(entities);
PupilRepository = new PupilRepository(entities);
}
public IActionResult PupilListAndSearch()
{
var pupils = PupilRepository
.GetAll()
.Select(x => Mapper.Map <StudentViewModel>(x))
.ToList();
return(View(pupils));
}
public TeacherServiceTests(QuestedContextFactory questedContextFactory)
{
var teacherRepository = new TeacherRepository(questedContextFactory.ContextInstance);
var courseRepository = new PupilRepository(questedContextFactory.ContextInstance);
var questionRepository = new QuestionRepository(questedContextFactory.ContextInstance);
var teacherMapper = questedContextFactory.TeacherMapper;
_sut = new TeacherService(teacherRepository, courseRepository, questionRepository, teacherMapper);
}
public PupilController()
{
var entities = new Entities.Entities();
PupilRepository = new PupilRepository(entities);
ClassroomRepository = new ClassroomRepository(entities);
LevelRepository = new LevelRepository(entities);
TutorRepository = new TutorRepository(entities);
}
public TeacherServiceRelationshipsTests(QuestedContextFactory questedContextFactory)
{
_context = questedContextFactory.ContextInstance;
var teacherRepository = new TeacherRepository(_context);
var pupilRepository = new PupilRepository(_context);
var questionRepository = new QuestionRepository(_context);
_teacherService = new TeacherService(teacherRepository, pupilRepository, questionRepository,
questedContextFactory.TeacherMapper);
}
public async Task <IActionResult> PupilListAndSearch(int minValueForGrant)
{
ViewData["PostMinValueForGrant"] = minValueForGrant;
// проверка значения инпута (если пользователь ввел букву например
// или текст а не числовое значение)
// добавить вытаскивание айди универа рандомно
// enum faculty добавить и тоже рандомно присвоивать при выдаче гранта и
// регистрации ученика в качестве студента
if (minValueForGrant != null)
{
var pupils = PupilRepository.GetAll();
foreach (var pupil in pupils)
{
if (pupil.ENT != null)
{
StudentViewModel studentVIewModel = new StudentViewModel();
studentVIewModel.IIN = pupil.IIN;
studentVIewModel.Name = pupil.Name;
studentVIewModel.Surname = pupil.Surname;
studentVIewModel.Patronymic = pupil.Patronymic;
studentVIewModel.Birthday = pupil.Birthday;
studentVIewModel.Email = pupil.Email;
studentVIewModel.Faculty = "Biology";
studentVIewModel.CourseYear = 1;
studentVIewModel.Gpa = 0.0;
studentVIewModel.EnteredYear = DateTime.Now;
studentVIewModel.GraduatedYear = null;
studentVIewModel.UniversityId = 100; // Random()
if (pupil.ENT >= minValueForGrant)
{
studentVIewModel.OnGrant = true;
var student = Mapper.Map <Student>(studentVIewModel);
StudentRepository.Save(student);
PupilRepository.Remove(pupil);
}
else
{
studentVIewModel.OnGrant = false;
var student = Mapper.Map <Student>(studentVIewModel);
StudentRepository.Save(student);
PupilRepository.Remove(pupil);
}
}
}
}
return(View());
}
public ActionResult GetByFilter(string filter)
{
filter = filter.ToUpper();
return(Json(PupilRepository.All()
.Where(p =>
p.FirstName.ToUpper().Contains(filter) ||
p.LastName.ToUpper().Contains(filter) ||
p.Classrooms.Title.ToUpper().Contains(filter) ||
p.Levels.Title.ToUpper().Contains(filter) ||
p.Tutors.FirstName.ToUpper().Contains(filter) ||
p.Tutors.LastName.ToUpper().Contains(filter))
.Select(p => p.Id), JsonRequestBehavior.AllowGet));
}
public UnitOfWork(DbContext context, ClassRoomRepository classRoomRepository, CommentRepository commentRepository, MailRepository mailRepository, ParentRepository parentRepository, PupilRepository pupilRepository, RequisitionRepository requisitionRepository, RoleRepository roleRepository, TeacherRepository teacherRepository, UserRepository userRepository)
{
Context = context;
this.classRoomRepository = classRoomRepository;
this.commentRepository = commentRepository;
this.mailRepository = mailRepository;
this.parentRepository = parentRepository;
this.pupilRepository = pupilRepository;
this.requisitionRepository = requisitionRepository;
this.roleRepository = roleRepository;
this.teacherRepository = teacherRepository;
this.userRepository = userRepository;
}
public List <PupilModel> GetPupilsBornThisDate(DateTime day)
{
var result =
from pupil in PupilRepository.GetAll()
where DbFunctions.TruncateTime(pupil.BirthDate) == day.Date
select new PupilModel
{
Id = pupil.PupilId,
FirstName = pupil.FirstName,
LastName = pupil.LastName
};
return(result.ToList());
}
public ActionResult AddOrUpdate(Guid?id, Guid?classroomId, Guid?tutorId)
{
var model = new PupilModel();
if (id.HasValue)
{
model = PupilModel.ToModel(PupilRepository.GetById(id.Value));
}
if (classroomId.HasValue)
{
model.ClassroomId = classroomId.Value;
}
if (tutorId.HasValue)
{
model.TutorId = tutorId.Value;
}
return(View(model));
}
public void SavePupil()
{
_initialPupil.Class = SelectedPupil.Class;
_initialPupil.Birthday = SelectedPupil.Birthday;
_initialPupil.Firstname = SelectedPupil.Firstname;
_initialPupil.Lastname = SelectedPupil.Lastname;
_initialPupil.Sex = SelectedPupil.Sex;
if (FormRepository.GetInstance().GetForms().All(f => f.Name != _initialPupil.Class))
{
FormRepository.GetInstance().AddForm(new Form
{
Name = _initialPupil.Class
});
}
PupilRepository.GetInstance().UpdatePupil(_initialPupil);
}
static void Main(string[] args)
{
SchoolClassRepository schoolClassRepository = new SchoolClassRepository();
SchoolClass schoolClass = schoolClassRepository.GetById(2);
Console.WriteLine($"Klasse! ID: {schoolClass.Id}, Raum: {schoolClass.RoomNumber}");
PupilRepository pupilRepository = new PupilRepository();
Pupil pupil = pupilRepository.GetById(3);
Console.WriteLine($"Schüler! ID: {pupil.Id}, Name: {pupil.FirstName} {pupil.LastName}");
RepositoryBase <SchoolClass> schoolClassRepositoryGeneric = new RepositoryBase <SchoolClass>();
SchoolClass schoolClassGeneric = schoolClassRepositoryGeneric.GetById(2);
Console.WriteLine($"Klasse! ID: {schoolClassGeneric.Id}, Raum: {schoolClassGeneric.RoomNumber}");
RepositoryBase <Pupil> pupilRepositoryGeneric = new RepositoryBase <Pupil>();
Pupil pupilGeneric = pupilRepositoryGeneric.GetById(3);
Console.WriteLine($"Schüler! ID: {pupilGeneric.Id}, Name: {pupilGeneric.FirstName} {pupilGeneric.LastName}");
}
public ActionResult Delete(Guid id)
{
PupilRepository.Delete(id);
PupilRepository.Save();
return(Redirect(Url.Action("GetAll", "Pupil")));
}
public ActionResult Get(Guid id)
{
var model = PupilModel.ToModel(PupilRepository.GetById(id));
return(View(model));
}
public ActionResult GetAll()
{
var models = PupilRepository.All().Select(c => PupilModel.ToModel(c));
return(View(models));
}
public void DeletePupil()
{
PupilRepository.GetInstance().RemovePupil(SelectedPupil);
}
public PupilRepositoryBasicTests(QuestedContextFactory questedContextFactory)
{
_context = questedContextFactory.ContextInstance;
_sut = new PupilRepository(_context);
}
public void UpdatePupils()
{
Pupils = PupilRepository.GetInstance().GetPupils().Where(p => p.Class == SelectedForm.Name).ToList();
OnPropertyChanged(nameof(Pupils));
}
public PersonController(StudentRepository studentRepository, PupilRepository pupilRepository, IMapper mapper)
{
StudentRepository = studentRepository;
PupilRepository = pupilRepository;
Mapper = mapper;
}
