public List <StorageMessageArchiveUsers> GetMessageArchiveUsers()
{
if (this.mDatabaseConnection.State != System.Data.ConnectionState.Open)
{
this.mDatabaseConnection.Open();
}
DataSet ds = new DataSet();
List <StorageMessageArchiveUsers> list = new List <StorageMessageArchiveUsers>();
try
{
FbDataAdapter fbda = new FbDataAdapter("MESSAGE_ARCHIVE_USERS", this.mDatabaseConnection);
fbda.SelectCommand.CommandType = CommandType.StoredProcedure;
fbda.SelectCommand.Parameters.Add("@iUSER_ID", this.mUserID);
fbda.Fill(ds, "TABLE");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
StorageMessageArchiveUsers item = new StorageMessageArchiveUsers();
item.JID = row[0].ToString();
item.Direction = row[1].ToString() == "IN" ? StorageItemDirection.In : StorageItemDirection.Out;
item.Created = row[2].ToString();
list.Add(item);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Storage - GetMessageArchiveUsers : " + ex.Message);
}
return(list);
}
public List<StorageMessageArchiveUsers> GetMessageArchiveUsers()
{
if (this.mDatabaseConnection.State != System.Data.ConnectionState.Open)
{
this.mDatabaseConnection.Open();
}
DataSet ds = new DataSet();
List<StorageMessageArchiveUsers> list = new List<StorageMessageArchiveUsers>();
try
{
FbDataAdapter fbda = new FbDataAdapter("MESSAGE_ARCHIVE_USERS", this.mDatabaseConnection);
fbda.SelectCommand.CommandType = CommandType.StoredProcedure;
fbda.SelectCommand.Parameters.Add("@iUSER_ID", this.mUserID);
fbda.Fill(ds, "TABLE");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
StorageMessageArchiveUsers item = new StorageMessageArchiveUsers();
item.JID = row[0].ToString();
item.Direction = row[1].ToString() == "IN" ? StorageItemDirection.In : StorageItemDirection.Out;
item.Created = row[2].ToString();
list.Add(item);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Storage - GetMessageArchiveUsers : " + ex.Message);
}
return list;
}
