public int Update_RPD(BatchPackingMR obj, MTN.Status MTNState, MTN.Type MTNType, MTN.ItemType MTNItemType, string EnteredBy) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchID", obj.BatchID), new SqlParameter("@BatchUsed", obj.BatchUsed), new SqlParameter("@BatchDamaged", obj.BatchDamaged), new SqlParameter("@BatchReturned", obj.BatchReturned), new SqlParameter("@State", obj.State), new SqlParameter("@MTNStatus", Convert.ToInt32(MTNState)), new SqlParameter("@MTNType", Convert.ToInt32(MTNType)), new SqlParameter("@MTNItemType", Convert.ToInt32(MTNItemType)), new SqlParameter("@EnteredBy", EnteredBy), new SqlParameter("@IssuedBy", Convert.ToInt32(MTNType)), new SqlParameter("@StartQty", obj.StartQty), new SqlParameter("@ID", obj.ID) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_BatchPackingMR_RPD", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
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 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); } }
private void cmbMRNO_SelectedIndexChanged(object sender, EventArgs e) { try { obj = objBatchPackingMR_DL.Get(Convert.ToInt64(cmbMRNO.SelectedValue)); 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 btnFinalize_Click(object sender, EventArgs e) { try { BatchPackingMR obj = new BatchPackingMR(); obj = objBatchPackingMR_DL.Get(Convert.ToInt64(cmbMRNO.SelectedValue)); 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; objBatchPackingMR_DL.Update_RPD(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(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public String Add(BatchPackingMR obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@BatchNo", obj.BatchID), new SqlParameter("@MRNO", obj.MRNO), new SqlParameter("@BatchUsed", obj.BatchUsed), new SqlParameter("@BatchDamaged", obj.BatchDamaged), new SqlParameter("@BatchReturned", obj.BatchReturned), new SqlParameter("@MRState", obj.State), new SqlParameter("@IssuedBy", obj.IssuedBy), new SqlParameter("@IssuedDate", obj.IssuedDate), new SqlParameter("@BulkPrint", obj.BulkPrint) }; return(Execute.RunSP_Output_String(Connection, "SPADD_BatchPackingMR", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public BatchPackingMR Get(long ID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@ID", ID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_BatchPackingMR_ByID", paramList); BatchPackingMR obj = new BatchPackingMR(); if (dt.Rows.Count != 0) { obj.BatchDamaged = Convert.ToDecimal(dt.Rows[0]["BatchDamaged"]); if (dt.Rows[0]["BatchNO"] != DBNull.Value) { obj.BatchID = Convert.ToString(dt.Rows[0]["BatchNO"]); } obj.BatchReturned = Convert.ToDecimal(dt.Rows[0]["BatchReturned"]); obj.BatchUsed = Convert.ToDecimal(dt.Rows[0]["BatchUsed"]); obj.ID = Convert.ToInt64(dt.Rows[0]["ID"]); obj.State = Convert.ToInt32(dt.Rows[0]["State"]); obj.MRNO = Convert.ToInt64(dt.Rows[0]["MRNO"]); obj.MaterialCode = Convert.ToString(dt.Rows[0]["MaterialCode"]); obj.StartQty = Convert.ToDecimal(dt.Rows[0]["StartQty"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }