public ActionResult VideosAddedViewerPartialExport()
{
VideoAddedReport.DataSource = VideoService.Get()
.Include(c => c.Genre)
.ToList();
return(DocumentViewerExtension.ExportTo(VideoAddedReport, Request));
}
public ActionResult NoOfTestsDocumentViewerExport()
{
TestNosGraphReport report = new TestNosGraphReport();
return(DocumentViewerExtension.ExportTo(report));
//return PartialView("ProdBarcodeMissingIndex", model);
}
public ActionResult DocumentViewerPartialExport()
{
TempData.Keep("MaDatHang");
HoaDonDatHang report = new HoaDonDatHang(long.Parse(TempData["MaDatHang"].ToString()));
return(DocumentViewerExtension.ExportTo(report, Request));
}
public ActionResult PartialBaoCaoThongTinKhoaHocExport(int IdLyLich)
{
reportkhoahoc.DataSource = GetThongTinLyLich(IdLyLich).ToList();
reportkhoahoc.IdLyLich = IdLyLich;
reportkhoahoc.QuaTrinhDaoTao();
return(DocumentViewerExtension.ExportTo(reportkhoahoc, Request));
}
public ActionResult DocumentViewerPartialExport()
{
TempData.Keep("MaTT");
reportTinTuccs report = new reportTinTuccs(int.Parse(TempData["MaTT"].ToString()));
return(DocumentViewerExtension.ExportTo(report, Request));
}
public ActionResult DocumentViewerPartialExport(int ma)
{
EFDbContext db = new EFDbContext();
var model = (from dd in db.tbl_DailyDetail
join d in db.tbl_Daily on dd.DailyId equals d.Id
join u in db.AppUsers on d.UserName equals u.UserName
join u1 in db.AppUsers on d.User_Autho1 equals u1.UserName
join u2 in db.AppUsers on d.User_Autho2 equals u2.UserName
join c in db.tbl_CV on u.Ma_CV equals c.Ma_CV
join t in db.tbl_TO on u.Ma_TO equals t.Ma_TO
where d.Id == ma
select new ExportDailyModel
{
DailyId = d.Id,
Id = dd.Id,
FullName = u.FullName,
FullName1 = u1.FullName,
FullName2 = u2.FullName,
Date = d.Date,
FromTime = dd.FormTime,
ToTime = dd.ToTime,
Total = d.Total_Job,
Content = dd.Content_Job,
Method = dd.Method,
Result = dd.Result,
Comment1 = dd.Comment1,
Comment2 = dd.Comment2,
Ten_TO = t.Ten_TO,
Ten_CV = c.Ten_CV
}).ToList();
XtraReportDaily report = new XtraReportDaily();
report.DataSource = model;
return(DocumentViewerExtension.ExportTo(report));
}
public ActionResult ProdStandardDocumentViewerExport()
{
ProductStandardMinMaxReport report = new ProductStandardMinMaxReport();
return(DocumentViewerExtension.ExportTo(report));
//return PartialView("ProdBarcodeMissingIndex", model);
}
public ActionResult DocumentViewerExportToDienLuc()
{
var report = new PhuongTienDo.Reports.rpDienLuc();
report.Fill();
return(DocumentViewerExtension.ExportTo(report));
}
public ActionResult DocumentViewerExportToXuatKho1Phieu()
{
var report = new CongCuDungCu.Reports.rpXuatKho1Phieu();
int sttct = (int)Session["STTCT"];
report.Fill(sttct);
return(DocumentViewerExtension.ExportTo(report));
}
public ActionResult DocumentViewerExportToDonViDuocCap()
{
var report = new CongCuDungCu.Reports.rpDonViDuocCap();
report.getIDDonVi(System.Web.HttpContext.Current.User.Identity.Name);
report.Fill((string)Session["Tendonvi"]);
return(DocumentViewerExtension.ExportTo(report));
}
public ActionResult DocumentViewerExportToNhapKho()
{
var report = new CongCuDungCu.Reports.rpNhapKho();
report.getIDDonVi(System.Web.HttpContext.Current.User.Identity.Name);
report.Fill(AccountDataProvider.GetSystemDate());
return(DocumentViewerExtension.ExportTo(report));
}
public ActionResult DocumentViewerExportToBieuMau9KK()
{
var report = new CongCuDungCu.Reports.rpBieuMau9KK();
report.getMaDVQL(System.Web.HttpContext.Current.User.Identity.Name);
report.Fill();
return(DocumentViewerExtension.ExportTo(report));
}
public ActionResult BacsDetailDocumentViewerExport(System.Int64?headerrecid)
{
ViewBag.headerrecid = headerrecid;
BacsDetailReport report = new BacsDetailReport();
return(DocumentViewerExtension.ExportTo(report));
//return PartialView("ProdBarcodeMissingIndex", model);
}
public ActionResult DocumentViewerPartialExport()
{
var data = System.Web.HttpContext.Current.Session["tempData"] as List <ERP_V2.Reports.TR01.TR01ReportModel>;
ERP_V2.Reports.TR01.TR01Report report = new ERP_V2.Reports.TR01.TR01Report(data.First());
report.DataSource = data;
return(DocumentViewerExtension.ExportTo(report, Request));
}
public ActionResult DocumentViewerExport()
{
XtraReport report = new CategoryProductsReport();
report.DataSource = from category in DataContext.Categories
select category;
return(DocumentViewerExtension.ExportTo(report));
}
public ActionResult ExportDocumentViewer()
{
var model = Session["ReportViewer"] as DesignModel;
var report = XtraReport.FromStream(new MemoryStream(model.Report), true);
report.DataSource = model.DataSource;
return(DocumentViewerExtension.ExportTo(report));
}
public ActionResult RentalReportViewerPartialExport()
{
RentalsReport.DataSource = RentalService.Get()
.Include(c => c.Status)
.Include(c => c.User)
.Include(c => c.Video)
.ToList();
return(DocumentViewerExtension.ExportTo(RentalsReport, Request));
}
public ActionResult DocumentViewerPartialExport()
{
TempData.Keep("tukhoa");
TempData.Keep("tungay");
TempData.Keep("dengay");
ThongKeSanPham report = new ThongKeSanPham(TempData["tukhoa"].ToString(), TempData["tungay"].ToString(), TempData["denngay"].ToString());
return(DocumentViewerExtension.ExportTo(report, Request));
}
public async Task <ActionResult> OverDueVideosViewerPartialExport()
{
OverDueVideosReport.DataSource = (await RentalService.Get()
.Include(c => c.Status)
.Include(c => c.User)
.Include(c => c.Video).ToListAsync())
.Where(e => e.OverDueDays > 0);
return(DocumentViewerExtension.ExportTo(OverDueVideosReport, Request));
}
public ActionResult DocViewerSemillasFamiliaPartialExport()
{
//Reportes.Semillas.SemillasPorFamilia _reporte = new Reportes.Semillas.SemillasPorFamilia();
Reportes.GruposFamilia.TotalesPorGrupoFamiliaReport _reporte = new Reportes.GruposFamilia.TotalesPorGrupoFamiliaReport();
IRepositoryWrapper _repository = new RepositoryWrapper();
short empresaId = -1;
short sucursalId = -1;
short regionId = -1;
int divisionId = -1;
if (Request.Params["Clave_Empresa"] != null)
{
short.TryParse("0" + Request.Params["Clave_Empresa"], out empresaId);
}
if (Request.Params["Clave_Region"] != null)
{
string[] divisionRegion = Request.Params["Clave_Region"].ToString().Split(';');
if (divisionRegion.Count() > 1)
{
divisionId = Convert.ToInt32(divisionRegion[0]);
regionId = Convert.ToInt16(divisionRegion[1]);
}
}
if (Request.Params["Clave_Sucursal"] != null)
{
short.TryParse("0" + Request.Params["Clave_Sucursal"], out sucursalId);
}
var modelTodos = FTPresupuestoProvider.GetSemillasReporteByEmpresaRegionClienteUser(empresaId, regionId, divisionId, sucursalId);
var modelTotales = TotalPorGrupoFamilia(modelTodos.ToList());
string _emp = empresaId == 0 ? "(TODAS)" : _repository.Catalogos.GetNombreEmpresa(empresaId);
string _division = divisionId == 0 ? "(TODAS)" : _repository.Catalogos.GetNombreDivision(empresaId, divisionId);
string _region = regionId == 0 ? "(TODAS)" : _repository.Catalogos.GetNombreRegion(empresaId, regionId, divisionId);
string _centroCosto = sucursalId == 0 ? "(TODOS)" : _repository.Catalogos.GetNombreSucursal(empresaId, sucursalId);
//_repository.Catalogos.GetNombreCentroCosto(empresaId, sucursalId);
foreach (var total in modelTotales)
{
total.Desc_Empresa = _emp;
total.Desc_Division = _division;
total.Desc_Region = _region;
total.Desc_Sucursal = _centroCosto;
}
_reporte.Parameters["TituloReporte"].Value = "PRESUPUESTO SEMILLAS POR GRUPO / FAMILIA";
_reporte.DataSource = modelTotales;
return(DocumentViewerExtension.ExportTo(_reporte, Request));
}
public ActionResult ExportDocumentViewer()
{
// Specify the report service URI and the name of the remote report to export.
MVCxDocumentViewerRemoteSourceSettings settings =
new MVCxDocumentViewerRemoteSourceSettings();
settings.ServerUri = @"http://localhost:52511/ReportService1.svc";
settings.ReportTypeName = "WebApplication1.XtraReport1, WebApplication1";
return(DocumentViewerExtension.ExportTo(settings, HttpContext.Request));
}
public ActionResult ExportDocumentViewer()
{
var dtEventualidad = (DataTable)Session["DtNoConformidadSeleccionada"];
var reporte = (XtraReportNoConformidad)Session["ReporteNoConformidad"];
reporte.ExportOptions.Html.TableLayout = false;
reporte.Parameters["NoConformidad_Id"].Value = Convert.ToInt32(dtEventualidad.Rows[0][0]);
reporte.Parameters["NoConformidad_Id"].Visible = false;
reporte.PaperKind = PaperKind.A4;
return(DocumentViewerExtension.ExportTo(reporte, Request));
}
public ActionResult Export(string templateId, string dataProviderId, string dataProviderArgs)
{
var template = TemplateMgr.GetTemplate(templateId);
if (!string.IsNullOrEmpty(dataProviderId))
{
FillDataSource(template.XtraReport, dataProviderId, dataProviderArgs);
}
return(DocumentViewerExtension.ExportTo(template.XtraReport));
}
public ActionResult DocViewerGastosAreasPartialExport()
{
IRepositoryWrapper _repository = new RepositoryWrapper();
short empresaId = -1;
short sucursalId = -1;
short regionId = -1;
int divisionId = -1;
if (Request.Params["Clave_Empresa"] != null)
{
short.TryParse("0" + Request.Params["Clave_Empresa"], out empresaId);
}
if (Request.Params["Clave_Region"] != null)
{
string[] divisionRegion = Request.Params["Clave_Region"].ToString().Split(';');
if (divisionRegion.Count() > 1)
{
divisionId = Convert.ToInt32(divisionRegion[0]);
regionId = Convert.ToInt16(divisionRegion[1]);
}
}
if (Request.Params["Clave_Sucursal"] != null)
{
short.TryParse("0" + Request.Params["Clave_Sucursal"], out sucursalId);
}
var modelTodos = FTPresupuestoProvider.GetGastosConsultaByEmpresaRegionClienteUser(empresaId, regionId, divisionId, sucursalId);
var modelTotales = TotalPorArea(modelTodos.ToList());
string _emp = empresaId == 0 ? "(TODAS)" : _repository.Catalogos.GetNombreEmpresa(empresaId);
string _division = divisionId == 0 ? "(TODAS)" : _repository.Catalogos.GetNombreDivision(empresaId, divisionId);
string _region = regionId == 0 ? "(TODAS)" : _repository.Catalogos.GetNombreRegion(empresaId, regionId, divisionId);
string _centroCosto = sucursalId == 0 ? "(TODOS)" : _repository.Catalogos.GetNombreCentroCosto(empresaId, sucursalId);
foreach (var total in modelTotales)
{
total.Desc_Empresa = _emp;
total.Desc_Division = _division;
total.Desc_Region = _region;
total.Nombre_cCostos = _centroCosto;
}
_gastosAreaReport.DataSource = modelTotales;
return(DocumentViewerExtension.ExportTo(_gastosAreaReport, Request));
}
public ActionResult DocViewerGastosDepartamentoPartialExport()
{
IRepositoryWrapper _repository = new RepositoryWrapper();//new FTPresupuestoEntities());
int empresaId = -1;
int sucursalId = -1;
int areaId = -1;
int cuentaId = -1;
int departamentoId = -1;
if (Request.Params["Clave_Empresa"] != null)
{
int.TryParse("0" + Request.Params["Clave_Empresa"], out empresaId);
}
if (Request.Params["Clave_Sucursal"] != null)
{
int.TryParse("0" + Request.Params["Clave_Sucursal"], out sucursalId);
}
if (Request.Params["Clave_Area"] != null)
{
int.TryParse("0" + Request.Params["Clave_Area"], out areaId);
}
if (Request.Params["SubCuenta"] != null)
{
int.TryParse("0" + Request.Params["SubCuenta"], out cuentaId);
}
if (Request.Params["DepartamentoID"] != null)
{
int.TryParse("0" + Request.Params["DepartamentoID"], out departamentoId);
}
int verPptoId = FTPresupuestoProvider.getVersionPresupuestoIdByTipo(enumTipoDePresupuesto.GASTOS);
var _gastosDepartamento = _repository.GastoDetalle.GetGastoDetalleToReport(empresaId, sucursalId, verPptoId, areaId, cuentaId, departamentoId);
_gastosDepartamentosReport.DataSource = _gastosDepartamento;
return(DocumentViewerExtension.ExportTo(_gastosDepartamentosReport, Request));
}
public ActionResult CustomerwiseReceiptClearancePartialExport(DateTime fromDate, DateTime toDate, long customerId)
{
return(DocumentViewerExtension.ExportTo(createCustomerwiseReceiptClearanceReport(fromDate, toDate, customerId), Request));
}
public ActionResult ReceiptAuditTrialPartialExport(DateTime fromDate, DateTime toDate)
{
return(DocumentViewerExtension.ExportTo(createReceiptAuditTrialReport(fromDate, toDate), Request));
}
public ActionResult ReceiptPrintoutPartialExport(DateTime fromDate, DateTime toDate, string receiptNo, long customerId, long customerSiteId)
{
return(DocumentViewerExtension.ExportTo(createReceiptPrintoutReport(fromDate, toDate, receiptNo, customerId, customerSiteId), Request));
}
public ActionResult PeriodwiseActivityPartialExport(DateTime fromDate, DateTime toDate, long customerId)
{
return(DocumentViewerExtension.ExportTo(createPeriodwiseActivityReport(fromDate, toDate, customerId), Request));
}
public ActionResult InvoiceAuditTrailPartialExport(DateTime fromDate, DateTime toDate)
{
return(DocumentViewerExtension.ExportTo(createInvoiceAuditTrailReport(fromDate, toDate), Request));
}
