Ejemplo n.º 1
0
        public FingerPrint getFingerPrintById(String id)
        {
            string query = "SELECT * FROM fingerprint WHERE FINGERPRINT_ID = "+id+" ";

            //Create a list to store the result
            FingerPrint fingerPrint = new FingerPrint();

            if (this.OpenConnection() == true)
            {
                //Create Command
                MySqlCommand cmd1 = new MySqlCommand(query, connection);
                //Create a data reader and Execute the command
                MySqlDataReader dataReader1 = cmd1.ExecuteReader();

                //Read the data and store them in the list
                while (dataReader1.Read())
                {
                    fingerPrint.FingerPrintId = dataReader1["fingerprint_id"] + "";
                    fingerPrint.AudioType = getAudioTypeById(dataReader1["type_id"] + "");
                }

                //close Data Reader
                dataReader1.Close();

                //close Connection
                this.CloseConnection();

                //return list to be displayed
                return fingerPrint;
            }
            else
            {
                return null;
            }
        }
Ejemplo n.º 2
0
 public LogAudioDetection()
 {
     fingerprintId = new FingerPrint();
 }
Ejemplo n.º 3
0
        public List<LogAudioDetection> getAllLogAudioDetectionShortByDateForDataGrid()
        {
            string query = "SELECT log_audio_detected.log_id, audio_type.type_name,log_audio_detected.log_detected_time,log_audio_detected.log_message,log_audio_detected.log_seen_status from log_audio_detected,audio_type,fingerprint where log_audio_detected.fingerprint_id = fingerprint.fingerprint_id AND fingerprint.type_id = audio_type.type_id ORDER BY log_audio_detected.log_detected_time DESC ";
            List<LogAudioDetection> LogAudios = new List<LogAudioDetection>();

            if (this.OpenConnection() == true)
            {
                //Create Command
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Create a data reader and Execute the command
                MySqlDataReader dataReader = cmd.ExecuteReader();

                //Read the data and store them in the list
                while (dataReader.Read())
                {
                    LogAudioDetection logAudioDetection = new LogAudioDetection();
                    FingerPrint fingerPrint = new FingerPrint();
                    AudioType audioType = new AudioType();

                    //audioType.Type_ = dataReader["type_id"] + "";
                    //audioType.Type_name = dataReader["type_name"] + "";
                    logAudioDetection.LogId = dataReader["log_id"] + "";
                    audioType.Type_name = dataReader["type_name"] + "";
                    fingerPrint.AudioType = audioType;
                    logAudioDetection.FingerprintId = fingerPrint;
                    logAudioDetection.LogDetectionTime = dataReader["log_detected_time"] + "";
                    logAudioDetection.LogSeenStatus = dataReader["log_seen_status"] + "";
                    logAudioDetection.LogMessage = dataReader["log_message"] + "";

                    LogAudios.Add(logAudioDetection);
                }

                //close Data Reader
                dataReader.Close();

                //close Connection
                this.CloseConnection();

                //return list to be displayed
                return LogAudios;
            }
            else
            {
                return null;
            }
        }