private void btnManagerAdd_Click(object sender, EventArgs e) { try { if (cmbManagers.Items.Count > 0) { DivisionManage obj = new DivisionManage(); obj.ManagerID = cmbManagers.SelectedValue.ToString(); obj.DivisionID = Convert.ToInt64(txtID.Text); int res = objDivisionManageDL.Add(obj, objSelectedManager); if (res > 0) { bindManagers.DataSource = objDivisionManageDL.Get(obj.DivisionID); objSelectedManager = new DivisionManage(); cmbManagers.SelectedIndex = -1; } } } catch (SqlException ex) { if (ex.Number == 2627) { MessageBox.Show(this, "Manager already added", "Duplicate Record", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception) { MessageBox.Show(this, "Error occured while saving Manager", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void ClearForm() { txtID.Text = "[Auto]"; txtName.Text = ""; cmbType.SelectedIndex = 0; IsSelect = false; btnManagerAdd.Enabled = false; btnMangerDelete.Enabled = false; btnManagerClear.Enabled = false; objSelectedManager = new DivisionManage(); bindManagers.DataSource = objDivisionManageDL.Get(0); }
public int Delete(DivisionManage obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_DivisionID", obj.DivisionID), new SqlParameter("@Original_ManagerID", obj.ManagerID) }; return(Execute.RunSP_RowsEffected(Connection, "SPDELETE_DivisionManage", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(DivisionManage obj, DivisionManage OriginalObj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@DivisionID", obj.DivisionID), new SqlParameter("@ManagerID", obj.ManagerID), new SqlParameter("@Original_DivisionID", OriginalObj.DivisionID), new SqlParameter("@Original_ManagerID", OriginalObj.ManagerID) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_DivisionManage_Update", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void btnMangerDelete_Click(object sender, EventArgs e) { try { if (objSelectedManager.DivisionID > 0) { DialogResult dr = MessageBox.Show(this, "Are you sure you want to delete Selected manager?\n\nClick Yes to Delete", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dr == DialogResult.Yes) { int res = objDivisionManageDL.Delete(objSelectedManager); bindManagers.DataSource = objDivisionManageDL.Get(Convert.ToInt64(txtID.Text)); objSelectedManager = new DivisionManage(); } } else { MessageBox.Show(this, "Please select a Manager", "Selection Empty", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception) { MessageBox.Show(this, "Error occured while deleting", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnManagerClear_Click(object sender, EventArgs e) { cmbManagers.SelectedIndex = -1; objSelectedManager = new DivisionManage(); }