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 void reset()
{
sqlServer db = new sqlServer("server=s06.winhost.com;database=DB_40114_codeclub;uid=DB_40114_codeclub_user;pwd=p0$31d0n;");
db.exec("[Accounting].[resetSeeds]");
var cur_ca = new accounting.classes.Currency();
cur_ca.create("CAD", (int)accounting.classes.enums.currencyType.Real);
}
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 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 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 JsonResult json_deleteTopic()
{
var pars = Request.Params;
string topic_id = pars["topic_id"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString);
db.exec("update saeid.topic set is_active=0 , datetime='" + DateTime.Now.Ticks + "' where topic_id=" + topic_id);
return(Json(new { result = "Done" }, JsonRequestBehavior.AllowGet));
}
public JsonResult json_createNewTopic()
{
var pars = Request.Params;
string topic_parent_id = pars["foldering_editPanel_id"];
string topic_title = pars["foldering_editPanel_title"];
string topic_details = pars["foldering_editPanel_detail"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString);
if (topic_parent_id == "")
{
db.exec("insert into saeid.topic (topic_title,topic_details,datetime)values("
+"'" + topic_title + "','" + topic_details + "','" + DateTime.Now.Ticks + "')");
}
else
{
db.exec("insert into saeid.topic (topic_parent_id,topic_title,topic_details,datetime)values("
+ topic_parent_id + ",'" + topic_title + "','" + topic_details + "','" + DateTime.Now.Ticks + "')");
}
return Json(new { result = "Done" }, JsonRequestBehavior.AllowGet);
}
public JsonResult json_createNewTopic()
{
var pars = Request.Params;
string topic_parent_id = pars["foldering_editPanel_id"];
string topic_title = pars["foldering_editPanel_title"];
string topic_details = pars["foldering_editPanel_detail"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString);
if (topic_parent_id == "")
{
db.exec("insert into saeid.topic (topic_title,topic_details,datetime)values("
+ "'" + topic_title + "','" + topic_details + "','" + DateTime.Now.Ticks + "')");
}
else
{
db.exec("insert into saeid.topic (topic_parent_id,topic_title,topic_details,datetime)values("
+ topic_parent_id + ",'" + topic_title + "','" + topic_details + "','" + DateTime.Now.Ticks + "')");
}
return(Json(new { result = "Done" }, JsonRequestBehavior.AllowGet));
}
public JsonResult json_saveSelectedTopic()
{
var pars = Request.Params;
string topic_id = pars["foldering_editPanel_id"];
string topic_title = pars["foldering_editPanel_title"];
string topic_details = pars["foldering_editPanel_detail"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString);
db.exec("update saeid.topic set topic_title='" + topic_title + "' , topic_details='" + topic_details + "',datetime='" + DateTime.Now.Ticks + "' where topic_id=" + topic_id);
return(Json(new { result = DateTime.Now.Ticks }, JsonRequestBehavior.AllowGet));
}
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("");
}
public JsonResult json_saveOrdering()
{
var pars = Request.Params;
string[] ordering = pars["newOrdering"].Split('-');
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString);
foreach (var item in ordering)
{
string parentId = item.Split(',')[0];
string id = item.Split(',')[1];
db.exec("update saeid.topic set topic_parent_id=" + ((parentId == "") ? null : "'" + parentId + "'") + " , datetime='" + DateTime.Now.Ticks + "' where topic_id=" + id);
}
return(Json(new { result = "Done" }, JsonRequestBehavior.AllowGet));
}
public JsonResult json_deleteTopic()
{
var pars = Request.Params;
string topic_id = pars["topic_id"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString);
db.exec("update saeid.topic set is_active=0 , datetime='" + DateTime.Now.Ticks + "' where topic_id=" + topic_id);
return Json(new { result = "Done" }, JsonRequestBehavior.AllowGet);
}
public JsonResult json_saveSelectedTopic()
{
var pars = Request.Params;
string topic_id = pars["foldering_editPanel_id"];
string topic_title = pars["foldering_editPanel_title"];
string topic_details = pars["foldering_editPanel_detail"];
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString);
db.exec("update saeid.topic set topic_title='" + topic_title + "' , topic_details='" + topic_details + "',datetime='" + DateTime.Now.Ticks + "' where topic_id=" + topic_id);
return Json(new { result = DateTime.Now.Ticks }, JsonRequestBehavior.AllowGet);
}
public JsonResult json_saveOrdering()
{
var pars = Request.Params;
string[] ordering = pars["newOrdering"].Split('-');
sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString);
foreach (var item in ordering)
{
string parentId = item.Split(',')[0];
string id = item.Split(',')[1];
db.exec("update saeid.topic set topic_parent_id=" + ((parentId == "") ? null : "'" + parentId + "'") + " , datetime='" + DateTime.Now.Ticks + "' where topic_id=" + id);
}
return Json(new { result = "Done" }, JsonRequestBehavior.AllowGet);
}
