protected override void ProcessRecord()
{
if (base.ParameterSetName == PSName_ByComponent && !IntegratedSecurity.ToBool())
{
if (string.IsNullOrEmpty(User))
{
throw new ArgumentException("Parameter User is required");
}
if (string.IsNullOrEmpty(Password))
{
throw new ArgumentException("Parameter Password is required");
}
}
if (base.ParameterSetName == PSName_ByComponent)
{
WriteObject(
new Albatross.Database.Database {
DataSource = DataSource,
InitialCatalog = InitialCatalog,
SSPI = IntegratedSecurity.ToBool(),
UserName = User,
Password = Password,
}
);
}
else
{
WriteObject(new Albatross.Database.Database {
ConnectionString = ConnectionString,
});
}
}
public string GetConnectionString()
{
StringBuilder sb = new StringBuilder();
sb.Append($"data source={DataSource};");
sb.Append($"attachdbfilename={AttachDBFileName};");
sb.Append($"integrated security={IntegratedSecurity.ToPascalString()};");
sb.Append($"connect timeout={ConnectTimeout};");
sb.Append($"MultipleActiveResultSets={MultipleActiveResultSets.ToPascalString()};");
sb.Append($"App={App}");
return(sb.ToString());
}
public void SaveConfig()
{
var configFile = ConfigurationManager.OpenConfiguration(ConfigurationUserLevel.None);
var settings = configFile.AppSettings.Settings;
settings["InstanciaSQL"].Value = InstanciaSQL;
settings["NomeDB"].Value = NomeBD;
settings["Utilizador"].Value = Utilizador;
settings["Password"].Value = Password;
settings["DataSource"].Value = DataSource;
settings["AttachDbFilename"].Value = AttachDbFilename;
settings["IntegratedSecurity"].Value = IntegratedSecurity.ToString();
settings["ConnectTimeOut"].Value = ConnectTimeOut;
configFile.Save(ConfigurationSaveMode.Modfied);
ConfigurationManager.RefreshSection(configFile.AppSettings.Section.Information.Name);
}
public string ToVisibleString()
{
string str = string.Format("Data Source={0};Network=DBMSSOCN;Initial Catalog={1};Integrated Security={2};UID={3};PWD=******;MultipleActiveResultSets={5};Application Name={6}", DataSource, InitialCatalog, IntegratedSecurity, UserID,
Password, MultipleActiveResultsets, ApplicationName);
if (IntegratedSecurity.ToUpper() == "TRUE")
{
str = string.Format("Data Source={0};Initial Catalog={1};Integrated Security={2};MultipleActiveResultSets={5};Application Name={6}", DataSource, InitialCatalog, IntegratedSecurity, UserID,
Password, MultipleActiveResultsets, ApplicationName);
}
if (OtherAttributes != null)
{
foreach (string attr in OtherAttributes)
{
str += ";" + attr;
}
}
return(str);
}
