private void gvMRList_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
bindItemList.DataSource = null;
long MRNO = Convert.ToInt64(gvMRList.Rows[e.RowIndex].Cells[0].Value);
MR objMRTemp = objMRDL.Get(MRNO);
objMR = new MR();
objMR = objMRTemp;
// objMRTemp.MRType = MR.Type.Material;
if (objMRTemp.MRType == MR.Type.Material)
{
bindItemList.DataSource = objMRMaterialDL.Get(objMRTemp.MRNO);
}
if (objMRTemp.MRType == MR.Type.BasicProduct)
{
bindItemList.DataSource = objMRBasicProduct_DL.Get(objMRTemp.MRNO);
}
if (objMRTemp.MRType == MR.Type.FinishProduct)
{
bindItemList.DataSource = objMRFinishProductDL.Get(objMRTemp.MRNO);
}
txtapprovedBy.Text = objMR.MRApprovedBy;
txtApprovedDate.Text = objMR.MRApprovedDate.ToShortDateString();
txtDate.Text = objMR.MRDate.ToShortDateString();
txtDepartment.Text = objMR.MRDepartmentFrom.DepName;
txtMRNO.Text = objMR.MRNO.ToString();
txtRemarks.Text = objMR.MRRemarks;
txtRequestedBy.Text = objMR.MREnterdBy;
txtRequestedDate.Text = objMR.MRDate.ToShortDateString();
ItemSelect = true;
if (objMR.Print == true)
{
btnPrint.Enabled = false;
}
else
{
btnPrint.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if ((txtFinalQty.Text != "") && (txtSampleSize.Text != "") && (txtImpurities.Text != ""))
{
try
{
if (objQCReport_DL.IsPRPDBatchAccept(objPRPDBatch.PRPDBatchID, (int)QCReport.ReportStatus.Accept))
{
if (txtComments.Text == "")
{
objPRPDBatch.PRPDBatchComments = "N/A";
}
else
{
objPRPDBatch.PRPDBatchComments = txtComments.Text;
}
if (objPRPDBatch.Type == PRPDBatch.PRPDType.PrimaryOutsource)
{
objPRPDBatch.OutSourceQty = Convert.ToDecimal(txtOutsourceQty.Text);
}
else
{
objPRPDBatch.OutSourceQty = 0;
}
objPRPDBatch.PRPDBatchEndDate = dtpDateHandOver.Value;
objPRPDBatch.PRPDBatchFinalQty = Convert.ToDecimal(txtFinalQty.Text);
objPRPDBatch.PRPDBatchEndBy = CurrentUser.UserEmp;
objPRPDBatch.PRPDBatchTotalImpurities = Convert.ToDecimal(txtImpurities.Text);
objPRPDBatch.PRPDSampleSize = txtSampleSize.Text;
objPRPDBatch.Status = PRPDBatch.PRPDBatchStatus.Finished;
MRMaterial objMRMaterial = new MRMaterial();
MRMaterial_DL objMRMaterial_DL = new MRMaterial_DL(ConnectionStringClass.GetConnection());
objMRMaterial = objMRMaterial_DL.Get(objPRPDBatch.MRIN, objPRPDBatch.PRPDBatchMaterial.MaterialCode);
if ((objPRPDBatch.PRPDBatchFinalQty > 0) && (objMRMaterial.IssuedQty >= objPRPDBatch.PRPDBatchFinalQty))
{
if (objPRPDBatch.Type == PRPDBatch.PRPDType.PrimaryOutsource)
{
if (objPRPDBatch.OutSourceQty > 0)
{
Decimal sampleQty = Convert.ToDecimal(objPRPDBatch.PRPDSampleSize);
objPRPDBatch_DL.Update_Finish(objPRPDBatch);
//Update Batch Cost
objPRPDBatch_DL.Update_BatchCost(objPRPDBatch.PRPDBatchID, CurrentUser.EmployeeID, (int)objPRPDBatch.Type);
Load_Batches(objDepartment);
MessageBox.Show(this, "Successfully Saved and the Batch File is sent for Costing Approval", "Save Records", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (cmbPRPDBatchID.Items.Count <= 0)
{
MessageBox.Show(this, "Approved Batch file list Empty", "No Approved Batch Files", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
cmbPRPDBatchID_SelectedIndexChanged(sender, e);
grpFinalizeDetails.Enabled = false;
}
}
else
{
MessageBox.Show(this, "Outsource Qty Need to be greater than Zero", "Invalid Qty", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
Decimal sampleQty = Convert.ToDecimal(objPRPDBatch.PRPDSampleSize);
objPRPDBatch_DL.Update_Finish(objPRPDBatch);
//Update Batch Cost
objPRPDBatch_DL.Update_BatchCost(objPRPDBatch.PRPDBatchID, CurrentUser.EmployeeID, (int)objPRPDBatch.Type);
Load_Batches(objDepartment);
MessageBox.Show(this, "Successfully Saved and the Batch File is sent for Costing Approval", "Save Records", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (cmbPRPDBatchID.Items.Count <= 0)
{
MessageBox.Show(this, "Approved Batch file list Empty", "No Approved Batch Files", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
cmbPRPDBatchID_SelectedIndexChanged(sender, e);
grpFinalizeDetails.Enabled = false;
}
}
}
else
{
MessageBox.Show(this, "Invalid Final Quantity", "Invalid Value", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show(this, "PRPD Batch Quality test incomplete", "Quality Test", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Error occured while finalizing", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show(this, "Please Fill All Fields", "Fill Records", MessageBoxButtons.OK);
}
}
private void cmbPRPDBatchID_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbPRPDBatchID.Items.Count != 0)
{
try
{
bool IsStart = false;
objPRPDBatch = objPRPDBatch_DL.Get(cmbPRPDBatchID.SelectedValue.ToString());
gvActivity.AutoGenerateColumns = false;
bindActivities.DataSource = objPRPDBatchActivity_DL.GetView(objPRPDBatch.PRPDBatchID);
gvActivity.DataSource = bindActivities;
bindActivities.ResetBindings(true);
txtMaterial.Text = objPRPDBatch.PRPDBatchMaterial.MaterialCode + " - " + objPRPDBatch.PRPDBatchMaterial.MaterialDescription;
MR obj = new MR();
obj = objMR_DL.Get(objPRPDBatch.MRIN);
if (obj.MRStatus == MR.Status.Recevied)
{
IsStart = true;
}
MRMaterial_DL objMRMaterialDL = new MRMaterial_DL(ConnectionStringClass.GetConnection());
MRMaterial objMRMat = objMRMaterialDL.Get(objPRPDBatch.MRIN, objPRPDBatch.PRPDBatchMaterial.MaterialCode);
if (objMRMat.IssuedQty <= 0)
{
IsStart = false;
}
if (objPRPDBatch.Type == PRPDBatch.PRPDType.Rework)
{
lblTitle.Text = "Rework - " + objPRPDBatch.PRPDBatchID;
txtNote.Text = obj.MRNO.ToString() + " - " + obj.MRStatus.ToString();
txtReceivedQty.Text = objMRMaterialDL.Get(obj.MRNO, objPRPDBatch.PRPDBatchMaterial.MaterialCode).IssuedQty.ToString();
lblNote.Text = "MRNO";
lblUnit4.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
}
else if (objPRPDBatch.Type == PRPDBatch.PRPDType.PrimaryOutsource)
{
lblTitle.Text = "Primary Outsource - " + objPRPDBatch.PRPDBatchID;
txtNote.Text = obj.MRNO.ToString() + " - " + obj.MRStatus.ToString();
txtReceivedQty.Text = objMRMaterialDL.Get(obj.MRNO, objPRPDBatch.PRPDBatchMaterial.MaterialCode).IssuedQty.ToString();
lblNote.Text = "MRNO";
lblUnit4.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
}
else if (objPRPDBatch.Type == PRPDBatch.PRPDType.PrimaryPreperation)
{
lblTitle.Text = "Preperation - " + objPRPDBatch.PRPDBatchID;
txtNote.Text = obj.MRNO.ToString() + " - " + obj.MRStatus.ToString();
txtReceivedQty.Text = objMRMaterialDL.Get(obj.MRNO, objPRPDBatch.PRPDBatchMaterial.MaterialCode).IssuedQty.ToString();
lblNote.Text = "MRNO";
lblUnit4.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
}
if (IsStart)
{
btnStartBatch.Enabled = true;
tbcPRPDBatchProduction.Enabled = true;
if (objPRPDBatch.Status == PRPDBatch.PRPDBatchStatus.Started)
{
tbcPRPDBatchProduction.Enabled = true;
btnStartBatch.Enabled = false;
cmbSupervisedBy.Enabled = false;
}
else if (objPRPDBatch.Status == PRPDBatch.PRPDBatchStatus.Approved)
{
tbcPRPDBatchProduction.Enabled = false;
btnStartBatch.Enabled = true;
}
}
else
{
btnStartBatch.Enabled = false;
tbcPRPDBatchProduction.Enabled = false;
}
dtMainActtivity_PRPD = objMainActivity_DL.Get_Data_PRPD_Activity(objPRPDBatch.PRPDBatchID);
cmbActivity.DataSource = dtMainActtivity_PRPD;
if (dtMainActtivity_PRPD.Rows.Count != 0)
{
cmbActivity.SelectedIndex = 0;
}
objPRPDBatch = objPRPDBatch_DL.Get(cmbPRPDBatchID.SelectedValue.ToString());
txtMaterial.Text = objPRPDBatch.PRPDBatchMaterial.MaterialCode + " - " + objPRPDBatch.PRPDBatchMaterial.MaterialDescription;
txtInstructedBy.Text = objPRPDBatch.PRPDBatchInstructedBy.EmployeeName;
txtQuantity.Text = objPRPDBatch.PRPDBatchQty.ToString();
dtpCreatedDate.Value = objPRPDBatch.PRPDBatchInstructedDate;
//Load Instructions
dtPRPDBatchActivityInstructions = objPRPDBatchActivityInstructions_DL.GetDataByBatchID(cmbPRPDBatchID.SelectedValue.ToString());
objSourceActInstructions.DataSource = dtPRPDBatchActivityInstructions;
dgvActivityInstructions.AutoGenerateColumns = false;
dgvActivityInstructions.DataSource = objSourceActInstructions;
objSourceActInstructions.ResetBindings(true);
txtBatchState.Text = Enum.GetName(typeof(PRPDBatch.PRPDBatchStatus), objPRPDBatch.Status).ToString();
lblUnit.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
bindReports.DataSource = objQCReport_DL.GetView_PRPD(objPRPDBatch.PRPDBatchID);
if (objQCReport_DL.IsPRPDBatchAccept(objPRPDBatch.PRPDBatchID, (int)QCReport.ReportStatus.Accept))
{
grpFinalizeDetails.Enabled = true;
}
else
{
grpFinalizeDetails.Enabled = false;
}
lblUnit1.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
lblUnit2.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
lblUnit3.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
lblUnitSample.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
txtOutsourceQty.Text = "0";
//Load Reports
Load_Reports();
}
catch (Exception ex)
{
MessageBox.Show(this, "Error occured while loading", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void cmbPRPDBatch_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbPRPDBatch.SelectedValue != null)
{
try
{
objPRPDBatch = objPRPDBatch_DL.Get(cmbPRPDBatch.SelectedValue.ToString());
dtPRPDBatchActivity = objPRPDBatchActivityInstructions_DL.GetDataByBatchID(cmbPRPDBatch.SelectedValue.ToString());
dgvActivities.AutoGenerateColumns = false;
dgvActivities.DataSource = objSourcePRPDBatchActivity;
objSourcePRPDBatchActivity.DataSource = dtPRPDBatchActivity;
objSourcePRPDBatchActivity.ResetBindings(true);
txtAddedUnitCost.Text = objPRPDBatch_DL.UnitPrice(objPRPDBatch.PRPDBatchID).ToString();
txtBatchState.Text = Enum.GetName(typeof(PRPDBatch.PRPDBatchStatus), objPRPDBatch.Status);
txtMRNo.Text = objPRPDBatch.MRIN.ToString();
txtUnitPrice.Text = objMRMaterial_DL.Get(objPRPDBatch.MRIN, objPRPDBatch.PRPDBatchMaterial.MaterialCode).UniRate.ToString();
txtMaterialCode.Text = objPRPDBatch.PRPDBatchMaterial.MaterialCode;
txtMaterialName.Text = objPRPDBatch.PRPDBatchMaterial.MaterialNameCode;
txtStartDate.Text = objPRPDBatch.PRPDBatchInstructedDate.ToShortDateString();
txtStopDate.Text = objPRPDBatch.PRPDBatchEndDate.ToShortDateString();
txtPRPDBatchQty.Text = objPRPDBatch.PRPDBatchFinalQty.ToString();
txtInstructedBy.Text = objPRPDBatch.PRPDBatchInstructedBy.EmployeeName;
txtAfterReworkQty.Text = objPRPDBatch.PRPDBatchFinalQty.ToString();
txtDescription.Text = objPRPDBatch.PRPDBatchComments;
lblUnit.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
lblUnit1.Text = objPRPDBatch.PRPDBatchMaterial.MatUnit.UnitCode;
if (objPRPDBatch.Type == PRPDBatch.PRPDType.Rework)
{
objProcessed = objMaterial_DL.GetDryMaterial(objPRPDBatch.PRPDBatchMaterial.MaterialCode);
txtMaterial.Text = objProcessed.MaterialCode + " - " + objProcessed.MaterialDescription;
}
else
{
objProcessed = objMaterial_DL.GetProcessdMaterial(objPRPDBatch.PRPDBatchMaterial.MaterialCode);
txtMaterial.Text = objProcessed.MaterialCode + " - " + objProcessed.MaterialDescription;
}
if (objProcessed.MaterialCode == null)
{
btnTransfer.Enabled = false;
}
else
{
btnTransfer.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}