private void insertIntoDB(byte[] arr, int fing_num, int emp_id, int metr_id) { DBNetBroker DBNB = new DBNetBroker("localhost", "", "", "fingerdata"); DBHandler DBH = new DBHandler(DBNB); string str = ByteArrayToString(arr); string query = "INSERT INTO finger (FNumber, MetricsId, EmployeeID, FPrint) VALUES(" + "'" + fing_num + "'," + "'" + metr_id + "'," + "'" + emp_id + "'," + "'" + str + "')"; DBH.executeNQnoData(query); }
private MySqlDataReader GetPositionForUser(int uid) { DBNetBroker DBB = new DBNetBroker("localhost", "", "", "fingerdata"); DBB.Connection.Open(); string query = "SELECT * FROM employee WHERE employee.e_id = " + "'" + uid + "'"; MySqlCommand msc = new MySqlCommand(query, DBB.Connection); return(msc.ExecuteReader()); }
private MySqlDataReader GetData() { DBNetBroker DBB = new DBNetBroker("localhost", "", "", "fingerdata"); DBB.Connection.Open(); string query = "SELECT * FROM finger WHERE finger.MetricsId = " + "'" + Metric.Id + "'" + "AND finger.EmployeeID = " + "'" + Empl.Id + "'"; MySqlCommand msc = new MySqlCommand(query, DBB.Connection); return(msc.ExecuteReader()); }
private void initDB() { DBNB = new DBNetBroker("localhost", "", "", "fingerdata"); DBHandler DBH = new DBHandler(DBNB); Employee.DBHandlerInstance = DBH; //DirectionMap.DBHandlerInstance = DBH; //Finger.DBHandlerInstance = DBH; Location.DBHandlerInstance = DBH; Metrics.DBHandlerInstance = DBH; //Minutia.DBHandlerInstance = DBH; //MinutiaMap.DBHandlerInstance = DBH; Position.DBHandlerInstance = DBH; }