} // getOfRole
/// <summary>
/// Get User Roles Of User
/// </summary>
/// <param name="ctx">context</param>
/// <param name="AD_User_ID">ad user id</param>
/// <returns>array of user roles</returns>
public static MUserRoles[] GetOfUser(Ctx ctx, int AD_User_ID)
{
String sql = "SELECT * FROM AD_User_Roles WHERE AD_User_ID=@userid";
List <MUserRoles> list = new List <MUserRoles>();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@userid", AD_User_ID);
DataSet ds = DataBase.DB.ExecuteDataset(sql, param);
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new MUserRoles(ctx, dr, null));
}
ds = null;
}
catch (Exception e)
{
s_log.Log(Level.SEVERE, "getOfUser", e);
}
MUserRoles[] retValue = new MUserRoles[list.Count()];
retValue = list.ToArray();
return(retValue);
} // getOfUser
} // getForstAD_Role_ID
public int GetFirstUserAD_Role_ID()
{
GetRecipients(false);
int AD_User_ID = GetFirstAD_User_ID();
if (AD_User_ID != -1)
{
MUserRoles[] urs = MUserRoles.GetOfUser(GetCtx(), AD_User_ID);
foreach (MUserRoles element in urs)
{
if (element.IsActive())
{
return(element.GetAD_Role_ID());
}
}
}
return(-1);
} // getFirstUserAD_Role_ID
