public List <NegociacaoCondicaoController> NegociacaoCondicaoPorUsuario(Int64 TB011_Id) { List <NegociacaoCondicaoController> Retorno = new List <NegociacaoCondicaoController>(); try { SqlConnection con = new SqlConnection(ParametrosDAO.StringConexao); StringBuilder sSQL = new StringBuilder(); sSQL.Append(" SELECT "); sSQL.Append(" dbo.TB036_NegociacaoCondicao.TB036_Id "); sSQL.Append(" ,dbo.TB036_NegociacaoCondicao.TB036_Nome "); sSQL.Append(" FROM "); sSQL.Append(" dbo.TB038_TB037_TB036 "); sSQL.Append(" INNER JOIN "); sSQL.Append(" dbo.TB036_NegociacaoCondicao ON dbo.TB038_TB037_TB036.TB036_id = dbo.TB036_NegociacaoCondicao.TB036_Id "); sSQL.Append(" INNER JOIN "); sSQL.Append(" dbo.TB011_APPUsuarios "); sSQL.Append(" ON dbo.TB038_TB037_TB036.TB037_Id = dbo.TB011_APPUsuarios.TB037_Id "); sSQL.Append(" WHERE dbo.TB036_NegociacaoCondicao.TB036_Status = 1 "); sSQL.Append(" AND dbo.TB011_APPUsuarios.TB011_Id = "); sSQL.Append(TB011_Id); SqlCommand command = new SqlCommand(sSQL.ToString(), con); command.CommandTimeout = 300; con.Open(); SqlDataReader reader = command.ExecuteReader(); NegociacaoCondicaoController obj1 = new NegociacaoCondicaoController(); obj1.TB036_Id = 0; obj1.TB036_Nome = "<SELECIONE>"; Retorno.Add(obj1); while (reader.Read()) { NegociacaoCondicaoController obj = new NegociacaoCondicaoController(); obj.TB036_Id = Convert.ToInt64(reader["TB036_Id"]); obj.TB036_Nome = reader["TB036_Nome"].ToString().TrimEnd().TrimStart().ToUpper().ToUpper().Trim(); Retorno.Add(obj); } con.Close(); } catch (Exception ex) { throw ex; } return(Retorno); }
public NegociacaoCondicaoController NegociacaoCondicaoId(long TB036_Id) { var retorno = new NegociacaoCondicaoController(); try { var con = new SqlConnection(ParametrosDAO.StringConexao); var sSql = new StringBuilder(); sSql.Append(" SELECT * from TB036_NegociacaoCondicao"); sSql.Append(" WHERE "); sSql.Append(" TB036_Id = "); sSql.Append(TB036_Id); var command = new SqlCommand(sSql.ToString(), con); command.CommandTimeout = 300; con.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { retorno.TB036_Id = Convert.ToInt64(reader["TB036_Id"]); retorno.TB036_Nome = reader["TB036_Nome"].ToString().ToUpper(); retorno.TB036_Descricao = reader["TB036_Descricao"].ToString(); retorno.TB036_NParcelasMinimo = Convert.ToInt16(reader["TB036_NParcelasMinimo"]); retorno.TB036_NParcelasMaximo = Convert.ToInt16(reader["TB036_NParcelasMaximo"]); retorno.TB036_DescontoJurosAdesao = Convert.ToDouble(reader["TB036_DescontoJurosAdesao"]); retorno.TB036_DescontoMultaAdesao = Convert.ToDouble(reader["TB036_DescontoMultaAdesao"]); retorno.TB036_DescontoMultaMensalidade = Convert.ToDouble(reader["TB036_DescontoMultaMensalidade"]); retorno.TB036_DescontoJurosMensalidade = Convert.ToDouble(reader["TB036_DescontoJurosMensalidade"]); retorno.TB036_DescontoParcela = Convert.ToDouble(reader["TB036_DescontoParcela"]); retorno.TB036_DescontoAdesao = Convert.ToDouble(reader["TB036_DescontoAdesao"]); retorno.TB036_ValorMinimoParcela = Convert.ToDouble(reader["TB036_ValorMinimoParcela"]); } con.Close(); } catch (Exception ex) { // ReSharper disable once PossibleIntendedRethrow throw ex; } return(retorno); }