public bool EnsurePermissionsInDatabase()
{
bool ret = true;
if (!ensuredInDatabase)
{
ret = PortalApplicationPermission.EnsurePermissionsInDatabase(this);
ensuredInDatabase = true;
}
return(ret);
}
public void RemoveUserPermission(PortalApplicationPermission permissionToRemove)
{
foreach (PortalApplicationPermission p in Permissions)
{
if (p.ID == permissionToRemove.ID)
{
ApplicationPermissions.Remove(p);
return;
}
} // foreach
}
/// <summary>
/// adds a permission to the user's Permissions list. Does NOT save this addition to the database.
/// </summary>
/// <param name="role"></param>
public void AddUserPermission(PortalApplicationPermission permission)
{
foreach (PortalApplicationPermission p in Permissions)
{
if (p.ID == permission.ID)
{
return;
}
}
ApplicationPermissions.Add(permission);
}
} // Update
private bool arrayContains(PortalApplicationPermission needle, PortalApplicationPermission[] haystack)
{
foreach (PortalApplicationPermission p in haystack)
{
if ((String.Compare(needle.ApplicationName, p.ApplicationName, true) == 0) &&
(String.Compare(needle.Action, p.Action, true) == 0))
{
return(true);
}
}
return(false);
}
private PortalApplicationPermission GetFromRow(DataRow dr)
{
PortalApplicationPermission item = new PortalApplicationPermission();
item.ID = Convert.ToInt32(dr["PermissionsId"]);
item.ApplicationName = (dr["ApplicationName"]).ToString();
item.Action = (dr["Action"]).ToString();
item.Description = (dr["Description"]).ToString();
return(item);
} // GetFromRow
} // Insert
public bool Update(PortalApplicationPermission item)
{
string sql = "UPDATE permissions SET ";
sql += "ApplicationName = " + "'" + dbEncode(item.ApplicationName) + "'" + ", ";
sql += "Action = " + "'" + dbEncode(item.Action) + "'" + ", ";
sql += "Description = " + "'" + dbEncode(item.Description) + "'" + ", ";
sql += " WHERE PermissionsId = " + item.ID.ToString();
sql += " ; ";
int numAffected = this.RunUpdateQuery(sql);
if (numAffected < 0)
{
return(false);
}
return(true);
} // Update
public bool Insert(PortalApplicationPermission item)
{
string sql = "INSERT INTO permissions ";
sql += "(ApplicationName, Action, Description)";
sql += " VALUES ( ";
sql += "'" + dbEncode(item.ApplicationName) + "'" + ", ";
sql += "'" + dbEncode(item.Action) + "'" + ", ";
sql += "'" + dbEncode(item.Description) + "'" + ", ";
sql += " ); ";
int newId = this.RunInsertQuery(sql);
if (newId > -1)
{
item.ID = newId;
return(true);
}
return(false);
} // Insert
} // getAllWebPortalUsers
/// <summary>
/// returns an ArrayList of WebPortalUser objects. The passed in DataSet MUST have been created
/// using getStandardUserSQL()
/// </summary>
/// <param name="ds">The DataSet returned from the query</param>
/// <returns>an ArrayList of WebPortalUser objects</returns>
private WebPortalUser[] getWebPortalUsersFromStandardDataSet(DataSet ds)
{
Dictionary <string, WebPortalUser> storage = new Dictionary <string, WebPortalUser>();
if (hasRows(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
string key = dr["AppUserId"].ToString();
// -- get the user
WebPortalUser user;
if (!storage.ContainsKey(key))
{
user = new WebPortalUser(Convert.ToInt32(dr["AppUserId"]), dr["username"].ToString(), dr["password"].ToString());
user.FullName = dr["FullName"].ToString();
user.EmailAddress = dr["EmailAddress"].ToString();
user.LastLogin = getPossiblyNullValue(dr, "LastLoginDateTime", DateTime.MinValue);
}
else
{
user = storage[key];
}
// -- roles
if (dr["roleid"] != System.DBNull.Value)
{
WebPortalUserRole role = new WebPortalUserRole(Convert.ToInt32(dr["roleid"]), dr["RoleName"].ToString(), dr["RoleDesc"].ToString());
user.AddUserRole(role);
}
// x.`key` as exKey, x.`value` as exVal,
// -- Permissions
// p.PermissionsId, p.ApplicationName, p.Action, p.Description
if (dr["PermissionsId"] != System.DBNull.Value)
{
PortalApplicationPermission p = new PortalApplicationPermission();
p.ID = Convert.ToInt32(dr["PermissionsId"]);
p.ApplicationName = dr["ApplicationName"].ToString().Trim();
p.Action = dr["Action"].ToString().Trim();
p.Description = dr["Description"].ToString();
user.AddUserPermission(p);
}
if (!storage.ContainsKey(key))
{
storage.Add(key, user);
}
} // foreach row
// ---- copy the storage NameValueCollection to the ArrayList
} // if there is data
List <WebPortalUser> ret = new List <WebPortalUser>();
foreach (string k in storage.Keys)
{
ret.Add(storage[k]);
}
return(ret.ToArray());
} // getWebPortalUsersFromStandardDataSet
public bool hasPermissionTo(PortalApplicationPermission permissionRequested)
{
return(hasPermissionTo(permissionRequested.Action, permissionRequested.ApplicationName));
}
public static bool Delete(PortalApplicationPermission toDelete)
{
return((new permissionsDB()).Delete(toDelete.ID));
} // Delete