public PRPDBatchActivityInstructions.PRPDBatchActivityInstructionsCollec Get() { try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDBatchActivityInstructions"); PRPDBatchActivityInstructions.PRPDBatchActivityInstructionsCollec objCollec = new PRPDBatchActivityInstructions.PRPDBatchActivityInstructionsCollec(); PRPDBatchActivityInstructions obj = new PRPDBatchActivityInstructions(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { obj.PRPDBatchActivityInstructionsID = Convert.ToInt64(dt.Rows[i]["PRPDBatchActivityInstructionsID"]); obj.PRPDBatch = objPRPDBatch_DL.Get(Convert.ToString(dt.Rows[i]["PRPDBatchID"])); obj.Machine = objMachine_DL.Get(Convert.ToString(dt.Rows[i]["MachineID"])); obj.Activity = objMainActivity_DL.Get(Convert.ToInt64(dt.Rows[i]["ActivityID"])); obj.ActivityID = Convert.ToInt64(dt.Rows[i]["ActivityID"]); obj.MachineCode = Convert.ToString(dt.Rows[i]["MachineID"]); obj.ParticleSize = Convert.ToString(dt.Rows[i]["ParticleSize"]); obj.InstructionDesc = Convert.ToString(dt.Rows[i]["InstructionDesc"]); objCollec.Add(obj); } } return(objCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void btnAdd_Click(object sender, EventArgs e) { cmbMachine.ValueMember = "MachineID"; cmbMachine.DisplayMember = "MachineName"; PRPDBatchActivityInstructions obj = new PRPDBatchActivityInstructions(); try { obj.Activity = objMainActivity_DL.Get(Convert.ToInt64(cmbActivityID.SelectedValue)); if (txtInstruction.Text != "") { obj.InstructionDesc = txtInstruction.Text; } else { obj.InstructionDesc = "No"; } obj.ParticleSize = "N/A"; if (cmbMachine.SelectedValue != null) { obj.MachineCode = cmbMachine.SelectedValue.ToString(); obj.Machine = objMachine_DL.Get(cmbMachine.SelectedValue.ToString()); obj.MachineName = obj.Machine.MachineName; } else { obj.MachineCode = "No Machine"; obj.MachineName = "No Machine"; } objPRPDBatchActivityInstructionsCollec.Add(obj); dgvActivityInstructions.AutoGenerateColumns = false; dgvActivityInstructions.DataSource = objSource; objSource.DataSource = objPRPDBatchActivityInstructionsCollec; objSource.ResetBindings(true); txtInstruction.Text = ""; cmbActivityID.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }