public PersonModel getAllFromDataBaseForEmail(String tableName, String email, out int personTableID) { PersonModel person = new PersonModel(); personTableID = -1; try { using (OracleConnection connection = new OracleConnection(OracleSQLConnectorLoginWindow.GetConnectionString())) { connection.Open(); OracleCommand cmd; string sql = String.Format("select * from {0} WHERE email LIKE '{1}'", tableName, email); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; OracleDataReader reader = cmd.ExecuteReader(); try { if (reader.Read()) { person.setID(reader.GetInt32(0)); person.setPassword(reader.GetString(1)); personTableID = reader.GetInt32(2); person.setEmailAddress(reader.GetString(3)); } } finally { reader.Close(); } } }catch { } return(person); }
public int getIDFromDataBase(String tableName, String searchedValue) { try { using (OracleConnection connection = new OracleConnection(OracleSQLConnectorLoginWindow.GetConnectionString())) { connection.Open(); OracleCommand cmd; string sql = string.Format("select id from {0} WHERE email LIKE '{1}'", tableName, searchedValue); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; OracleDataReader reader = cmd.ExecuteReader(); try { if (reader.Read()) { int result = (reader.GetInt32(0)); reader.Close(); return(result); } } finally { reader.Close(); } } } catch { return(-1); } return(-1); }