public FileContentResult RacunReportCollection(string jqGridFilters)
{
DataAccessAdapterBase adapter = Helpers.Helper.GetDataAccessAdapter();
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
string reportPath = Server.MapPath(string.Format("~/ReportTemplates/{0}/Racun.xls", firmaId));
FlexCel.XlsAdapter.XlsFile xls = new FlexCel.XlsAdapter.XlsFile();
xls.Open(reportPath);
short godina = ConfigEntity.GetInstance(adapter, firmaId).AktivnaGodina;
RelationPredicateBucket bucket = RacunGlavaPager.CreateBucket(godina, jqGridFilters);
bucket.PredicateExpression.Add(RacunGlavaFields.FirmaId == firmaId);
IEnumerable <RacunReport> racunReportCollection = CoolJ.DatabaseGeneric.BusinessLogic.RacunReport.GetRacunReportCollection(adapter, bucket, firmaId);
FlexCel.Report.FlexCelReport report = new FlexCel.Report.FlexCelReport();
report.AddTable("Racun", racunReportCollection);
report.Run(xls);
using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
{
FlexCel.Render.FlexCelPdfExport pdfExport = new FlexCel.Render.FlexCelPdfExport(xls);
pdfExport.BeginExport(ms);
pdfExport.ExportAllVisibleSheets(false, "");
pdfExport.EndExport();
//xls.Save(ms);
ms.Position = 0;
return(File(ms.ToArray(), "application/pdf"));
}
}
public FileContentResult RacunReport(long racunGlavaId)
{
DataAccessAdapterBase adapter = Helpers.Helper.GetDataAccessAdapter();
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
string reportPath = Server.MapPath(string.Format("~/ReportTemplates/{0}/Racun.xls", firmaId));
FlexCel.XlsAdapter.XlsFile xls = new FlexCel.XlsAdapter.XlsFile();
xls.Open(reportPath);
List <RacunReport> racunGlavaList = new List <RacunReport>();
racunGlavaList.Add(new RacunReport(adapter, racunGlavaId));
FlexCel.Report.FlexCelReport report = new FlexCel.Report.FlexCelReport();
report.AddTable("Racun", racunGlavaList);
report.Run(xls);
using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
{
FlexCel.Render.FlexCelPdfExport pdfExport = new FlexCel.Render.FlexCelPdfExport(xls);
pdfExport.BeginExport(ms);
pdfExport.ExportAllVisibleSheets(false, "");
pdfExport.EndExport();
//xls.Save(ms);
ms.Position = 0;
return(File(ms.ToArray(), "application/pdf"));
}
}
/// <summary>
///
/// </summary>
/// <param name="lv"></param>
public void Export()
{
FlexCel.XlsAdapter.XlsFile xls = new FlexCel.XlsAdapter.XlsFile(true);
xls.NewFile(1);
int row = 1;
int col = 1;
foreach (ColumnHeader ch in lv.Columns)
{
xls.SetCellValue(row, col, ch.Text);
col++;
}
row++;
foreach (ListViewItem lvi in lv.Items)
{
col = 1;
//foreach (ListViewItem.ListViewSubItem lvsi in lvi.SubItems)
for (int subItemIndex = 0; subItemIndex < lvi.SubItems.Count; subItemIndex++)
{
ListViewItem.ListViewSubItem lvsi = lvi.SubItems[subItemIndex];
if (lvsi.Text != string.Empty)
{
//ListViewItem.ListViewSubItem lvsi in lvi.SubItems)
TypeCode typeCode = GetTypeCode(lv.Columns, subItemIndex);
object value = null;
if (typeCode == TypeCode.Int32 || typeCode == TypeCode.Int16 || typeCode == TypeCode.Int64)
{
value = Convert.ToInt32(lvsi.Text);
}
else if (typeCode == TypeCode.Single)
{
float fvalue = Convert.ToSingle(lvsi.Text);
value = Math.Round(fvalue, 2);
}
else
{
value = lvsi.Text;
}
xls.SetCellValue(row, col, value);
}
col++;
}
row++;
}
xls.Save(this.FileName);
}
