///<summary>
///Adds the parameters from cache.
///</summary>
///<param name="key">The key.</param>
///<param name="cmd">The CMD.</param>
///<param name="types">The types.</param>
///<param name="values">The values.</param>
public void AddParametersFromCache(string key, DbCommand cmd, DbType[] types, object[] values)
{
DbParameterCollection parms = cmd.Parameters;
parms.Clear();
DbParameter[] cacheParams = cache[key];
if (cacheParams != null && cacheParams.Length > 0)
{
if (types == null)
{
for (int i = 0; i < cacheParams.Length; i++)
{
DbParameter param = (DbParameter)((ICloneable)cacheParams[i]).Clone();
param.Value = values[i];
this.db.DbConfiguration.DbDriver.AdjustParameter(param);
parms.Add(param);
}
}
else
{
for (int i = 0; i <= cacheParams.Length - 1; i++)
{
DbParameter param = (DbParameter)((ICloneable)cacheParams[i]).Clone();
param.DbType = types[i];
param.Value = values[i];
this.db.DbConfiguration.DbDriver.AdjustParameter(param);
parms.Add(param);
}
}
}
}
public void CreateAndCacheParameters(string key, DbCommand cmd, string[] names, DbType[] types, object[] values)
{
DbParameterCollection parameters = cmd.Parameters;
parameters.Clear();
if (names != null && names.Length > 0)
{
if (types == null)
{
for (int i = 0; i < names.Length; i++)
{
this.db.AddInParameter(cmd, names[i], values[i]);
}
}
else
{
for (int i = 0; i < names.Length; i++)
{
this.db.AddInParameter(cmd, names[i], types[i], values[i]);
}
}
cache.Add(key, CreateCachableParamsClone(parameters));
}
}
public void CreateAndCacheParameters(string key, DbCommand cmd, string[] names, DbType[] types, object[] values)
{
DbParameterCollection parms = cmd.Parameters;
parms.Clear();
if (names != null && names.Length > 0)
{
if (types == null)
{
for (int i = 0; i < names.Length; i++)
{
db.AddInParameter(cmd, db.DbProvider.BuildParameterName(names[i]), values[i]);
db.DbProvider.AdjustParameter(cmd.Parameters[cmd.Parameters.Count - 1]);
AdjustParamNameForOracle(cmd, db.DbProvider.BuildParameterName(names[i]));
}
}
else
{
for (int i = 0; i < names.Length; i++)
{
db.AddInParameter(cmd, db.DbProvider.BuildParameterName(names[i]), types[i], values[i]);
db.DbProvider.AdjustParameter(cmd.Parameters[cmd.Parameters.Count - 1]);
AdjustParamNameForOracle(cmd, db.DbProvider.BuildParameterName(names[i]));
}
}
cache.Add(key, CreateCachableParamsClone(parms));
}
}
public void AddParametersFromCache(string key, DbCommand cmd, DbType[] types, object[] values)
{
DbParameterCollection parms = cmd.Parameters;
parms.Clear();
DbParameter[] cachedParams = cache[key];
if (cachedParams != null && cachedParams.Length > 0)
{
if (types == null)
{
for (int i = 0; i < cachedParams.Length; i++)
{
parms.Add(((ICloneable)cachedParams[i]).Clone());
parms[i].Value = values[i];
db.DbProvider.AdjustParameter(parms[i]);
}
}
else
{
for (int i = 0; i < cachedParams.Length; i++)
{
parms.Add(((ICloneable)cachedParams[i]).Clone());
parms[i].Value = values[i];
parms[i].DbType = types[i];
db.DbProvider.AdjustParameter(parms[i]);
}
}
}
}
/// <summary>
/// Fill SQL Command Parameter with Converted Values.
/// </summary>
/// <param name="parameter">Parameter collection for this Command</param>
/// <param name="dbParams">DbParameter Object to Fill</param>
protected virtual void FillSQLParameter(IEnumerable <QueryParameter> parameter, DbParameterCollection dbParams)
{
dbParams.Clear();
foreach (var param in parameter)
{
dbParams.Add(ConvertToDBParameter(param));
}
}
/// <summary>
/// 添加参数
/// </summary>
/// <param name="parameters">SqlParameterCollection的参数对象</param>
/// <param name="parmsCollection">参数值</param>
private DbParameterCollection AddParms(DbParameterCollection parmsCollection, DbParameter[] parameters)
{
parmsCollection.Clear();
if (parameters != null)
{
foreach (var parms in parameters)
{
parmsCollection.Add(parms);
}
}
return(parmsCollection);
}
public void Clear_Clears_All_Parameters()
{
// Arrange
var sut = new DbParameterCollection
{
["Parameter1"] = "value1"
};
// Act
sut.Clear();
// Assert
sut.Count.Should().Be(0);
}
private void SortParameters(string query, DbParameterCollection parameters)
{
if (parameters.Count == 0)
{
return;
}
var parameterArray = parameters.Cast <OleDbParameter>().ToArray();
// ReSharper disable once CoVariantArrayConversion
Array.Sort(parameterArray, new ParameterPositionComparer(query));
parameters.Clear();
foreach (OleDbParameter parameter in parameterArray)
{
parameters.Add(new OleDbParameter(parameter.ParameterName, parameter.Value));
}
}
public void BasicOperationsTest()
{
SqlCommand command = new SqlCommand();
DbParameterCollection collection = command.Parameters;
SqlParameter firstParam = new SqlParameter();
// Add
int index = collection.Add(firstParam);
Assert.Equal(0, index);
// Get
Assert.Same(firstParam, collection[index]);
Assert.Equal(0, collection.IndexOf(firstParam));
Assert.Equal(-1, collection.IndexOf(new SqlParameter()));
Assert.Equal(-1, collection.IndexOf(null));
// Insert
SqlParameter secondParam = new SqlParameter();
collection.Insert(0, secondParam);
Assert.Same(secondParam, collection[0]);
Assert.Same(firstParam, collection[1]);
// Replace
SqlParameter thirdParam = new SqlParameter();
collection[1] = thirdParam;
Assert.Same(thirdParam, collection[1]);
// Remove
collection.Remove(secondParam);
Assert.Equal(1, collection.Count);
Assert.Same(thirdParam, collection[0]);
// Clear
collection.Clear();
Assert.Equal(0, collection.Count);
}
private TParameter[] ToParameter(DbParameterCollection parameters)
{
if (parameters == null || parameters.Count == 0)
{
return(null);
}
var results = new List <TParameter>();
for (int i = 0; i < parameters.Count; i++)
{
var p = parameters[i] as TParameter;
if (p == null)
{
throw new ArgumentException("parameters[" + i + "] is not of type TParameter");
}
results.Add(p);
}
parameters.Clear();
return(results.ToArray());
}
public override void Clear()
{
m_parameters.Clear();
}
public WorkflowRequestProccess SetStatus(IAMDatabase database, WorkflowRequestStatus status, Int64 executing_user)
{
WorkflowRequestProccess initial = GetInicialData(database);
if (!initial.Success)
{
return(initial);
}
//Verifica se o usuário atual faz parte do grupo de aprovadores
if (!database.ExecuteScalar <Boolean>("select case when COUNT(*) > 0 then CAST(1 as bit) else CAST(0 as bit) end from entity e with(nolock) where e.id in (" + workflow.Owner + "," + activity.ManualApproval.EntityApprover + ") or e.id in (select i.entity_id from identity_role ir with(nolock) inner join [identity] i with(nolock) on i.id = ir.identity_id where ir.role_id = " + activity.ManualApproval.RoleApprover + ")", CommandType.Text, null))
{
return(new WorkflowRequestProccess(false, "Access denied. You are not part of the group of approvers users"));
}
Object trans = database.BeginTransaction();
try
{
String changeTextAdmin = "";
String changeText = "";
changeText = activity.Name + " " + MessageResource.GetMessage("wf_" + status.ToString().ToLower(), status.ToString());
using (DbParameterCollection par2 = new DbParameterCollection())
{
//Só altera o status do ítem ptincipal quando a aprovação for da última activity
if ((status == WorkflowRequestStatus.Approved) && (nextActivity == null))
{
par2.Add("@request_id", typeof(Int64)).Value = this.workflow_request_id;
par2.Add("@status", typeof(Int32)).Value = (Int32)status;
database.ExecuteNonQuery("UPDATE [st_workflow_request] SET [status] = @status, deployed = 0 WHERE ID = @request_id", CommandType.Text, par2, trans);
}
else if (status == WorkflowRequestStatus.Approved)
{
par2.Add("@request_id", typeof(Int64)).Value = this.workflow_request_id;
database.ExecuteNonQuery("UPDATE [st_workflow_request] SET deployed = 0 WHERE ID = @request_id", CommandType.Text, par2, trans);
}
else
{
par2.Add("@request_id", typeof(Int64)).Value = this.workflow_request_id;
par2.Add("@status", typeof(Int32)).Value = (Int32)status;
database.ExecuteNonQuery("UPDATE [st_workflow_request] SET [status] = @status, deployed = 0 WHERE ID = @request_id", CommandType.Text, par2, trans);
}
//Adiciona o status da activity atual
par2.Clear();
par2.Add("@workflow_request_id", typeof(Int64)).Value = this.workflow_request_id;
par2.Add("@status", typeof(String)).Value = (Int32)status;
par2.Add("@description", typeof(String)).Value = changeText;
par2.Add("@activity_id", typeof(Int64)).Value = activity.ActivityId;
par2.Add("@executed_by_entity_id", typeof(Int64)).Value = executing_user;
par2.Add("@date", typeof(DateTime)).Value = DateTime.Now;
database.ExecuteNonQuery("INSERT INTO [st_workflow_request_status]([workflow_request_id],[date],[status],[description],[executed_by_entity_id],[activity_id])VALUES(@workflow_request_id,@date,@status,@description,@executed_by_entity_id,@activity_id)", CommandType.Text, par2, trans);
//Adiciona o status da próxima atividade
if ((status == WorkflowRequestStatus.Approved) && (nextActivity != null))
{
par2.Clear();
par2.Add("@workflow_request_id", typeof(Int64)).Value = this.workflow_request_id;
par2.Add("@status", typeof(String)).Value = (Int32)WorkflowRequestStatus.Waiting;
par2.Add("@description", typeof(String)).Value = "Aguardando análise";
par2.Add("@activity_id", typeof(Int64)).Value = nextActivity.ActivityId;
par2.Add("@executed_by_entity_id", typeof(Int64)).Value = executing_user;
par2.Add("@date", typeof(DateTime)).Value = DateTime.Now.AddSeconds(1);
database.ExecuteNonQuery("INSERT INTO [st_workflow_request_status]([workflow_request_id],[date],[status],[description],[executed_by_entity_id],[activity_id])VALUES(@workflow_request_id,@date,@status,@description,@executed_by_entity_id,@activity_id)", CommandType.Text, par2, trans);
}
}
//E-mails para os próximos aprovadores, se houver
if ((status == WorkflowRequestStatus.Approved) && (nextActivity != null))
{
try
{
Dictionary <Int64, List <String> > mails = new Dictionary <long, List <string> >();
if ((nextActivity.ManualApproval != null) && ((nextActivity.ManualApproval.EntityApprover > 0) || (nextActivity.ManualApproval.RoleApprover > 0)))
{
DataTable dtUserMails = database.ExecuteDataTable("select distinct entity_id, mail, full_name from vw_entity_mails where entity_id in (" + activity.ManualApproval.EntityApprover + ") or entity_id in (select i.entity_id from identity_role ir with(nolock) inner join [identity] i with(nolock) on i.id = ir.identity_id where ir.role_id = " + activity.ManualApproval.RoleApprover + ")", CommandType.Text, null, trans);
if ((dtUserMails != null) && (dtUserMails.Rows.Count > 0))
{
foreach (DataRow dr in dtUserMails.Rows)
{
try
{
MailAddress m = new MailAddress(dr["mail"].ToString());
if (!mails.ContainsKey((Int64)dr["entity_id"]))
{
mails.Add((Int64)dr["entity_id"], new List <string>());
}
mails[(Int64)dr["entity_id"]].Add(m.Address);
}
catch { }
}
}
}
if (mails.Count > 0)
{
foreach (Int64 admin_id in mails.Keys)
{
try
{
Dictionary <String, String> vars = new Dictionary <string, string>();
vars.Add("workflow_name", workflow.Name);
vars.Add("user_name", this.user_name);
vars.Add("user_login", this.user_login);
vars.Add("user_id", this.user_id.ToString());
vars.Add("admin_id", admin_id.ToString());
vars.Add("description", workflow.Description);
vars.Add("approval_link", "%enterprise_uri%/admin/access_request/" + this.workflow_request_id + "/allow/");
vars.Add("deny_link", "%enterprise_uri%/admin/access_request/" + this.workflow_request_id + "/deny/");
MessageBuilder msgAdm = MessageBuilder.BuildFromTemplate(database, this.enterprise_id, "access_request_admin", String.Join(",", mails[admin_id]), vars, trans);
msgAdm.SaveToDb(database, trans);
}
catch { }
}
}
}
catch { }
}
try
{
//E-mail para o usuário
DataTable dtUserMails = database.ExecuteDataTable("select distinct mail from vw_entity_mails where entity_id = " + this.user_id, CommandType.Text, null, trans);
if ((dtUserMails != null) && (dtUserMails.Rows.Count > 0))
{
List <String> mails = new List <string>();
foreach (DataRow dr in dtUserMails.Rows)
{
try
{
MailAddress m = new MailAddress(dr["mail"].ToString());
mails.Add(m.Address);
}
catch { }
}
if (mails.Count > 0)
{
Dictionary <String, String> vars = new Dictionary <string, string>();
vars.Add("workflow_name", this.workflow.Name);
vars.Add("user_name", this.user_name);
vars.Add("user_login", this.user_login);
vars.Add("user_id", this.user_id.ToString());
vars.Add("change", changeText);
MessageBuilder msg1 = MessageBuilder.BuildFromTemplate(database, this.enterprise_id, "access_request_changed", String.Join(",", mails), vars, trans);
msg1.SaveToDb(database, trans);
}
}
}
catch { }
database.Commit();
return(new WorkflowRequestProccess(true, ""));
}
catch (Exception ex)
{
database.Rollback();
return(new WorkflowRequestProccess(false, "Erro on deny access.", ex.Message));
}
}
public void LimpaParametros()
{
// sqlParameterCollection.Clear();
dbParameterCollection.Clear();
}
public override void Clear()
{
_parameterCollection.Clear();
}
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;
}
}
