public Observacao BuscaObservacao(int pIDResponsavel)
{
//string Observacaov = "";
using (SqlConnection objConexao = new SqlConnection(strConexao))
{
using (SqlCommand objComando = new SqlCommand(strSelect, objConexao))
{
try
{
objComando.Parameters.AddWithValue("@IdResponsavel", Convert.ToString(IDTeste));
objConexao.Open();
SqlDataReader objDataReader = objComando.ExecuteReader();
Observacao objOservacao = new Observacao();
if (objDataReader.HasRows)
{
objDataReader.Read();
//nome = leitor["Nome"].ToString();
objOservacao.observacaov = objDataReader["Observacao"].ToString();
}
objConexao.Close();
//retorno o nome
return(objOservacao);
}
catch (Exception ex)
{
MessageBox.Show("Erro!" + ex.Message);
//throw;
}
}
}
Observacao objOservacaoFalha = new Observacao();
return(objOservacaoFalha);
}
public List <Observacao> Selecionar()
{
List <Observacao> lstObservacaos = new List <Observacao>();
using (SqlConnection objConexao = new SqlConnection(strConexao))
{
using (SqlCommand objComando = new SqlCommand(strSelect, objConexao))
{
try
{
objComando.Parameters.AddWithValue("@IdResponsavel", Convert.ToString(IDTeste));
objConexao.Open();
SqlDataReader objDataReader = objComando.ExecuteReader();
if (objDataReader.HasRows)
{
while (objDataReader.Read())
{
Observacao objObservacao = new Observacao();
//objObservacao.IdResponsavel = Convert.ToInt32(objDataReader["IDResponsavel"].ToString());
objObservacao.Observacaov = objDataReader["Observacaov"].ToString();
lstObservacaos.Add(objObservacao);
}
objDataReader.Close();
}
objConexao.Close();
}
catch (Exception ex)
{
MessageBox.Show("Erro!" + ex.Message);
// throw;
}
}
}
return(lstObservacaos);
}
public Observacao BuscaObservacao(int pIDResponsavel)
{
//string Observacaov = "";
using (SqlConnection objConexao = new SqlConnection(strConexao))
{
using (SqlCommand objComando = new SqlCommand(strSelect, objConexao))
{
try
{
objComando.Parameters.AddWithValue("@IdResponsavel", Convert.ToString(IDTeste));
objConexao.Open();
SqlDataReader objDataReader = objComando.ExecuteReader();
Observacao objOservacao = new Observacao();
if (objDataReader.HasRows)
{
objDataReader.Read();
//nome = leitor["Nome"].ToString();
objOservacao.observacaov = objDataReader["Observacao"].ToString();
}
objConexao.Close();
//retorno o nome
return objOservacao;
}
catch (Exception ex)
{
MessageBox.Show("Erro!" + ex.Message);
//throw;
}
}
}
Observacao objOservacaoFalha = new Observacao();
return objOservacaoFalha;
}
public List<Observacao> Selecionar()
{
List<Observacao> lstObservacaos = new List<Observacao>();
using (SqlConnection objConexao = new SqlConnection(strConexao))
{
using (SqlCommand objComando = new SqlCommand(strSelect, objConexao))
{
try
{
objComando.Parameters.AddWithValue("@IdResponsavel", Convert.ToString(IDTeste));
objConexao.Open();
SqlDataReader objDataReader = objComando.ExecuteReader();
if (objDataReader.HasRows)
{
while (objDataReader.Read())
{
Observacao objObservacao = new Observacao();
//objObservacao.IdResponsavel = Convert.ToInt32(objDataReader["IDResponsavel"].ToString());
objObservacao.Observacaov = objDataReader["Observacaov"].ToString();
lstObservacaos.Add(objObservacao);
}
objDataReader.Close();
}
objConexao.Close();
}
catch (Exception ex)
{
MessageBox.Show("Erro!" + ex.Message);
// throw;
}
}
}
return lstObservacaos;
}