public ArrayList GetMeetingIDs(enuMeetingState state) { ArrayList lstMeetings = new ArrayList(); OdbcDataReader dr = null; try { StringBuilder strQueryBuilder = new StringBuilder(); strQueryBuilder.Append(" SELECT "); strQueryBuilder.Append(Constants.MTG_ID); strQueryBuilder.Append(" FROM "); strQueryBuilder.Append(Constants.MEETINGS_TABLENAME); strQueryBuilder.Append(" WHERE "); strQueryBuilder.Append(Constants.MTG_STATE); strQueryBuilder.Append("="); strQueryBuilder.Append("'" + QueryService.MakeQuotesafe(state.ToString()) + "'"); dr = QueryService.ExecuteReader(this.DBConnect, strQueryBuilder.ToString()); if (dr == null) { throw new Exception("Null data reader returned from query"); } // Scroll thru list returned while (dr.Read()) { // Add participant to list lstMeetings.Add((string)dr[Constants.MTG_ID]); } } catch (Exception /*e*/) { } finally { if (dr != null) { dr.Close(); } } return(lstMeetings); }
public bool UpdateMeetingState(string strMeetingID, enuMeetingState state) { // Quick error checks if (strMeetingID == null || strMeetingID.Length == 0) { throw new ArgumentException("Invalid meeting ID", "strMeetingID"); } bool bRetVal = false; try { StringBuilder strQueryBuilder = new StringBuilder(); strQueryBuilder.Append(" UPDATE "); strQueryBuilder.Append(Constants.MEETINGS_TABLENAME); strQueryBuilder.Append(" SET "); strQueryBuilder.Append(Constants.MTG_STATE); strQueryBuilder.Append("="); strQueryBuilder.Append("'" + state.ToString() + "'"); strQueryBuilder.Append(" WHERE "); strQueryBuilder.Append(Constants.MTG_ID); strQueryBuilder.Append("="); strQueryBuilder.Append("'" + QueryService.MakeQuotesafe(strMeetingID) + "'"); int nRowsAffected = QueryService.ExecuteNonQuery(this.DBConnect, strQueryBuilder.ToString()); if (nRowsAffected == 1) { bRetVal = true; } } catch (Exception /*e*/) { } finally { } return(bRetVal); }