public void addFrame(kFrame frame) { //System.Console.WriteLine("New frame"); try { //reference table code //"CREATE TABLE frameManager (session INTEGER, frame INTEGER, object VARCHAR(20), accept VARCHAR(20), x DOUBLE, y DOUBLE, z DOUBLE, PRIMARY KEY(session, frame, object));"; queries = "INSERT INTO frameManager (session, frame, object, accept, x, y, z) VALUES (@session, @frame, @object, @accept, @x, @y, @z);"; sqCmd = new SQLiteCommand(queries, sqConnection); sqCmd.Parameters.AddWithValue("@session", frame.getSession()); sqCmd.Parameters.AddWithValue("@frame", frame.getFrame()); sqCmd.Parameters.AddWithValue("@object", frame.getObject()); sqCmd.Parameters.AddWithValue("@accept", frame.getAccept()); sqCmd.Parameters.AddWithValue("@x", frame.getX()); sqCmd.Parameters.AddWithValue("@y", frame.getY()); sqCmd.Parameters.AddWithValue("@z", frame.getZ()); sqCmd.ExecuteNonQuery(); } catch (Exception e) { System.Console.WriteLine(e); } //System.Console.WriteLine("New frame END"); }
private void InsertDB_Collected(string str, string is_accept, float x, float y, float z) { //System.Console.WriteLine("Inserting Collected Values for " + str); kFrame frame = new kFrame(sessionID, frame_counter, str, is_accept, x, y, z); sessionData.addFrame(frame); //System.Console.WriteLine("Collected Data Inserted"); //sessionData.printFrames(sessionID); }
private void InsertDB_Calibrate(string str, float x, float y, float z) { System.Console.WriteLine("Inserting Calibration Values for " + str); kFrame boxframe = new kFrame(sessionID, 0, str, null, x, y, z); sessionData.createBox(boxframe); System.Console.WriteLine("Calibration Data Inserted"); //sessionData.printFrames(sessionID); }
/* pointless function with zero use so far but left in code public kFrame getObjkFrame(int framenum, int sessionid, string obj) { System.Console.WriteLine("Get frame for obj" + obj.ToString()); kFrame frame = null; try { queries = "SELECT * FROM frameManager WHERE frame=@frame, and session=@sessionid, and object=@object"; sqCmd = new SQLiteCommand(queries, sqConnection); sqCmd.Parameters.AddWithValue("@frame", framenum); sqCmd.Parameters.AddWithValue("@sessionid", sessionid); sqCmd.Parameters.AddWithValue("@object", obj); sqDatareader = sqCmd.ExecuteReader(); sqDatareader.Read(); frame = new kFrame((int)sqDatareader["session"], (int)sqDatareader["frame"], (string)sqDatareader["object"], (string)sqDatareader["accept"], (double)sqDatareader["x"], (double)sqDatareader["y"], (double)sqDatareader["z"]); } catch (Exception e) { System.Console.WriteLine(e); } System.Console.WriteLine("Return found frame"); return frame; } */ //create the frame for acceptable movement, highly recommended to change range multipliers with further testing public void createBox(kFrame frame) { //System.Console.WriteLine("Creating box parameter"); try { //reference for table code //"CREATE TABLE boxManager (session INTEGER, object VARCHAR(20), minx DOUBLE, miny DOUBLE, minz DOUBLE, maxx DOUBLE, maxy DOUBLE, maxz double, PRIMARY KEY (session, object));"; queries = "INSERT INTO boxManager (session, object, minx, miny, minz, maxx, maxy, maxz) VALUES (@session, @object, @minx, @miny, @minz, @maxx, @maxy, @maxz);"; sqCmd = new SQLiteCommand(queries, sqConnection); sqCmd.Parameters.AddWithValue("@session", frame.getSession()); sqCmd.Parameters.AddWithValue("@object", frame.getObject()); sqCmd.Parameters.AddWithValue("@minx", frame.getX() * 1 / 4); sqCmd.Parameters.AddWithValue("@miny", frame.getY() * 1 / 4); sqCmd.Parameters.AddWithValue("@minz", frame.getZ() * 1 / 4); sqCmd.Parameters.AddWithValue("@maxx", frame.getX() * 2); sqCmd.Parameters.AddWithValue("@maxy", frame.getY() * 2); sqCmd.Parameters.AddWithValue("@maxz", frame.getZ() * 2); sqCmd.ExecuteNonQuery(); } catch (Exception e) { System.Console.WriteLine(e); } //System.Console.WriteLine("Box parameters inserted"); }
public List<kFrame> getSkeleton(int sessionid, int framenum) { System.Console.WriteLine("Get frame for session #" + sessionid + " and frame #" + framenum); //create list of kframes to return List<kFrame> frameValues = new List<kFrame>(); try { //create reader object to read rows queries = "SELECT * FROM frameManager WHERE frame=@frame, and session=@sessionid"; sqCmd = new SQLiteCommand(queries, sqConnection); sqCmd.Parameters.AddWithValue("@frame", framenum); sqCmd.Parameters.AddWithValue("@sessionid", sessionid); sqDatareader = sqCmd.ExecuteReader(); //read while rows exist with data while(sqDatareader.Read()) { kFrame frame = new kFrame((int)sqDatareader["session"], (int)sqDatareader["frame"], (string)sqDatareader["object"], (string)sqDatareader["accept"], (double)sqDatareader["x"], (double)sqDatareader["y"], (double)sqDatareader["z"]); frameValues.Add(frame); } } catch (Exception e) { System.Console.WriteLine(e); } System.Console.WriteLine("Sucess. Returning found skeletal frame"); return frameValues; }
public List<kFrame> getSession(int sessionid) { //gets all frames for a specified sessionId System.Console.WriteLine("Get ALL frames for session #" + sessionid); //return list of kframes List<kFrame> frameValues = new List<kFrame>(); try { //create a reader object to read rows queries = "SELECT * FROM frameManager WHERE session=@sessionid"; sqCmd = new SQLiteCommand(queries, sqConnection); sqCmd.Parameters.AddWithValue("@sessionid", sessionid); sqDatareader = sqCmd.ExecuteReader(); //while a row exists with data while(sqDatareader.Read()) { //int fnum = (int)sqDatareader["frame"]; kFrame frame = new kFrame((int)sqDatareader["session"], (int)sqDatareader["frame"], (string)sqDatareader["object"], (string)sqDatareader["accept"], (double)sqDatareader["x"], (double)sqDatareader["y"], (double)sqDatareader["z"]); frameValues.Add(frame); } } catch (Exception e) { System.Console.WriteLine(e); } System.Console.WriteLine("Sucess. Returning session frames"); return frameValues; }