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(); }