private void dgvBatcList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dgvBatcList.Rows.Count > 0) { objBatch = objBatch_DL.Get(dgvBatcList.CurrentRow.Cells["BatchNo"].Value.ToString()); txtBatchID.Text = objBatch.BatchID; lblUnit.Text = objBatch.StandardBatch.STDBatchBasicProduct.BasicProductUnit.UnitCode; lblUnit1.Text = objBatch.StandardBatch.STDBatchBasicProduct.BasicProductUnit.UnitCode; objBatchActivity = objBatchActivity_DL.Get(objBatch.BatchID, objActivity.MainActID); DataTable dt = objFinishProduct_DL.GetBy_TypeandBasicProduct(objBatch.StandardBatch.STDBatchBasicProduct.BasicProductCode, true, "Primary"); objSourceFinishedProducts.DataSource = dt; cmbFinishedProduct.DataSource = objSourceFinishedProducts; Load_Activity(); } } catch (Exception) { MessageBox.Show(this, "Error occured while loading Batch List", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnFinishPacking_Click(object sender, EventArgs e) { try { DialogResult dr = MessageBox.Show(this, "Do you want to finish the Activity", "Confirmation", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); frmBatchActivity_Packing objForm = new frmBatchActivity_Packing(objBatchActivity); objForm.ShowDialog(this); if (dgvActivity.Rows.Count == 1) { objBatch_DL.Update_QCStatus(objBatch.BatchID, CurrentUser.EmployeeID, Batch.Status.Finished); Load_Batch_List(); } } Load_Activity(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
public long Add(BatchActivity objBatchActivity) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchActivity.BatchActID), new SqlParameter("@BatchID", objBatchActivity.Batch.BatchID), new SqlParameter("@ActID", objBatchActivity.MainActivity.MainActID), new SqlParameter("@BatchActStatus", Convert.ToInt32(objBatchActivity.BatchActStatus)), new SqlParameter("@SequenceNo", objBatchActivity.SequenceNo), new SqlParameter("@Part", objBatchActivity.Part), new SqlParameter("@ActType", objBatchActivity.ActType), new SqlParameter("@BlockNextActivity", objBatchActivity.BlockNextActivity), new SqlParameter("@ActMethod", objBatchActivity.ActMethod), new SqlParameter("@outParam", SqlDbType.Int) { Direction = ParameterDirection.Output } }; return(Execute.RunSP_Int(Connection, "SPADD_BatchActivity_Update", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e) { try { objBatch = objBatch_DL.Get(dgvActivity.CurrentRow.Cells["BatchID"].Value.ToString()); txtBatchID.Text = objBatch.BatchID; objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); Load_ProductList(); txtInputQty.Text = objBatchActivity.StartQty.ToString(); txtOutputQty.Text = objBatchActivity.StopQty.ToString(); cmbOutputCode.SelectedValue = objBatchActivity.EndProductCode; Load_BatchLabourDetails(); if (objBatchActivity.BatchActStatus == BatchActivity.Status.SecondaryPacking_Start) { btnFinishPacking.Enabled = true; } else if (objBatchActivity.BatchActStatus == BatchActivity.Status.SecondaryPacking_Finish) { btnFinishPacking.Enabled = false; } else { btnFinishPacking.Enabled = false; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgvActivity.CurrentRow.IsNewRow == false) { try { objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); objActivity = objMainActivity_DL.Get(Convert.ToInt64(dgvActivity.CurrentRow.Cells["MainActID"].Value)); txtActivity.Text = objActivity.MainActivityTitle; Load_Machine(); Load_employee(); Load_BatchLabourDetails(); Load_BatchMachineDetails(); } catch (Exception) { MessageBox.Show(this, "Error occured while loading Main Activity", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } Load_Machine_List(); Load_BatchLabourDetails(); Load_BatchMachineDetails(); }
private void btnFinishPacking_Click(object sender, EventArgs e) { try { DialogResult dr = MessageBox.Show(this, "Do you want to finish the Activity", "Confirmation", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { DataTable dtReports = objQCReport_DL.Get_IsPackingQCPass(objBatch.BatchID, Convert.ToInt32(QCReport.ReportStatus.Accept), "Packing_Secondary"); if (dtReports.Rows.Count > 0) { objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); frmBatchActivity_Packing objForm = new frmBatchActivity_Packing(objBatchActivity); objForm.ShowDialog(this); } else { MessageBox.Show(this, "Secondary QC Is Not Passed", "Wrong Attempt", MessageBoxButtons.OK); } } Load_SecondaryActivityList(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dgvActivity.CurrentRow != null) { objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); Load_BatchLabourDetails(); Load_BatchMachineDetails(); if (objBatchActivity.BatchActStatus == BatchActivity.Status.Initial) { btnFinishPacking.Enabled = true; btnStartPacking.Enabled = false; } else if (objBatchActivity.BatchActStatus == BatchActivity.Status.Start) { btnFinishPacking.Enabled = true; btnStartPacking.Enabled = false; } else { btnFinishPacking.Enabled = false; btnStartPacking.Enabled = false; } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void btnFinalize_Click(object sender, EventArgs e) { if (DataValidation.Is3DecimalPointNumber(txtDamagedQty.Text) && DataValidation.Is3DecimalPointNumber(txtBatchUsed.Text)) { try { BatchPackingMR obj = new BatchPackingMR(); BatchActivity objBatchActivity = new BatchActivity(); BatchActivity_DL objBatchActivity_DL = new BatchActivity_DL(ConnectionStringClass.GetConnection()); obj = objBatchPackingMR_DL.Get(Convert.ToInt64(cmbMRNO.SelectedValue)); objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(txtPackingBatch.Text)); if ((objBatchActivity.BatchActStatus == BatchActivity.Status.Finished) | (objBatchActivity.BatchActStatus == BatchActivity.Status.SecondaryPacking_Finish) | (objBatchActivity.BatchActStatus == BatchActivity.Status.Transferred)) { MessageBox.Show("Activity is Already Finished"); } else { if (obj.StartQty >= Convert.ToDecimal(txtDamagedQty.Text) + Convert.ToDecimal(txtBatchReturned.Text) + Convert.ToDecimal(txtBatchUsed.Text)) { obj.BatchID = BatchID; obj.BatchDamaged = Convert.ToDecimal(txtDamagedQty.Text); obj.BatchReturned = Convert.ToDecimal(txtBatchReturned.Text); obj.BatchUsed = Convert.ToDecimal(txtBatchUsed.Text); obj.State = 1; obj.BatchPackingID = Convert.ToInt64(txtPackingBatch.Text); objBatchPackingMR_DL.Update(obj, MTN.Status.Initial, MTN.Type.Reject, MTN.ItemType.Material, CurrentUser.EmployeeID); } else { MessageBox.Show("Invalid Qty"); } } Load_MRList(); cmbMRNO_SelectedIndexChanged(sender, e); txtBatchReturned.Text = ""; txtBatchUsed.Text = ""; txtDamagedQty.Text = ""; txtBatchUsed.Select(); loadSectionData(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { MessageBox.Show(this, "please enter valid quantity", "MRP System", MessageBoxButtons.OK); } }
public BatchActivity Get(string BatchID, long ActID) { BatchActivity objBatchActivity = new BatchActivity(); Batch_DL objBatch_DL = new Batch_DL(Connection); Employee_DL objEmployee_DL = new Employee_DL(Connection); MainActivity_DL objMainActivity_DL = new MainActivity_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@ActID", ActID), new SqlParameter("@BatchID", BatchID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_BatchActivity_By_Batch_Act", paramList); if (dt.Rows.Count != 0) { objBatchActivity.MainActivity = objMainActivity_DL.Get(Convert.ToInt64(dt.Rows[0]["ActID"])); objBatchActivity.BatchActID = Convert.ToInt64(dt.Rows[0]["BatchActID"]); objBatchActivity.Batch = objBatch_DL.Get(dt.Rows[0]["BatchID"].ToString()); objBatchActivity.BatchActStatus = (BatchActivity.Status)dt.Rows[0]["BatchActStatus"]; if (dt.Rows[0]["SequenceNo"] != DBNull.Value) { objBatchActivity.SequenceNo = Convert.ToInt32(dt.Rows[0]["SequenceNo"]); } objBatchActivity.Part = dt.Rows[0]["Part"].ToString(); objBatchActivity.LastEdited = Convert.ToDateTime(dt.Rows[0]["LastEdited"]); objBatchActivity.BlockNextActivity = Convert.ToBoolean(dt.Rows[0]["BlockNextActivity"]); objBatchActivity.ActMethod = Convert.ToString(dt.Rows[0]["ActMethod"]); if (dt.Rows[0]["StartQty"] != DBNull.Value) { objBatchActivity.StartQty = Convert.ToDecimal(dt.Rows[0]["StartQty"]); } if (dt.Rows[0]["StopQty"] != DBNull.Value) { objBatchActivity.StopQty = Convert.ToDecimal(dt.Rows[0]["StopQty"]); } if (dt.Rows[0]["SupervisedBy"] != DBNull.Value) { objBatchActivity.SupervisedBy = objEmployee_DL.Get(dt.Rows[0]["SupervisedBy"].ToString()); } } return(objBatchActivity); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void btnAdd_Click_1(object sender, EventArgs e) { BatchActivity obj = new BatchActivity(); objBatchActivity_DL.Add_Packing_Rework(BatchID, (int)BatchActivity.Status.Start, cmbStartProduct.SelectedValue.ToString(), cmbEndProduct.SelectedValue.ToString(), Convert.ToDecimal(txtStartQty.Text), CurrentUser.EmployeeID, "Normal"); Load_BatchActivity(); }
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e) { try { objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); Load_BatchLabourDetails(); Load_BatchMachineDetails(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void SetColors() { for (int i = 0; i < dgvActivity.Rows.Count; i++) { objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.Rows[i].Cells["BatchActID"].Value)); if (objBatchActivity.ActType == "Manufacturing") { dgvActivity.Rows[i].DefaultCellStyle.BackColor = Color.LightGreen; } else { dgvActivity.Rows[i].DefaultCellStyle.BackColor = Color.RosyBrown; } } }
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e) { try { FinishProduct objFinishProduct = new FinishProduct(); objFinishProduct = objFinishProduct_DL.Get(dgvActivityz.CurrentRow.Cells["PrimaryFinishProduct"].Value.ToString()); objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivityz.CurrentRow.Cells["BatchActID"].Value)); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
public long Update_Initial(BatchActivity objBatchActivity) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchActivity.BatchActID), new SqlParameter("@StartQty", objBatchActivity.StartQty), new SqlParameter("@EndProductCode", objBatchActivity.EndProductCode), }; return(Execute.RunSP_Int(Connection, "SPUPDATE_BatchActivity_Initial", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void dgvBatcList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dgvBatcList.Rows.Count > 0) { objBatch = objBatch_DL.Get(dgvBatcList.CurrentRow.Cells["BatchNo"].Value.ToString()); txtBatchID.Text = objBatch.BatchID; objBatchActivity = objBatchActivity_DL.Get(objBatch.BatchID, objActivity.MainActID); Load_Activity(); } } catch (Exception) { MessageBox.Show(this, "Error occured while loading Batch List", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public long Update(BatchActivity objBatchActivity) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchActID", objBatchActivity.BatchActID), new SqlParameter("@StopQty", objBatchActivity.StopQty), new SqlParameter("@BatchActStatus", Convert.ToInt32(objBatchActivity.BatchActStatus)), new SqlParameter("@ActMethod", objBatchActivity.ActMethod), }; return(Execute.RunSP_Int(Connection, "SPUPDATE_BatchActivity", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void dgvBatcList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dt.Rows.Count > 0) { if (dgvBatcList.CurrentRow.IsNewRow == false) { objBatch = objBatch_DL.Get(dgvBatcList.CurrentRow.Cells["BatchNo"].Value.ToString()); objBatchActivity = objBatchActivity_DL.Get(objBatch.BatchID, objMainAct.MainActID); if (objBatchActivity.BatchActID != 0) { } else { objBatchActivity = new BatchActivity(); objBatchActivity.Batch = objBatch; objBatchActivity.BatchActStatus = BatchActivity.Status.Initial; objBatchActivity.BlockNextActivity = true; objBatchActivity.SequenceNo = -1; objBatchActivity.Part = "N/A"; objBatchActivity.MainActivity = objMainAct; objBatchActivity.LastEdited = DateTime.Now; objBatchActivity.ActType = "Manufacturing"; long ID = objBatchActivity_DL.Add(objBatchActivity); if (ID > 0) { objBatchActivity.BatchActID = ID; } } Load_LabourDetails(); Load_Formula(objBatch.BatchID, Part); } } } catch (Exception) { MessageBox.Show(this, "Error occured while loading", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void SetColors() { for (int i = 0; i < dgvActivity.Rows.Count; i++) { objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.Rows[i].Cells["BatchActID"].Value)); if (objBatchActivity.BatchActStatus == BatchActivity.Status.Finished) { dgvActivity.Rows[i].DefaultCellStyle.BackColor = Color.Green; } else if (objBatchActivity.BatchActStatus == BatchActivity.Status.Start) { dgvActivity.Rows[i].DefaultCellStyle.BackColor = Color.Yellow; } else { dgvActivity.Rows[i].DefaultCellStyle.BackColor = Color.White; } } }
private void btnFinishPacking_Click(object sender, EventArgs e) { try { DialogResult dr = MessageBox.Show(this, "Do you want to finish the Activity", "Confirmation", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); objBatchActivity.BatchActStatus = BatchActivity.Status.Finished; objBatchActivity_DL.Update(objBatchActivity); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void btnApprove_Click(object sender, EventArgs e) { try { MainActivity_DL objMainActivity_DL = new MainActivity_DL(ConnectionStringClass.GetConnection()); DialogResult dr = MessageBox.Show(this, "Do you want to Approve Selected Batch?\n\nClick Yes to Approve", "Are you sure?", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dr == DialogResult.Yes) { objBatch.BatchApprovedBy = CurrentUser.UserEmp; objBatch.BatchStatus = Batch.Status.Approved; int x = objBatchDL.Update_Approve(objBatch); if (x > 0) { BatchActivity objWeigh = new BatchActivity(); MainActivity objMainAct = objMainActivity_DL.GetByName("Weighing"); objWeigh.Batch = objBatch; objWeigh.BatchActStatus = BatchActivity.Status.Initial; objWeigh.BlockNextActivity = false; objWeigh.SequenceNo = -1; objWeigh.Part = "N/A"; objWeigh.MainActivity = objMainAct; objWeigh.LastEdited = DateTime.Now; objWeigh.ActType = "Manufacturing"; objWeigh.ActMethod = "Normal"; objBatchActivity_DL.Add(objWeigh); Clear(); LoadBatches(Batch.Status.Initial); objBatch = new Batch(); } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e) { try { FinishProduct objFinishProduct = new FinishProduct(); objFinishProduct = objFinishProduct_DL.Get(dgvActivity.CurrentRow.Cells["SecondaryFinishProduct"].Value.ToString()); objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); btnSendToStore.Enabled = true; txtProductCode.Text = objFinishProduct.FinishProductCode; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e) { try { FinishProduct objFinishProduct = new FinishProduct(); objFinishProduct = objFinishProduct_DL.Get(dgvActivity.CurrentRow.Cells["SecondaryFinishProduct"].Value.ToString()); objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); Load_BatchLabourDetails(); Load_BatchMachineDetails(); txtProductCode.Text = objFinishProduct.FinishProductCode; txtTransferQty.Text = objBatchActivity.StopQty.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void btnEditBatch_Click(object sender, EventArgs e) { if (DataValidation.Is3DecimalPointNumber(txtPackingQty.Text)) { try { BatchActivity objBatchActivity = new BatchActivity(); objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value)); //if (objBatchActivity.BatchActStatus == BatchActivity.Status.Start) //{ objBatchActivity.EndProductCode = cmbFinishedProduct.SelectedValue.ToString(); objBatchActivity.StartQty = Convert.ToDecimal(txtPackingQty.Text); objBatchActivity.StopQty = Convert.ToDecimal(txtOutputQty.Text); objBatchActivity_DL.Update_All(objBatchActivity); Load_Activity(); //} //else //{ // MessageBox.Show(this, "This Activity Can not be Edited", "Wrong Attempt", MessageBoxButtons.OK); //} } catch (Exception) { MessageBox.Show(this, "Error occured while loading Labour Details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show(this, "please enter valid Quantity Details", "MRP System", MessageBoxButtons.OK); } }
public frmBatchActivity(BatchActivity obj) { InitializeComponent(); objBatchActivity = obj; }
public frmMultipleLabour(BatchActivity obj, int _SectionID) { InitializeComponent(); objBatchActivity = obj; SectionID = _SectionID; }