private void ClearMachine() { objMachineActivity = null; cmbMachineList.SelectedIndex = 0; btnMachineAdd.Text = "Add"; bindMachineList.DataSource = objMachineActivity_DL.GetDataByAct(objMainActivity.MainActID); }
private void btnMachineAdd_Click(object sender, EventArgs e) { try { if (objMainActivity != null) { if (objMachineActivity == null) { objMachineActivity = new MachineActivity(); objMachineActivity.MainActivityID = objMainActivity.MainActID; objMachineActivity.MachineID = (cmbMachineList.SelectedValue.ToString()); int res = objMachineActivity_DL.Add(objMachineActivity); if (res > 0) { ClearMachine(); } } else { int res = objMachineActivity_DL.Delete(objMachineActivity); if (res > 0) { ClearMachine(); } } } } catch (Exception) { MessageBox.Show(this, "Error occured while saving", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public int Delete(MachineActivity Obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_MachineID", Obj.MachineID), new SqlParameter("@Original_MainActID", Obj.MainActivityID) }; return(Execute.RunSP_RowsEffected(Conncetion, "SPDELEE_MachineActivity", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(MachineActivity obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MachineID", obj.MachineID), new SqlParameter("@MainActID", obj.MainActivityID) }; return(Execute.RunSP_RowsEffected(Conncetion, "SPADD_MachineActivity", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void gvMachine_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { try { String MachineID = gvMachine.Rows[e.RowIndex].Cells["ColMachineID"].Value.ToString(); objMachineActivity = new MachineActivity(); objMachineActivity.MachineID = MachineID; objMachineActivity.MainActivityID = objMainActivity.MainActID; cmbMachineList.SelectedValue = MachineID; btnMachineAdd.Text = "Remove"; } catch (Exception) { MessageBox.Show(this, "Error occured while loading Machine", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);; } } }