public ActionResult getListings() { sqlServer db = new sqlServer(connString); var listings = db.fetch("exec realestate.getListings").Tables[0].AsEnumerable(); ViewBag.data = listings; return PartialView("index1/listings"); }
public static organization getOrgDetails(string org_id) { sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString); DataTable dt = db.fetch("select * from organization where org_id=" + org_id).Tables[0]; organization data = new organization(); data = new organization() { org_id = dt.Rows[0][0].ToString(), parent_org_id = dt.Rows[0][1].ToString(), org_name = dt.Rows[0][2].ToString(), street = dt.Rows[0][3].ToString(), city = dt.Rows[0][4].ToString(), postalcode = dt.Rows[0][5].ToString() }; return data; }
public object getTransactions() { string connString = "server=s06.winhost.com;uid=DB_40114_codeclub_user;pwd=p0$31d0n;database=DB_40114_codeclub"; sqlServer db = new sqlServer(connString); var data = db.fetch("select * from accounting.categoryType ct " + "inner join accounting.gltype t on t.id=ct.glTypeID " + "inner join Accounting.account a on a.catTypeID=ct.ID " + "full join Accounting.[transaction] trans on trans.accountid=a.ID") .Tables[0] .AsEnumerable() .Select(r => new { catTypeID = r.ItemArray[0], name = r.ItemArray[1] }); return data; }
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 string headercontent_delete() { var pars = Request.Params; string contentid = pars["contentid"]; sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhost"].ConnectionString); db.fetch(string.Format("delete from sandbox.headercontent where contentID='{0}' ;", contentid)); db.fetch(string.Format("delete from sandbox.content where contentID='{0}' ;", contentid)); return ""; }
//DS public ActionResult getHeaders() { sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhost"].ConnectionString); var source = db.fetch("select id,label from sandbox.header").Tables[0] .AsEnumerable() .Select(x => new { id = x.ItemArray[0], label = x.ItemArray[1] }); return Json(source, JsonRequestBehavior.AllowGet); }
public ActionResult getHeaderContents() { var query = "select id,label from sandbox.header;" + "select hc.ID as headerContentID,h.id as headerID , contentID,c.label , content,viewurl from sandbox.header h " + "inner join sandbox.headerContent hc on hc.headerID=h.ID " + "inner join sandbox.Content c on hc.contentID=c.ID " + " order by h.id" ; sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhost"].ConnectionString); var ds = db.fetch(query); var headers = ds.Tables[0] .AsEnumerable() .Select(x => new { id = x.ItemArray[0], label = x.ItemArray[1] }); var headerContents = ds.Tables[1] .AsEnumerable() .Select(x => new { headerContentID = x.ItemArray[0], headerID = x.ItemArray[1], contentID = x.ItemArray[2], contentLabel = x.ItemArray[3], content = x.ItemArray[4], viewurl = x.ItemArray[5] }) .OrderBy(x => x.headerID); return Json(new { headers = headers, headerContents = headerContents }, JsonRequestBehavior.AllowGet); }
public JsonResult transactionTypes() { sqlServer db = new sqlServer(connString); var data = db.fetch("select id,name from accounting.categoryType") .Tables[0] .AsEnumerable() .Select(r=>new { id=r.ItemArray[0] , name = r.ItemArray[1] }); return Json(data,JsonRequestBehavior.AllowGet); }