public String cpfPaciente(String email)
{
StringBuilder query = new StringBuilder();
var session = new DBSession();
query.Append(" SELECT m.cpf");
query.Append(" FROM Paciente m ");
query.Append(" WHERE (1=1) AND ");
query.AppendFormat(" m.email = '{0}' ", email);
Query executar = session.CreateQuery(query.ToString());
IDataReader reader = executar.ExecuteQuery();
//verificar se ele encontrou algum registro no banco de dados
if (reader.Read())
{
return(reader["cpf"].ToString());
}
return("000");
}
public String id(String email, String tabela)
{
StringBuilder query = new StringBuilder();
var session = new DBSession();
query.Append(" SELECT u.cpf");
query.AppendFormat(" FROM {0} u ", tabela);
query.Append(" WHERE (1=1) ");
query.AppendFormat(" AND u.email = '{0}'", email);
Query executar = session.CreateQuery(query.ToString());
IDataReader reader = executar.ExecuteQuery();
//verificar se ele encontrou algum registro no banco de dados
if (reader.Read())
{
return(reader["cpf"].ToString());
}
return("0");
}
public bool cadastrarEspecialidade(string nomeEsp)
{
StringBuilder query = new StringBuilder();
var session = new DBSession();
query.Append(" INSERT INTO Especialidade");
query.Append(" VALUES (");
query.AppendFormat(" '{0}')", nomeEsp);
Query executar = session.CreateQuery(query.ToString());
try
{
executar.ExecuteNonQuery();
}
catch
{
return(false); //insercao nao deu certo
}
return(true); //insercao deu certo
}
