public async Task <List <TenderValueToTypesModel> > ReportTendersToActivity(TenderValueToTypeSearchCriteria searchCriteria)
{
var tenders = await _reportsService.ReportTendersToActivity(searchCriteria);
return(tenders);
}
public async Task <List <MostTendersActivitiesModel> > ReportGetMostTendersActivitiesAsync(TenderValueToTypeSearchCriteria searchCriteria)
{
var tenders = await _reportsService.ReportGetMostTendersActivitiesAsync(searchCriteria);
return(tenders);
}
public async Task <List <TenderValueToTypesModel> > TenderValueToTypesReport(TenderValueToTypeSearchCriteria searchCriteria)
{
var tenders = await _reportsService.GetTendersForTenderToTypesReport(searchCriteria);
return(tenders);
}
public async Task <TendersSummryReportCountsViewModel> GetTendersSummaryCountsAsync(TenderValueToTypeSearchCriteria searchCriteria)
{
var result = await _reportsService.GetTendersSummaryCountsAsync(searchCriteria);
return(result);
}
public async Task <QueryResult <TendersSummryReportViewModel> > GetTendersSummaryAsync(TenderValueToTypeSearchCriteria searchCriteria)
{
var tenders = await _reportsService.GetTendersSummaryAsync(searchCriteria);
return(tenders);
}
public async Task <byte[]> DownloadTenderSummaryReport(TenderValueToTypeSearchCriteria criteria)
{
criteria.PageSize = 999;
var tenders = await _reportsService.GetTendersSummaryAsync(criteria);
var mapedTenders = _mapper.Map <QueryResult <TendersSummryReportViewModel> >(tenders, opt => opt.Items["statusFlag"] = true);
byte[] fileContents;
using (var package = new ExcelPackage())
{
var worksheet = package.Workbook.Worksheets.Add("Report");
int rowNum = 1;
// for cell on row1 col1
worksheet.View.RightToLeft = true;
worksheet.Cells[rowNum, 1].Value = Resources.TenderResources.DisplayInputs.Agency;
worksheet.Cells[rowNum, 1].Style.Font.Size = 12;
worksheet.Cells[rowNum, 1].Style.Font.Bold = true;
worksheet.Cells[rowNum, 1].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 2].Value = Resources.TenderResources.DisplayInputs.AgencyBranch;
worksheet.Cells[rowNum, 2].Style.Font.Size = 12;
worksheet.Cells[rowNum, 2].Style.Font.Bold = true;
worksheet.Cells[rowNum, 2].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 3].Value = Resources.TenderResources.DisplayInputs.SummationOfGeneralTenders;
worksheet.Cells[rowNum, 3].Style.Font.Size = 12;
worksheet.Cells[rowNum, 3].Style.Font.Bold = true;
worksheet.Cells[rowNum, 3].Style.Border.Top.Style = ExcelBorderStyle.Hair;
///////////////////////////////////////////////////////////////
worksheet.Cells[rowNum, 4].Value = Resources.TenderResources.DisplayInputs.LimitedTender;
worksheet.Cells[rowNum, 4].Style.Font.Size = 12;
worksheet.Cells[rowNum, 4].Style.Font.Bold = true;
worksheet.Cells[rowNum, 4].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 5].Value = Resources.TenderResources.DisplayInputs.ReverseBidding;
worksheet.Cells[rowNum, 5].Style.Font.Size = 12;
worksheet.Cells[rowNum, 5].Style.Font.Bold = true;
worksheet.Cells[rowNum, 5].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 6].Value = Resources.TenderResources.DisplayInputs.FrameworkAgreement;
worksheet.Cells[rowNum, 6].Style.Font.Size = 12;
worksheet.Cells[rowNum, 6].Style.Font.Bold = true;
worksheet.Cells[rowNum, 6].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 7].Value = Resources.TenderResources.DisplayInputs.SummationOfInvitationsAndDirectPurchaseTenders;
worksheet.Cells[rowNum, 7].Style.Font.Size = 12;
worksheet.Cells[rowNum, 7].Style.Font.Bold = true;
worksheet.Cells[rowNum, 7].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 8].Value = Resources.TenderResources.DisplayInputs.NumberOfPurchases;
worksheet.Cells[rowNum, 8].Style.Font.Size = 12;
worksheet.Cells[rowNum, 8].Style.Font.Bold = true;
worksheet.Cells[rowNum, 8].Style.Border.Top.Style = ExcelBorderStyle.Hair;
///////////////////////////////////////////
worksheet.Cells[rowNum, 9].Value = Resources.TenderResources.DisplayInputs.SummationOfInvitationsAndDirectPurchaseTenders;
worksheet.Cells[rowNum, 9].Style.Font.Size = 12;
worksheet.Cells[rowNum, 9].Style.Font.Bold = true;
worksheet.Cells[rowNum, 9].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 10].Value = Resources.TenderResources.DisplayInputs.NumberOfSuppliers;
worksheet.Cells[rowNum, 10].Style.Font.Size = 12;
worksheet.Cells[rowNum, 10].Style.Font.Bold = true;
worksheet.Cells[rowNum, 10].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 11].Value = Resources.TenderResources.DisplayInputs.NumberOfSuppliersEnquiries;
worksheet.Cells[rowNum, 11].Style.Font.Size = 12;
worksheet.Cells[rowNum, 11].Style.Font.Bold = true;
worksheet.Cells[rowNum, 11].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 12].Value = Resources.TenderResources.DisplayInputs.NumberOfOpenedOffers;
worksheet.Cells[rowNum, 12].Style.Font.Size = 12;
worksheet.Cells[rowNum, 12].Style.Font.Bold = true;
worksheet.Cells[rowNum, 12].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 13].Value = Resources.TenderResources.DisplayInputs.NumberOfTechnicalChecked;
worksheet.Cells[rowNum, 13].Style.Font.Size = 12;
worksheet.Cells[rowNum, 13].Style.Font.Bold = true;
worksheet.Cells[rowNum, 13].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 14].Value = Resources.TenderResources.DisplayInputs.NumberOfAwardded;
worksheet.Cells[rowNum, 14].Style.Font.Size = 12;
worksheet.Cells[rowNum, 14].Style.Font.Bold = true;
worksheet.Cells[rowNum, 14].Style.Border.Top.Style = ExcelBorderStyle.Hair;
/////////////////////////////////////
worksheet.Cells[rowNum, 15].Value = Resources.TenderResources.DisplayInputs.TheElectronicOffersOnTenders;
worksheet.Cells[rowNum, 15].Style.Font.Size = 12;
worksheet.Cells[rowNum, 15].Style.Font.Bold = true;
worksheet.Cells[rowNum, 15].Style.Border.Top.Style = ExcelBorderStyle.Hair;
worksheet.Cells[rowNum, 16].Value = Resources.TenderResources.DisplayInputs.TheElectronicOffersOnDirectPurchase;
worksheet.Cells[rowNum, 16].Style.Font.Size = 12;
worksheet.Cells[rowNum, 16].Style.Font.Bold = true;
worksheet.Cells[rowNum, 16].Style.Border.Top.Style = ExcelBorderStyle.Hair;
if (mapedTenders.Items.Count() > 0)
{
foreach (TendersSummryReportViewModel tenderItem in mapedTenders.Items)
{
rowNum++;
worksheet.Cells[rowNum, 1].Value = tenderItem.AgencyName;
worksheet.Cells[rowNum, 2].Value = tenderItem.BranchName;
worksheet.Cells[rowNum, 3].Value = tenderItem.TendersCount;
worksheet.Cells[rowNum, 4].Value = tenderItem.TenderLimitedValue;
worksheet.Cells[rowNum, 4].Value = tenderItem.TenderReverseBiddingValue;
worksheet.Cells[rowNum, 5].Value = tenderItem.TenderFrameworkAgreementValue;
worksheet.Cells[rowNum, 6].Value = tenderItem.DirectPurchaseCount;
worksheet.Cells[rowNum, 7].Value = tenderItem.NumberOfPurchasedSuppliers;
worksheet.Cells[rowNum, 8].Value = tenderItem.NumberOfOppenedOffers;
worksheet.Cells[rowNum, 9].Value = tenderItem.NumberTechnicalCheckedOfferd;
worksheet.Cells[rowNum, 9].Value = tenderItem.NumberAwardedOffered;
worksheet.Cells[rowNum, 9].Value = tenderItem.ElectronicOffersOnTenders;
worksheet.Cells[rowNum, 9].Value = tenderItem.ElectronicOffersOnDirectPurchase;
}
}
fileContents = package.GetAsByteArray();
}
return(fileContents);
}
public async Task <QueryResult <MostSuppliersHaveTendersModel> > Report_GetMostSuppliersHaveTendersAsync(TenderValueToTypeSearchCriteria criteria)
{
var tenders = await _reportsService.ReportGetMostSuppliersHaveTendersListAsync(criteria);
return(tenders);
}
public async Task <QueryResult <AgencyFileViewModel> > AgencyFileReport(TenderValueToTypeSearchCriteria searchCriteria)
{
var tenders = await _reportsService.GetAgencyFileAsync(searchCriteria);
return(tenders);
}
public async Task <QueryResult <DirectPurchaseModel> > DirectPurchaseReportAsyncReport(TenderValueToTypeSearchCriteria searchCriteria)
{
var tenders = await _reportsService.GetDirectPurchaseReport(searchCriteria);
return(tenders);
}
public async Task <TotalAmountOfSavingsViewModel> GetTotalAmountOfSavingsAsync(TenderValueToTypeSearchCriteria searchCriteria)
{
var result = await _reportsService.GetTotalAmountOfSavingsAsync(searchCriteria);
return(result);
}
public async Task <QueryResult <QualificationModel> > QualificationReportAsyncReport(TenderValueToTypeSearchCriteria searchCriteria)
{
var tenders = await _reportsService.GetQualificationReport(searchCriteria);
return(tenders);
}
