private void loadPage()
{
DataSet ds = dal.execDataSet("SELECT * FROM SimpleArticles WHERE nodeID = " + currentNode.Id);
if (ds.Tables[0].Rows.Count == 0)
{
//string sql = String.Format("INSERT INTO SimpleArticles (nodeID,title,body,dateCreated,dateModified,createdBy) VALUES ('{0}','{1}','{2}','{3}','{4}',{5})",currentNode.Id,"new page","new body",System.DateTime.Now,System.DateTime.Now,((UserIdentity)user.Identity).ID);
//dal.execNonQuery(sql);
DataContainer dc = new DataContainer("SimpleArticles");
DataRow dr = dc.GetNewRow();
dr["nodeID"] = currentNode.Id;
dr["title"] = "new page";
dr["body"] = "new body";
dr["dateCreated"] = System.DateTime.Now;
dr["dateModified"] = System.DateTime.Now;
dr["createdBy"] = ((UserIdentity)user.Identity).ID;
dc.AddNewRow(dr);
dc.Update();
Response.Redirect(Request.RawUrl);
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
title.Text = dr["title"].ToString();
content.Text = dr["body"].ToString();
templateCheck.Checked = (dr["showTemplate"] != System.DBNull.Value) ? (bool)dr["showTemplate"] : false;
publishCheck.Checked = (dr["publish"] != System.DBNull.Value) ? (bool)dr["publish"] : false;
}
}
private void addPage_Click(object sender, EventArgs e)
{
int currentPage = int.Parse(pageSelect.SelectedValue);
int newPageNumber = currentPage + 1;
// bump up other pages
insertPage(this.articleID, currentPage, languageSelect.SelectedValue);
DataContainer dc = new DataContainer(dbTable);
DataRow dr = dc.GetNewRow();
dr["articleID"] = articleID;
dr["templateID"] = 1;
dr["lang"] = languageSelect.SelectedValue;
dr["pageNumber"] = newPageNumber;
dr["title"] = "new article title";
dr["summary"] = "new summary";
dr["body"] = "new body";
dr["createdBy"] = ((UserIdentity)user.Identity).ID;
dr["editedBy"] = ((UserIdentity)user.Identity).ID;
dr["statusID"] = 1;
dr["publish"] = false;
dr["dateCreated"] = System.DateTime.Now;
dr["dateModified"] = System.DateTime.Now;
dc.AddNewRow(dr);
dc.Update();
//string sql = String.Format("INSERT INTO ArticleBodies (articleID, templateID, lang, pageNumber, title, summary, body, createdBy, editedBy, statusID, publish, dateCreated, dateModified) VALUES ( {0}, {1},'{2}',{3},'{4}','{5}','{6}',{7},{8},{9},{10},'{11}','{12}')",
//this.dal.execNonQuery(sql);
fillPageSelect();
loadPage(newPageNumber);
msg.Text = "<nobr>new page added</nobr>";
}
private void loadPage()
{
DataSet ds = dal.execDataSet("SELECT * FROM Links WHERE nodeID = " + currentNode.Id);
if (ds.Tables[0].Rows.Count == 0)
{
//string sql = String.Format("INSERT INTO Links (nodeID,linkURL,publish,dateCreated,dateModified,createdBy,editedBy) VALUES ({0},'{1}',{2},'{3}','{4}',{5},{6})",currentNode.Id,"http://www.somewhere.com",1,System.DateTime.Now,System.DateTime.Now,((UserIdentity)user.Identity).ID,((UserIdentity)user.Identity).ID);
//dal.execNonQuery(sql);
DataContainer dc = new DataContainer("Links");
DataRow dr = dc.GetNewRow();
dr["nodeID"] = currentNode.Id;
dr["linkURL"] = "http://www.somewhere.com";
dr["publish"] = true;
dr["dateCreated"] = System.DateTime.Now;
dr["dateModified"] = System.DateTime.Now;
dr["createdBy"] = ((UserIdentity)user.Identity).ID;
dr["editedBy"] = ((UserIdentity)user.Identity).ID;
dc.AddNewRow(dr);
dc.Update();
Response.Redirect(Request.RawUrl);
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
url.Text = dr["linkURL"].ToString();
publish.Checked = (dr["publish"] != null) ? (bool)dr["publish"] : false;
}
}
private void createArticleMain()
{
DataContainer dc = new DataContainer("sf_Articles");
DataRow dr = dc.GetNewRow();
dr["nodeID"] = currentNode.Id;
dr["statusID"] = 1;
dr["lang"] = newLanguage.Text;
dr["createdBy"] = ((UserIdentity)user.Identity).ID;
dr["editedBy"] = ((UserIdentity)user.Identity).ID;
dr["dateCreated"] = System.DateTime.Now;
dr["dateModified"] = System.DateTime.Now;
dc.AddNewRow(dr);
dc.Update();
DataRow dr1 = dc.GetRowByCustomSql("SELECT id FROM sf_Articles WHERE lang = '" + newLanguage.Text + "' AND nodeID = " + currentNode.Id);
this.articleID = (int)dr1["id"];
createArticlePage(1);
}
private void createArticlePage(int pageNumber)
{
DataContainer dc = new DataContainer(dbTable);
DataRow dr = dc.GetNewRow();
dr["articleID"] = articleID;
dr["templateID"] = 1;
dr["versionNumber"] = 1;
dr["pageNumber"] = pageNumber;
dr["title"] = "new article page title";
dr["summary"] = "new summary";
dr["keywords"] = "new keywords";
dr["body"] = "new body";
dr["createdBy"] = ((UserIdentity)user.Identity).ID;
dr["editedBy"] = ((UserIdentity)user.Identity).ID;
dr["publish"] = false;
dr["preview"] = false;
dr["dateCreated"] = System.DateTime.Now;
dr["dateModified"] = System.DateTime.Now;
dc.AddNewRow(dr);
dc.Update();
}
