public async Task GetObtainedCertifications_Should()
{
var obtainedCertificatonNotices = new List <ObtainCertificationNoticeDTO>();
var obtainedCertificationNotice = new ObtainCertificationNoticeDTO()
{
FirstName = "Steve",
LastName = "Miazga",
Email = "*****@*****.**",
CertificationCredential = "MCSD",
CertificationDescription = "Microsoft Certified Solutions Developer in Web Applications",
ObtainCertificationDate = Convert.ToDateTime("08/01/2017")
};
obtainedCertificatonNotices.Add(obtainedCertificationNotice);
var obtainedCertificatons = new ObtainCertificationsDTO()
{
Count = 1,
ObtainCertificationNotices = obtainedCertificatonNotices
};
_mockQueryRepository.Setup(x => x.GetObtainCertifications(Convert.ToDateTime("08/01/2017"))).Returns(obtainedCertificatons);
var query = new GetObtainCertificationNoticesQuery(Convert.ToDateTime("08/01/2017"));
var handler = new GetObtainCertificationNoticesQueryHandler(_mockQueryRepository.Object);
var result = await handler.Handle(query, CancellationToken.None);
Assert.NotNull(result);
}
public ObtainCertificationsDTO GetObtainCertifications(DateTime obtainCertificationDate)
{
string sql = @"select FirstName,LastName,Email,CertificationCredential,CertificationDescription,ObtainCertificationDate
from StudentObtainedCertificationEvent a
inner join Certify_Student b on b.StudentId = a.StudentId
inner join Certify_Certification c on c.CertificationId = a.CertificationId
where convert(date,a.ObtainCertificationDate) = convert(date,@ObtainCertificationDate)";
using (SqlConnection connection = new SqlConnection(_connectionString.Value))
{
var obtainCertificationNoticesDTO = connection.Query <ObtainCertificationNoticeDTO>(sql, new { ObtainCertificationDate = obtainCertificationDate }).ToList();
var count = obtainCertificationNoticesDTO.Count();
ObtainCertificationsDTO obtainCertificationsDTO = new ObtainCertificationsDTO()
{
Count = count,
ObtainCertificationNotices = obtainCertificationNoticesDTO
};
return(obtainCertificationsDTO);
}
}
