private void saveData() { UserGroup _userGroup = new UserGroup(); ProcessUserGroup _pGroup = new ProcessUserGroup(AlarmasABC.BLL.InvokeOperations.operations.INSERT); try { int _comID =int.Parse(Session["trkCompany"].ToString()); _userGroup.GroupName = _txtGroupName.Text; _userGroup.ComID = _comID; _pGroup.UserGroup = _userGroup; _pGroup.invoke(); loadGrid(_comID); clearControls(); } catch (Exception ex) { ex.Message.ToString(); } finally { _userGroup = null; _pGroup = null; } }
protected void _grdGroup_Update(object sender, GridCommandEventArgs e) { if (e.CommandName == "Edit") { string lblGrpName = ((Label)e.Item.FindControl("lblgrpName")).Text; if (lblGrpName == "Administrator") { e.Canceled = true; return; } } if (e.CommandName == "Update") { GridEditableItem editedItem = e.Item as GridEditableItem; string _groupID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["groupID"].ToString(); string _groupName = (editedItem["groupName"].Controls[0] as TextBox).Text; UserGroup _userGroup = new UserGroup(); ProcessUserGroup _updateGroup = new ProcessUserGroup(AlarmasABC.BLL.InvokeOperations.operations.UPDATE); try { _userGroup.GroupID = int.Parse(_groupID); _userGroup.GroupName = _groupName; _updateGroup.UserGroup = _userGroup; _updateGroup.invoke(); } catch (Exception ex) { ex.Message.ToString(); } finally { _userGroup = null; _updateGroup = null; } _lblMessage.Text = "User Group Updated Successfully."; _lblMessage.ForeColor = System.Drawing.Color.Green; } }
protected void _rgridGroup_DeleteCommand(object source, GridCommandEventArgs e) { GridDataItem item = (GridDataItem)e.Item; string _groupID = item.OwnerTableView.DataKeyValues[item.ItemIndex]["groupID"].ToString(); string _groupName = ((Label)e.Item.FindControl("lblgrpName")).Text; if (!UserExist(_groupID)) { UserGroup _userGrp = new UserGroup(); ProcessUserGroup _delGroup = new ProcessUserGroup(AlarmasABC.BLL.InvokeOperations.operations.DELETE); try { _userGrp.GroupID = int.Parse(_groupID); _delGroup.UserGroup = _userGrp; _delGroup.invoke(); } catch (Exception ex) { } finally { _delGroup = null; _userGrp = null; } clearControls(); _lblMessage.Text = "User Group " + _groupName + " Deleted Successfully."; _lblMessage.ForeColor = System.Drawing.Color.Green; } else { _lblMessage.Text = "User Group \"" + _groupName + "\" is in use and can't be deleted."; _lblMessage.ForeColor = System.Drawing.Color.Red; } }
private int createUserGroup(string name) { UserGroup userGroup = new UserGroup(); ProcessUserGroup pGroup = new ProcessUserGroup(AlarmasABC.BLL.InvokeOperations.operations.INSERT); try { userGroup.GroupName = name; userGroup.ComID = comID; pGroup.UserGroup = userGroup; pGroup.invoke(); DataSet _ds = new DataSet(); ExecuteSQL exec = new ExecuteSQL(); _ds = exec.getDataSet("SELECT groupID FROM tblGroup WHERE comID = " + comID + " AND groupName = '" + name + "';"); int groupID = int.Parse(_ds.Tables[0].Rows[0][0].ToString()); if (groupID < 1) { return -1; } return groupID; } catch (Exception ex) { Console.WriteLine("CreateNewAccount::createUserGroup():" + ex.Message.ToString()); } finally { userGroup = null; pGroup = null; } return -1; }