public void GetsCurrentProviderCode()
{
using (var dbContext = SqliteInMemory.GetSqliteDbContext())
{
dbContext.Database.EnsureCreated();
var providerCodeRepo = new ProviderCodeRepo <ProviderCode>(dbContext);
var providerCode1 = new ProviderCode
{
Code = "414",
StartDate = new DateTime(2018, 7, 1),
EndDate = new DateTime(2019, 6, 30)
};
var providerCode2 = new ProviderCode
{
Code = "525",
StartDate = new DateTime(2019, 7, 1),
EndDate = new DateTime(2020, 6, 30)
};
providerCodeRepo.AddRange(providerCode1, providerCode2);
var currentProviderCode = providerCodeRepo.GetCurrent();
Assert.AreEqual("525", currentProviderCode.Code);
}
}
public void CanAddAttendee()
{
using (var dbContext = SqliteInMemory.GetSqliteDbContext())
{
dbContext.Database.EnsureCreated();
var attendeeRepo = new AttendeeRepo <Attendee>(dbContext);
}
}
public void CanFindAgency()
{
using (var dbContext = SqliteInMemory.GetSqliteDbContext())
{
dbContext.Database.EnsureCreated();
var agencyRepo = new AgencyRepo <Agency>(dbContext);
var agencyName = "Jones School";
agencyRepo.Add(new Agency
{
AgencyName = agencyName
});
var agencies = agencyRepo.Search(agencyName);
Assert.AreEqual(agencyName, agencies.First().AgencyName);
}
}
public void CanAddAgency()
{
using (var dbContext = SqliteInMemory.GetSqliteDbContext())
{
dbContext.Database.EnsureCreated();
var agencyRepo = new AgencyRepo <Agency>(dbContext);
// Attempt
agencyRepo.Add(new Agency
{
AgencyName = "Jones School"
});
var agency = agencyRepo.Get(1);
// Verify
Assert.AreEqual("Jones School", agency.AgencyName);
}
}
public void CanGetAttendeeHours()
{
using (var dbContext = SqliteInMemory.GetSqliteDbContext())
{
dbContext.Database.EnsureCreated();
// Create project
// Create employee
// Create workshop
// Create agency
// Create attendees
// Assign attendees to workshop (AttendeeHours)
var workshopName = "Women Be Healthy";
var project = new Project
{
ProjectName = "Arkansas Disability and Health Project",
Description = "Health education for people with disabilities"
};
dbContext.Projects.Add(project);
var employee = new Employee {
FirstName = "John", LastName = "Employee"
};
dbContext.Employees.Add(employee);
dbContext.SaveChanges();
var workshop = new Workshop
{
WorkshopName = workshopName,
EmployeeId = employee.Id,
ProjectId = project.Id,
Description = "Women's health class",
TrainingDate = DateTime.Now,
SessionIdentifier = "WBH-4181234500000"
};
var workshop2 = new Workshop
{
WorkshopName = "Diabetes",
EmployeeId = employee.Id,
ProjectId = project.Id,
Description = "Diabetes health class",
TrainingDate = DateTime.Now,
SessionIdentifier = "DBH-4181234500000"
};
dbContext.Workshops.AddRange(workshop, workshop2);
var agency = new Agency {
AgencyName = "Little Rock High School"
};
dbContext.Agencies.Add(agency);
dbContext.SaveChanges();
var attendee1 = new Attendee
{
FirstName = "Sarah",
LastName = "Smith",
JobTitle = "Supervisor",
AgencyId = agency.Id
};
var attendee2 = new Attendee
{
FirstName = "Andy",
LastName = "Pablo",
JobTitle = "Manager",
AgencyId = agency.Id
};
dbContext.Attendees.AddRange(attendee1, attendee2);
dbContext.SaveChanges();
dbContext.AttendeeHours.Add(new AttendeeHour
{
AttendeeId = attendee1.Id,
WorkshopId = workshop.Id,
PDHours = 1
});
dbContext.AttendeeHours.Add(new AttendeeHour
{
AttendeeId = attendee2.Id,
WorkshopId = workshop.Id,
PDHours = 1
});
dbContext.AttendeeHours.Add(new AttendeeHour
{
AttendeeId = attendee1.Id,
WorkshopId = workshop2.Id,
PDHours = 1
});
dbContext.AttendeeHours.Add(new AttendeeHour
{
AttendeeId = attendee2.Id,
WorkshopId = workshop2.Id,
PDHours = 1
});
dbContext.SaveChanges();
var attendeeHourProvider = new AttendeeHourProvider(dbContext);
var attendeeWorkshopHours = attendeeHourProvider.GetAttendeeWorkshopHours(attendee1.Id);
Assert.AreEqual(2, attendeeWorkshopHours.Count);
}
}