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