public void GetAllRegistrationRecordsFromDbContextNotNull() { var dbContext = new SQLConnType(@"localhost\SQLEXPRESS14", "CSG", "sa", "@1Mops4moa"); var sysUnderTest = new RegistrationRepo(dbContext); var result = sysUnderTest.GetAllAsync(); Assert.NotNull(result); }
public void GetAllRegistrationRecordsFromDbContextGreaterThanZeroRecords() { var dbContext = new SQLConnType(@"localhost\SqlExpress14", "CSG", "sa", "@1Mops4moa"); var sysUnderTest = new RegistrationRepo(dbContext); var result = sysUnderTest.GetAllAsync(); Assert.True(result.Count > 0); }
public void DeleteAllClassRecords_Succeed() { var dbContext = new SQLConnType(@"localhost\SqlExpress14", "CSG", "sa", "@1Mops4moa"); var sysUnderTest = new ClassRepo(dbContext); sysUnderTest.DeleteAllAsync(); var result = sysUnderTest.GetAllAsync(); Assert.True(result.Count == 0); }
public void DeleteClassRecordByID_Succeed() { var dbContext = new SQLConnType(@"localhost\SqlExpress14", "CSG", "sa", "@1Mops4moa"); var sysUnderTest = new RegistrationRepo(dbContext); var regEnt = new Registration("50f14850-1161-4b7f-8093-af335090268f"); sysUnderTest.DeleteByIdAsync(regEnt.Id); var result = sysUnderTest.GetAllAsync(); Assert.True(result.Count > 0); }
public void InsertClassRecord_Succeed() { var dbContext = new SQLConnType(@"localhost\SqlExpress14", "CSG", "sa", "@1Mops4moa"); var sysUnderTest = new ClassRepo(dbContext); var classEnt = new ClassEntity(Guid.NewGuid().ToString()); classEnt.ClassName = "English"; classEnt.Description = "English Poetry"; sysUnderTest.InsertEntityAsync(classEnt); var result = sysUnderTest.GetAllAsync(); Assert.True(result.Count > 0); }
public void InsertTeacherRecord_Succeed() { var dbContext = new SQLConnType(@"localhost\SqlExpress14", "CSG", "sa", "@1Mops4moa"); var sysUnderTest = new TeacherRepo(dbContext); var teacher = new Teacher(Guid.NewGuid().ToString()); teacher.Name = "Johan"; teacher.Surname = "Potgieter"; teacher.DateRegistered = DateTime.Now.Date; sysUnderTest.InsertEntityAsync(teacher); var result = sysUnderTest.GetAllAsync(); Assert.True(result.Count > 0); }
public void InsertRegistrationRecord_Succeed() { var dbContext = new SQLConnType(@"localhost\SqlExpress14", "CSG", "sa", "@1Mops4moa"); var sysUnderTest = new RegistrationRepo(dbContext); var reg = new Registration(Guid.NewGuid().ToString()); reg.AttendanceDate = DateTime.Now.Date; reg.AttendanceStatusId = 1; reg.ClassId = "50f14850-1161-4b7f-8093-af335090268f"; reg.Grade = 75; reg.StudentId = "50f14850-1161-4b7f-8093-af335090268f"; reg.TeacherId = "50f14850-1161-4b7f-8093-af335090268f"; sysUnderTest.InsertEntityAsync(reg); var result = sysUnderTest.GetAllAsync(); Assert.True(result.Count > 0); }
public ClassRepo(SQLConnType dbContext) { _dbContext = dbContext; }
public TeacherRepo(SQLConnType dbContext) { _dbContext = dbContext; }
public StudentRepo(SQLConnType dbContext) { _dbContext = dbContext; }
public UserRepo(SQLConnType dbContext) { _dbContext = dbContext; }
public RegistrationRepo(SQLConnType dbContext) { _dbContext = dbContext; }
public LoginRepo(SQLConnType dbContext) { _dbContext = dbContext; }