private void btnAdd_Click(object sender, EventArgs e) { try { if (cmbActivity.SelectedValue == null) { MessageBox.Show(this, "Please Fill All Fields", "Fill Records", MessageBoxButtons.OK); } else { PRPDBatchActivityInstructions obj = new PRPDBatchActivityInstructions(); obj.Activity = objMainActivity_DL.Get(Convert.ToInt64(cmbActivity.SelectedValue)); if (cmbMachine.SelectedValue != null) { obj.Machine = objMachine_DL.Get(cmbMachine.SelectedValue.ToString()); obj.MachineCode = obj.Machine.MachineCode; } else { obj.MachineCode = "No Machine"; } obj.ParticleSize = "N/A"; if (txtInstruction.Text != "") { obj.InstructionDesc = txtInstruction.Text; } else { obj.InstructionDesc = "No"; } obj.PRPDBatch = objPRPDBatch_DL.Get(txtPRPDBatch.Text); objPRPDBatchActivityInstructions_DL.Add(obj); dtPRPDBatchInstructions = objPRPDBatchActivityInstructions_DL.GetDataByBatchID(txtPRPDBatch.Text); dgvActivityInstructions.AutoGenerateColumns = false; dgvActivityInstructions.DataSource = objSourceInstructions; objSourceInstructions.DataSource = dtPRPDBatchInstructions; objSourceInstructions.ResetBindings(true); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void btnGRN_Click(object sender, EventArgs e) { try { objMTN = objMTNDL.Get(objMTN.MTNNo); if (objMTN.MTNStatus == MTN.Status.Cost) { if ((objMTN != null) && (objStore != null)) { if (objMTN.MTNItemType == MTN.ItemType.Material) { PRPDBatch_DL objPRPDBatch_DL = new PRPDBatch_DL(ConnectionStringClass.GetConnection()); PRPDBatch objPRPDBatch = objPRPDBatch_DL.Get(gvMTNList.CurrentRow.Cells["BatchID"].Value.ToString()); if (objPRPDBatch.Type == PRPDBatch.PRPDType.Rework) { objStore = objStoreDL.Get("RM_Main"); long GRNNO = objMTNDL.AddGRN(objMTN.MTNNo, MTN.Status.ReceviedGRN, CurrentUser.EmployeeID, objStore.StoreID, GRN.Type.Material, GRN.Status.Initial); MessageBox.Show(this, "Successfully Raised a GRN. The GRNNO is : " + GRNNO.ToString(), "Successful", MessageBoxButtons.OK); } else { long GRNNO = objMTNDL.AddGRN(objMTN.MTNNo, MTN.Status.ReceviedGRN, CurrentUser.EmployeeID, objStore.StoreID, GRN.Type.Material, GRN.Status.Initial); MessageBox.Show(this, "Successfully Raised a GRN. The GRNNO is : " + GRNNO.ToString(), "Successful", MessageBoxButtons.OK); } } else if (objMTN.MTNItemType == MTN.ItemType.Basic_Product) { long GRNNO = objMTNDL.AddGRN(objMTN.MTNNo, MTN.Status.ReceviedGRN, CurrentUser.EmployeeID, objStore.StoreID, GRN.Type.BasicProduct, GRN.Status.Initial); MessageBox.Show(this, "Successfully Raised a GRN. The GRNNO is : " + GRNNO.ToString(), "Successful", MessageBoxButtons.OK); } else if (objMTN.MTNItemType == MTN.ItemType.Finish_Product) { long GRNNO = objMTNDL.AddGRN(objMTN.MTNNo, MTN.Status.ReceviedGRN, CurrentUser.EmployeeID, objStore.StoreID, GRN.Type.FinishProduct, GRN.Status.Initial); MessageBox.Show(this, "Successfully Raised a GRN. The GRNNO is : " + GRNNO.ToString(), "Successful", MessageBoxButtons.OK); } bindMTNList.DataSource = objMTNDL.Get_From_PRPD_Batches(Convert.ToInt64(MTN.Type.PRPD), Convert.ToInt32(MTN.Status.Cost)); if (gvMTNList.Rows.Count > 0) { DataGridViewCellEventArgs dr = new DataGridViewCellEventArgs(1, 0); gvMTNList_CellClick(sender, dr); } else { bindItemList.DataSource = null; } } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void dgvPRPDbatchByState_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { try { PRPDBatch obj = objPRPDBatch_DL.Get(dgvPRPDbatchByState.Rows[e.RowIndex].Cells["PRPDBatchID"].Value.ToString()); frmRptPRPDBatchCost objFrm = new frmRptPRPDBatchCost(CurrentUser, obj.PRPDBatchID); objFrm.ShowDialog(this); Load_Batch_List(); } catch (Exception) { MessageBox.Show(this, "Error occurred while loading PRPD Batch details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
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()); } } }
private void frmQC_Load(object sender, EventArgs e) { try { if (objQCReport != null) { cmbTestBy.DataSource = objEmployee_DL.Get_By_DepType("LAB", true); cmbRDQAOfficer.DataSource = objEmployee_DL.Get_By_DepType("LAB", true); cmbAnalizedBy.DataSource = objEmployee_DL.Get_By_DepType("LAB", true); cmbParameter.DataSource = objTestParameter_DL.GetView(objQCReport.ReportType); bindDetails.DataSource = objQCReportDetails_DL.GetView(objQCReport.QCReportID); if (objQCReport.ReportType.Equals("RPD")) { txtBatch.Text = objQCReport.RPDBatchID; objRPDBatch = objRPDBatch_DL.Get(objQCReport.RPDBatchID); cmbMaterial.DataSource = objMaterial_DL.GetDataViewIntermediates(objRPDBatch.RPDBatchMaterial.MaterialCode); //cmbMaterial.DataSource = objMaterial_DL.Get_RPD_DataView(objQCReport.RPDBatchID); txtBatch.Text = objRPDBatch.RPDBatchID; } else if (objQCReport.ReportType.Equals("PRPD")) { txtBatch.Text = objQCReport.RPDBatchID; objPRPDBatch = objPRPDBatch_DL.Get(objQCReport.PRPDBatchID); cmbMaterial.DataSource = objMaterial_DL.GetDataViewIntermediates(objPRPDBatch.PRPDBatchMaterial.MaterialCode); txtBatch.Text = objPRPDBatch.PRPDBatchID; } else if (objQCReport.ReportType.Equals("PRODUCTION")) { txtBatch.Text = objQCReport.ProductionBatchID; objBatch = objBatch_DL.Get(objQCReport.ProductionBatchID); //cmbMaterial.DataSource = objMaterial_DL.GetDataViewIntermediates("", "", objPRPDBatch.PRPDBatchMaterial.MaterialCode); lblItem.Text = "Product"; BasicProductCollec objCollec = new BasicProductCollec(); objCollec.Add(objBatch.StandardBatch.STDBatchBasicProduct); cmbMaterial.DataSource = objCollec; cmbMaterial.DisplayMember = "Code"; cmbMaterial.ValueMember = "BasicProductCode"; } txtReportID.Text = objQCReport.QCReportID.ToString(); txtReportType.Text = objQCReport.ReportType; txtSampleSize.Text = objQCReport.SampleSize; txtSendBy.Text = objEmployee_DL.Get(objQCReport.SendBy).EmployeeNameID; txtSendDate.Text = objQCReport.SendDate.Value.ToShortDateString(); if (objQCReport.RDQAOfficer != null) { cmbRDQAOfficer.SelectedValue = objQCReport.RDQAOfficer; } if (objQCReport.AnalyzedBy != null) { cmbAnalizedBy.SelectedValue = objQCReport.AnalyzedBy; } if (objQCReport.TestBy != null) { cmbTestBy.SelectedValue = objQCReport.TestBy; } txtRemarks.Text = objQCReport.Remarks; if (objQCReport.Status != Convert.ToInt32(QCReport.ReportStatus.Initial)) { grpDetails.Enabled = false; } } } catch (Exception) { MessageBox.Show(this, "Error occured while loading", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }