/// <summary> /// Get Chats Of Table - of client in context /// </summary> /// <param name="ctx">context</param> /// <param name="AD_Table_ID">table</param> /// <returns> array of chats</returns> public static MChat[] GetOfTable(Ctx ctx, int AD_Table_ID) { int AD_Client_ID = ctx.GetAD_Client_ID(); List <MChat> list = new List <MChat>(); // String sql = "SELECT * FROM CM_Chat " + "WHERE AD_Client_ID=" + AD_Client_ID + " AND AD_Table_ID=" + AD_Table_ID + " ORDER BY Record_ID"; DataTable dt = null; IDataReader idr = null; try { idr = DataBase.DB.ExecuteReader(sql, null, null); dt = new DataTable(); dt.Load(idr); idr.Close(); foreach (DataRow dr in dt.Rows)// while (rs.next()) { list.Add(new MChat(ctx, dr, null)); } } catch (Exception e) { idr.Close(); _log.Log(Level.SEVERE, sql, e); } finally { dt = null; idr.Close(); } MChat[] retValue = new MChat[list.Count]; retValue = list.ToArray(); return(retValue); }
/// <summary> /// Parent Constructor /// </summary> /// <param name="chat">chat parent</param> /// <param name="data">data text</param> public MChatEntry(MChat chat, String data) : this(chat.GetCtx(), 0, chat.Get_TrxName()) { //set chatID SetCM_Chat_ID(chat.GetCM_Chat_ID()); //set chat confidential type SetConfidentialType(chat.GetConfidentialType()); //set entered chat text SetCharacterData(data); //chat entry type "N" SetChatEntryType(CHATENTRYTYPE_NoteFlat); // N }