} // setResponseText /// <summary> /// Process Request. /// </summary> /// <returns>answer</returns> public String Process() { MIssueProject.Get(this); // sets also Asset MIssueSystem.Get(this); MIssueUser.Get(this); // // setR_IssueKnown_ID(0); // setR_Request_ID(0); return(CreateAnswer()); } // process
/// <summary> /// Get/Set User for Issue /// </summary> /// <param name="issue">issue</param> /// <returns>user</returns> static public MIssueUser Get(MIssue issue) { if (issue.GetUserName() == null) { return(null); } MIssueUser user = null; // Find Issue User String sql = "SELECT * FROM R_IssueUser WHERE UserName=@param"; SqlParameter[] param = new SqlParameter[1]; IDataReader idr = null; try { //pstmt = DataBase.prepareStatement (sql, null); //pstmt.setString (1, issue.getUserName()); param[0] = new SqlParameter("@param", issue.GetUserName()); idr = DataBase.DB.ExecuteReader(sql, param, null); if (idr.Read()) { user = new MIssueUser(issue.GetCtx(), idr, null); } idr.Close(); } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, e); } // New if (user == null) { user = new MIssueUser(issue.GetCtx(), 0, null); user.SetUserName(issue.GetUserName()); user.SetAD_User_ID(); if (!user.Save()) { return(null); } } issue.SetR_IssueUser_ID(user.GetR_IssueUser_ID()); return(user); } // MIssueUser