public List <StorageMessageDate> GetMessageDatesFromArchive(string jid, string search, int limit)
{
if (this.mDatabaseConnection.State != System.Data.ConnectionState.Open)
{
this.mDatabaseConnection.Open();
}
DataSet ds = new DataSet();
List <StorageMessageDate> list = new List <StorageMessageDate>();
try
{
FbDataAdapter fbda = new FbDataAdapter("MESSAGE_DATES_FIND", 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.Fill(ds, "TABLE");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
StorageMessageDate date = new StorageMessageDate();
date.Day = row[0].ToString();
date.Date = (DateTime)row[1];
date.DaysAway = 0;
Int32.TryParse(row[2].ToString(), out date.DaysAway);
list.Add(date);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Storage - GetMessageDatesFromArchive : " + ex.Message);
}
return(list);
}
public List<StorageMessageDate> GetMessageDatesFromArchive(string jid, string search, int limit)
{
if (this.mDatabaseConnection.State != System.Data.ConnectionState.Open)
{
this.mDatabaseConnection.Open();
}
DataSet ds = new DataSet();
List<StorageMessageDate> list = new List<StorageMessageDate>();
try
{
FbDataAdapter fbda = new FbDataAdapter("MESSAGE_DATES_FIND", 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.Fill(ds, "TABLE");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
StorageMessageDate date = new StorageMessageDate();
date.Day = row[0].ToString();
date.Date = (DateTime)row[1];
date.DaysAway = 0;
Int32.TryParse(row[2].ToString(), out date.DaysAway);
list.Add(date);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Storage - GetMessageDatesFromArchive : " + ex.Message);
}
return list;
}
