public FrmGroupChat(XmppClient xmppClient, Jid roomJid, string nickname, ListView listContract)
{
InitializeComponent();
local_history = new HistoryTransactionTableAdapter();
connection = new SqlCeConnection(local_history.Connection.ConnectionString);
_roomJid = roomJid;
_xmppClient = xmppClient;
_nickname = nickname;
_listContract = listContract;
fm.XmppClient = FrmLogin.Instance.xmppClient;
fm.OnFile += fm_OnFile;
Text = roomJid.User + " Group";;
mm = new MucManager(xmppClient);
// Setup new Message Callback using the MessageFilter
_xmppClient.MessageFilter.Add(roomJid, new BareJidComparer(), MessageCallback);
// Setup new Presence Callback using the PresenceFilter
_xmppClient.PresenceFilter.Add(roomJid, new BareJidComparer(), PresenceCallback);
GetLastRow(_xmppClient.Username, _xmppClient.XmppDomain, _roomJid.Bare, out LastDtDB);
btnHistory.Enabled = false;
Form.CheckForIllegalCrossThreadCalls = false;
Instance = this;
}
public FrmGroupChat(XmppClient xmppClient, Jid roomJid, string nickname, ListView listContract)
{
InitializeComponent();
local_history = new HistoryTransactionTableAdapter();
connection = new SqlCeConnection(local_history.Connection.ConnectionString);
_roomJid = roomJid;
_xmppClient = xmppClient;
_nickname = nickname;
_listContract = listContract;
fm.XmppClient = FrmLogin.Instance.xmppClient;
fm.OnFile += fm_OnFile;
Text = roomJid.User + " Group"; ;
mm = new MucManager(xmppClient);
// Setup new Message Callback using the MessageFilter
_xmppClient.MessageFilter.Add(roomJid, new BareJidComparer(), MessageCallback);
// Setup new Presence Callback using the PresenceFilter
_xmppClient.PresenceFilter.Add(roomJid, new BareJidComparer(), PresenceCallback);
GetLastRow(_xmppClient.Username, _xmppClient.XmppDomain, _roomJid.Bare, out LastDtDB);
btnHistory.Enabled = false;
Form.CheckForIllegalCrossThreadCalls = false;
Instance = this;
}
private void InitGroupList()
{
DataTable dt = new DataTable();
HistoryTransactionTableAdapter local_history = new HistoryTransactionTableAdapter();
SqlCeConnection connection = new SqlCeConnection(local_history.Connection.ConnectionString);
connection.Open();
SqlCeDataAdapter adapter = new SqlCeDataAdapter(string.Format(@"Select GroupName from HistoryTransaction
where AccountName = '{0}' and ServerID = '{1}' and IsGroup = '{2}' Group By GroupName",
xmppClient.Username, xmppClient.XmppDomain, "1"), connection);
adapter.Fill(dt);
connection.Close();
foreach (DataRow item in dt.Rows)
{
if (item[0].ToString() != string.Empty)
{
Jid room = new Jid(item[0].ToString());
var newItem = new RosterListViewItem(room.User ?? room.Bare, 0, null)
{
Name = room.Bare
};
listBookmarkedRooms.Items.Add(newItem);
}
}
DiscoManager _dm = new DiscoManager(xmppClient);
_dm.DiscoverItems("conference." + FrmLogin.Instance.HostName, new EventHandler <IqEventArgs>(DiscoItemsResult));
}
private void resetDatabaseToolStripMenuItem_Click(object sender, System.EventArgs e)
{
string query = "DELETE FROM HistoryTransaction";
HistoryTransactionTableAdapter local_history = new HistoryTransactionTableAdapter();
SqlCeConnection connection = new SqlCeConnection(local_history.Connection.ConnectionString);
connection.Open();
var command = connection.CreateCommand();
command.CommandText = query;
command.ExecuteNonQuery();
connection.Close();
}
private void FrmHistoryTransaction_Load(object sender, System.EventArgs e)
{
DataTable dt = new DataTable();
HistoryTransactionTableAdapter local_history = new HistoryTransactionTableAdapter();
SqlCeConnection connection = new SqlCeConnection(local_history.Connection.ConnectionString);
connection.Open();
SqlCeDataAdapter adapter = new SqlCeDataAdapter(string.Format(@"Select Body, DateTime, PIC from HistoryTransaction
where AccountName = '{0}' and ServerID = '{1}' and GroupName = '{2}' and IsGroup = '{3}' ORDER BY DateTime ASC",
_xmppClient.Username, _xmppClient.XmppDomain, _roomJid.Bare, (_isGroup ? "1" : "0")), connection);
adapter.Fill(dt);
connection.Close();
DateTime dtTemp = new DateTime();
foreach (DataRow item in dt.Rows)
{
DateTime dTime = DateTime.Parse(item["DateTime"].ToString());
string decrypt = item["PIC"].ToString() + " said: " + Cryptography.RSA2.Decrypt(item["Body"].ToString());
if (dt.Rows.IndexOf(item) == 0)
{
dtTemp = dTime;
txtBox.SelectionColor = Color.Black;
txtBox.SelectionAlignment = HorizontalAlignment.Center;
txtBox.SelectionFont = new System.Drawing.Font(txtBox.Font, FontStyle.Bold);
txtBox.AppendText(dtTemp.ToLongDateString().ToString());
txtBox.AppendText("\r\n");
}
else if (dtTemp.Date.CompareTo(dTime.Date) != 0)
{
dtTemp = dTime;
txtBox.SelectionColor = Color.Black;
txtBox.SelectionAlignment = HorizontalAlignment.Center;
txtBox.SelectionFont = new System.Drawing.Font(txtBox.Font, FontStyle.Bold);
txtBox.AppendText(dtTemp.ToLongDateString().ToString());
txtBox.AppendText("\r\n");
}
txtBox.SelectionAlignment = HorizontalAlignment.Left;
txtBox.SelectionFont = new System.Drawing.Font(txtBox.Font, FontStyle.Regular);
txtBox.AppendText("(" + DateTime.Parse(item["DateTime"].ToString()).TimeOfDay.ToString() + ") " + decrypt);
txtBox.AppendText("\r\n");
}
}
private void FrmHistoryTransaction_Load(object sender, System.EventArgs e)
{
DataTable dt = new DataTable();
HistoryTransactionTableAdapter local_history = new HistoryTransactionTableAdapter();
SqlCeConnection connection = new SqlCeConnection(local_history.Connection.ConnectionString);
connection.Open();
SqlCeDataAdapter adapter = new SqlCeDataAdapter(string.Format(@"Select Body, DateTime, PIC from HistoryTransaction
where AccountName = '{0}' and ServerID = '{1}' and GroupName = '{2}' and IsGroup = '{3}' ORDER BY DateTime ASC",
_xmppClient.Username, _xmppClient.XmppDomain, _roomJid.Bare, (_isGroup ? "1" : "0")), connection);
adapter.Fill(dt);
connection.Close();
DateTime dtTemp = new DateTime();
foreach (DataRow item in dt.Rows)
{
DateTime dTime = DateTime.Parse(item["DateTime"].ToString());
string decrypt = item["PIC"].ToString() + " said: " + Cryptography.RSA2.Decrypt(item["Body"].ToString());
if (dt.Rows.IndexOf(item) == 0)
{
dtTemp = dTime;
txtBox.SelectionColor = Color.Black;
txtBox.SelectionAlignment = HorizontalAlignment.Center;
txtBox.SelectionFont = new System.Drawing.Font(txtBox.Font, FontStyle.Bold);
txtBox.AppendText(dtTemp.ToLongDateString().ToString());
txtBox.AppendText("\r\n");
}
else if (dtTemp.Date.CompareTo(dTime.Date) != 0)
{
dtTemp = dTime;
txtBox.SelectionColor = Color.Black;
txtBox.SelectionAlignment = HorizontalAlignment.Center;
txtBox.SelectionFont = new System.Drawing.Font(txtBox.Font, FontStyle.Bold);
txtBox.AppendText(dtTemp.ToLongDateString().ToString());
txtBox.AppendText("\r\n");
}
txtBox.SelectionAlignment = HorizontalAlignment.Left;
txtBox.SelectionFont = new System.Drawing.Font(txtBox.Font, FontStyle.Regular);
txtBox.AppendText("(" + DateTime.Parse(item["DateTime"].ToString()).TimeOfDay.ToString() + ") " + decrypt);
txtBox.AppendText("\r\n");
}
}
public FrmChat(Jid jid, XmppClient con, string nickname)
{
_jid = jid;
_xmppClient = con;
_nickname = nickname;
local_history = new HistoryTransactionTableAdapter();
connection = new SqlCeConnection(local_history.Connection.ConnectionString);
InitializeComponent();
Text = "Chat with " + nickname;
Util.ChatForms.Add(_jid.Bare.ToLower(), this);
// Setup new Message Callback
con.MessageFilter.Add(jid, new BareJidComparer(), OnMessage);
GetLastRow(_xmppClient.Username, _xmppClient.XmppDomain, _jid.Bare, out LastDtDB);
this.Load += new EventHandler(FrmChat_Load);
Instance = this;
Form.CheckForIllegalCrossThreadCalls = false;
}
public FrmChat(Jid jid, XmppClient con, string nickname)
{
_jid = jid;
_xmppClient = con;
_nickname = nickname;
local_history = new HistoryTransactionTableAdapter();
connection = new SqlCeConnection(local_history.Connection.ConnectionString);
InitializeComponent();
Text = "Chat with " + nickname;
Util.ChatForms.Add(_jid.Bare.ToLower(), this);
// Setup new Message Callback
con.MessageFilter.Add(jid, new BareJidComparer(), OnMessage);
GetLastRow(_xmppClient.Username, _xmppClient.XmppDomain, _jid.Bare, out LastDtDB);
this.Load += new EventHandler(FrmChat_Load);
Instance = this;
Form.CheckForIllegalCrossThreadCalls = false;
}
void FrmHistoryChat_Load(object sender, System.EventArgs e)
{
FrmParent.Instance.ShowLoading();
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
HistoryTransactionTableAdapter local_history = new HistoryTransactionTableAdapter();
SqlCeConnection connection = new SqlCeConnection(local_history.Connection.ConnectionString);
connection.Open();
SqlCeDataAdapter adapter = new SqlCeDataAdapter(string.Format(@"Select DateTime, convert(nvarchar(12), DateTime, 101) as Date,
convert(nvarchar(12), DateTime, 108) as Time, PIC, Body from HistoryTransaction
where AccountName = '{0}' and ServerID = '{1}' and GroupName = '{2}' and IsGroup = '{3}' ORDER BY DateTime ASC",
_xmppClient.Username, _xmppClient.XmppDomain, _roomJid.Bare, (_isGroup ? "1" : "0")), connection);
adapter.Fill(dt);
adapter = new SqlCeDataAdapter(string.Format(@"Select Distinct convert(nvarchar(12), DateTime, 101) as Date from HistoryTransaction
where AccountName = '{0}' and ServerID = '{1}' and GroupName = '{2}' and IsGroup = '{3}'",
_xmppClient.Username, _xmppClient.XmppDomain, _roomJid.Bare, (_isGroup ? "1" : "0")), connection);
adapter.Fill(dt1);
connection.Close();
foreach (DataRow item in dt.Rows)
{
item["Body"] = Cryptography.RSA2.Decrypt(item["Body"].ToString());
}
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dt1);
dataSet.Tables.Add(dt);
dataSet.Relations.Add("Content", dataSet.Tables[0].Columns["Date"],
dataSet.Tables[1].Columns["Date"]);
this.dgcHistoryChat.DataSource = dt1;
FrmParent.Instance.HideLoading();
}
private void resetDatabaseToolStripMenuItem_Click(object sender, System.EventArgs e)
{
string query = "DELETE FROM HistoryTransaction";
HistoryTransactionTableAdapter local_history = new HistoryTransactionTableAdapter();
SqlCeConnection connection = new SqlCeConnection(local_history.Connection.ConnectionString);
connection.Open();
var command = connection.CreateCommand();
command.CommandText = query;
command.ExecuteNonQuery();
connection.Close();
}
private void InitGroupList()
{
DataTable dt = new DataTable();
HistoryTransactionTableAdapter local_history = new HistoryTransactionTableAdapter();
SqlCeConnection connection = new SqlCeConnection(local_history.Connection.ConnectionString);
connection.Open();
SqlCeDataAdapter adapter = new SqlCeDataAdapter(string.Format(@"Select GroupName from HistoryTransaction
where AccountName = '{0}' and ServerID = '{1}' and IsGroup = '{2}' Group By GroupName",
xmppClient.Username, xmppClient.XmppDomain, "1"), connection);
adapter.Fill(dt);
connection.Close();
foreach (DataRow item in dt.Rows)
{
if (item[0].ToString() != string.Empty)
{
Jid room = new Jid(item[0].ToString());
var newItem = new RosterListViewItem(room.User ?? room.Bare, 0, null) { Name = room.Bare };
listBookmarkedRooms.Items.Add(newItem);
}
}
DiscoManager _dm = new DiscoManager(xmppClient);
_dm.DiscoverItems("conference." + FrmLogin.Instance.HostName, new EventHandler<IqEventArgs>(DiscoItemsResult));
}
