public IActionResult Post(StringConnection s)
{
try
{
string dbDataConn = string.Format("Data Source={0} ;Initial Catalog={1} ;User ID={2} ;Password={3} ;MultipleActiveResultSets=True;Application Name=EntityFramework"
, s.source.Trim()
, s.database.Trim()
, s.user.Trim()
, s.password.Trim());
byte[] plainTextBytes = Encoding.UTF8.GetBytes(dbDataConn);
string jsonString = "{\"data\":[{\"dbconn\":\"" + Convert.ToBase64String(plainTextBytes).Trim() + "\"},{\"dbname\":\"" + s.database + "\"}]}";
TextWriter archivo;
archivo = new StreamWriter("conf.json");
archivo.WriteLine(jsonString);
archivo.Close();
SqlConnection con = new SqlConnection(dbDataConn);
con.Open();
con.Close();
return(Ok("[{\"status\":\"Conectado a la base de datos: " + s.database + "\"}]"));
}
catch (Exception err)
{
string message = "[{\"status\":\"" + err.Message + "\"}]";
return(StatusCode(200, message));
}
}
public Startup(IConfiguration configuration)
{
Configuration = configuration;
StringConnection = Configuration.GetConnectionString("Development");
StringConnection = StringConnection.Replace("#password#", Configuration["Connection:Password"]);
}
// GET: ContaRegistos
public ActionResult Index()
{
StringConnection connection = new StringConnection();
string query = "select count(*) from tarefas";
ViewBag.registos = connection.ContaRegistos(connection.getSConnection(), query).Rows[0][0];
return(View());
}
public IActionResult Post(StringConnection s)
{
try
{
string cmd = string.Format("execute articulos_insert '{0}','{1}','{2}','{3}'"
, s.source.Trim()
, s.database.Trim()
, s.user.Trim()
, s.password.Trim());
DataSet Ds = SqlServerDbConn.Ejecutar(cmd);
return(Ok(Ds));
}
catch (Exception err)
{
return(StatusCode(400, "Revise la sentencia sql" + err));
}
}