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