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;
}
