private void SaveToSend(Int64 enterpriseId, DirectoryInfo saveTo, ProxyConfig config, List <PluginConnectorBaseDeployPackage> packages)
{
if ((packages == null) || (packages.Count == 0))
{
return;
}
Byte[] jData = Encoding.UTF8.GetBytes(SafeTrend.Json.JSON.Serialize <List <PluginConnectorBaseDeployPackage> >(packages));
String certPass = CATools.SHA1Checksum(Encoding.UTF8.GetBytes(config.fqdn));
using (CryptApi cApi = new CryptApi(CATools.LoadCert(Convert.FromBase64String(config.client_cert), certPass), jData))
{
if (!saveTo.Exists)
{
saveTo.Create();
}
FileInfo f = new FileInfo(Path.Combine(saveTo.FullName, DateTime.Now.ToString("yyyyMMddHHmss-ffffff")) + ".iamdat");
File.WriteAllBytes(f.FullName, cApi.ToBytes());
foreach (PluginConnectorBaseDeployPackage pkg in packages)
{
try
{
//db.AddUserLog(LogKey.Deploy, null, "Deploy", UserLogLevel.Debug, 0, enterpriseId, 0, 0, 0, pkg.entityId, pkg.identityId, "Saving package ID: " + pkg.pkgId, SafeTrend.Json.JSON.Serialize<PluginConnectorBaseDeployPackage>(pkg));
String tpkg = SafeTrend.Json.JSON.Serialize <PluginConnectorBaseDeployPackage>(pkg);
DbParameterCollection par = new DbParameterCollection();
par.Add("@entity_id", typeof(Int64)).Value = pkg.entityId;
par.Add("@date", typeof(DateTime)).Value = DateTime.Now;
par.Add("@flow", typeof(String)).Value = "deploy";
par.Add("@package_id", typeof(String), pkg.pkgId.Length).Value = pkg.pkgId;
par.Add("@filename", typeof(String), f.FullName.Length).Value = f.FullName;
par.Add("@package", typeof(String), tpkg.Length).Value = tpkg;
Int64 trackId = db.ExecuteScalar <Int64>("sp_new_package_track", System.Data.CommandType.StoredProcedure, par, null);
tpkg = null;
db.AddPackageTrack(trackId, "deploy", "Package generated");
}
catch { }
}
#if DEBUG
db.AddUserLog(LogKey.Deploy, null, "Deploy", UserLogLevel.Info, 0, enterpriseId, 0, 0, 0, 0, 0, "File to send created " + f.Name + " (" + packages.Count + ")");
#endif
}
}
protected void Page_Load(object sender, EventArgs e)
{
Request.InputStream.Position = 0;
try
{
JSONRequest req = JSON.GetRequest(Request.InputStream);
using (IAMDatabase database = new IAMDatabase(IAMDatabase.GetWebConnectionString()))
{
ProxyConfig config = new ProxyConfig(true);
config.GetDBConfig(database.Connection, ((EnterpriseData)Page.Session["enterprise_data"]).Id, req.host);
if (config.fqdn != null) //Encontrou o proxy
{
DirectoryInfo inDir = null;
using (ServerDBConfig c = new ServerDBConfig(IAMDatabase.GetWebConnection()))
inDir = new DirectoryInfo(c.GetItem("inboundFiles"));
if (!inDir.Exists)
{
inDir.Create();
}
req.enterpriseid = ((EnterpriseData)Page.Session["enterprise_data"]).Id.ToString();
String filename = config.proxy_name + "-" + DateTime.Now.ToString("yyyyMMddHHmmss-ffffff") + ".iamreq";
if (String.IsNullOrEmpty(req.filename))
{
req.filename = "Empty";
}
StringBuilder trackData = new StringBuilder();
trackData.AppendLine("Proxy: " + req.host);
trackData.AppendLine("Enterprise ID: " + req.enterpriseid);
trackData.AppendLine("Proxy filename: " + req.filename);
trackData.AppendLine("Saved filename: " + filename);
UserLogLevel level = UserLogLevel.Info;
trackData.AppendLine("");
trackData.AppendLine("Checking package...");
if (String.IsNullOrEmpty(req.data))
{
throw new Exception("Request data is empty");
}
Byte[] rData = Convert.FromBase64String(req.data);
if (!String.IsNullOrEmpty(req.sha1hash))
{
if (!CATools.SHA1CheckHash(rData, req.sha1hash))
{
throw new Exception("SHA1 Checksum is not equal");
}
}
String type = "";
try
{
JsonGeneric jData = new JsonGeneric();
try
{
String certPass = CATools.SHA1Checksum(Encoding.UTF8.GetBytes(config.fqdn));
if (String.IsNullOrEmpty(config.server_pkcs12_cert))
{
throw new Exception("Server PKCS12 from proxy config is empty");
}
using (CryptApi cApi = CryptApi.ParsePackage(CATools.LoadCert(Convert.FromBase64String(config.server_pkcs12_cert), certPass), rData))
jData.FromJsonBytes(cApi.clearData);
}
catch (Exception ex)
{
jData = null;
trackData.AppendLine("Error decrypting package data for enterprise " + req.enterpriseid + " and proxy " + req.host + ", " + ex.Message);
#if DEBUG
trackData.AppendLine(ex.StackTrace);
#endif
}
if (jData != null)
{
#if DEBUG
trackData.AppendLine("");
trackData.AppendLine("Request data:");
trackData.AppendLine(jData.ToJsonString());
trackData.AppendLine("");
#endif
type = jData.function;
trackData.AppendLine("Type: " + type);
trackData.AppendLine("Data array length: " + (jData.data == null ? "0" : jData.data.Count.ToString()));
if (type.ToLower() == "processimportv2")
{
Int32 d = 1;
foreach (String[] dr in jData.data)
{
try
{
Int32 resourcePluginCol = jData.GetKeyIndex("resource_plugin");
Int32 pkgCol = jData.GetKeyIndex("package");
if (resourcePluginCol == -1)
{
trackData.AppendLine("[Package data " + d + "] Erro finding column 'resource_plugin'");
}
if (pkgCol == -1)
{
trackData.AppendLine("[Package data " + d + "] Erro finding column 'package'");
}
if ((resourcePluginCol != -1) && (pkgCol != -1))
{
PluginConnectorBaseImportPackageUser pkg = JSON.DeserializeFromBase64 <PluginConnectorBaseImportPackageUser>(dr[pkgCol]);
trackData.AppendLine("[Package data " + d + "] Import id: " + pkg.importId);
trackData.AppendLine("[Package data " + d + "] Package id: " + pkg.pkgId);
Int64 trackId = 0;
try
{
String tpkg = JSON.Serialize2(pkg);
DbParameterCollection par = new DbParameterCollection();
par.Add("@entity_id", typeof(Int64)).Value = 0;
par.Add("@date", typeof(DateTime)).Value = pkg.GetBuildDate();
par.Add("@flow", typeof(String)).Value = "inbound";
par.Add("@package_id", typeof(String), pkg.pkgId.Length).Value = pkg.pkgId;
par.Add("@filename", typeof(String)).Value = req.filename;
par.Add("@package", typeof(String), tpkg.Length).Value = tpkg;
trackId = database.ExecuteScalar <Int64>("sp_new_package_track", System.Data.CommandType.StoredProcedure, par, null);
trackData.AppendLine("[Package data " + d + "] Package track id: " + trackId);
tpkg = null;
if (trackId > 0)
{
database.AddPackageTrack(trackId, "ProxyAPI", "Package received from proxy and saved at " + filename);
}
}
catch (Exception ex3) {
trackData.AppendLine("[Package data " + d + "] Erro generating package track: " + ex3.Message);
}
pkg.Dispose();
pkg = null;
}
}
catch (Exception ex2)
{
trackData.AppendLine("[Package data " + d + "] Erro parsing package data " + ex2.Message);
}
d++;
}
}
}
}
catch (Exception ex1) {
trackData.AppendLine("Erro parsing package " + ex1.Message);
level = UserLogLevel.Error;
}
database.AddUserLog(LogKey.API_Log, DateTime.Now, "ProxyAPI", level, 0, ((EnterpriseData)Page.Session["enterprise_data"]).Id, 0, 0, 0, 0, 0, "File received from proxy " + req.host + (String.IsNullOrEmpty(type) ? "" : " (" + type + ")"), trackData.ToString());
File.WriteAllBytes(Path.Combine(inDir.FullName, filename), Encoding.UTF8.GetBytes(JSON.Serialize <JSONRequest>(req)));
ReturnHolder.Controls.Add(new LiteralControl(JSON.GetResponse(true, "", "Request received and proxy finded (" + (req.data != null ? req.data.Length.ToString() : "0") + ")")));
}
}
}
catch (Exception ex) {
Tools.Tool.notifyException(ex);
throw ex;
}
}
private void ImportRegistersV2(ProxyConfig config, JsonGeneric jData, FileInfo f, JSONRequest req, IAMDatabase db)
{
Int32 resourcePluginCol = jData.GetKeyIndex("resource_plugin");
Int32 pkgCol = jData.GetKeyIndex("package");
if (resourcePluginCol == -1)
{
TextLog.Log("Inbound", "\t[ImportRegistersV2] Erro on find column 'resource_plugin' in " + f.Name + " enterprise " + req.enterpriseid + " and proxy " + req.host);
return;
}
if (pkgCol == -1)
{
TextLog.Log("Inbound", "\t[ImportRegistersV2] Erro on find column 'package' in " + f.Name + " enterprise " + req.enterpriseid + " and proxy " + req.host);
return;
}
//Realiza a importação no modelo BulkInsert por melhor desempenho do banco
DataTable dtBulk = new DataTable();
dtBulk.Columns.Add(new DataColumn("date", typeof(DateTime)));
dtBulk.Columns.Add(new DataColumn("file_name", typeof(String)));
dtBulk.Columns.Add(new DataColumn("resource_plugin", typeof(Int64)));
dtBulk.Columns.Add(new DataColumn("import_id", typeof(String)));
dtBulk.Columns.Add(new DataColumn("package_id", typeof(String)));
dtBulk.Columns.Add(new DataColumn("package", typeof(String)));
dtBulk.Columns.Add(new DataColumn("status", typeof(String)));
foreach (String[] dr in jData.data)
{
PluginConnectorBaseImportPackageUser pkg = JSON.DeserializeFromBase64 <PluginConnectorBaseImportPackageUser>(dr[pkgCol]);
dtBulk.Rows.Add(new Object[] { DateTime.Now, f.Name, dr[resourcePluginCol], pkg.importId, pkg.pkgId, JSON.Serialize2(pkg), 'F' });
try
{
DbParameterCollection par = new DbParameterCollection();
par.Add("@date", typeof(DateTime)).Value = pkg.GetBuildDate();
par.Add("@package_id", typeof(String), pkg.pkgId.Length).Value = pkg.pkgId;
Int64 trackId = db.ExecuteScalar <Int64>("select id from st_package_track where flow = 'inbound' and date = @date and package_id = @package_id", System.Data.CommandType.Text, par, null);
db.AddPackageTrack(trackId, "inbound", "Package imported to process queue");
}
catch { }
}
db.BulkCopy(dtBulk, "collector_imports");
//Apaga todos os registros da tabela temporaria
/*
* Procedimento desabiliato em 2018-08-29 por suspeita de problema
* db.ExecuteNonQuery("delete from collector_imports_temp", System.Data.CommandType.Text, null, null);
*
* db.BulkCopy(dtBulk, "collector_imports_temp");
*
* //Proteção contra reimportação de pacotes (loop)
* db.ExecuteNonQuery("delete from collector_imports_temp where exists (select 1 from collector_imports_old o where o.date >= dateadd(day,-1,getdate()) and o.file_name = file_name and o.resource_plugin_id = resource_plugin_id and o.import_id = import_id and o.package_id = package_id)", System.Data.CommandType.Text, null, null);
* db.ExecuteNonQuery("delete from collector_imports_temp where exists (select 1 from collector_imports o where o.date >= dateadd(day,-1,getdate()) and o.file_name = file_name and o.resource_plugin_id = resource_plugin_id and o.import_id = import_id and o.package_id = package_id)", System.Data.CommandType.Text, null, null);
*
* db.ExecuteNonQuery("insert into collector_imports select * from collector_imports_temp", System.Data.CommandType.Text, null, null);
* db.ExecuteNonQuery("delete from collector_imports_temp", System.Data.CommandType.Text, null, null);
* */
//Atualiza os registros importados deste arquivo para liberar o processamento
//Isso avisa o sistema que estes registros estão livres para processamento
//*** Desabilitado essa funç~~ao em 2018-03-08, e colocado o registro para ser importado diretamente com o Status 'F'
//db.ExecuteNonQuery("update collector_imports set status = 'F' where [file_name] = '" + f.Name + "'", CommandType.Text, null);
//Realiza o rebuild do indice desta tabela para agilizar no engine
//Este processo será executado somente uma vez pelo objeto pai
//db.ExecuteNonQuery("sp_reindex_imports", CommandType.StoredProcedure, null);
#if DEBUG
TextLog.Log("Inbound", "\t[ImportRegistersV2] Imported " + dtBulk.Rows.Count + " registers for enterprise " + req.enterpriseid + " and proxy " + req.host);
#endif
dtBulk.Dispose();
dtBulk = null;
jData = null;
}
private void ImportPackageTrack(ProxyConfig config, JsonGeneric jData, FileInfo f, JSONRequest req, IAMDatabase db)
{
Int32 resourceCol = jData.GetKeyIndex("resource");
Int32 dateCol = jData.GetKeyIndex("date");
Int32 sourceCol = jData.GetKeyIndex("source");
Int32 filenameCol = jData.GetKeyIndex("filename");
Int32 packageIdCol = jData.GetKeyIndex("packageid");
Int32 flowCol = jData.GetKeyIndex("flow");
Int32 textCol = jData.GetKeyIndex("text");
if (resourceCol == -1)
{
TextLog.Log("Inbound", "\t[ImportLogs] Erro on find column 'resource' in " + f.Name + " enterprise " + req.enterpriseid + " and proxy " + req.host);
return;
}
if (sourceCol == -1)
{
TextLog.Log("Inbound", "\t[ImportLogs] Erro on find column 'source' in " + f.Name + " enterprise " + req.enterpriseid + " and proxy " + req.host);
return;
}
if (textCol == -1)
{
TextLog.Log("Inbound", "\t[ImportLogs] Erro on find column 'text' in " + f.Name + " enterprise " + req.enterpriseid + " and proxy " + req.host);
return;
}
if (flowCol == -1)
{
TextLog.Log("Inbound", "\t[ImportLogs] Erro on find column 'flow' in " + f.Name + " enterprise " + req.enterpriseid + " and proxy " + req.host);
return;
}
if (filenameCol == -1)
{
TextLog.Log("Inbound", "\t[ImportLogs] Erro on find column 'filename' in " + f.Name + " enterprise " + req.enterpriseid + " and proxy " + req.host);
return;
}
if (packageIdCol == -1)
{
TextLog.Log("Inbound", "\t[ImportLogs] Erro on find column 'packageid' in " + f.Name + " enterprise " + req.enterpriseid + " and proxy " + req.host);
return;
}
DateTime date = DateTime.Now;
foreach (String[] dr in jData.data)
{
try
{
//Console.WriteLine(f.Name + " - " + dr[entityIdCol] + " ==> " + dr[textCol]);
//Console.WriteLine(dr[additionaldataCol]);
//Console.WriteLine("");
Int64 packageId = 0;
DbParameterCollection par = new DbParameterCollection();
par.Add("@flow", typeof(String)).Value = dr[flowCol];
par.Add("@package_id", typeof(String)).Value = dr[packageIdCol];
try
{
Int64 tmp = db.ExecuteScalar <Int64>("select id from st_package_track where flow = @flow and package_id = @package_id", System.Data.CommandType.Text, par, null);
if (tmp > 0)
{
packageId = tmp;
}
}
catch { }
if (packageId == 0)
{
par = new DbParameterCollection();
par.Add("@entity_id", typeof(Int64)).Value = 0;
par.Add("@date", typeof(DateTime)).Value = (dateCol >= 0 ? DateTime.Parse(dr[dateCol]) : date);
par.Add("@flow", typeof(String)).Value = dr[flowCol];
par.Add("@package_id", typeof(String), dr[packageIdCol].Length).Value = dr[packageIdCol];
par.Add("@filename", typeof(String), dr[filenameCol].Length).Value = dr[filenameCol];
par.Add("@package", typeof(String), dr[textCol].Length).Value = dr[textCol];
packageId = db.ExecuteScalar <Int64>("sp_new_package_track", System.Data.CommandType.StoredProcedure, par, null);
}
db.AddPackageTrack(packageId, dr[flowCol], dr[textCol]);
}
catch (Exception ex)
{
throw ex;
}
}
jData = null;
}
public RegistryProcessStatus Process(EnterpriseKeyConfig enterpriseKey, LockRules lockRules, IgnoreRules ignoreRules, RoleRules roleRules, LicenseControl lic)
{
List <UserDataFields> fieldsData = null;
List <UserDataFields> filter = null;
TestTimer tmp = null;
Boolean showError = true;
SqlTransaction trans = null;
try
{
RegistryProcess.ProccessLog dLog = new RegistryProcess.ProccessLog(delegate(String text)
{
#if DEBUG
Log("\t{profile} " + text);
#endif
});
tmp = new TestTimer("Process->Starting", dLog);
Log("Starting registry processor");
Log("");
Log("Plugin Config");
Log(pluginConfig.ToString());
Log("");
Log("Registry data:");
Log("\tGenerated Date: " + package.build_data);
Log("\tContext id: " + this.contextId);
Log("\tResource plugin id: " + this.resourcePluginId);
Log("\tResource id: " + this.resourceId);
Log("\tPlugin: " + this.pluginUri);
Log("\tImport id: " + this.importId);
Log("\tPackage id: " + this.packageId);
Log("\tContainer: " + package.container);
Log("\tGroups: " + (package.groups != null ? String.Join(", ", package.groups) : ""));
Log("");
if (this.pluginConfig.mapping == null)
{
if (!pluginConfig.enable_import)
{
showError = false;
}
throw new Exception("Plugin mapping is null");
}
if (this.pluginConfig.mapping.Count == 0)
{
if (!pluginConfig.enable_import)
{
showError = false;
}
throw new Exception("Plugin mapping is empty");
}
String where = "ci.status = 'F' and ci.resource_plugin_id = '" + this.resourcePluginId + "' and ci.import_id = '" + this.importId + "' and ci.package_id = '" + this.packageId + "'";
tmp.Stop(dbAux.Connection, null);
/*
* ======================================
* == Resgata Package Track ID*/
try
{
DbParameterCollection par = new DbParameterCollection();
par.Add("@date", typeof(DateTime)).Value = this.package.GetBuildDate();
par.Add("@package_id", typeof(String), this.package.pkgId.Length).Value = this.package.pkgId;
this.packageTrackId = dbAux.ExecuteScalar <Int64>("select id from st_package_track where flow = 'inbound' and date = @date and package_id = @package_id", System.Data.CommandType.Text, par, null);
}
catch (Exception ex)
{
#if DEBUG
internalLog.AppendLine("Error getting package track entity id: " + ex.Message);
#endif
}
/*
* == Final do resgate Package Track ID
* ======================================*/
/*
* ======================================
* == Monta tabela de filtragem*/
tmp = new TestTimer("Process->Filter table", dLog);
filter = new List <UserDataFields>();
//Adiciona os mapeamentos que são ID ou único para filtragem
foreach (PluginConnectorBasePackageData data in package.properties)
{
if (String.IsNullOrWhiteSpace(data.dataValue))
{
continue;
}
foreach (PluginConfigMapping m in this.pluginConfig.mapping)
{
if ((m.is_id || m.is_unique_property) && (m.data_name.ToLower() == data.dataName.ToLower()) && !filter.Exists(f => (f.Mapping.field_id == m.field_id && f.Equal(data.dataValue.Trim()))))
{
filter.Add(new UserDataFields((PluginConfigMapping)m.Clone(), data.dataValue.Trim()));
}
}
}
Log("Filter data:");
foreach (UserDataFields f in filter)
{
Log("\t[" + f.Mapping.data_name.ToLower() + "] is " + (f.Mapping.is_id ? "ID" : "Unique field") + " = " + f.Value);
}
Log("");
tmp.Stop(dbAux.Connection, null);
/*
* == Final tabela de filtragem
* ======================================*/
/*
* ======================================
* == Monta tabela de dados*/
tmp = new TestTimer("Process->Data table", dLog);
//Monta tabela de dados com base no mapeamento e dados recebidos
fieldsData = new List <UserDataFields>();
foreach (PluginConnectorBasePackageData data in package.properties)
{
if (String.IsNullOrWhiteSpace(data.dataValue))
{
continue;
}
foreach (PluginConfigMapping m in this.pluginConfig.mapping)
{
if ((m.data_name.ToLower() == data.dataName.ToLower()) && !fieldsData.Exists(f => (f.Mapping.field_id == m.field_id && f.Equal(data.dataValue.Trim()))))
{
try
{
fieldsData.Add(new UserDataFields((PluginConfigMapping)m.Clone(), data.dataValue.Trim()));
}
catch (Exception ex2)
{
Log(ex2.Message);
}
}
}
}
Log("Proccess data: " + (fieldsData.Count == 0 ? "empty" : ""));
foreach (UserDataFields f in fieldsData)
{
Log("\t[" + f.Mapping.data_name.ToLower() + "] Flags (" + (f.Mapping.is_login ? "is_login " : "") + (f.Mapping.is_name ? "is_name " : "") + (f.Mapping.is_password ? "is_password " : "") + ") " + (f.Mapping.is_id ? "is ID" : (f.Mapping.is_unique_property ? "is Unique field" : "")) + " = " + (f.Mapping.is_password ? "*****" : f.Value));
}
Log("");
tmp.Stop(dbAux.Connection, null);
/*
* == Final tabela de dados
* ======================================*/
/*
* ======================================
* == Cria o objeto do usuário e tenta localiza-lo*/
tmp = new TestTimer("Process->Create user object", dLog);
userData = new UserData(db.Connection, this.pluginConfig, enterpriseKey, enterpriseId, contextId, resourcePluginId, resourceId, pluginId, pluginConfig.mail_domain, pluginConfig.mail_field_id, filter, fieldsData, package.container);
userData.OnLog += Log;
userData.CheckUser();
tmp.Stop(dbAux.Connection, null);
tmp = new TestTimer("Process->Check exists and import enabled", dLog);
//Não existe e não é possível adicionar
if ((userData.EntityId == 0) && ((!pluginConfig.permit_add_entity) || (!pluginConfig.enable_import)))
{
String sId = "";
foreach (UserDataFields f in filter)
{
if (sId != "")
{
sId += ", ";
}
sId += f.Mapping.data_name + " = " + f.Value;
}
//Add identity to audit
userData.AddToAudit("not_exists", null);
throw new Exception("Entity not found and this plugin " + (!pluginConfig.enable_import ? "is disabled to import" : "not permit add entity") + ": " + sId);
return(RegistryProcessStatus.Error);
}
tmp.Stop(dbAux.Connection, null);
tmp = new TestTimer("Process->Check deleted", dLog);
if (userData.Deleted)
{
String sId = "";
foreach (UserDataFields f in filter)
{
if (sId != "")
{
sId += ", ";
}
sId += f.Mapping.data_name + " = " + f.Value;
}
//Add identity to audit
//userData.AddToAudit("deleted");
throw new Exception("Entity found but marked as deleted: " + sId);
return(RegistryProcessStatus.Error);
}
tmp.Stop(dbAux.Connection, null);
//Verifica se o registro deve ser ignorado
//Se sim, nada será realizado, nem bloqueio, nem explusão, nem adição....
tmp = new TestTimer("Process->Check ignore", dLog);
if (userData.Ignore(ignoreRules, this.pluginUri))
{
DbParameterCollection par = new DbParameterCollection();
par.Add("@resource_plugin_id", typeof(Int64)).Value = resourcePluginId;
par.Add("@import_id", typeof(String)).Value = importId;
par.Add("@package_id", typeof(String)).Value = packageId;
par.Add("@status", typeof(String)).Value = 'F';
par.Add("@new_status", typeof(String)).Value = 'I';
ExecuteNonQuery(db.Connection, "sp_migrate_imported2", CommandType.StoredProcedure, par, null);
par.Clear();
par = null;
return(RegistryProcessStatus.Ignored);
}
tmp.Stop(dbAux.Connection, null);
//Esta parte do código está propositalmente depois da verificação de existência e se permite add o login
//Pois este código é dispendioso, e só deve ser executado quando realmente necessario
tmp = new TestTimer("Process->Check lock", dLog);
userData.CheckLock(lockRules, this.pluginUri);
tmp.Stop(dbAux.Connection, null);
if ((userData.EntityId == 0) && (userData.Locked))
{
tmp = new TestTimer("Process->Check exists and locked", dLog);
String sId = "";
foreach (UserDataFields f in filter)
{
if (sId != "")
{
sId += ", ";
}
sId += f.Mapping.data_name + " = " + f.Value;
}
//userData.AddToAudit("locked", trans);
throw new Exception("Entity not found and this user is locked: " + sId);
return(RegistryProcessStatus.Error);
}
else if (userData.EntityId == 0)//Não existe a entidade
{
tmp = new TestTimer("Process->Add entity (check lic)", dLog);
lic.Count++;
if ((lic.Entities > 0) && (lic.Count > lic.Entities))
{
String sId = "";
foreach (UserDataFields f in filter)
{
if (sId != "")
{
sId += ", ";
}
sId += f.Mapping.data_name + " = " + f.Value;
}
throw new Exception("License error: Entity not found and license limit (" + lic.Entities + " entities) exceeded. " + sId);
return(RegistryProcessStatus.Error);
}
tmp.Stop(dbAux.Connection, null);
userData.NewUser = true;
tmp = new TestTimer("Process->Add entity (UpdateName)", dLog);
userData.UpdateName();
tmp.Stop(dbAux.Connection, null);
//Cria o login
tmp = new TestTimer("Process->Add entity (MakeLogin)", dLog);
//Define o campo de login com base nas informações recebidas
foreach (UserDataFields f in fieldsData)
{
if (f.Mapping.is_login && !String.IsNullOrEmpty(f.Value.ToString()) && !String.IsNullOrWhiteSpace(f.Value.ToString()))
{
userData.Login = f.Value.ToString();
}
}
Log("Build login...");
userData.MakeLogin(pluginConfig.build_login, null);
tmp.Stop(dbAux.Connection, null);
tmp = new TestTimer("Process->Add entity (MakeEmail)", dLog);
//Cria o e-mail
Log("Build e-mail...");
if (pluginConfig.build_mail)
{
userData.MakeEmail(null, pluginConfig.mail_domain, pluginConfig.mail_field_id);
}
tmp.Stop(dbAux.Connection, null);
if (userData.FullName == null)
{
userData.FullName = userData.Login;
}
trans = db.Connection.BeginTransaction();
tmp = new TestTimer("Process->Add entity", dLog);
DbParameterCollection par = new DbParameterCollection();
par.Add("@resourcePluginId", typeof(Int64)).Value = resourcePluginId;
par.Add("@alias", typeof(String)).Value = userData.FullName;
par.Add("@full_name", typeof(String)).Value = userData.FullName;
DataTable dtEnt = ExecuteDataTable(db.Connection, "sp_new_entity_and_identity", CommandType.StoredProcedure, par, trans);
if ((dtEnt == null) || (dtEnt.Rows.Count == 0))
{
throw new Exception("Erro on insert entity & identity");
}
par.Clear();
par = null;
userData.EntityId = (Int64)dtEnt.Rows[0]["id"];
userData.IdentityId = (Int64)dtEnt.Rows[0]["identity_id"];
Log("New entity/identity");
AddUserLog(db.Connection, LogKey.User_Added, null, "Engine", UserLogLevel.Info, 0, 0, 0, this.resourceId, this.pluginId, userData.EntityId, userData.IdentityId, "User added in IAM Database", this.internalLog.ToString(), trans);
tmp.Stop(dbAux.Connection, null);
}
else if (userData.IdentityId == 0)//Existe a entidade porém não a identidade
{
tmp = new TestTimer("Process->Add identity", dLog);
trans = db.Connection.BeginTransaction();
DbParameterCollection par1 = new DbParameterCollection();
par1.Add("@entityId", typeof(Int64)).Value = userData.EntityId;
par1.Add("@resourcePluginId", typeof(Int64)).Value = resourcePluginId;
DataTable dtEnt = ExecuteDataTable(db.Connection, "sp_new_identity", CommandType.StoredProcedure, par1, trans);
if ((dtEnt == null) || (dtEnt.Rows.Count == 0))
{
throw new Exception("Erro on insert identity");
}
par1.Clear();
par1 = null;
if ((Boolean)dtEnt.Rows[0]["new_identity"])
{
Log("New identity");
}
userData.IdentityId = (Int64)dtEnt.Rows[0]["identity_id"];
AddUserLog(db.Connection, LogKey.User_Added, null, "Engine", UserLogLevel.Info, 0, 0, 0, this.resourceId, this.pluginId, userData.EntityId, userData.IdentityId, "Identity added", this.internalLog.ToString(), trans);
tmp.Stop(dbAux.Connection, null);
}
try
{
DbParameterCollection par = new DbParameterCollection();
par.Add("@entity_id", typeof(Int64)).Value = userData.EntityId;
par.Add("@date", typeof(DateTime)).Value = this.package.GetBuildDate();
par.Add("@package_id", typeof(String), this.package.pkgId.Length).Value = this.package.pkgId;
dbAux.ExecuteNonQuery("UPDATE st_package_track SET entity_id = @entity_id where flow = 'inbound' and date = @date and package_id = @package_id", System.Data.CommandType.Text, par, null);
}
catch (Exception ex) {
#if DEBUG
internalLog.AppendLine("Error updating package track entity id: " + ex.Message);
#endif
}
if (trans == null)
{
trans = db.Connection.BeginTransaction();
}
try
{
tmp = new TestTimer("Process->Lockunlock", dLog);
//Só permite alterar este status se for um plugin de entrada
if ((pluginConfig.permit_add_entity) && (userData.Locked != userData.LastLocked))
{
Log((userData.Locked ? "Locking user" : "Unlocking user"));
AddUserLog(db.Connection, (userData.Locked ? LogKey.User_Locked : LogKey.User_Unlocked), null, "Engine", UserLogLevel.Debug, 0, 0, 0, this.resourceId, this.pluginId, userData.EntityId, userData.IdentityId, (userData.Locked ? "Locking user" : "Unlocking user"), (userData != null ? userData.LockedInfo : ""), trans);
}
else
{
//Caso não permitido retorna ao estado anterior
userData.Locked = userData.LastLocked;
}
tmp.Stop(dbAux.Connection, null);
tmp = new TestTimer("Process->UpdateFields", dLog);
//Atualiza as propriedades (fields)
Log("Updating user values...");
userData.UpdateFields(trans, pluginConfig.enable_import);
tmp.Stop(dbAux.Connection, null);
if (pluginConfig.enable_import)
{
tmp = new TestTimer("Process->BuildPassword", dLog);
Log("Building password...");
userData.BuildPassword(trans);
tmp.Stop(dbAux.Connection, null);
tmp = new TestTimer("Process->UpdateUser", dLog);
//Registro tudo que está pendente no banco
Log("Updating user data (name, login and password)...");
userData.UpdateUser(trans);
tmp.Stop(dbAux.Connection, null);
tmp = new TestTimer("Process->UpdateGroups", dLog);
//Registro tudo que está pendente no banco
if (pluginConfig.import_groups)
{
Log("Updating user groups...");
userData.UpdateGroups(trans, package.groups);
}
tmp.Stop(dbAux.Connection, null);
}
tmp = new TestTimer("Process->update collector_imports", dLog);
//Excluir estes registros processados
//ExecuteNonQuery(conn,"delete from collector_imports where " + where.Replace("ci.", ""), CommandType.Text, null, trans);
//ExecuteNonQuery(conn,"update collector_imports set status = 'I' where " + where.Replace("ci.", ""), CommandType.Text, null, trans);
/* @plugin_uri varchar(500),
* @resource_id bigint,
* @import_id varchar(40),
* @registry_id varchar(40),
* @status varchar(2),
* @new_status varchar(2)*/
tmp.Stop(dbAux.Connection, null);
tmp = new TestTimer("Process->Commit", dLog);
Log("Commit user data on database");
trans.Commit();
trans = null;
//try to rebuild user index
for (Int32 i = 0; i <= 5; i++)
{
try
{
if (pluginConfig.enable_import)
{
userData.RebuildIndexes(null);
break;
}
else
{
break;
}
}
catch {
Thread.Sleep(2000);
}
}
tmp.Stop(dbAux.Connection, null);
DbParameterCollection par = new DbParameterCollection();
par.Add("@resource_plugin_id", typeof(Int64)).Value = resourcePluginId;
par.Add("@import_id", typeof(String)).Value = importId;
par.Add("@package_id", typeof(String)).Value = packageId;
par.Add("@status", typeof(String)).Value = 'F';
par.Add("@new_status", typeof(String)).Value = 'I';
ExecuteNonQuery(db.Connection, "sp_migrate_imported2", CommandType.StoredProcedure, par, null);
par.Clear();
par = null;
/*
* ======================================*/
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
trans = null;
throw ex;
}
tmp = new TestTimer("Process->UpdateRoles", dLog);
//Por fim verifica as roles
if (pluginConfig.enable_import)
{
userData.UpdateRoles(null, roleRules, this.pluginUri);
}
tmp.Stop(dbAux.Connection, null);
try
{
dbAux.AddPackageTrack(this.packageTrackId, "engine", "Process sucess: " + this.internalLog.ToString());
}
catch { }
#if DEBUG
AddUserLog(dbAux.Connection, LogKey.User_ImportInfo, null, "Engine", UserLogLevel.Debug, 0, 0, 0, this.resourceId, this.pluginId, (userData != null ? userData.EntityId : 0), (userData != null ? userData.IdentityId : 0), "User process status", this.internalLog.ToString());
#endif
Log("Success");
return(RegistryProcessStatus.OK);
}
catch (Exception ex)
{
if (tmp != null)
{
tmp.Stop(dbAux.Connection, null);
}
String traceError = "";
traceError += "Erro: " + ex.Message + ex.StackTrace;
Log("Erro: " + ex.Message);
if (ex.InnerException != null)
{
Log("Erro: " + ex.InnerException.Message);
}
#if DEBUG
Log("StackTrace: " + ex.StackTrace);
#endif
if (showError)
{
if (ex is SqlException)
{
AddUserLog(dbAux.Connection, LogKey.User_ImportError, null, "Engine", UserLogLevel.Error, 0, 0, 0, this.resourceId, this.pluginId, (userData != null ? userData.EntityId : 0), (userData != null ? userData.IdentityId : 0), ex.Message, SafeTrend.Json.JSON.Serialize2(new { import_id = importId, package_id = packageId, db_laet_error = LastDBError }));
}
else
{
AddUserLog(dbAux.Connection, LogKey.User_ImportError, null, "Engine", UserLogLevel.Error, 0, 0, 0, this.resourceId, this.pluginId, (userData != null ? userData.EntityId : 0), (userData != null ? userData.IdentityId : 0), ex.Message, SafeTrend.Json.JSON.Serialize2(new { import_id = importId, package_id = packageId, trace_error = traceError }));
}
}
try
{
dbAux.AddPackageTrack(this.packageTrackId, "engine", "Process error: " + SafeTrend.Json.JSON.Serialize2(new { error_message = ex.Message, error_stack_trace = ex.StackTrace, import_id = importId, package_id = packageId, trace_error = traceError }));
}
catch { }
//Se o erro for de deadlock, mantem o registro na base para ser reprocessado
if (!(ex is SqlException) || ((ex is SqlException) && (ex.Message.IndexOf("deadlock") == -1)))
{
ExecuteNonQuery(dbAux.Connection, "update collector_imports set status = 'E' where status = 'F' and resource_plugin_id = '" + this.resourcePluginId + "' and import_id = '" + this.importId + "' and package_id = '" + this.packageId + "'", CommandType.Text, null);
ExecuteNonQuery(dbAux.Connection, "delete from collector_imports where status = 'E' and resource_plugin_id = '" + this.resourcePluginId + "' and import_id = '" + this.importId + "' and package_id = '" + this.packageId + "'", CommandType.Text, null);
}
//Console.ReadLine();
//System.Diagnostics.Process.GetCurrentProcess().Kill();
//throw ex;
if (trans != null)
{
trans.Rollback();
}
trans = null;
return(RegistryProcessStatus.Error);
}
finally
{
Log("End of registry processor");
if (fieldsData != null)
{
fieldsData.Clear();
}
fieldsData = null;
}
}
