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; }