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