public void TestInitializer()
{
_eventParticipationService = Substitute.For <IEventParticipationService>();
_eventUtilitiesService = Substitute.For <IEventUtilitiesService>();
_excelBuilder = new ExcelBuilder();
_eventExportService = new EventExportService(_eventParticipationService, _eventUtilitiesService, _excelBuilder);
}
public KudosExportService(
IUnitOfWork2 uow,
IExcelBuilder excelBuilder)
{
_uow = uow;
_kudosLogsDbSet = _uow.GetDbSet<KudosLog>();
_userDbSet = _uow.GetDbSet<ApplicationUser>();
_excelBuilder = excelBuilder;
}
public EventExportService(
IEventParticipationService eventParticipationService,
IEventUtilitiesService eventUtilitiesService,
IExcelBuilder excelBuilder)
{
_eventParticipationService = eventParticipationService;
_eventUtilitiesService = eventUtilitiesService;
_excelBuilder = excelBuilder;
}
public void TestInitializer()
{
_uow = Substitute.For <IUnitOfWork2>();
_serviceRequestsDbSet = Substitute.For <DbSet <ServiceRequest>, IQueryable <ServiceRequest>, IDbAsyncEnumerable <ServiceRequest> >();
_uow.GetDbSet <ServiceRequest>().Returns(_serviceRequestsDbSet);
_excelBuilder = new ExcelBuilder();
_serviceRequestExportService = new ServiceRequestExportService(_uow, _excelBuilder);
}
private static void BuildDays(IExcelBuilder excelBuilder, Guid sheetId, ReportDataBuilder reportDataBuilder)
{
int columnStart = DAYS_COLUMN_START;
foreach (var day in reportDataBuilder.Days)
{
excelBuilder.AddValueToCell(sheetId, new ExcelCell(DAYS_ROW, columnStart), day);
columnStart++;
}
}
private static void BuildSumPerDayRow(IExcelBuilder excelBuilder, Guid sheetId, ReportDataBuilder reportDataBuilder)
{
int rowWithSum = reportDataBuilder.People.Count() + PEOPLE_ROW_START;
int columnStart = DAYS_COLUMN_START;
foreach (var day in reportDataBuilder.Days)
{
excelBuilder.SumCells(sheetId, new ExcelCell(rowWithSum, columnStart), new ExcelCell(PEOPLE_ROW_START, columnStart), new ExcelCell(rowWithSum - 1, columnStart));
excelBuilder.SetCellBackground(sheetId, new ExcelCell(rowWithSum, columnStart), Color.Gold);
columnStart++;
}
}
private static void Build(IExcelBuilder excelBuilder, ReportDataBuilder reportDataBuilder)
{
var sheetId = excelBuilder.CreateSheet(reportDataBuilder.ReportName);
BuildTitle(excelBuilder, sheetId, reportDataBuilder);
BuildSubTitle(excelBuilder, sheetId, reportDataBuilder);
BuildDays(excelBuilder, sheetId, reportDataBuilder);
BuildPeopleAttendancesList(excelBuilder, sheetId, reportDataBuilder);
BuildSumPerDayRow(excelBuilder, sheetId, reportDataBuilder);
BuildSumPerPerson(excelBuilder, sheetId, reportDataBuilder);
excelBuilder.AutoFitColumns(sheetId, 3.0);
}
private static void BuildSumPerPerson(IExcelBuilder excelBuilder, Guid sheetId,
ReportDataBuilder reportDataBuilder)
{
excelBuilder.AddValueToCell(sheetId, new ExcelCell(DAYS_ROW + 1, SUM_PER_PERSON_COLUMN), "SUMA", Color.LawnGreen);
int rowStart = PEOPLE_ROW_START;
foreach (var person in reportDataBuilder.People)
{
excelBuilder.SumCells(sheetId, new ExcelCell(rowStart, SUM_PER_PERSON_COLUMN), new ExcelCell(rowStart, DAYS_COLUMN_START), new ExcelCell(rowStart, SUM_PER_PERSON_COLUMN - 1));
excelBuilder.SetCellBackground(sheetId, new ExcelCell(rowStart, SUM_PER_PERSON_COLUMN), Color.LawnGreen);
rowStart++;
}
}
private static void BuildPeopleAttendancesList(IExcelBuilder excelBuilder, Guid sheetId, ReportDataBuilder reportDataBuilder)
{
int orderNo = 1;
int rowStart = PEOPLE_ROW_START;
foreach (var person in reportDataBuilder.People)
{
excelBuilder.AddValueToCell(sheetId, new ExcelCell(rowStart, 1), orderNo);
excelBuilder.AddValueToCell(sheetId, new ExcelCell(rowStart, 2), person.FullName);
excelBuilder.AddValueToCell(sheetId, new ExcelCell(rowStart, 3), person.Year, Color.Tomato);
int columnStart = DAYS_COLUMN_START;
foreach (var attendance in person.Attendances)
{
excelBuilder.AddValueToCell(sheetId, new ExcelCell(rowStart, columnStart), attendance ? 1 : 0);
columnStart++;
}
orderNo++;
rowStart++;
}
}
public MyExcelBuilder(IExcelBuilder excelBuilder)
{
_excelBuilder = excelBuilder;
}
public ServiceRequestExportService(IUnitOfWork2 uow, IExcelBuilder excelBuilder)
{
_serviceRequestsDbSet = uow.GetDbSet<ServiceRequest>();
_excelBuilder = excelBuilder;
}
public LotteryExportService(IExcelBuilder excelBuilder, IParticipantService participantService)
{
_excelBuilder = excelBuilder;
_participantService = participantService;
}
private static void BuildSubTitle(IExcelBuilder excelBuilder, Guid sheetId, ReportDataBuilder reportDataBuilder)
{
excelBuilder.AddValueToCell(sheetId, new ExcelCell(2, 1), reportDataBuilder.SubTitle);
excelBuilder.MergeCells(sheetId, new ExcelCell(2, 1), new ExcelCell(2, 35));
excelBuilder.CenterInHorizontal(sheetId, new ExcelCell(2, 1), new ExcelCell(2, 35));
}
