public IType BuscarPorUsuario(IType iType, int idUsuario, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BUSCA_HIERARQUIA_POR_CREDENCIAL";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idcredencial";
paran.Value = idUsuario;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idcampanha";
paran1.Value = idCampanha;
Cmd.Parameters.Add(paran1);
SetObjectToGet(iType);
return(iType);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public LIType BuscarPorHierarquiaENivel(IType iType, int idHierarquia, int idSubNivel, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_Ambev_Lista_Nivel_Hierarquia_dsPessoa";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@nivel";
paran.Value = idSubNivel;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idHierarquiaPai";
paran1.Value = idHierarquia;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idcampanha";
paran2.Value = idCampanha;
Cmd.Parameters.Add(paran2);
return(MakeListToGet(iType));
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public IType BuscarHomePagina(IType iType, int idCliente)
{
Cn = DataBaseGeneric.CreateConnection(BaseType, iType.InstanceConectionString);
Cn.Open();
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BuscarHomePagina";
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idCliente";
paran2.Value = idCliente;
Cmd.Parameters.Add(paran2);
OpenConnection(iType);
DbDataReader dr = Cmd.ExecuteReader();
if (dr.Read())
{
return(SetObject(dr, (IType)Activator.CreateInstance(iType.GetType())));
}
return(null);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public LIType ListaByHierarquia(IType iType, int idPessoa, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_Ambev_Lista_RelacionaPessoa";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idPessoa";
paran1.Value = idPessoa;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idcampanha";
paran2.Value = idCampanha;
Cmd.Parameters.Add(paran2);
return(MakeListToGet(iType));
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public IType BuscarHomePaginaRestrito(IType iType, int idUsuario, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BUSCA_HIERARQUIA_POR_CREDENCIAL";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idcredencial";
paran.Value = idUsuario;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idcampanha";
paran1.Value = idCampanha;
Cmd.Parameters.Add(paran1);
OpenConnection(iType);
DbDataReader dr = Cmd.ExecuteReader();
if (dr.Read())
{
return(SetObject(dr, (IType)Activator.CreateInstance(iType.GetType())));
}
return(null);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public void DeletePai(IType iType, int idPessoa, int idPessoaPai)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_DeleteEstruturaPessoaPai";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idPessoaPai";
paran1.Value = idPessoaPai;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idPessoa";
paran2.Value = idPessoa;
Cmd.Parameters.Add(paran2);
OpenConnectionTrans(iType);
Cmd.ExecuteNonQuery();
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public bool EFilhoDaPessoaCargo(IType iType, int idPessoaPai, int idPessoa)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_PessoaEFilhoDaPessoaCargo";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idPessoaPai";
paran1.Value = idPessoaPai;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idPessoa";
paran2.Value = idPessoa;
Cmd.Parameters.Add(paran2);
SetObjectToGet(iType);
return(iType.Id != null);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public IType GetPessoaCampanha(IType iType, int IDUsuario, int idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_GetPessoaPorCampanha";
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idCampanha";
paran1.Value = idCampanha;
Cmd.Parameters.Add(paran1);
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idCredencial";
paran.Value = IDUsuario;
Cmd.Parameters.Add(paran);
SetObjectToGet(iType);
return(iType);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public LIType BuscarPaginas(IType iType, string dsPagina, bool restrito, int?idCliente, int?idPrograma, int?idCampanha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BuscarPaginas";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@dsPagina";
paran.Value = dsPagina;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idCliente";
paran1.Value = (int)idCliente;
Cmd.Parameters.Add(paran1);
if (restrito)
{
DbParameter paran3 = Cmd.CreateParameter();
paran3.ParameterName = "@restrito";
paran3.Value = restrito;
Cmd.Parameters.Add(paran3);
}
if (idPrograma != null)
{
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idPrograma";
paran2.Value = (int)idPrograma;
Cmd.Parameters.Add(paran2);
}
if (idCampanha != null)
{
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idCampanha";
paran2.Value = (int)idCampanha;
Cmd.Parameters.Add(paran2);
}
return(MakeListToGet(iType));
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public IType BuscarPaginaRestrita(IType iType, string slugPagina, int idCliente, int?idPrograma, int?idCampanha, int?idUsuario)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BuscarPaginaRestrito";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idCliente";
paran.Value = idCliente;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idUsuario";
paran1.Value = (int)idUsuario;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@slugPagina";
paran2.Value = slugPagina;
Cmd.Parameters.Add(paran2);
if (idPrograma != null)
{
DbParameter paran3 = Cmd.CreateParameter();
paran3.ParameterName = "@idPrograma";
paran3.Value = (int)idPrograma;
Cmd.Parameters.Add(paran3);
}
if (idCampanha != null)
{
DbParameter paran3 = Cmd.CreateParameter();
paran3.ParameterName = "@idCampanha";
paran3.Value = (int)idCampanha;
Cmd.Parameters.Add(paran3);
}
SetObjectToGet(iType);
return(iType);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
/// <summary>
/// Seta parâmetros para procedure
/// </summary>
/// <param name="iType">interface do objeto</param>
/// <param name="pi">proprieade do objeto</param>
/// <param name="cmd">comando de execução</param>
protected void setParan(IType iType, PropertyInfo pi, DbCommand cmd)
{
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@" + CType.GetPropertyName(pi);
if (pi.GetValue(iType, null) == null || pkValue)
{
paran.Value = DBNull.Value;
}
else
{
paran.Value = pi.GetValue(iType, null);
}
Cmd.Parameters.Add(paran);
}
/// <summary>
/// Busca os dados da base através dos parâmetros por condição
/// </summary>
public virtual LIType FindByConditions(ref IType iType, string conditions)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_" + iType.GetType().Name + "_BuscarConditions";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@conditions";
paran.Value = conditions;
Cmd.Parameters.Add(paran);
return(MakeListToGet(iType));
}
catch (Exception ex) { throw ex; }
finally { CloseConnection(iType); }
}
public int BuscaQuantidadeAcesso(IType iType, int idCliente, int?idPrograma, int?idCampanha, int?idUsuario)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_SYS_BuscaQuantidadeAcesso";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idCliente";
paran.Value = idCliente;
Cmd.Parameters.Add(paran);
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idUsuario";
paran1.Value = (int)idUsuario;
Cmd.Parameters.Add(paran1);
if (idPrograma != null)
{
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idPrograma";
paran2.Value = (int)idPrograma;
Cmd.Parameters.Add(paran2);
}
if (idCampanha != null)
{
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@idCampanha";
paran2.Value = (int)idCampanha;
Cmd.Parameters.Add(paran2);
}
OpenConnection(iType);
return(Convert.ToInt32(Cmd.ExecuteScalar()));
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public IType Validate(IType iType, int idCampanha, string chave, string senha)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
DbParameter paran1 = Cmd.CreateParameter();
paran1.ParameterName = "@idCampanha";
paran1.Value = idCampanha;
Cmd.Parameters.Add(paran1);
DbParameter paran2 = Cmd.CreateParameter();
paran2.ParameterName = "@chave";
paran2.Value = chave;
Cmd.Parameters.Add(paran2);
if (senha != null)
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_SYS_ValidateChaveAtivacao";
DbParameter paran3 = Cmd.CreateParameter();
paran3.ParameterName = "@senha";
paran3.Value = senha;
Cmd.Parameters.Add(paran3);
}
else
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_SYS_ValidateChaveAtivacaoSemSenha";
}
SetObjectToGet(iType);
return(iType);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
/// <summary>
/// Seta parâmetros para procedure, usado em delete
/// </summary>
/// <param name="iType">interface do objeto</param>
/// <param name="pi">proprieade do objeto</param>
/// <param name="cmd">comando de execução</param>
private void setParanDel(IType iType, PropertyInfo pi, DbCommand cmd)
{
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@" + CType.GetPropertyName(pi);
if (pi.GetValue(iType, null) == null || pkValue)
{
paran.Value = DBNull.Value;
}
else
{
paran.Value = pi.GetValue(iType, null);
PropertyAttribute[] pAttProperty = (PropertyAttribute[])pi.GetCustomAttributes(typeof(PropertyAttribute), false);
if (pAttProperty != null && pAttProperty.Length > 0 && pAttProperty[0].IsPk)
{
pkValue = true;
}
}
Cmd.Parameters.Add(paran);
}
public IType GetCargoPorPessoa(IType iType, int idPessoa)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "sp_GetCargoPorPessoa";
DbParameter paran = Cmd.CreateParameter();
paran.ParameterName = "@idPessoa";
paran.Value = idPessoa;
Cmd.Parameters.Add(paran);
SetObjectToGet(iType);
return(iType);
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
public SqlParameter CreateParameter()
{
return(Cmd.CreateParameter());
}
