/// <summary>
/// Gets a specific access for a user.
/// </summary>
/// <param name="aUserKey">A user key composite.</param>
/// <param name="aFunction">A function.</param>
/// <returns></returns>
public static Access GetAccess(UserKey aUserKey, string aFunction)
{
UserFunctionAccess vUserFunctionAccess = new UserFunctionAccess() { UsrKey = aUserKey.UsrKey };
vUserFunctionAccess.FunctionAccess.Function = aFunction;
Load(vUserFunctionAccess);
return vUserFunctionAccess.FunctionAccess.Access;
}
/// <summary>
/// Gets a specific access for a user.
/// </summary>
/// <param name="aUserKey">A user key composite.</param>
/// <param name="aFunction">A function.</param>
/// <returns></returns>
public static Access GetAccess(UserKey aUserKey, string aFunction)
{
UserFunctionAccess vUserFunctionAccess = new UserFunctionAccess()
{
UsrKey = aUserKey.UsrKey
};
vUserFunctionAccess.FunctionAccess.Function = aFunction;
Load(vUserFunctionAccess);
return(vUserFunctionAccess.FunctionAccess.Access);
}
/// <summary>
/// Gets a specific access of a Specific mode for a user.
/// </summary>
/// <param name="aUserKey">A user key composite.</param>
/// <param name="aFunction">A function.</param>
/// <param name="aAccessMode">A access mode.</param>
/// <returns></returns>
public static bool HasModeAccess(UserKey aUserKey, string aFunction, AccessMode aAccessMode)
{
UserFunctionAccess vUserFunctionAccess = new UserFunctionAccess()
{
UsrKey = aUserKey.UsrKey
};
vUserFunctionAccess.FunctionAccess.Function = aFunction;
Load(vUserFunctionAccess);
bool vAccess = false;
switch (aAccessMode)
{
case AccessMode.List:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.List;
break;
}
case AccessMode.Read:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.Read;
break;
}
case AccessMode.Create:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.Create;
break;
}
case AccessMode.Update:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.Update;
break;
}
case AccessMode.Delete:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.Delete;
break;
}
default:
{
vAccess = false;
break;
}
}
return(vAccess);
}
/// <summary>
/// Loads the access to a specific function for a specific user.
/// </summary>
/// <param name="aUserFunctionAccess">A user function access.</param>
public static void Load(UserFunctionAccess aUserFunctionAccess)
{
if (aUserFunctionAccess == null)
{
throw new ArgumentNullException("aUserFunctionAccess");
}
// Clear the map
aUserFunctionAccess.FunctionAccess.Access.AccessMap = 0;
using (var vSqlCommand = new SqlCommand()
{
CommandType = CommandType.Text,
Connection = new SqlConnection(Connection.Instance.SqlConnectionString)
})
{
var vStringBuilder = new StringBuilder();
vStringBuilder.AppendLine("select RFC_AccessMap");
vStringBuilder.AppendLine("from URL_UserRole t1, RFC_RoleFunction t2, FNC_Function t3");
vStringBuilder.AppendLine("where t1.ROL_Key = t2.ROL_Key");
vStringBuilder.AppendLine("and t2.FNC_Key = t3.FNC_Key");
vStringBuilder.AppendLine("and t1.USR_Key = @USRKey");
vStringBuilder.AppendLine("and t3.FNC_Code = @FNCCode");
vSqlCommand.Parameters.AddWithValue("@USRKey", aUserFunctionAccess.UsrKey);
vSqlCommand.Parameters.AddWithValue("@FNCCode", aUserFunctionAccess.FunctionAccess.Function);
vSqlCommand.CommandText = vStringBuilder.ToString();
vSqlCommand.Connection.Open();
using (var vSqlDataReader = vSqlCommand.ExecuteReader())
{
bool _haveRows = Read(vSqlDataReader);
while (_haveRows)
{
aUserFunctionAccess.FunctionAccess.Access.Merge(new Access()
{
AccessMap = Convert.ToInt32(vSqlDataReader["RFC_AccessMap"])
});
_haveRows = Read(vSqlDataReader);
}
aUserFunctionAccess.FunctionAccess.Access.Loaded = true;
vSqlDataReader.Close();
}
vSqlCommand.Connection.Close();
}
}
/// <summary>
/// Loads the access to a specific function for a specific user.
/// </summary>
/// <param name="aUserFunctionAccess">A user function access.</param>
public static void Load(UserFunctionAccess aUserFunctionAccess)
{
if (aUserFunctionAccess == null)
{
throw new ArgumentNullException("aUserFunctionAccess");
}
// Clear the map
aUserFunctionAccess.FunctionAccess.Access.AccessMap = 0;
using (var vSqlCommand = new SqlCommand()
{
CommandType = CommandType.Text,
Connection = new SqlConnection(Connection.Instance.SqlConnectionString)
})
{
var vStringBuilder = new StringBuilder();
vStringBuilder.AppendLine("select RFC_AccessMap");
vStringBuilder.AppendLine("from URL_UserRole t1, RFC_RoleFunction t2, FNC_Function t3");
vStringBuilder.AppendLine("where t1.ROL_Key = t2.ROL_Key");
vStringBuilder.AppendLine("and t2.FNC_Key = t3.FNC_Key");
vStringBuilder.AppendLine("and t1.USR_Key = @USRKey");
vStringBuilder.AppendLine("and t3.FNC_Code = @FNCCode");
vSqlCommand.Parameters.AddWithValue("@USRKey", aUserFunctionAccess.UsrKey);
vSqlCommand.Parameters.AddWithValue("@FNCCode", aUserFunctionAccess.FunctionAccess.Function);
vSqlCommand.CommandText = vStringBuilder.ToString();
vSqlCommand.Connection.Open();
using (var vSqlDataReader = vSqlCommand.ExecuteReader())
{
bool _haveRows = Read(vSqlDataReader);
while (_haveRows)
{
aUserFunctionAccess.FunctionAccess.Access.Merge(new Access() { AccessMap = Convert.ToInt32(vSqlDataReader["RFC_AccessMap"]) });
_haveRows = Read(vSqlDataReader);
}
aUserFunctionAccess.FunctionAccess.Access.Loaded = true;
vSqlDataReader.Close();
}
vSqlCommand.Connection.Close();
}
}
/// <summary>
/// Gets a specific access of a Specific mode for a user.
/// </summary>
/// <param name="aUserKey">A user key composite.</param>
/// <param name="aFunction">A function.</param>
/// <param name="aAccessMode">A access mode.</param>
/// <returns></returns>
public static bool HasModeAccess(UserKey aUserKey, string aFunction, AccessMode aAccessMode)
{
UserFunctionAccess vUserFunctionAccess = new UserFunctionAccess() { UsrKey = aUserKey.UsrKey };
vUserFunctionAccess.FunctionAccess.Function = aFunction;
Load(vUserFunctionAccess);
bool vAccess = false;
switch (aAccessMode)
{
case AccessMode.List:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.List;
break;
}
case AccessMode.Read:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.Read;
break;
}
case AccessMode.Create:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.Create;
break;
}
case AccessMode.Update:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.Update;
break;
}
case AccessMode.Delete:
{
vAccess = vUserFunctionAccess.FunctionAccess.Access.Delete;
break;
}
default:
{
vAccess = false;
break;
}
}
return vAccess;
}
/// <summary>
/// Get a specific <see cref="UserFunctionAccess"/>.
/// </summary>
/// <param name="aUserToken">A user token.</param>
/// <param name="aUserFunctionAccess">The UserFunctionAccess to return</param>
public static void GetUserFunctionAccessCollection(UserToken aUserToken, UserFunctionAccess aUserFunctionAccess)
{
UserCallHandler.ServiceCall<UserFunctionAccess>(aUserToken, "GetUserFunctionAccess", aUserFunctionAccess);
}
/// <summary>
/// Get a specific <see cref="UserFunctionAccess"/>.
/// </summary>
/// <param name="aUserToken">A user token.</param>
/// <param name="aUserFunctionAccess">The UserFunctionAccess to return</param>
public static void GetUserFunctionAccessCollection(UserToken aUserToken, UserFunctionAccess aUserFunctionAccess)
{
UserCallHandler.ServiceCall <UserFunctionAccess>(aUserToken, "GetUserFunctionAccess", aUserFunctionAccess);
}