public void SetupStandardOptionsTable() { _databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString); _unitOfWork = new UnitOfWork(_databaseConnection); _repository = new StandardRepository(_unitOfWork); _options = GetListOfOptions(); _standards = GetListOfStandardVersions(); StandardOptionsHandler.InsertRecords(_options); StandardsHandler.InsertRecords(_standards); _expectedStandardResult = new StandardOptions { StandardUId = "ST0001_1.1", StandardReference = "ST0001", StandardCode = 1, Version = "1.1", CourseOption = new List <string> { "ST0001_1.1 Option 1", "ST0001_1.1 Option 2" } }; }
public UnitOfWork(ApplicationDbContext context) { _context = context; Attempts = new AttemptRepository(_context); Exams = new ExamRepository(_context); Images = new ImageRepository(_context); NoteParameters = new NoteParameterRepository(_context); Notifications = new NotificationRepository(_context); Notes = new NoteRepository(_context); Opinions = new OpinionRepository(_context); Options = new OptionRepository(_context); Passages = new PassageRepository(_context); Questions = new QuestionRepository(_context); Requirements = new RequirementRepository(_context); Roles = new RoleRepository(_context); RoleClaims = new RoleClaimRepository(_context); Standards = new StandardRepository(_context); Sittings = new SittingRepository(_context); Topics = new TopicRepository(_context); Users = new UserRepository(_context); UserClaims = new UserClaimRepository(_context); UserLogins = new UserLoginRepository(_context); UserRoles = new UserRoleRepository(_context); UserTokens = new UserTokenRepository(_context); }
public void SetupStandardsTable() { _databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString); _unitOfWork = new UnitOfWork(_databaseConnection); _repository = new StandardRepository(_unitOfWork); _standards = GetListOfStandardVersions(); StandardsHandler.InsertRecords(_standards); }
public StudentBusinessLogic() { _StudentRepository = S360RepositoryFactory.GetRepository("STUDENT") as StudentRepository; _SectionRepository = S360RepositoryFactory.GetRepository("SECTION") as SectionRepository; _Standardpository = S360RepositoryFactory.GetRepository("STANDARD") as StandardRepository; _LanguageRepository = S360RepositoryFactory.GetRepository("LANGUAGE") as LanguageRepository; _StudentCategoryRepository = S360RepositoryFactory.GetRepository("STUDENTCATEGORY") as StudentCategoryRepository; _ReligionRepository = S360RepositoryFactory.GetRepository("RELIGION") as ReligionRepository; _StudentAcademicRepository = S360RepositoryFactory.GetRepository("STUDENTACADEMIC") as StudentAcademicRepository; _studentDetainPromotionRepository = S360RepositoryFactory.GetRepository("DETAINORPROMOTION") as StudentDetainPromotionRepository; _studentTCRepository = S360RepositoryFactory.GetRepository("STUDENTTC") as StudentTCRepository; }
public IHttpActionResult GetSTANDARD_SELECTION() { try { int asssessmentId = Auth.AssessmentForUser(); TinyMapper.Bind <STANDARD_SELECTION, Sals>(); TinyMapper.Bind <Sals, STANDARD_SELECTION>(); STANDARD_SELECTION sTANDARD_SELECTION = db.STANDARD_SELECTION.Find(asssessmentId); Sals rsal; if (sTANDARD_SELECTION == null) { rsal = new Sals() { Selected_Sal_Level = "Low", Last_Sal_Determination_Type = "Simple", CLevel = "Low", ALevel = "Low", ILevel = "Low" }; sTANDARD_SELECTION = TinyMapper.Map <STANDARD_SELECTION>(rsal); sTANDARD_SELECTION.Assessment_Id = asssessmentId; sTANDARD_SELECTION.Application_Mode = AssessmentModeData.DetermineDefaultApplicationMode(); db.STANDARD_SELECTION.Add(sTANDARD_SELECTION); db.SaveChanges(); } else { rsal = TinyMapper.Map <Sals>(sTANDARD_SELECTION); } LevelManager lm = new LevelManager(asssessmentId, db); lm.RetrieveOtherLevels(rsal); StandardRepository sr = new StandardRepository(asssessmentId, lm, new StandardManager(), new AssessmentModeData(db, asssessmentId), new StandardSpecficLevelRepository(db)); sr.Confidence_Level = rsal.CLevel; sr.Integrity_Level = rsal.ILevel; sr.Availability_Level = rsal.ALevel; //if(!rsal.SelectedSALOverride) // rsal.Selected_Sal_Level = sr.Selected_Sal_Level; return(Ok(rsal)); } catch (Exception) { return(Conflict()); //return (HttpResponseMessage)CSETWeb_Api.Helpers.ElmahWrapper.LogAndReportException(e, Request, HttpContext.Current); } }
public void SetupOrganisationTests() { _databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString); _unitOfWork = new UnitOfWork(_databaseConnection); _repository = new StandardRepository(_unitOfWork); _standardId1 = 1; _standardId2 = 10; _standardId3 = 100; _referenceNumber1 = "ST0001"; _referenceNumber2 = "ST0010"; _title1 = "Standard 1"; _title2 = "Standard title 2"; _title3 = "standard title 3"; _standardDataLevel1 = 4; _standardData1 = "{\"Level\": " + _standardDataLevel1 + " }"; _standardCollation1 = new StandardCollationModel { StandardId = _standardId1, ReferenceNumber = _referenceNumber1, Title = _title1, StandardData = _standardData1 }; _standardCollation2 = new StandardCollationModel { StandardId = _standardId2, ReferenceNumber = _referenceNumber2, Title = _title2, StandardData = null }; _standardCollation3 = new StandardCollationModel { StandardId = _standardId3, ReferenceNumber = null, Title = _title3, StandardData = null }; StandardCollationHandler.InsertRecords(new List <StandardCollationModel> { _standardCollation1, _standardCollation2, _standardCollation3 }); }
//IGenericRepository IUnitOfWork.Repository => throw new NotImplementedException(); public UnitOfWork() { dbContext = new DatabaseContext(); Repository = new GenericRepository(dbContext); SchoolRepository = new SchoolRepository(dbContext); ExceptionLoggerRepository = new ExceptionLoggerRepository(dbContext); ApiLogRepository = new ApiLogRepository(dbContext); ImageFileTypeRepository = new ImageFileTypeRepository(dbContext); AssessmentRepository = new AssessmentRepository(dbContext); AttendanceRepository = new AttendanceRepository(dbContext); BookRepository = new BookRepository(dbContext); BookTransactionRepository = new BookTransactionRepository(dbContext); EventRepository = new EventRepository(dbContext); HomeworkRepository = new HomeworkRepository(dbContext); ImageFileUrlRepository = new ImageFileUrlRepository(dbContext); ParentRepository = new ParentRepository(dbContext); StandardRepository = new StandardRepository(dbContext); StudentRepository = new StudentRepository(dbContext); SubjectRepository = new SubjectRepository(dbContext); TeacherRepository = new TeacherRepository(dbContext); YearRepository = new YearRepository(dbContext); OperationalStaffRepository = new OperationalStaffRepository(dbContext); }
public IHttpActionResult PostSAL(Sals tmpsal) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } int assessmentId = Auth.AssessmentForUser(); TinyMapper.Bind <Sals, STANDARD_SELECTION>(); STANDARD_SELECTION sTANDARD_SELECTION = db.STANDARD_SELECTION.Where(x => x.Assessment_Id == assessmentId).FirstOrDefault(); if (sTANDARD_SELECTION != null) { sTANDARD_SELECTION = TinyMapper.Map <Sals, STANDARD_SELECTION>(tmpsal, sTANDARD_SELECTION); } else { sTANDARD_SELECTION = TinyMapper.Map <STANDARD_SELECTION>(tmpsal); } sTANDARD_SELECTION.Assessment_Id = assessmentId; db.Entry(sTANDARD_SELECTION).State = EntityState.Modified; LevelManager lm = new LevelManager(assessmentId, db); lm.SaveOtherLevels(assessmentId, tmpsal); lm.Init(sTANDARD_SELECTION); if (tmpsal.SelectedSALOverride) { lm.SaveSALLevel(tmpsal.Selected_Sal_Level); } try { db.SaveChanges(); StandardRepository sr = new StandardRepository(assessmentId, lm, new StandardManager(), new AssessmentModeData(db, assessmentId), new StandardSpecficLevelRepository(db)); sr.Confidence_Level = tmpsal.CLevel; sr.Integrity_Level = tmpsal.ILevel; sr.Availability_Level = tmpsal.ALevel; // save the newly-calculated overall value if (!tmpsal.SelectedSALOverride) { tmpsal.Selected_Sal_Level = sr.Selected_Sal_Level; lm.SaveSALLevel(tmpsal.Selected_Sal_Level); } return(Ok(tmpsal)); } catch (DbUpdateConcurrencyException dbe) { if (!STANDARD_SELECTIONExists(assessmentId)) { return(NotFound()); } else { throw dbe; } } catch (Exception e) { CSETWeb_Api.Helpers.ElmahWrapper.LogAndReportException(e, Request, HttpContext.Current); } return(StatusCode(HttpStatusCode.NoContent)); }
public void SetupStandardCollationTests() { _databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString); _unitOfWork = new UnitOfWork(_databaseConnection); _repository = new StandardRepository(_unitOfWork); _standardCollations.Add(new StandardCollationModel { StandardId = _firstStandardId, ReferenceNumber = _firstStandardReference, Title = $"Standard title {_firstStandardId}", StandardData = JsonConvert.SerializeObject(new StandardDataModel { Level = 1 }), Options = new List <OptionDataModel> { new OptionDataModel { StdCode = _firstStandardId, OptionName = $"Option {_firstStandardId}.1", IsLive = 1 }, new OptionDataModel { StdCode = 1, OptionName = $"Option {_firstStandardId}.2", IsLive = 1 }, new OptionDataModel { StdCode = 1, OptionName = $"Option {_firstStandardId}.3", IsLive = 0 } }, IsLive = 1 }); _standardCollations.Add(new StandardCollationModel { StandardId = _secondStandardId, ReferenceNumber = _secondStandardReference, Title = $"Standard title {_secondStandardId}", StandardData = JsonConvert.SerializeObject(new StandardDataModel { Level = 2 }), Options = new List <OptionDataModel> { new OptionDataModel { StdCode = _secondStandardId, OptionName = $"Option {_secondStandardId}.1", IsLive = 1 }, new OptionDataModel { StdCode = _secondStandardId, OptionName = $"Option {_secondStandardId}.2", IsLive = 1 } }, IsLive = 1 }); _standardCollations.Add(new StandardCollationModel { StandardId = _thirdStandardId, ReferenceNumber = _thirdStandardReference, Title = $"Standard title {_thirdStandardId}", StandardData = null, Options = new List <OptionDataModel>(), IsLive = 1 }); _standardCollations.Add(new StandardCollationModel { StandardId = _fourthStandardId, ReferenceNumber = _fourthStandardReference, Title = $"Standard title {_fourthStandardId}", StandardData = JsonConvert.SerializeObject(new StandardDataModel { Level = 4 }), Options = new List <OptionDataModel> { new OptionDataModel { StdCode = _fourthStandardId, OptionName = $"Option {_fourthStandardId}.1", IsLive = 0 }, new OptionDataModel { StdCode = _fourthStandardId, OptionName = $"Option {_fourthStandardId}.2", IsLive = 1 } }, IsLive = 0 }); StandardCollationHandler.InsertRecords(_standardCollations); }