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