public static void update(Guid userAccountID, Guid id, string name, string notes, List <int> userAccountAccessEnum)
{
UserAccountRole objOld = new UserAccountRole(id);
string log = "";
log = Util.appendChange(log, objOld.Name, name, "Name: '{0}' to '{1}'");
log = Util.appendChange(log, objOld.Notes, notes, "Notes: '{0}' to '{1}'");
using (SqlConnection sqlConnection = new SqlConnection(DBConnection.ConnectionString))
{
if (!string.IsNullOrEmpty(log))
{
SqlQueryResult result = DBConnection.query(
sqlConnection,
QueryTypes.ExecuteNonQuery,
"UserAccountRoles_update",
new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, id),
new SqlQueryParameter(COL_DB_Name, SqlDbType.NVarChar, Util.wrapNullable(name))
);
if (result.IsSuccessful)
{
LOGGING.ActivityLog.add(sqlConnection, userAccountID, id, String.Format("Updated: {0}", log));
}
}
UserAccountAccessRoleAssignment.update(sqlConnection, userAccountID, id, userAccountAccessEnum);
}
}
/// <summary>
/// <para>userAccountID is user that is performing the assignment</para>
/// <para>userAccountsId is the user to be assigned to the userAccountRoleId </para>
/// </summary>
public static void delete(Guid userAccountID, Guid id)
{
using (SqlConnection sqlConnection = new SqlConnection(DBConnection.ConnectionString))
{
SqlQueryResult result = DBConnection.query(
sqlConnection,
QueryTypes.ExecuteNonQuery,
"UserAccountAccessRoleAssignments_delete",
new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, id)
);
if (result.IsSuccessful)
{
UserAccountAccessRoleAssignment obj = new UserAccountAccessRoleAssignment(id);
LOGGING.ActivityLog.add(sqlConnection, userAccountID, obj.UserAccountRoles_Id, "Deleted Access " + Util.GetEnumDescription <UserAccountAccess>(obj.UserAccountAccess_EnumId));
}
}
}
protected override void populateInputFields()
{
UserAccountRole obj = new UserAccountRole(selectedRowID());
itxt_Name.ValueText = obj.Name;
itxt_Notes.ValueText = obj.Notes;
//populate access tree
clearUserAccountAccessTree();
DataTable accesses = UserAccountAccessRoleAssignment.getByUserAccountRoleId(obj.Id);
CheckBox checkbox;
foreach (DataRow row in accesses.Rows)
{
_userAccountAccessDictionary.TryGetValue(Util.parseEnum <UserAccountAccessEnum>(row[UserAccountAccessRoleAssignment.COL_DB_UserAccountAccess_EnumId]), out checkbox);
checkbox.Checked = true;
}
}
/*******************************************************************************************************/
#region DATABASE METHODS
public static Guid add(Guid userAccountID, string name, string notes, List <int> userAccountAccessEnum)
{
Guid id = Guid.NewGuid();
using (SqlConnection sqlConnection = new SqlConnection(DBConnection.ConnectionString))
{
SqlQueryResult result = DBConnection.query(
sqlConnection,
QueryTypes.ExecuteNonQuery,
"UserAccountRoles_add",
new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, id),
new SqlQueryParameter(COL_DB_Name, SqlDbType.NVarChar, name),
new SqlQueryParameter(COL_DB_Notes, SqlDbType.NVarChar, Util.wrapNullable(notes))
);
if (result.IsSuccessful)
{
LOGGING.ActivityLog.add(sqlConnection, userAccountID, id, "Added");
UserAccountAccessRoleAssignment.update(sqlConnection, userAccountID, id, userAccountAccessEnum);
}
}
return(id);
}
