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;
}
