/// <summary> /// Returns the count of tables /// </summary> /// <returns></returns> public int GetRecordCount(Epi2000.View view) { try { #region Input Validation if (view == null) { throw new System.ArgumentNullException("view"); } #endregion Input Validation string qryString = " select count(*) from " + db.InsertInEscape(view.TableNames[0]); Query query = db.CreateQuery(qryString); return(Int32.Parse((db.ExecuteScalar(query)).ToString())); } catch (Exception ex) { throw new ApplicationException("Could not retrieve record count.", ex); //TODO: move to shared strings } finally { } }
/// <summary> /// Method LoadViews() /// </summary> //protected override void LoadViews() public void LoadViews() { this.views = new Collection <View>(); System.Collections.Hashtable RelatedViews = new System.Collections.Hashtable(); DataTable viewsTable = GetViewsAsDataTable(); foreach (DataRow viewRow in viewsTable.Rows) { View V = new Epi2000.View(viewRow, this); // set the is related view attribute IDataReader R = this.collectedData.GetTableDataReader(V.Name); while (R.Read()) { if (R["Name"].ToString().ToUpperInvariant().StartsWith("RELVIEW")) { if (!RelatedViews.ContainsKey(R["DataTable"].ToString())) { RelatedViews.Add(R["DataTable"].ToString(), R["DataTable"].ToString()); } } } R.Close(); this.views.Add(V); } foreach (Epi2000.View V in this.views) { if (RelatedViews.ContainsKey(V.Name)) { V.IsRelatedView = true; } } }