public void LoadBasicData()
{
CheckDisposed();
int hvoPhm_17_21 = 0;
IOleDbCommand odc = null;
try
{
m_fdoCache.DatabaseAccessor.CreateCommand(out odc);
string sSql = @"select id from StTxtPara_ " +
@"where Owner$ = (select dst from scrsection_content c " +
@"join scrSection s on c.src = s.id " +
@"where s.VerseRefStart = 57001001) " +
@"and substring(contents, 1, 2) = '17'";
odc.ExecCommand(sSql,
(int)SqlStmtType.knSqlStmtSelectWithOneRowset);
odc.GetRowset(0);
bool fMoreRows;
odc.NextRow(out fMoreRows);
if (fMoreRows)
odc.GetInt(1, out hvoPhm_17_21);
}
finally
{
DbOps.ShutdownODC(ref odc);
}
// SqlConnection sqlConMaster = new SqlConnection(
// string.Format("Server={0}; Database={1};" +
// "User ID = sa; Password=inscrutable; Pooling=false;",
// m_fdoCache.ServerName, m_fdoCache.DatabaseName));
// sqlConMaster.Open();
// SqlCommand sqlComm = sqlConMaster.CreateCommand();
// // Select the hvo of the paragraph containing Philemon 17-21.
// string sSql = @"select id from StTxtPara_ " +
// @"where Owner$ = (select dst from scrsection_content c " +
// @"join scrSection s on c.src = s.id " +
// @"where s.VerseRefStart = 57001001) " +
// @"and substring(contents, 1, 2) = '17'";
// sqlComm.CommandText = sSql;
// SqlDataReader sqlreader =
// sqlComm.ExecuteReader(System.Data.CommandBehavior.SingleResult);
// if (sqlreader.Read())
// hvoPhm_17_21 = sqlreader.GetInt32(0);
//
// sqlreader.Close();
// sqlreader = null;
// sqlComm.Dispose();
// sqlComm = null;
// sqlConMaster.Close();
// sqlConMaster.Dispose();
// sqlConMaster = null;
Assert.IsTrue(hvoPhm_17_21 > 0);
NewStPara.s_fPopCalledInNewStPara = false;
m_fdoCache.VwCacheDaAccessor.ClearInfoAbout(hvoPhm_17_21,
VwClearInfoAction.kciaRemoveObjectInfoOnly);
NewStPara para = new NewStPara(m_fdoCache, hvoPhm_17_21);
Assert.IsTrue(NewStPara.s_fPopCalledInNewStPara,
"PopulateCsBasic wasn't called in NewStPara");
Assert.IsNotNull(para.Contents, "Contents of NewStPara is null");
DerivedStTxtPara2.s_fPopCalledInNewStPara = false;
DerivedStTxtPara2.s_fPopCalledInDerived = false;
m_fdoCache.VwCacheDaAccessor.ClearInfoAbout(hvoPhm_17_21,
VwClearInfoAction.kciaRemoveObjectInfoOnly);
DerivedStTxtPara2 para2 = new DerivedStTxtPara2(m_fdoCache, hvoPhm_17_21);
Assert.IsFalse(DerivedStTxtPara2.s_fPopCalledInNewStPara,
"PopulateCsBasic was called in NewStPara instead of DerivedStTxtPara2");
Assert.IsTrue(DerivedStTxtPara2.s_fPopCalledInDerived,
"PoplulateCsBasic wasn't called in DerviedStTxtPara2");
Assert.IsNotNull(para.Contents, "Contents of DerivedStTxtPara2 is null");
DerivedStTxtPara.s_fPopCalledInNewStPara = false;
m_fdoCache.VwCacheDaAccessor.ClearInfoAbout(hvoPhm_17_21,
VwClearInfoAction.kciaRemoveObjectInfoOnly);
DerivedStTxtPara para3 = new DerivedStTxtPara(m_fdoCache, hvoPhm_17_21);
Assert.IsTrue(DerivedStTxtPara.s_fPopCalledInNewStPara,
"PoplulateCsBasic wasn't called in DerviedStTxtPara");
Assert.IsNotNull(para.Contents, "Contents of DerivedStTxtPara is null");
}
public void LoadBasicData()
{
CheckDisposed();
int hvoPhm_17_21 = 0;
IOleDbCommand odc = null;
try
{
m_fdoCache.DatabaseAccessor.CreateCommand(out odc);
string sSql = @"select id from StTxtPara_ " +
@"where Owner$ = (select dst from scrsection_content c " +
@"join scrSection s on c.src = s.id " +
@"where s.VerseRefStart = 57001001) " +
@"and substring(contents, 1, 2) = '17'";
odc.ExecCommand(sSql,
(int)SqlStmtType.knSqlStmtSelectWithOneRowset);
odc.GetRowset(0);
bool fMoreRows;
odc.NextRow(out fMoreRows);
if (fMoreRows)
{
odc.GetInt(1, out hvoPhm_17_21);
}
}
finally
{
DbOps.ShutdownODC(ref odc);
}
// SqlConnection sqlConMaster = new SqlConnection(
// string.Format("Server={0}; Database={1};" +
// "User ID = sa; Password=inscrutable; Pooling=false;",
// m_fdoCache.ServerName, m_fdoCache.DatabaseName));
// sqlConMaster.Open();
// SqlCommand sqlComm = sqlConMaster.CreateCommand();
// // Select the hvo of the paragraph containing Philemon 17-21.
// string sSql = @"select id from StTxtPara_ " +
// @"where Owner$ = (select dst from scrsection_content c " +
// @"join scrSection s on c.src = s.id " +
// @"where s.VerseRefStart = 57001001) " +
// @"and substring(contents, 1, 2) = '17'";
// sqlComm.CommandText = sSql;
// SqlDataReader sqlreader =
// sqlComm.ExecuteReader(System.Data.CommandBehavior.SingleResult);
// if (sqlreader.Read())
// hvoPhm_17_21 = sqlreader.GetInt32(0);
//
// sqlreader.Close();
// sqlreader = null;
// sqlComm.Dispose();
// sqlComm = null;
// sqlConMaster.Close();
// sqlConMaster.Dispose();
// sqlConMaster = null;
Assert.IsTrue(hvoPhm_17_21 > 0);
NewStPara.s_fPopCalledInNewStPara = false;
m_fdoCache.VwCacheDaAccessor.ClearInfoAbout(hvoPhm_17_21,
VwClearInfoAction.kciaRemoveObjectInfoOnly);
NewStPara para = new NewStPara(m_fdoCache, hvoPhm_17_21);
Assert.IsTrue(NewStPara.s_fPopCalledInNewStPara,
"PopulateCsBasic wasn't called in NewStPara");
Assert.IsNotNull(para.Contents, "Contents of NewStPara is null");
DerivedStTxtPara2.s_fPopCalledInNewStPara = false;
DerivedStTxtPara2.s_fPopCalledInDerived = false;
m_fdoCache.VwCacheDaAccessor.ClearInfoAbout(hvoPhm_17_21,
VwClearInfoAction.kciaRemoveObjectInfoOnly);
DerivedStTxtPara2 para2 = new DerivedStTxtPara2(m_fdoCache, hvoPhm_17_21);
Assert.IsFalse(DerivedStTxtPara2.s_fPopCalledInNewStPara,
"PopulateCsBasic was called in NewStPara instead of DerivedStTxtPara2");
Assert.IsTrue(DerivedStTxtPara2.s_fPopCalledInDerived,
"PoplulateCsBasic wasn't called in DerviedStTxtPara2");
Assert.IsNotNull(para.Contents, "Contents of DerivedStTxtPara2 is null");
DerivedStTxtPara.s_fPopCalledInNewStPara = false;
m_fdoCache.VwCacheDaAccessor.ClearInfoAbout(hvoPhm_17_21,
VwClearInfoAction.kciaRemoveObjectInfoOnly);
DerivedStTxtPara para3 = new DerivedStTxtPara(m_fdoCache, hvoPhm_17_21);
Assert.IsTrue(DerivedStTxtPara.s_fPopCalledInNewStPara,
"PoplulateCsBasic wasn't called in DerviedStTxtPara");
Assert.IsNotNull(para.Contents, "Contents of DerivedStTxtPara is null");
}
