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 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 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 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 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 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 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 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();
}
}
/// <summary>
/// Fecha a conexão com o banco de dados
/// </summary>
protected internal void CloseConnection(IType iType)
{
if (Cn != null)
{
if (Cn.State == ConnectionState.Open && iType.Transaction == null)
{
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();
}
}
public LIType GetPrimeiroNoCargo(IType iType)
{
try
{
Cmd = DataBaseGeneric.CreateCommand(BaseType);
Cmd.Connection = Cn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "Sp_GetPrimeiroNoCargo";
return(MakeListToGet(iType));
}
catch (Exception ex) { throw ex; }
finally
{
Cn.Close();
Cn.Dispose();
}
}
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();
}
}
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();
}
}
/// <summary>
/// Performs disposal.
/// </summary>
public void Dispose()
{
Cn.Dispose();
}
