public BEGroups SelectAllInactive()
{
BEGroups ds = new BEGroups();
DAGroups da = new DAGroups();
da.SelectAllInactive(ds.tbl_Groups);
return ds;
}
public BEGroups SelectAll()
{
BEGroups ds = new BEGroups();
DAGroupUsers da = new DAGroupUsers();
da.SelectAll(ds.tbl_GroupUsers);
return ds;
}
public BEGroups SelectAllInactive()
{
BEGroups ds = new BEGroups();
DAPermissions da = new DAPermissions();
da.SelectAllInactive(ds.tbl_Permissions);
return ds;
}
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();
DASystemAreas da = new DASystemAreas();
da.SelectAllInactive(ds.tbl_SystemAreas);
return ds;
}
public BEGroups SelectAll()
{
BEGroups ds = new BEGroups();
DAGroupPermissions da = new DAGroupPermissions();
da.SelectAll(ds.tbl_GroupPermissions);
return ds;
}
public BEGroups SelectSystemAreasByID(int SystemAreasID)
{
BEGroups ds = new BEGroups();
DASystemAreas da = new DASystemAreas();
da.SelectByID(SystemAreasID.ToString(), ds.tbl_SystemAreas);
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 SelectByID(int PermissionID)
{
BEGroups ds = new BEGroups();
DAPermissions da = new DAPermissions();
da.SelectByID(PermissionID.ToString(), ds.tbl_Permissions);
return ds;
}
public BEGroups SelectByGroupID(int GroupID)
{
BEGroups ds = new BEGroups();
DAGroupUsers da = new DAGroupUsers();
da.SelectByGroupID(GroupID, ds.tbl_GroupUsers);
return ds;
}
public BEGroups SelectAllExceptMWS(int mwsPermGroupID)
{
BEGroups ds = new BEGroups();
DAGroups da = new DAGroups();
da.SelectAllExceptMWS(mwsPermGroupID, ds.tbl_Groups);
return ds;
}
public BEGroups SelectByUserID(int UserID)
{
BEGroups ds = new BEGroups();
DAGroups da = new DAGroups();
da.SelectByUserID(UserID, ds.tbl_Groups);
return ds;
}
public BEGroups SelectByID(int GroupID)
{
BEGroups ds = new BEGroups();
DAGroups da = new DAGroups();
da.SelectByID(GroupID.ToString(), ds.tbl_Groups);
return ds;
}
protected DataView GetData()
{
BPGroups bp = new BPGroups();
DSGroups = bp.SelectAllExceptMWS(Convert.ToInt32(ConfigurationManager.AppSettings["MWSPermGroupID"]));
DSGroups.tbl_Groups.DefaultView.RowFilter = RowFilter("GroupName", ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, "GroupActive", lstActive.SelectedValue);
return DSGroups.tbl_Groups.DefaultView;
}
public void Update(BEGroups ds)
{
DAGroups da = new DAGroups();
da.Update(ds.tbl_Groups);
}
public void Update(BEGroups ds)
{
DAPermissions da = new DAPermissions();
da.Update(ds.tbl_Permissions);
}
public void Update(BEGroups ds)
{
DASystemAreas da = new DASystemAreas();
da.Update(ds.tbl_SystemAreas);
}
