public CargoTransferReportView() { // // Required for telerik Reporting designer support // InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtOrigin.Value = TrackingReportGlobalModel.Origin; txtDestination.Value = TrackingReportGlobalModel.Destination; txtDriver.Value = TrackingReportGlobalModel.Driver; txtChecker.Value = TrackingReportGlobalModel.Checker; txtPlateNo.Value = TrackingReportGlobalModel.PlateNo; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; // txtRemarks.Value = TrackingReportGlobalModel.Remarks; // txtNotes.Value = TrackingReportGlobalModel.Notes; }
public async Task <byte[]> GetReport(string Type, string basepath, CustomClearanceBIZSearchDTO arg) { var helper = new ReportHelper(); var datasource = new Telerik.Reporting.ObjectDataSource(); arg.gmsDashboardSearchFilter.pageNo = 0; datasource.DataSource = helper.GetGMSReleaseReportData(arg); Telerik.Reporting.Report instanceReport; var settings = new System.Xml.XmlReaderSettings(); settings.IgnoreWhitespace = true; var path = basepath + "/Report/GMSStatusReport.trdx"; using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(path, settings)) { var xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer(); instanceReport = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader); } Telerik.Reporting.Table tbl = instanceReport.Items.Find("table1", true)[0] as Telerik.Reporting.Table; tbl.DataSource = datasource; DateTime frmdate; if (DateTime.TryParseExact(arg.gmsDashboardSearchFilter.fromDT, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out frmdate)) { instanceReport.ReportParameters["FromDate"].Value = frmdate.ToString("dd/MM/yyyy"); } else { instanceReport.ReportParameters["FromDate"].Value = string.Empty; } DateTime todate; if (DateTime.TryParseExact(arg.gmsDashboardSearchFilter.toDT, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out todate)) { instanceReport.ReportParameters["ToDate"].Value = todate.ToString("dd/MM/yyyy"); } else { instanceReport.ReportParameters["ToDate"].Value = string.Empty; } //instanceReport.ReportParameters.Add("ToDate", parameters[1]); Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport(Type, new InstanceReportSource { ReportDocument = instanceReport }, null); byte[] contents = result.DocumentBytes; return(contents); }
public PickupCargoManifestReportView() { InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtArea.Value = TrackingReportGlobalModel.Area; txtDriver.Value = TrackingReportGlobalModel.Driver; txtChecker.Value = TrackingReportGlobalModel.Checker; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; }
public UnbundleReportView() { InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtOrigin.Value = TrackingReportGlobalModel.Origin; txtSackNo.Value = TrackingReportGlobalModel.SackNo; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; txtRemarks.Value = TrackingReportGlobalModel.Remarks; txtNotes.Value = TrackingReportGlobalModel.Notes; }
protected void DesplegarReporte(DateTime fecha1, DateTime fecha2) { ReporteExameneFechas reporte = new ReporteExameneFechas(); Telerik.Reporting.ObjectDataSource ds = new Telerik.Reporting.ObjectDataSource(); MuestraLaboratorioBll muestras = new MuestraLaboratorioBll(); ds.DataSource = muestras.GetReportMonth(fecha1, fecha2); reporte.DataSource = ds; InstanceReportSource fuente = new InstanceReportSource(); fuente.ReportDocument = reporte; examenesXFechas.ReportSource = fuente; }
public GatewayOutboundReportView() { InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtGateway.Value = TrackingReportGlobalModel.Gateway; txtDriver.Value = TrackingReportGlobalModel.Driver; txtPlateNo.Value = TrackingReportGlobalModel.PlateNo; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; // txtRemarks.Value = TrackingReportGlobalModel.Remarks; // txtNotes.Value = TrackingReportGlobalModel.Notes; }
public BundleReportView() { InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtBundleNo.Value = TrackingReportGlobalModel.SackNo; txtDestination.Value = TrackingReportGlobalModel.Destination; txtWeight.Value = TrackingReportGlobalModel.Weight; //txtRemarks.Value = TrackingReportGlobalModel.Remarks; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; // txtNotes.Value = TrackingReportGlobalModel.Notes; }
public BranchAcceptanceReportView() { InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtArea.Value = TrackingReportGlobalModel.Branch; //BRANCH txtDriver.Value = TrackingReportGlobalModel.Driver; txtChecker.Value = TrackingReportGlobalModel.Checker; txtBatch.Value = TrackingReportGlobalModel.Batch; txtPlateNo.Value = TrackingReportGlobalModel.PlateNo; txtRemarks.Value = TrackingReportGlobalModel.Remarks; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; txtNotes.Value = TrackingReportGlobalModel.Notes; }
public DeliveryStatusReportView() { // // Required for telerik Reporting designer support // InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtDriver.Value = TrackingReportGlobalModel.Driver; txtChecker.Value = TrackingReportGlobalModel.Checker; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; txtRevenueUnit.Value = TrackingReportGlobalModel.Area; //txtRemarks.Value = TrackingReportGlobalModel.Remarks; //txtNotes.Value = TrackingReportGlobalModel.Notes; }
public DailyTripReportView() { InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); var objectDataSource2 = new Telerik.Reporting.ObjectDataSource(); var objectDataSource3 = new Telerik.Reporting.ObjectDataSource(); var objectDataSource4 = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; DataTable dataTable2 = TrackingReportGlobalModel.table2; objectDataSource2.DataSource = dataTable2; table2.DataSource = objectDataSource2; DataTable dataTable3 = TrackingReportGlobalModel.table3; objectDataSource3.DataSource = dataTable3; table3.DataSource = objectDataSource3; DataTable dataTable4 = TrackingReportGlobalModel.table4; objectDataSource4.DataSource = dataTable4; table4.DataSource = objectDataSource4; txtDate.Value = TrackingReportGlobalModel.Date; txtArea.Value = TrackingReportGlobalModel.Area; txtBatch.Value = TrackingReportGlobalModel.Batch; txtpaymentMode.Value = TrackingReportGlobalModel.PaymentMode; txtPlateNo.Value = TrackingReportGlobalModel.PlateNo; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; // txtRemarks.Value = TrackingReportGlobalModel.Remarks; // txtNotes.Value = TrackingReportGlobalModel.Notes; }
public GatewayInboundReportView() { // // Required for telerik Reporting designer support // InitializeComponent(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtGateway.Value = TrackingReportGlobalModel.Gateway; txtMAWB.Value = TrackingReportGlobalModel.AirwayBillNo; txtFlightNo.Value = TrackingReportGlobalModel.FlightNo; txtCommodityType.Value = TrackingReportGlobalModel.CommodityType; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; // txtRemarks.Value = TrackingReportGlobalModel.Remarks; // txtNotes.Value = TrackingReportGlobalModel.Notes; }
public SegregationReportView() { // // Required for telerik Reporting designer support // InitializeComponent(); //List<string> x = new List<string>(); var objectDataSource = new Telerik.Reporting.ObjectDataSource(); DataTable dataTable = TrackingReportGlobalModel.table; objectDataSource.DataSource = dataTable; table1.DataSource = objectDataSource; txtDate.Value = TrackingReportGlobalModel.Date; txtDriver.Value = TrackingReportGlobalModel.Driver; txtChecker.Value = TrackingReportGlobalModel.Checker; txtPlateNo.Value = TrackingReportGlobalModel.PlateNo; txtScannedBy.Value = TrackingReportGlobalModel.ScannedBy; // txtRemarks.Value = TrackingReportGlobalModel.Remarks; // txtNotes.Value = TrackingReportGlobalModel.Notes; }
public void BindDataset() { var objectDataSource = new Telerik.Reporting.ObjectDataSource(); string selectCommandText = ""; string Start = Monthstartlbl.Text.ToString(); string End = Monthendlbl.Text.ToString(); //Getting Datasouce SqlConnection con = new SqlConnection(Repository.Connection.DBConnectionString()); SqlCommand mySqlCommand = con.CreateCommand(); mySqlCommand.CommandText = "ReportHartford_byDate_sp"; mySqlCommand.Parameters.Add("@Startdate", SqlDbType.NVarChar, -1).Value = Start; mySqlCommand.Parameters.Add("@Enddate", SqlDbType.NVarChar, -1).Value = End; mySqlCommand.CommandType = CommandType.StoredProcedure; SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); mySqlDataAdapter.SelectCommand = mySqlCommand; DataTable dt = new DataTable(); con.Open(); mySqlDataAdapter.Fill(dt); objectDataSource.DataSource = dt; CensusHartford HartReport = new CensusHartford(); HartReport.DataSource = objectDataSource; Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource(); reportSource.ReportDocument = HartReport; ReportViewer1.ReportSource = reportSource; }