public string SelectByUserID(int UserID)
{
BEGroups ds = new BEGroups();
DAGroupPermissions da = new DAGroupPermissions();
StringBuilder SystemAreaPerms = new StringBuilder();
int temp = -1;
da.SelectByUserID(UserID, ds.tbl_GroupPermissions);
ds.tbl_GroupPermissions.DefaultView.Sort = "SystemAreaPermissionID";
foreach (DataRowView drv in ds.tbl_GroupPermissions.DefaultView)
{
BEGroups.tbl_GroupPermissionsRow row = (BEGroups.tbl_GroupPermissionsRow)drv.Row;
if (row.SystemAreaPermissionID != temp)
{
SystemAreaPerms.Append(row.SystemAreaPermissionID.ToString());
SystemAreaPerms.Append(",");
temp = row.SystemAreaPermissionID;
}
}
if (SystemAreaPerms.Length > 0)
return SystemAreaPerms.ToString(0, SystemAreaPerms.Length - 1);
else
return "";
}
public BEGroups SelectAllInactive()
{
BEGroups ds = new BEGroups();
DAGroupPermissions da = new DAGroupPermissions();
da.SelectAllInactive(ds.tbl_GroupPermissions);
return ds;
}
public BEGroups SelectByGroupID(int GroupID)
{
BEGroups ds = new BEGroups();
DAGroupPermissions da = new DAGroupPermissions();
da.SelectByGroupID(GroupID, ds.tbl_GroupPermissions);
return ds;
}
public BEGroups SelectGroupPermissionByID(int GroupPermissionID)
{
BEGroups ds = new BEGroups();
DAGroupPermissions da = new DAGroupPermissions();
da.SelectByID(GroupPermissionID.ToString(), ds.tbl_GroupPermissions);
return ds;
}
public void Update(BEGroups ds)
{
DAGroupPermissions da = new DAGroupPermissions();
da.Update(ds.tbl_GroupPermissions);
}
