private void btnGetShipmentRefs_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtShipmentYear.Text.Trim()) && !string.IsNullOrEmpty(txtClassType.Text.Trim()))
{
int.TryParse(txtShipmentYear.Text.Trim(), out shipmentYear);
if (shipmentYear > 0)
{
DataSet dsDeliveryData = ShipmentManagementDB.GetDeliveryDataOnYearAndClassType(shipmentYear, txtClassType.Text.Trim());
if (dsDeliveryData != null && dsDeliveryData.Tables.Count == 2)
{
//Bind Delivery Shipment References to grid
BindDeliveryDataToGrid(dsDeliveryData.Tables[0]);
//Bind Delivery Solvents to grid
BindDeliverySolventsToGrid(dsDeliveryData.Tables[1]);
//Get Next Mdl No
txtMDLNo.Text = DeliveriesDB.GetNextMDLNumber().ToString();
}
}
}
else
{
dgvRDFRefs.DataSource = null;
dgvSolvents.DataSource = null;
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
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 cmbModule_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
//Get Shipments on Module
dtShipments = ShipmentManagementDB.GetShipmentsOnModule(GetSelectedModuleCode());
if (dtShipments != null)
{
dgvShipmentDocs.DataSource = null;
cmbShipment.DataSource = dtShipments;
cmbShipment.DisplayMember = "SHIPMENT_NAME";
cmbShipment.ValueMember = "SHIPMENT_ID";
}
else
{
cmbShipment.DataSource = null;
dgvShipmentDocs.DataSource = null;
}
}
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;
}
}
private void btnValidate_Click(object sender, EventArgs e)
{
try
{
//Validate user inputs
string strErrMsg = "";
if (ValidateUserInputs(out strErrMsg))
{
//Get Selected TANs for Export
List <int> lstSelRefs = GetSelectedTasksForValidate();
if (lstSelRefs != null)
{
if (lstSelRefs.Count > 0)
{
if (ShipmentManagementDB.ValidateTaskPreparation(lstSelRefs, Convert.ToInt32(cmbShipment.SelectedValue), GlobalVariables.UR_ID))
{
MessageBox.Show("Selected Tasks validated successfully", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbShipment_SelectionChangeCommitted(null, null);
}
else
{
MessageBox.Show("Error in task validation.", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("No tasks are selected for validate", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show(strErrMsg, GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void cmbModule_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
//Get Shipments on Module
DataTable dtShipments = ShipmentManagementDB.GetShipmentsOnModule(GetSelectedModuleCode());
if (dtShipments != null)
{
cmbShipment.DataSource = dtShipments;
cmbShipment.DisplayMember = "SHIPMENT_NAME";
cmbShipment.ValueMember = "SHIPMENT_ID";
}
//Ger User Task Count on Module
GetUsersTaskCountAndBindToGrid();
//Set Module Users
SetApplicationModuleUsersToComboBox();
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
