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)); }