public StringBuilder Execute(Dictionary <string, StringBuilder> values, IWorkspace theWorkspace) { ExecuteMessage msg = new ExecuteMessage(); Dev2JsonSerializer serializer = new Dev2JsonSerializer(); try { Dev2Logger.Info("Save Resource Service"); StringBuilder resourceDefinition; values.TryGetValue("DbSource", out resourceDefinition); IDbSource src = serializer.Deserialize <DbSourceDefinition>(resourceDefinition); if (src.Path.EndsWith("\\")) { src.Path = src.Path.Substring(0, src.Path.LastIndexOf("\\", StringComparison.Ordinal)); } var res = new DbSource { AuthenticationType = src.AuthenticationType, Server = src.ServerName, Password = src.Password, ServerType = src.Type, UserID = src.UserName, ResourceID = src.Id, DatabaseName = src.DbName, ResourceName = src.Name, ResourceType = src.Type.ToString() }; var con = new DbSources(); var result = con.DoDatabaseValidation(res); if (result.IsValid) { ResourceCatalog.Instance.SaveResource(GlobalConstants.ServerWorkspaceID, res, src.Path); ServerExplorerRepo.UpdateItem(res); msg.HasError = false; } else { msg.HasError = false; msg.Message = new StringBuilder(res.IsValid ? "" : result.ErrorMessage); } } catch (Exception err) { msg.HasError = true; msg.Message = new StringBuilder(err.Message); Dev2Logger.Error(err); } return(serializer.SerializeToBuilder(msg)); }
public StringBuilder Execute(Dictionary <string, StringBuilder> values, IWorkspace theWorkspace) { ExecuteMessage msg = new ExecuteMessage(); Dev2JsonSerializer serializer = new Dev2JsonSerializer(); try { Dev2Logger.Info("Test DB Connection Service"); StringBuilder resourceDefinition; values.TryGetValue("DbSource", out resourceDefinition); IDbSource src = serializer.Deserialize <DbSourceDefinition>(resourceDefinition); var con = new DbSources(); DatabaseValidationResult result = con.DoDatabaseValidation(new DbSource { AuthenticationType = src.AuthenticationType, Server = src.ServerName, Password = src.Password, ServerType = src.Type, UserID = src.UserName }); msg.HasError = false; msg.Message = new StringBuilder(result.IsValid ? serializer.Serialize(result.DatabaseList) : result.ErrorMessage); msg.HasError = !result.IsValid; } catch (Exception err) { msg.HasError = true; msg.Message = new StringBuilder(err.Message); Dev2Logger.Error(err); } return(serializer.SerializeToBuilder(msg)); }