public GroupProperties GetUTSGroups(string groupName)
{
DataTable dtUsers = new DataTable();
DataTable dtShares = new DataTable();
GroupProperties group = new GroupProperties();
try
{
SqlCommand getUsers = new SqlCommand(@"SELECT DISTINCT UsersName from Groups
JOIN Groups_User on GroupsID = GroupsIDGroups_User
JOIN USERS on UsersID = UserIDGroups_User
WHERE GroupsID IN (SELECT GroupsID from Groups WHERE GroupsName = '" + groupName + "')", sqlConnection);
SqlCommand getShares = new SqlCommand(@"SELECT DISTINCT ShareName, Share_GroupGroupPermissions from Share
JOIN Share_Groups on Share_GroupShareID = ShareID
WHERE Share_GroupGroupID IN (SELECT GroupsID from Groups WHERE GroupsName = '" + groupName + "')", sqlConnection);
sqlConnection.Open();
SqlDataReader myReader = getUsers.ExecuteReader();
dtUsers.Load(myReader);
myReader = getShares.ExecuteReader();
dtShares.Load(myReader);
sqlConnection.Close();
}
catch (Exception e)
{
throw (e);
}
if (dtUsers.Rows.Count > 0)
{
group.users = new List <string>();
foreach (DataRow row in dtUsers.Rows)
{
group.users.Add(row[0].ToString());
}
}
if (dtShares.Rows.Count > 0)
{
group.shares = new List <Tuple <string, string> >();
foreach (DataRow row in dtShares.Rows)
{
string sName = row[0].ToString();
sName = sName.Substring(sName.LastIndexOf(@"\") + 1);
group.shares.Add(new Tuple <string, string>(sName, row[1].ToString()));
}
}
return(group);
}
public GroupProperties GetUTSGroups(string groupName)
{
DataTable dtUsers = new DataTable();
DataTable dtShares = new DataTable();
GroupProperties group = new GroupProperties();
try
{
SqlCommand getUsers = new SqlCommand(@"SELECT DISTINCT UsersName from Groups
JOIN Groups_User on GroupsID = GroupsIDGroups_User
JOIN USERS on UsersID = UserIDGroups_User
WHERE GroupsID IN (SELECT GroupsID from Groups WHERE GroupsName = '" + groupName + "')", sqlConnection);
SqlCommand getShares = new SqlCommand(@"SELECT DISTINCT ShareName, Share_GroupGroupPermissions from Share
JOIN Share_Groups on Share_GroupShareID = ShareID
WHERE Share_GroupGroupID IN (SELECT GroupsID from Groups WHERE GroupsName = '" + groupName + "')", sqlConnection);
sqlConnection.Open();
SqlDataReader myReader = getUsers.ExecuteReader();
dtUsers.Load(myReader);
myReader = getShares.ExecuteReader();
dtShares.Load(myReader);
sqlConnection.Close();
}
catch (Exception e)
{
throw (e);
}
if (dtUsers.Rows.Count > 0)
{
group.users = new List<string>();
foreach (DataRow row in dtUsers.Rows)
{
group.users.Add(row[0].ToString());
}
}
if (dtShares.Rows.Count > 0)
{
group.shares = new List<Tuple<string, string>>();
foreach (DataRow row in dtShares.Rows)
{
string sName = row[0].ToString();
sName = sName.Substring(sName.LastIndexOf(@"\") + 1);
group.shares.Add(new Tuple<string, string>(sName, row[1].ToString()));
}
}
return group;
}