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 ActionResult GetRacunGlavaCollectionForPaging(string sidx, string sord, string filters, int page = 1)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
short godina = ConfigEntity.GetInstance(adapter, firmaId).AktivnaGodina;
RelationPredicateBucket bucket = RacunGlavaPager.CreateBucket(godina, filters);
bucket.PredicateExpression.Add(RacunGlavaFields.FirmaId == firmaId);
bucket.Relations.Add(RacunGlavaEntity.Relations.PartnerEntityUsingPartnerId);
bool?isSortAscending = PagerBase.IsJqgridSortAscending(sord);
RacunGlavaPager pager = new RacunGlavaPager();
pager.LoadData(adapter, bucket, page, Common.Config.JqGridPageSize, sidx, isSortAscending);
return(CreateJsonResponse(pager.CreateJqGridRespose()));
}
}
