private void cmbShipment_SelectedIndexChanged(object sender, EventArgs e) { try { if (cmbShipment.SelectedIndex != -1) { DataTable shipmentData = ShipmentManagementDB.GetShipmentStatusReport(Convert.ToInt32(cmbShipment.SelectedValue)); if (shipmentData != null) { //Get Shipment Year on ShipmentID shipmentYear = GetShipmentYearOnShipmentID(Convert.ToInt32(cmbShipment.SelectedValue)); dgvShipmentDocs.AutoGenerateColumns = false; dgvShipmentDocs.DataSource = shipmentData; colShipmentRefID.DataPropertyName = "SHIPMENT_REF_ID"; colReferenceName.DataPropertyName = "REFERENCE_NAME"; colReferenceStatus.DataPropertyName = "TASK_STATUS"; } } else { MessageBox.Show("Please select shipment.", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } }
private void cmbShipment_SelectionChangeCommitted(object sender, EventArgs e) { try { if (cmbShipment.SelectedIndex != -1) { //Get Year & Issue strYear_Issue = GetYearAndIssueFromShipmentName(cmbShipment.Text); DataTable dtReportData = ShipmentManagementDB.GetShipmentStatusReport(Convert.ToInt32(cmbShipment.SelectedValue)); if (dtReportData != null) { Cursor = Cursors.WaitCursor; ShipmentData = dtReportData; if (dtReportData.Rows.Count > 0) { //Bind shipment data to grid BindShipmentDataToGrid(dtReportData); //set Status labels SetShipmentStatusLabels(dtReportData); } else { dgvReport.DataSource = null; MessageBox.Show("No data available for the shipment", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); Cursor = Cursors.Default; } } else { dgvReport.DataSource = null; MessageBox.Show("No data available for the shipment", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); Cursor = Cursors.Default; } } } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } finally { Cursor = Cursors.Default; } }