public JsonResult SaveToExcel(
int?cropId,
string searchFromDate,
string searchToDate)
{
List <Crop_Details> cropDetailsData = CropDetailsManager.SearchCropData(
cropId.GetValueOrDefault(),
DateTime.Parse(searchFromDate),
DateTime.Parse(searchToDate));
ReportingManager.GenerateReport(cropDetailsData);
return(Json("Report Generated!"));
}
private void Export()
{
DocsPaWR.PrintReportRequest request = new DocsPaWR.PrintReportRequest();
// Parametri requesti
request.Title = "Registro degli Accessi - " + UserManager.getInfoAmmCorrente(UserManager.GetInfoUser().idAmministrazione).Descrizione;
request.ContextName = "RegistroAccessiExport";
request.ReportKey = "RegistroAccessiExport";
request.SearchFilters = this.SetFilters();
switch (this.ddlFormatoPreReport.SelectedValue)
{
case "XLS":
request.ReportType = DocsPaWR.ReportTypeEnum.Excel;
break;
case "ODS":
request.ReportType = DocsPaWR.ReportTypeEnum.ODS;
break;
}
DocsPaWR.FileDocumento fileDoc = ReportingManager.GenerateReport(request);
if (fileDoc != null && fileDoc.content != null && fileDoc.content.Length > 0)
{
this.UpPnlDocumentData.Visible = true;
this.FileDoc = fileDoc;
this.frame.Attributes["src"] = "../Document/AttachmentViewer.aspx";
this.UpPnlDocumentData.Update();
this.UpPnlContentDxSx.Update();
}
else
{
string msg = "ProceedingsReportNoDataFound";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ajaxDialogModal", "if (parent.fra_main) {parent.fra_main.ajaxDialogModal('" + msg.Replace("'", @"\'") + "', 'warning', '');} else {parent.ajaxDialogModal('" + msg.Replace("'", @"\'") + "', 'warning', '');}", true);
this.UpPnlDocumentData.Visible = false;
this.UpPnlDocumentData.Update();
this.UpPnlContentDxSx.Update();
}
}
private FileDocumento GenerateReport(String contextName, String reportKey, String title, String subtitle, ReportTypeEnum reportType, FiltroRicerca[] filters)
{
PrintReportRequest request = new PrintReportRequest()
{
ContextName = contextName,
ReportKey = reportKey,
ReportType = reportType,
SubTitle = subtitle,
Title = title,
SearchFilters = filters,
UserInfo = UserManager.GetInfoUser(),
AdditionalInformation = (DocumentManager.getSelectedRecord() != null &&
DocumentManager.getInfoDocumento(DocumentManager.getSelectedRecord()) != null &&
DocumentManager.getInfoDocumento(DocumentManager.getSelectedRecord()).segnatura != null)
? DocumentManager.getInfoDocumento(DocumentManager.getSelectedRecord()).segnatura : string.Empty
};
//generazione report da codice
FileDocumento report = ReportingManager.GenerateReport(request);
return(report);
}
