public ActionResult SetConnectionString(string DatabaseName, string Server, string User, string Password)
{
if (DatabaseName is null)
{
throw new ArgumentNullException(nameof(DatabaseName));
}
if (Server is null)
{
throw new ArgumentNullException(nameof(Server));
}
string connectionString = $"Data Source={Server};Initial Catalog={DatabaseName.Replace(".", "_")};MultipleActiveResultSets=True;";
if (string.IsNullOrWhiteSpace(User))
{
connectionString += $"Integrated Security=True;";
}
else
{
connectionString += $"User ID={User};Password={Password};";
}
ConnectionStringSetupModel checkModel = this.CheckModel(connectionString);
if (checkModel.Exceptions.Any())
{
return(this.View("Index", checkModel));
}
string configuration = System.IO.File.ReadAllText(HostBuilder.ApplicationConfig);
JObject config = JObject.Parse(configuration);
if (!config.ContainsKey(SetupController.CONNECTION_STRINGS))
{
config.Add(SetupController.CONNECTION_STRINGS, new JObject());
}
JObject ConnectionStrings = (JObject)config[CONNECTION_STRINGS];
if (!ConnectionStrings.ContainsKey(Penguin.Persistence.Abstractions.Constants.Strings.CONNECTION_STRING_NAME))
{
ConnectionStrings.Add(Penguin.Persistence.Abstractions.Constants.Strings.CONNECTION_STRING_NAME, connectionString);
}
else
{
ConnectionStrings[Penguin.Persistence.Abstractions.Constants.Strings.CONNECTION_STRING_NAME] = connectionString;
}
System.IO.File.WriteAllText(HostBuilder.ApplicationConfig, config.ToString());
this.AppLifetime.StopApplication();
return(this.View());
}
public ConnectionStringSetupModel CheckModel(string?ToCheck = null)
{
ToCheck ??= this.ServiceProvider.GetService <PersistenceConnectionInfo>()?.ConnectionString;
ConnectionStringSetupModel toReturn = new ConnectionStringSetupModel();
if (string.IsNullOrEmpty(ToCheck))
{
return(toReturn);
}
toReturn.ConnectionString = ToCheck;
toReturn.Exceptions = Startup.Exceptions.ToList();
return(toReturn);
}
