private static int CreateNewSite(IDnaDataReader reader, string urlname)
{
string sql = @"exec createnewsite @urlname = '"+urlname+"',"+
"@shortname = '"+urlname+"',"+
"@description = '"+urlname+"',"+
"@defaultskin = 'default',"+
"@skindescription = '',"+
"@skinset ='boards',"+
"@useframes =0,"+
"@premoderation = 0,"+
"@noautoswitch =0,"+
"@customterms = 0,"+
"@moderatorsemail = '[email protected]',"+
"@editorsemail = '[email protected]',"+
"@feedbackemail = '[email protected]',"+
"@automessageuserid = 245,"+
"@passworded = 0,"+
"@unmoderated = 0,"+
"@articleforumstyle =0,"+
"@threadorder =1,"+
"@threadedittimelimit = 0,"+
"@eventemailsubject = '',"+
"@eventalertmessageuserid = 254,"+
"@includecrumbtrail = 0,"+
"@allowpostcodesinsearch = 0,"+
"@ssoservice = null,"+
"@siteemergencyclosed = 0,"+
"@allowremovevote = 0,"+
"@queuepostings = 0,"+
"@modclassid = 1,"+
"@identitypolicy = 'http://identity/policies/dna/adult'";
reader.ExecuteDEBUGONLY(sql);
reader.Read();
int siteid = reader.GetInt32("siteid");
return siteid;
}
private static bool SiteExists(IDnaDataReader reader,string urlname)
{
using (IDnaDataReader r = reader.ExecuteDEBUGONLY("select * from sites where urlname='"+urlname+"'"))
{
while (r.Read())
{
if (r.GetString("urlname") == urlname)
return true;
}
}
return false;
}
private void SetSiteID(IDnaDataReader dataReader, String urlname)
{
dataReader.ExecuteDEBUGONLY("select siteid from sites where urlname='" + urlname + "'");
if (dataReader.Read())
{
_siteId = dataReader.GetInt32("SiteID");
}
else
{
Assert.Fail("Unable to read the Sites table");
}
}
private void SetForumID(IDnaDataReader dataReader)
{
dataReader.ExecuteDEBUGONLY("select forumid from forums where canread = 1 and canwrite=1 and siteid =" + Convert.ToString(_siteId) );
if (dataReader.Read())
{
_forumId = dataReader.GetInt32("ForumID");
}
else
{
Assert.Fail("Unable to find a forum for site");
}
}
private void ReadTopDateRangeRecord(IDnaDataReader dataReader, ref DateRangeInfo drInfo)
{
dataReader.ExecuteDEBUGONLY("select top 1 * from articledaterange order by entryid desc");
if (dataReader.Read())
{
drInfo.entryId= dataReader.GetInt32("EntryID");
drInfo.startDate = dataReader.GetDateTime("StartDate");
drInfo.endDate = dataReader.GetDateTime("EndDate");
drInfo.timeIntervalNull = dataReader.IsDBNull("TimeInterval");
if (!drInfo.timeIntervalNull)
{
drInfo.timeInterval = dataReader.GetInt32("TimeInterval");
}
}
else
{
Assert.Fail("Unable to read the ArticleDateRange table");
}
}