private void dgvActivityInstructions_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { try { long ID = Convert.ToInt64(dgvActivityInstructions.Rows[e.RowIndex].Cells["ID"].Value); RPDBatchActivityInstructions obj = objRPDBatchActivityInstructionsDL.Get(ID); if (obj != null) { cmbActivityInstructions.SelectedValue = obj.Activity.MainActID; if (cmbMachine.Items.Count > 0) { cmbMachine.SelectedValue = obj.Machine.MachineCode; txtDescription.Text = obj.Description; txtParticleSize.Text = obj.ParticleSize; InstructionID = obj.ID; btnDeleteInstruction.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(this, "Error occured while loading", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
public RPDBatchActivityInstructions Get(long ID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@RPDBatchActivityInstructionsID", ID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_RPDBatchActivityInstructions_By_ID", paramList); RPDBatchActivityInstructions obj = new RPDBatchActivityInstructions(); if (dt.Rows.Count > 0) { obj.ID = Convert.ToInt64(dt.Rows[0]["RPDBatchActivityInstructionsID"]); obj.RPDBatch = objRPDBatch_DL.Get(Convert.ToString(dt.Rows[0]["BatchNo"])); obj.Activity = objMainActivity_DL.Get(Convert.ToInt64(dt.Rows[0]["ActivityID"])); obj.Machine = objMachine_DL.Get(Convert.ToString(dt.Rows[0]["MachineID"])); obj.ParticleSize = Convert.ToString(dt.Rows[0]["ParticleSize"]); obj.Description = Convert.ToString(dt.Rows[0]["InstructionDesc"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void btnAddInstructions_Click(object sender, EventArgs e) { try { if (cmbMachine.SelectedValue != null && cmbActivityInstructions.SelectedValue != null) { RPDBatchActivityInstructions obj = new RPDBatchActivityInstructions(); obj.Activity = objMainActivityDL.Get(Convert.ToInt64(cmbActivityInstructions.SelectedValue)); obj.Description = txtDescription.Text; obj.ID = InstructionID; obj.Machine = objMachineDL.Get(cmbMachine.SelectedValue.ToString()); obj.ParticleSize = txtParticleSize.Text; obj.RPDBatch = objRPDBatch; obj.Type = ""; long NewID = objRPDBatchActivityInstructionsDL.Add(obj); if (NewID > 0) { dgvActivityInstructions.AutoGenerateColumns = false; bindInstructions.DataSource = objRPDBatchActivityInstructionsDL.GetDataView(objRPDBatch.RPDBatchID); dgvActivityInstructions.DataSource = bindInstructions; bindInstructions.ResetBindings(true); ClearInstructionForm(); } } } catch (Exception) { MessageBox.Show(this, "Error occured while saving Instruction", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public long Add(RPDBatchActivityInstructions obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@RPDBatchActivityInstructionsID", obj.ID), new SqlParameter("@BatchNo", obj.RPDBatch.RPDBatchID), new SqlParameter("@ActivityID", obj.Activity.MainActID), new SqlParameter("@MachineID", obj.Machine.MachineCode), new SqlParameter("@ParticleSize", obj.ParticleSize), new SqlParameter("@InstructionDesc", obj.Description), new SqlParameter("@outParam", SqlDbType.Int) { Direction = ParameterDirection.Output } }; return(Execute.RunSP_Output(Connection, "SPADD_RPDBatchActivityInstructions_Update", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }