public string header_update()
{
var pars = Request.Params;
string header = pars["header"];
string headerid = pars["headerid"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhost"].ConnectionString);
db.exec(string.Format("update sandbox.header set label='{0}' where id='{1}'", header,headerid));
return "";
}
public string header_savenew()
{
var pars=Request.Params;
string header=pars["header"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhost"].ConnectionString);
db.exec(string.Format("insert into sandbox.header (label) values('{0}')",header));
return "";
}
public string headercontent_update()
{
var pars = Request.Params;
string headerid = pars["headerid"];
string url = pars["viewurl"];
string content = pars["description"];
string label = pars["label"];
string contentid = pars["contentid"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhost"].ConnectionString);
db.exec(string.Format("update sandbox.content set content='{0}' ,label = '{1}', viewurl ='{2}' where id='{3}';"
, content, label, url,contentid));
db.exec(string.Format("update sandbox.headercontent set headerID='{0}' where contentID='{1}'"
, headerid, contentid));
return "";
}
public string header_delete()
{
var pars = Request.Params;
string headerid = pars["headerid"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhost"].ConnectionString);
db.exec(string.Format("delete from sandbox.header where ID='{0}'", headerid));
return "";
}
public string headercontent_savenew()
{
var pars = Request.Params;
string headerid = pars["headerid"];
string url = pars["viewurl"];
string content = pars["description"];
string label = pars["label"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhost"].ConnectionString);
DataTable dt1 = db.fetch(string.Format("insert into sandbox.content (content,label,viewurl) values('{0}','{1}','{2}');select SCOPE_IDENTITY();", content, label, url)).Tables[0];
var contentid = dt1.Rows[0][0].ToString();
db.exec(string.Format("insert into sandbox.headercontent (headerId,contentid) values('{0}','{1}')", headerid, contentid));
return "";
}