/// <summary>
/// Graba los datos
/// </summary>
protected override void Save()
{
if (ValidateData())
{
// Asigna los datos al proyecto
Connection.Name = Name;
Connection.Description = Description;
Connection.Type = (ConnectionModel.ConnectionType)(ComboTypes.SelectedId ?? 0);
Connection.Parameters[nameof(Server)] = Server;
Connection.Parameters[nameof(Port)] = Port.ToString();
Connection.Parameters[nameof(User)] = User;
Connection.Parameters[nameof(Password)] = Password;
Connection.Parameters[nameof(Database)] = Database;
Connection.Parameters[nameof(UseIntegratedSecurity)] = UseIntegratedSecurity.ToString();
Connection.Parameters[nameof(MultipleActiveResultSets)] = MultipleActiveResultSets.ToString();
Connection.Parameters[nameof(ConnectionString)] = ConnectionString;
Connection.Parameters[nameof(FileName)] = FileName;
Connection.TimeoutExecuteScript = TimeSpan.FromMinutes(TimeoutExecuteScriptMinutes);
// Añade la conexión a la solución si es necesario
if (IsNew)
{
SolutionViewModel.Solution.Connections.Add(Connection);
}
// Graba la solución
SolutionViewModel.SaveSolution();
// Actualiza el combo de conexiones
SolutionViewModel.ConnectionExecutionViewModel.Load();
// Indica que ya no es nuevo y está grabado
IsNew = false;
IsUpdated = false;
// Cierra la ventana
RaiseEventClose(true);
}
}
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());
}
