} // 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