/********************************************************************************************************************************************/
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;
}
