public List <StorageMessage> GetMessageFromArchiveByDate(string jid, string search, int limit, string date)
{
if (this.mDatabaseConnection.State != System.Data.ConnectionState.Open)
{
this.mDatabaseConnection.Open();
}
DataSet ds = new DataSet();
List <StorageMessage> list = new List <StorageMessage>();
try
{
FbDataAdapter fbda = new FbDataAdapter("MESSAGE_FIND_BY_DATE", this.mDatabaseConnection);
fbda.SelectCommand.CommandType = CommandType.StoredProcedure;
fbda.SelectCommand.Parameters.Add("@iUSER_ID", this.mUserID);
fbda.SelectCommand.Parameters.Add("@iJID", jid.Trim());
fbda.SelectCommand.Parameters.Add("@iSEARCH", "%" + search.Trim('%') + "%");
fbda.SelectCommand.Parameters.Add("@iLIMIT", limit);
fbda.SelectCommand.Parameters.Add("@iDATE", date);
fbda.Fill(ds, "TABLE");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
StorageMessage item = new StorageMessage();
item.JID = row[0].ToString();
item.ContentText = row[1].ToString();
item.ContentHTML = row[2].ToString();
item.Direction = row[3].ToString() == "IN" ? StorageItemDirection.In : StorageItemDirection.Out;
item.Created = (DateTime)row[4];
list.Add(item);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Storage - GetMessageFromArchiveByDate : " + ex.Message);
}
return(list);
}
private TcpPackage WrapCommitAck(StorageMessage.CommitAck msg)
{
var dto = new ReplicationMessageDto.CommitAck(msg.LogPosition, msg.TransactionPosition, msg.FirstEventNumber, msg.LastEventNumber);
return new TcpPackage(TcpCommand.CommitAck, msg.CorrelationId, dto.Serialize());
}
public List<StorageMessage> GetMessageFromArchiveByDate(string jid, string search, int limit, string date)
{
if (this.mDatabaseConnection.State != System.Data.ConnectionState.Open)
{
this.mDatabaseConnection.Open();
}
DataSet ds = new DataSet();
List<StorageMessage> list = new List<StorageMessage>();
try
{
FbDataAdapter fbda = new FbDataAdapter("MESSAGE_FIND_BY_DATE", this.mDatabaseConnection);
fbda.SelectCommand.CommandType = CommandType.StoredProcedure;
fbda.SelectCommand.Parameters.Add("@iUSER_ID", this.mUserID);
fbda.SelectCommand.Parameters.Add("@iJID", jid.Trim());
fbda.SelectCommand.Parameters.Add("@iSEARCH", "%" + search.Trim('%') + "%");
fbda.SelectCommand.Parameters.Add("@iLIMIT", limit);
fbda.SelectCommand.Parameters.Add("@iDATE", date);
fbda.Fill(ds, "TABLE");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
StorageMessage item = new StorageMessage();
item.JID = row[0].ToString();
item.ContentText = row[1].ToString();
item.ContentHTML = row[2].ToString();
item.Direction = row[3].ToString() == "IN" ? StorageItemDirection.In : StorageItemDirection.Out;
item.Created = (DateTime)row[4];
list.Add(item);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Storage - GetMessageFromArchiveByDate : " + ex.Message);
}
return list;
}
private TcpPackage WrapPrepareAck(StorageMessage.PrepareAck msg)
{
var dto = new ReplicationMessageDto.PrepareAck(msg.LogPosition, (byte)msg.Flags);
return new TcpPackage(TcpCommand.PrepareAck, msg.CorrelationId, dto.Serialize());
}
