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