public JsonResult CarregarTabelas(string conection) { Base.ConnectionString = ConfigurationManager.ConnectionStrings[conection].ConnectionString; var lista = new CriarProcedures("", null).ListaTodasTabelas(); return(Json(lista, JsonRequestBehavior.AllowGet)); }
public ActionResult CriarDao(string conection, string Nome) { ViewData[TituloPageEnum.TituloPagina.ToString()] = "Criar Dao"; ViewData[TituloPageEnum.TituloModuloPagina.ToString()] = "Tabela: " + Nome; Base.ConnectionString = ConfigurationManager.ConnectionStrings[conection].ConnectionString; List <Table> colunas = new CriarProcedures(Nome).CarregaColunas(); var retorno = new CriarDao().CriarDaoTable(Nome, colunas); ViewBag.Dados = retorno; return(View("~/Areas/HelpersSistema/Views/Home/MostrarDados.cshtml")); //return Json(retorno, JsonRequestBehavior.AllowGet); }
public ActionResult CriarProcedure(string conection, string Nome) { ViewData[TituloPageEnum.TituloPagina.ToString()] = "Criar Procedure"; ViewData[TituloPageEnum.TituloModuloPagina.ToString()] = "Tabela: " + Nome; Base.ConnectionString = ConfigurationManager.ConnectionStrings[conection].ConnectionString; List <Table> colunas = new CriarProcedures(Nome).CarregaColunas(); var variaveis = new CriarProcedures(Nome, colunas).layoutProcedure(); var variaveis2 = new CriarProcedures(Nome, colunas).layoutVariaveis(); var variaveis3 = new CriarProcedures(Nome, colunas).ProcSelect(); var variaveis4 = new CriarProcedures(Nome, colunas).ProcInsert(); var variaveis5 = new CriarProcedures(Nome, colunas).ProcUpdate(); var variaveis6 = new CriarProcedures(Nome, colunas).ProcDelete(); variaveis = variaveis.Replace("@queryvariaveis", variaveis2).Replace("@nomeprocedure", Nome.Replace("tbl", "proc_")).Replace("@queryselect", variaveis3).Replace("@queryinsert", variaveis4).Replace("@queryupdate", variaveis5).Replace("@querydelete", variaveis6); ViewBag.Dados = variaveis; return(View("~/Areas/HelpersSistema/Views/Home/MostrarDados.cshtml")); //return Json(variaveis, JsonRequestBehavior.AllowGet); }