private void cmbMRNO_SelectedIndexChanged(object sender, EventArgs e) { try { BatchPackingMR obj = new BatchPackingMR(); MRMaterial objMRMaterial = new MRMaterial(); Material objMaterial = new Material(); obj = objBatchPackingMR_DL.Get(Convert.ToInt64(cmbMRNO.SelectedValue)); objMaterial = objMaterial_DL.Get(obj.MaterialCode); lblUnit1.Text = objMaterial.MatUnit.UnitCode; lblUnit2.Text = objMaterial.MatUnit.UnitCode; lblUnit3.Text = objMaterial.MatUnit.UnitCode; txtQunatityReceived.Text = obj.StartQty.ToString(); // txtDamagedQty.Text = obj.BatchDamaged.ToString(); // txtBatchReturned.Text = obj.BatchReturned.ToString(); // txtBatchUsed.Text = obj.BatchUsed.ToString(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void gvItemList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex >= 0) { if (cmbMRType.SelectedItem.Equals("Material")) { objMRMaterial = (MRMaterial)gvItemList.Rows[e.RowIndex].DataBoundItem; txtDescription.Text = objMRMaterial.Description; txtQty.Text = objMRMaterial.ReqdQty.ToString(); cmbItem.SelectedValue = objMRMaterial.Material.MaterialCode; } else if (cmbMRType.SelectedItem.Equals("Basic Products")) { objMRBasicProduct = (MRBasicProduct)gvItemList.Rows[e.RowIndex].DataBoundItem; txtDescription.Text = objMRBasicProduct.Description; txtQty.Text = objMRBasicProduct.ReqdQty.ToString(); cmbItem.SelectedValue = objMRBasicProduct.BasicProduct.BasicProductCode; } else if (cmbMRType.SelectedItem.Equals("Finish Products")) { objMRFinishProduct = (MRFinishProduct)gvItemList.Rows[e.RowIndex].DataBoundItem; txtDescription.Text = objMRFinishProduct.Description; txtQty.Text = objMRFinishProduct.ReqdQty.ToString(); cmbItem.SelectedItem = objMRFinishProduct.FinishProduct.FinishProductCode; } ItemSelect = true; } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public MRMaterialCollec Get(long MRNO) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", MRNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRMaterial_By_MR", paramList); MRMaterialCollec objMRMaterialCollec = new MRMaterialCollec(); for (int i = 0; i < dt.Rows.Count; i++) { MRMaterial objMRMaterial = new MRMaterial(); if (dt.Rows[i]["MRDescription"] != null) { objMRMaterial.Description = Convert.ToString(dt.Rows[i]["MRDescription"]); } if (dt.Rows[i]["MRMaterialCode"] != null) { objMRMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["MRMaterialCode"])); } if (dt.Rows[i]["MRNO"] != null) { objMRMaterial.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRNO"])); } objMRMaterial.MRBINNo = Convert.ToString(dt.Rows[i]["MRBINNo"]); objMRMaterial.ReqdQty = Convert.ToDecimal(dt.Rows[i]["MRReqdQty"]); objMRMaterial.IssuedQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]); if (dt.Rows[i]["MRUnitRate"] != null) { objMRMaterial.UniRate = Convert.ToDecimal(dt.Rows[i]["MRUnitRate"]); } else { objMRMaterial.UniRate = 0; } objMRMaterial.Item = objMRMaterial.Material.MaterialCode + " - " + objMRMaterial.Material.MaterialDescription; objMRMaterial.UnitCode = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["MRMaterialCode"])).MatUnit.UnitCode; objMRMaterialCollec.Add(objMRMaterial); } return(objMRMaterialCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long GenerateMR(PRPDBatch objPRPD) { MR objMR = new MR(); MRMaterialCollec objMRMatCollec = new MRMaterialCollec(); MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec(); MRBasicProductCollec objMRBasicProductCollec = new MRBasicProductCollec(); BatchMR objBatchMR = new BatchMR(); Department_DL objDepDL = new Department_DL(ConnectionStringClass.GetConnection()); MR_DL objMRDL = new MR_DL(ConnectionStringClass.GetConnection()); MRMaterial_DL objMRMaterialDL = new MRMaterial_DL(ConnectionStringClass.GetConnection()); Store_DL objStoreDL = new Store_DL(ConnectionStringClass.GetConnection()); try { objMR.MRDate = DateTime.Now; objMR.MRDepartmentFrom = objDepDL.GetByDepType("PRPD"); objMR.MREnterdBy = CurrentUser.EmployeeID; objMR.MRStatus = MR.Status.Initial; objMR.MRStore = objStore; objMR.MRType = MR.Type.Material; objMR.MRRemarks = "Material Requition(Materials) for PRPD Batch NO " + objPRPD.PRPDBatchID.ToString(); objMR.OriginType = MR.Origin.ToBatch; MRMaterial obj = new MRMaterial(); obj.Description = "PRPD Batch Material Requition"; obj.Material = objPRPD.PRPDBatchMaterial; obj.MRBINNo = ""; obj.ReqdQty = objPRPD.PRPDBatchQty; long MRNO = objMRDL.Add_M(objMR); if (MRNO > 0) { objMR.MRNO = MRNO; obj.MR = objMR; objMRMaterialDL.Add(obj); } return(MRNO); } catch (Exception ex) { return(0); } }
public int Issue(MRMaterial obj, String StoreID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", obj.MR.MRNO), new SqlParameter("@MRMaterialCode", obj.Material.MaterialCode), new SqlParameter("@MRIssuedQty", obj.IssuedQty), new SqlParameter("@StoreID", StoreID) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MRMaterial_Issue", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void gvItemList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex >= 0) { objMRMaterial = (MRMaterial)gvItemList.Rows[e.RowIndex].DataBoundItem; txtDescription.Text = objMRMaterial.Description; txtQty.Text = objMRMaterial.ReqdQty.ToString(); cmbItem.SelectedValue = objMRMaterial.Material.MaterialCode; ItemSelect = true; } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public MRMaterial Get(long MRNO, String MaterialCode) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", MRNO), new SqlParameter("@MaterialCode", MaterialCode) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRMaterialByID", paramList); MRMaterial objMRMaterial = new MRMaterial(); if (dt.Rows.Count > 0) { if (dt.Rows[0]["MRDescription"] != null) { objMRMaterial.Description = Convert.ToString(dt.Rows[0]["MRDescription"]); } objMRMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[0]["MRMaterialCode"])); objMRMaterial.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[0]["MRNO"])); objMRMaterial.MRBINNo = Convert.ToString(dt.Rows[0]["MRBINNo"]); objMRMaterial.ReqdQty = Convert.ToDecimal(dt.Rows[0]["MRReqdQty"]); objMRMaterial.IssuedQty = Convert.ToDecimal(dt.Rows[0]["MRIssuedQty"]); if (dt.Rows[0]["MRUnitRate"] != DBNull.Value) { objMRMaterial.UniRate = Convert.ToDecimal(dt.Rows[0]["MRUnitRate"]); } else { objMRMaterial.UniRate = 0; } } return(objMRMaterial); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(MRMaterial obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", obj.MR.MRNO), new SqlParameter("@MRMaterialCode", obj.Material.MaterialCode), new SqlParameter("@MRDescription", obj.Description), new SqlParameter("@MRReqdQty", obj.ReqdQty), new SqlParameter("@MRIssuedQty", obj.IssuedQty), new SqlParameter("@MRBINNo", obj.MRBINNo) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_MRMaterial", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update(MRMaterial obj, long OriginalMRNO, String OriginalMaterialCode) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", obj.MR.MRNO), new SqlParameter("@MRMaterialCode", obj.Material.MaterialCode), new SqlParameter("@MRDescription", obj.Description), new SqlParameter("@MRReqdQty", obj.ReqdQty), new SqlParameter("@MRIssuedQty", obj.IssuedQty), new SqlParameter("@MRBINNo", obj.MRBINNo), new SqlParameter("@Original_MRNO", OriginalMRNO), new SqlParameter("@Original_MRFinishMaterialCode", OriginalMaterialCode) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MRMaterial", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void btnAdd_Click(object sender, EventArgs e) { if (rdbMaterial.Checked == true) { MRMaterial obj = new MRMaterial(); bool duplicate = false; obj.Material = objMaterialDL.Get(dgvItemList.CurrentRow.Cells["ItemCode"].Value.ToString()); obj.ReqdQty = Convert.ToDecimal(dgvItemList.CurrentRow.Cells["ReqQty"].Value); obj.IssuedQty = 0; obj.Description = "Batch Material Requisition"; obj.MRBINNo = "N/A"; obj.MaterialCode = obj.Material.MaterialCode; obj.MaterialName = obj.Material.MaterialDescription; foreach (MRMaterial _obj in objMRMaterialCollec) { if (_obj.MaterialCode == obj.MaterialCode) { duplicate = true; break; } } for (int i = 0; i < dgvItemRequested.Rows.Count; i++) { if (dgvItemRequested.Rows[i].Cells["MaterialCode"].Value.ToString() == obj.MaterialCode) { duplicate = true; break; } } if (duplicate == false) { objMRMaterialCollec.Add(obj); } dgvItem_toRequest.AutoGenerateColumns = false; objSourceItems_toRequest.DataSource = objMRMaterialCollec; dgvItem_toRequest.DataSource = objSourceItems_toRequest; objSourceItems_toRequest.ResetBindings(true); } else { MRBasicProduct obj = new MRBasicProduct(); obj.BasicProduct = objBasicProductDL.Get(dgvItemList.CurrentRow.Cells["ItemCode"].Value.ToString()); obj.ReqdQty = Convert.ToDecimal(dgvItemList.CurrentRow.Cells["ReqQty"].Value); obj.ItemCode = obj.BasicProduct.BasicProductCode; obj.Item = obj.BasicProduct.BasicProductDescription; obj.Description = "No"; obj.MRBINNo = "No"; objMRBasicProductCollec.Add(obj); dgvItem_toRequest_BP.AutoGenerateColumns = false; objSourceItems_toRequest.DataSource = objMRBasicProductCollec; dgvItem_toRequest_BP.DataSource = objSourceItems_toRequest; objSourceItems_toRequest.ResetBindings(true); } }
private void btnItemAdd_Click(object sender, EventArgs e) { if (txtQty.Text.Equals("")) { MessageBox.Show(this, "Please fill the quantity field", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { bool ItemList = false; MRMaterial objMRMat = new MRMaterial(); try { if (ItemSelect) { objMRMat.Description = txtDescription.Text; objMRMat.Material = objMaterialDL.Get(cmbItem.SelectedValue.ToString()); objMRMat.ReqdQty = Convert.ToDecimal(txtQty.Text); objMRMat.MRBINNo = "N/A"; objMRMat.Item = objMRMat.Material.MaterialCode + " - " + objMRMat.Material.MaterialDescription; objMRMat.UnitCode = objMRMat.Material.MatUnit.UnitCode; if (objMRMaterial.Material.MaterialCode != objMRMat.Material.MaterialCode) { foreach (MRMaterial obj in objMRMaterialCollec) { if (obj.Material.MaterialCode == objMRMat.Material.MaterialCode) { MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemList = true; break; } } if (!ItemList) { objMRMaterialCollec.Delete(objMRMaterial); objMRMaterialCollec.Add(objMRMat); ClearItem(); } } else { objMRMaterialCollec.Delete(objMRMaterial); objMRMaterialCollec.Add(objMRMat); ClearItem(); } bindItemList.DataSource = objMRMaterialCollec; bindItemList.ResetBindings(false); } else { objMRMat.Description = txtDescription.Text; objMRMat.Material = objMaterialDL.Get(cmbItem.SelectedValue.ToString()); objMRMat.ReqdQty = Convert.ToDecimal(txtQty.Text); objMRMat.Item = objMRMat.Material.MaterialCode + " - " + objMRMat.Material.MaterialDescription; objMRMat.UnitCode = objMRMat.Material.MatUnit.UnitCode; objMRMat.MRBINNo = "N/A"; if (objMRMaterialCollec.Count > 0) { foreach (MRMaterial obj in objMRMaterialCollec) { if (obj.Material.MaterialCode == objMRMat.Material.MaterialCode) { MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemList = true; break; } } if (!ItemList) { objMRMaterialCollec.Add(objMRMat); ClearItem(); } } else { objMRMaterialCollec.Add(objMRMat); ClearItem(); } bindItemList.DataSource = objMRMaterialCollec; bindItemList.ResetBindings(false); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objMRMat = null; } } }
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 button2_Click(object sender, EventArgs e) { try { DialogResult dresutl = MessageBox.Show(this, "Are you sure you want to Issue Items for selected Material Requsition?\n\nClick Yes to Issue", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dresutl == DialogResult.Yes) { if (cmbStore.Items.Count > 0) { Store objStore = (Store)cmbStore.SelectedItem; if (this.ItemSelect) { if (objMR.MRType == MR.Type.Material) { bool isZero = false; bool Transfer = true; int Stock = 0; int zerocount = 0; foreach (DataGridViewRow dr in gvItemList.Rows) { MRMaterial objMRMat = new MRMaterial(); objMRMat = (MRMaterial)dr.DataBoundItem; Stock = objMRMaterialDL.Get_StockByStore(objStore.StoreID, objMRMat.Material.MaterialCode, objMRMat.IssuedQty); if (Stock == 0 && objMRMat.IssuedQty != 0) { MessageBox.Show(this, objMRMat.Material.MaterialCode + " Stock is lower than Issued Quantity,Please enter lower quantity", "Stock is not Enough", MessageBoxButtons.OK, MessageBoxIcon.Information); Transfer = false; break; } if (objMRMat.IssuedQty == 0) { isZero = true; zerocount++; } } if (Transfer) { DialogResult drRes; if (zerocount >= gvItemList.Rows.Count) { MessageBox.Show(this, "Please enter a Issue Quantity", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (isZero) { drRes = MessageBox.Show(this, "One more items does not have a quantity, Do you want to continue\n\nClick Yes to continue", "Empty Quantities", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (drRes == DialogResult.Yes) { foreach (DataGridViewRow dr in gvItemList.Rows) { MRMaterial objMRMat = new MRMaterial(); objMRMat = (MRMaterial)dr.DataBoundItem; objMRMaterialDL.Issue(objMRMat, objStore.StoreID); } objMR.MRIssuedBy = CurrentUser.UserEmp.EmployeeID; objMR.MRStatus = MR.Status.Issued; int x = objMRDL.Update_Issue(objMR); if (x > 0) { bindItemList.DataSource = null; Clear(); if (objStore != null) { bindMRList.DataSource = objMRDL.GetDataView(objStore.StoreID, MR.Status.Approved); } } } } else { foreach (DataGridViewRow dr in gvItemList.Rows) { MRMaterial objMRMat = new MRMaterial(); objMRMat = (MRMaterial)dr.DataBoundItem; objMRMaterialDL.Issue(objMRMat, objStore.StoreID); } objMR.MRIssuedBy = CurrentUser.UserEmp.EmployeeID; objMR.MRStatus = MR.Status.Issued; int x = objMRDL.Update_Issue(objMR); if (x > 0) { bindItemList.DataSource = null; Clear(); if (objStore != null) { bindMRList.DataSource = objMRDL.GetDataView(objStore.StoreID, MR.Status.Approved); } } } } } } if (objMR.MRType == MR.Type.BasicProduct) { IssueSemiFinished(); } if (objMR.MRType == MR.Type.FinishProduct) { IssueFinishFinished(); } } else { MessageBox.Show(this, "Please Select a Material Requition", "Selection Empty", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show(this, "Stores list is empty", "Empty List", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }