/********************************************************************************************************************************************/ public void RehacerConexion() { dynamic d = TempData.Get <dynamic>("DataServer"); if (d != null) { JObject datosSesion = new JObject(); datosSesion.Add(new JProperty("servidor", ModeloUsuComp.Desencriptar(d.servidor.ToString()))); datosSesion.Add(new JProperty("Base_datos", ModeloUsuComp.Desencriptar(d.Base_datos.ToString()))); datosSesion.Add(new JProperty("usuario_server", ModeloUsuComp.Desencriptar(d.usuario_server.ToString()))); datosSesion.Add(new JProperty("contrasenia", ModeloUsuComp.Desencriptar(d.contrasenia.ToString()))); datosSesion.Add(new JProperty("empresa", TempData["USU_EMPRESA"].ToString())); HttpContext.Session.SetString("empresa", TempData["USU_EMPRESA"].ToString()); HttpContext.Session.SetString("USU_CODIGO", TempData["USU_CODIGO"].ToString()); HttpContext.Session.SetString("USU_NOMBRE", TempData["USU_NOMBRE"].ToString()); HttpContext.Session.SetObjectAsJson("DataServer", datosSesion); } TempData.Keep(); dynamic s = HttpContext.Session.GetObjectFromJson <dynamic>("DataServer"); var optionsBuilder = new DbContextOptionsBuilder <BDWENCO>(); //services.AddDbContext<BDCOMUN>(options => options.UseSqlServer(Configuration.GetConnectionString("BDCOMUNConnectionString"))); string cadena = "Data Source=" + s.servidor + ";Initial Catalog=" + s.Base_datos + ";MultipleActiveResultSets=true;User ID=" + s.usuario_server + ";Password="******""; optionsBuilder.UseSqlServer(cadena); Wenco = new BDWENCO(optionsBuilder.Options); var optionsBuilder2 = new DbContextOptionsBuilder <BDCOMUN>(); cadena = "Data Source=" + s.servidor + ";Initial Catalog=" + s.empresa + "BDCOMUN;MultipleActiveResultSets=true;User ID=" + s.usuario_server + ";Password="******""; optionsBuilder2.UseSqlServer(cadena); Comun = new BDCOMUN(optionsBuilder2.Options); }
public MaestrasController(BDCOMUN context) { Comun = context; }
public ServiciosController(BDCOMUN context, BDWENCO context2) { Comun = context; Wenco = context2; }
public TestController(BDCOMUN context) { _context = context; }
public ComprasController(BDCOMUN context, BDWENCO context2, IGeneratePdf generatePdf) { Comun = context; Wenco = context2; this.generatePdf = generatePdf; }