public void Dispose()
{
if (_sqlCmd != null)
{
_resultSet.Dispose();
_sqlCmd.Dispose();
_record = null;
_resultSet = null;
_sqlCmd = null;
}
}
private void SaveHistory()
{
StringBuilder q = new StringBuilder();
connection.Open();
var transaction = connection.BeginTransaction();
SqlCeCommand sqlCeCommand = connection.CreateCommand();
sqlCeCommand.CommandType = CommandType.TableDirect;
sqlCeCommand.CommandText = "HistoryTransaction";
sqlCeCommand.Transaction = transaction;
SqlCeResultSet result = sqlCeCommand.ExecuteResultSet(ResultSetOptions.Updatable);
SqlCeUpdatableRecord rec = result.CreateRecord();
foreach (DataRow item in dtHistory.Rows)
{
string encrypt = Cryptography.RSA2.Encrypt(item["Body"].ToString());
// q.Append(@"INSERT INTO [HistoryTransaction] ([IsGroup], [AccountName],
// [ServerID], [GroupName], [Body], [DateTime], [PIC]) VALUES ");
// q.AppendFormat("({0}, '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')",
// 1, _xmppClient.Username, _xmppClient.XmppDomain,
// _roomJid.Bare, encrypt, DateTime.Parse(item["Body"].ToString()), item["PIC"].ToString());
rec.SetValue(1, 1);
rec.SetValue(2, _xmppClient.Username);
rec.SetValue(3, _xmppClient.XmppDomain);
rec.SetValue(4, _roomJid.Bare);
rec.SetValue(5, encrypt);
rec.SetValue(6, DateTime.Parse(item["DateTime"].ToString()));
rec.SetValue(7, item["PIC"].ToString());
result.Insert(rec);
}
result.Close();
result.Dispose();
transaction.Commit();
connection.Close();
}
/// <summary>
/// Releases resources
/// </summary>
public override void Dispose()
{
_resultSet.Dispose();
}