private void btnViewReport_Click(object sender, EventArgs e)
{
if (cbVessel.Text.Equals(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.cboDefaultText))
MessageBox.Show(this, "Please choose vessel", "Information");
else if(etVoy.Text.Trim().Length == 0)
MessageBox.Show(this, "Please fill voy", "Information");
else if (pickerATD.Value.Date > DateTime.Now.Date)
MessageBox.Show(this, "ATD must be lower from today", "Information");
else
{
string query = CreateSelectQueryAndParameters();
if (!query.Contains("Column"))
{
MessageBox.Show("No selection to display!");
return;
}
objReportContainer = new RptContainer();
try
{
SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString);
SqlDataAdapter da = new SqlDataAdapter(query, VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString);
ShippingMainDataSet ds = new ShippingMainDataSet();
da.Fill(ds, "CONTAINER");
objReportContainer.SetDataSource(ds);
crystalReportViewerContainer.ReportSource = objReportContainer;
}
catch (SqlException sqlEx)
{
MessageBox.Show(sqlEx.Message);
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
RptContainer rpt = new RptContainer();
rpt.Site = this.Site;
return rpt;
}
