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;
}
