//returns the all "rows" found in database
public Dictionary <string, MetaAdmRow> GetMetaAdmAllRows()
{
string sqlString = GetMetaAdm_SQLString_NoWhere();
Dictionary <string, MetaAdmRow> myOut = new Dictionary <string, MetaAdmRow>();
DataSet ds = mSqlCommand.ExecuteSelect(sqlString, null);
DataRowCollection myRows = ds.Tables[0].Rows;
if (myRows.Count < 1)
{
throw new PCAxis.Sql.Exceptions.DbException(44, "MetaAdm", "METAADM");
}
foreach (DataRow sqlRow in myRows)
{
MetaAdmRow outRow = new MetaAdmRow(sqlRow, DB);
myOut.Add(outRow.Property, outRow);
}
return(myOut);
}
//returns the single "row" found when all PKs are spesified
public MetaAdmRow GetMetaAdmRow(string aProperty)
{
//SqlDbConfig dbconf = DB;
string sqlString = GetMetaAdm_SQLString_NoWhere();
sqlString += " WHERE " + DB.MetaAdm.PropertyCol.IsUppered(mSqlCommand.GetParameterRef("aProperty"));
// creating the parameters
System.Data.Common.DbParameter[] parameters = new System.Data.Common.DbParameter[1];
parameters[0] = mSqlCommand.GetStringParameter("aProperty", aProperty);
DataSet ds = mSqlCommand.ExecuteSelect(sqlString, parameters);
DataRowCollection myRows = ds.Tables[0].Rows;
if (myRows.Count != 1)
{
throw new PCAxis.Sql.Exceptions.DbException(36, " Property = " + aProperty);
}
MetaAdmRow myOut = new MetaAdmRow(myRows[0], DB);
return(myOut);
}