public override PluginConnectorBaseFetchResult FetchFields(Dictionary <String, Object> config) { PluginConnectorBaseFetchResult ret = new PluginConnectorBaseFetchResult(); LogEvent iLog = new LogEvent(delegate(Object sender, PluginLogType type, string text) { if (Log != null) { Log(sender, type, text); } }); if (!CheckInputConfig(config, true, iLog, true, true)) { ret.success = false; return(ret); } List <PluginConfigFields> cfg = new List <PluginConfigFields>(); PluginConfigFields[] tmpF = this.GetConfigFields(); foreach (PluginConfigFields cf in tmpF) { try { iLog(this, PluginLogType.Information, "Field " + cf.Name + " (" + cf.Key + "): " + (config.ContainsKey(cf.Key) ? config[cf.Key].ToString() : "empty")); } catch (Exception ex) { iLog(this, PluginLogType.Information, "Field " + cf.Name + " (" + cf.Key + "): error on get data -> " + ex.Message); } } String connectionstring = "Data Source=" + config["server"].ToString() + ";Initial Catalog=master;User Id=" + config["username"].ToString() + ";Password='******';"; MSSQLDB db = null; try { db = new MSSQLDB(connectionstring); db.openDB(); String sql = "SELECT name AS Login_Name FROM sys.server_principals WHERE TYPE IN ('S') and name not like '%##%' ORDER BY name, type_desc"; DataTable dtSource = db.Select(sql); if (dtSource == null) { throw new Exception("Erro on select: " + db.LastError); } try { foreach (DataColumn dc in dtSource.Columns) { if (!ret.fields.ContainsKey(dc.ColumnName)) { ret.fields.Add(dc.ColumnName, new List <string>()); } } } catch (Exception ex) { iLog(this, PluginLogType.Error, "Erro ao listar as colunas: " + ex.Message); } foreach (DataRow dr in dtSource.Rows) { String regId = Guid.NewGuid().ToString(); try { foreach (DataColumn dc in dtSource.Columns) { if (!ret.fields.ContainsKey(dc.ColumnName)) { ret.fields.Add(dc.ColumnName, new List <string>()); } ret.fields[dc.ColumnName].Add(dr[dc.ColumnName].ToString()); } } catch (Exception ex) { iLog(this, PluginLogType.Error, "Erro ao importar o registro: " + ex.Message); } } ret.success = true; } catch (Exception ex) { iLog(this, PluginLogType.Error, ex.Message); } return(ret); }
public override void ProcessImport(String cacheId, String importId, Dictionary <String, Object> config, List <PluginConnectorBaseDeployPackageMapping> fieldMapping) { if (!CheckInputConfig(config, true, Log)) { return; } List <String> prop = new List <String>(); String connectionstring = "Data Source=" + config["server"].ToString() + ";Initial Catalog=master;User Id=" + config["username"].ToString() + ";Password='******';"; MSSQLDB db = null; try { db = new MSSQLDB(connectionstring); db.openDB(); String sql = "SELECT name AS Login_Name FROM sys.server_principals WHERE TYPE IN ('S') and name not like '%##%' ORDER BY name, type_desc"; DataTable dtSource = db.Select(sql); if (dtSource == null) { throw new Exception("Erro on select: " + db.LastError); } foreach (DataRow dr in dtSource.Rows) { PluginConnectorBaseImportPackageUser package = new PluginConnectorBaseImportPackageUser(importId); try { foreach (DataColumn dc in dtSource.Columns) { package.AddProperty(dc.ColumnName, dr[dc.ColumnName].ToString(), dc.DataType.ToString()); } ImportPackageUser(package); } catch (Exception ex) { Log2(this, PluginLogType.Error, 0, 0, "Erro ao importar o registro: " + ex.Message, ""); Log(this, PluginLogType.Error, "Erro ao importar o registro: " + ex.Message); } finally { package.Dispose(); package = null; } } } catch (Exception ex) { Log2(this, PluginLogType.Error, 0, 0, "Error on process import: " + ex.Message, ""); Log(this, PluginLogType.Error, ex.Message); } finally { if (db != null) { db.Dispose(); } } }