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