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 }