示例#1
0
        public void GetAllRegistrationRecordsFromDbContextNotNull()
        {
            var dbContext    = new SQLConnType(@"localhost\SQLEXPRESS14", "CSG", "sa", "@1Mops4moa");
            var sysUnderTest = new RegistrationRepo(dbContext);

            var result = sysUnderTest.GetAllAsync();

            Assert.NotNull(result);
        }
示例#2
0
        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);
        }
示例#3
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);
        }
示例#4
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);
        }
示例#5
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);
        }
示例#6
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);
        }
示例#7
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);
        }
示例#8
0
 public ClassRepo(SQLConnType dbContext)
 {
     _dbContext = dbContext;
 }
示例#9
0
 public TeacherRepo(SQLConnType dbContext)
 {
     _dbContext = dbContext;
 }
示例#10
0
 public StudentRepo(SQLConnType dbContext)
 {
     _dbContext = dbContext;
 }
示例#11
0
 public UserRepo(SQLConnType dbContext)
 {
     _dbContext = dbContext;
 }
示例#12
0
 public RegistrationRepo(SQLConnType dbContext)
 {
     _dbContext = dbContext;
 }
示例#13
0
 public LoginRepo(SQLConnType dbContext)
 {
     _dbContext = dbContext;
 }