private void lvwUser_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
//unselect all items in security group
foreach (ListViewItem lvi in lvwSecurityGroup.Items)
{
lvi.Selected = false;
}
if (lvwUser.SelectedIndices.Count > 0)
{
//String uId = lvwUser.Items[lvwUser.SelectedIndices[0]].SubItems[1].Text;
int uIndex = lvwUser.SelectedIndices[0];
User u = uInfo[uIndex];
//MessageBox.Show(uId);
usrScuGruAgnInfo.UserId = u.UserId;
}
usrScuGruAgnInfo = dbl.RetrieveAssingedSecurityGroup(usrScuGruAgnInfo);
foreach (String sgId in usrScuGruAgnInfo.SecurityGroupId)
{
foreach (ListViewItem lvi in lvwSecurityGroup.Items)
{
if (lvi.SubItems[1].Text == sgId)
{
lvi.Selected = true;
lvwSecurityGroup.Select();
}
}
}
}
private void lvwUser_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
//unselect all items in security group
foreach (ListViewItem lvi in lvwSecurityGroup.Items)
{
lvi.Selected = false;
}
if (lvwUser.SelectedIndices.Count > 0)
{
//String uId = lvwUser.Items[lvwUser.SelectedIndices[0]].SubItems[1].Text;
int uIndex = lvwUser.SelectedIndices[0];
User u = uInfo[uIndex];
//MessageBox.Show(uId);
usrScuGruAgnInfo.UserId = u.UserId;
}
usrScuGruAgnInfo = dbl.RetrieveAssingedSecurityGroup(usrScuGruAgnInfo);
foreach (String sgId in usrScuGruAgnInfo.SecurityGroupId)
{
foreach (ListViewItem lvi in lvwSecurityGroup.Items)
{
if (lvi.SubItems[1].Text == sgId)
{
lvi.Selected = true;
lvwSecurityGroup.Select();
}
}
}
}
/// <summary>
/// Save Security Group assignment to an User information in securitygroupassigns table from frmAssignsSecurityGroup form.
/// </summary>
/// <returns></returns>
public bool SaveSecurityGroupsAssings(RBACD.DatalayerDef.sSecurityGroupAssigns usrScuGruAgnInfo)
{
String uId = usrScuGruAgnInfo.UserId;
//List<String> sgID = usrScuGruAgnInfo.SecurityGroupId;
OdbcTransaction tran = null;
string sql = string.Empty;
try
{
OdbcConnection con = (OdbcConnection)this.DbConnection;
OdbcCommand cmd = new OdbcCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
tran = con.BeginTransaction();
cmd.Transaction = tran;
sql = "DELETE FROM securitygroupassigns WHERE UserId = " + uId;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
foreach (String sgId in usrScuGruAgnInfo.SecurityGroupId)
{
sql = "INSERT INTO rbac.securitygroupassigns (UserId, SecurityGroupId) VALUES(" + uId + ", '" + sgId + "')";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
tran.Commit();
return(true);
}
catch
{
if (tran != null)
{
tran.Rollback();
}
return(false);
}
}
/// <summary>
/// Retrieve assigned Security Group to an user from securitygroupassigns table
/// </summary>
/// <returns>Returns list of Security Group Assigns information</returns>
public RBACD.DatalayerDef.sSecurityGroupAssigns RetrieveAssingedSecurityGroup(RBACD.DatalayerDef.sSecurityGroupAssigns usrScuGruAgnInfo)
{
IDataReader ReturnValue;
// create a command object which we can use to retrive security gruoup assignment information
IDbCommand DbCommand = CreateCommandObject(DbConnection, "Select SecurityGroupID from securitygroupassigns where UserId=" + usrScuGruAgnInfo.UserId);
try
{
// open the database, query for the security group assigns
ReturnValue = DbCommand.ExecuteReader();
}
catch (Exception e)
{
throw new DataLayerException(GetString(DataAccessException));
}
// if the return value is null then we did not find security group assignment information
if (ReturnValue != null)
{
List <String> sgID = new List <String>();
while (ReturnValue.Read())
{
sgID.Add(ReturnValue[0].ToString());
}
usrScuGruAgnInfo.SecurityGroupId = sgID;
}
return(usrScuGruAgnInfo);
}
