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