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(); }