public void Hub() { DBUtils.OpenConection(); try { //if ( DBUtils.ExecuteScalar("SELECT COUNT(ID) FROM InputsView" ) > 0 && !isOn) // { try { IsOn(); } catch (Exception) { } if (begginingID == 0) { if (!isOn) { File.WriteAllText(path, DBUtils.ExecuteScalar("SELECT ID FROM InputsView ORDER BY Id DESC LIMIT 1").ToString()); isOn = true; } } // } } catch (Exception) { } DBUtils.CloseConnection(); }
private void Resutls() { SortList(); int mistakesCount = CompareArrays(); int percentage = Percentage(mistakesCount); int average = ListSum(); int ajustedAverage = CalculateAverage(mistakesCount, average, percentage); string userLevel = GetUserLevel(ajustedAverage); string message = ""; if (ajustedAverage == 0) { message = string.Format("You've made too many mistakes. {0} words were written with mistakes \n Which is {1}% of whole written text", mistakesCount, percentage); } else { DBUtils.OpenConection(); string query = string.Format("UPDATE User_level SET user_level = '{0}', user_speed = {1} WHERE Id=1", userLevel, ajustedAverage + 400); DBUtils.ExecuteQueries(query); DBUtils.CloseConnection(); message = string.Format("Your level has been assigned:{0} \n Your average typing speed is {1}", userLevel, ajustedAverage + 400); } mainForm.CheckForAutoCalibration(false); MessageBox.Show(message); }
public int UserLevelCheck() { try { DBUtils.OpenConection(); userLevel = DBUtils.ExecuteScalar("SELECT user_speed FROM user_level WHERE Id = 1"); DBUtils.CloseConnection(); if (userLevel < 500) { return(-100); } } catch (Exception a) { MessageBox.Show(a.ToString()); return(-500); } if (userLevel >= 500) { return(userLevel); } else { return(-100); } }
public int StoreHeatMapAndInputs() //TODO: make this thing async or something { if (inputBuffer.Any()) { writeInProgress = true; List <InputObj> tempList = new List <InputObj>(inputBuffer); inputBuffer.Clear(); DBUtils.OpenConection(); string query; foreach (var item in tempList) { query = string.Format("INSERT INTO Heatmap (input,delay,date,program_id) " + "VALUES ('{0}', {1}, '{2}', '{3}')", item._inputKey, item._delay, item._dateStamp.ToString(), item._programID); DBUtils.ExecuteQueries(query); if (item._inputASCI == "'") { item._inputASCI = "''"; } query = string.Format("INSERT INTO Inputs ([input], [program_id], [datetime], [timestamp]) VALUES ('{0}', {1}, '{2}', {3})", item._inputASCI, item._programID, item._dateStamp, item._delay); DBUtils.ExecuteQueries(query); } DBUtils.CloseConnection(); } writeInProgress = false; return(1); }
public int Run() { isLoadedFixed = false; isLoadedMistakes = false; isLoadedMistakesSpeed = false; isLoaderTypingSpeed = false; DBUtils.OpenConection(); if (!isLoadedMistakes) { MistakesCountLoader(); } if (!isLoaderTypingSpeed) { TypingSpeedLoader(); } if (!isLoadedMistakesSpeed) { MistakesSpeedLoader(); } if (!isLoadedFixed) { TimeSpentFixingLoader(); } DBUtils.CloseConnection(); return(1); }
public int RunFirst() { DBUtils.OpenConection(); AllInputsTypingSpeed(); if (selectedGraph == "mistakes") { MistakesCountLoader(); } else if (selectedGraph == "typing speed") { TypingSpeedLoader(); } else if (selectedGraph == "mistakes/speed") { MistakesSpeedLoader(); } else if (selectedGraph == "fixed") { TimeSpentFixingLoader(); } DBUtils.CloseConnection(); return(1); }
public void LoadTex() { DBUtils.OpenConection(); int userLevel = DBUtils.ExecuteScalar("SELECT user_speed FROM User_level WHERE id = 1"); DBUtils.CloseConnection(); if (userLevel > 200 && userLevel < 10000) { label_userLevel.Text = userLevel.ToString() + "ms"; } }
public int Run() { DBUtils.OpenConection(); if (selectedStats != "del_rep") { mistList = DBUtils.ReadMistakes(query + where); } if (selectedStats != "words") { wordsList = DBUtils.ReadWords(query + where); } DBUtils.CloseConnection(); return(1); }
private void materialFlatButton1_Click(object sender, EventArgs e) { if (numeric.Value < 200 || numeric.Value > 10000) { MessageBox.Show("Wrong values"); } else { DBUtils.OpenConection(); DBUtils.ExecuteQueries(string.Format("UPDATE User_level SET user_speed = {0} WHERE Id=1", numeric.Value)); DBUtils.CloseConnection(); cbMain.LoadTex(); mainForm.CheckForAutoCalibration(false); this.Close(); } }
public int Run() { DBUtils.OpenConection(); if (selectedHeatMap == "delay") { GetDelayHeatmap(); GetDailyHeatmap("SELECT AVG(delay) FROM HeatmapView WHERE strftime('%H:%M:%S', date) BETWEEN '{0}' AND '{1}' {2} "); GetWeeklyHeatmap("SELECT AVG(delay) FROM HeatmapView WHERE strftime('%w', date) = '{0}' {1}"); } else if (selectedHeatMap == "times_pressed") { GetTimesPressedHeatmap(); GetDailyHeatmap("SELECT COUNT(input) FROM HeatmapView WHERE strftime('%H:%M:%S', date) BETWEEN '{0}' AND '{1}' {2} "); GetWeeklyHeatmap("SELECT COUNT(input) FROM HeatmapView WHERE strftime('%w', date) = '{0}' {1}"); } DBUtils.CloseConnection(); return(1); }
public void CheckBoxFilter(DataGridView filterGrid) { List <ProgramExe> programList = new List <ProgramExe>(); try { foreach (DataGridViewRow row in filterGrid.Rows) { bool check = (bool)row.Cells["checkbox"].Value; int id = (int)row.Cells["id"].Value; ProgramExe program = new ProgramExe(id, check); programList.Add(program); } DBUtils.OpenConection(); foreach (var item in programList) { string query = string.Format("UPDATE Programs SET filter={0} WHERE Id={1} ", Convert.ToInt16(item._filter), item._id); DBUtils.ExecuteQueries(query); } DBUtils.CloseConnection(); // mistakes.MistakesHub(); JEIGU MISTAKES FILTRAS NEVEKIA BRING THIS BACK string connectionString = "Data Source=DatabaseLite.sqlite;Version=3;PRAGMA journal_mode=WAL;"; OrmLiteConnectionFactory dbFactory = new OrmLiteConnectionFactory(connectionString, SqliteDialect.Provider); //DateTime test = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); using (IDbConnection db = dbFactory.OpenDbConnection()) { //var filteredData = db.TABLE.Where(t => t.DATE > startDate && t.DATE < endDate); //var rows = db.From<Heatmap>().Where(x => x.date.CompareTo("2018-05-05 00:00:00") >= 0 && x.date.CompareTo("2018-06-21 23:59:59") <= 0); var rows = db.From <Heatmap>().Where <Heatmap>(x => x.program_id == 12); //db.From<Program>().Insert() } } catch (Exception xe) { MessageBox.Show(xe.ToString()); } }
private static int GetExeID() { IntPtr hwnd = WindowsAPI.GetForegroundWindow(); uint pid; WindowsAPI.GetWindowThreadProcessId(hwnd, out pid); int processId = (int)pid; IntPtr hprocess = WindowsAPI.OpenProcess(ProcessAccessFlags.All, false, processId); var buffer = new StringBuilder(1024); int size = buffer.Capacity; if (WindowsAPI.QueryFullProcessImageName(hprocess, 0, buffer, out size)) { buffer.ToString(); } Process p = Process.GetProcessById((int)pid); DBUtils.OpenConection(); if (p != null) { try { exeID = DBUtils.GetExeID(p); } catch (Exception ex) { } } else { } isTrackable = Convert.ToBoolean(DBUtils.ExecuteScalar(string.Format("SELECT filter FROM Programs WHERE Id = {0} ", exeID))); DBUtils.CloseConnection(); return(1); }
public void ResetProgram(MainForm mf) { DBUtils.OpenConection(); string[] tables = { "Heatmap", "Inputs", "Mistakes", "Programs", }; foreach (var table in tables) { DBUtils.ExecuteQueries("delete from " + table); DBUtils.ExecuteQueries(string.Format("UPDATE sqlite_sequence SET seq = 1 WHERE name = '{0}'", table)); } DBUtils.ExecuteQueries(string.Format("UPDATE User_level SET user_speed = {0} WHERE Id=1", 0)); DBUtils.CloseConnection(); string path = Application.StartupPath + "\\AuCal.json"; File.WriteAllText(path, ""); MessageBox.Show("Please restart the aplication"); mf.Close(); }
private void userLevelTimer_Tick(object sender, EventArgs e) { AsyncStoreHeatnInput(); userLevelTimer.Enabled = false; sw.Reset(); inputStopWatch.Reset(); timer2.Stop(); normalInputSW.Reset(); if (autContrl.isOn) { DBUtils.OpenConection(); int test = DBUtils.ExecuteScalar(autContrl.lastRowIDQuery); int test2 = autContrl.begginingID; if (DBUtils.ExecuteScalar(autContrl.lastRowIDQuery) - autContrl.begginingID > 2500) { timer2.Interval = autContrl.CalculateUserLevel(); //autContrl.isOn = false; } DBUtils.CloseConnection(); } }
private async void TestInsert() { string connectionString = "Data Source=DatabaseLite.sqlite;Version=3;PRAGMA journal_mode=WAL;"; OrmLiteConnectionFactory dbFactory = new OrmLiteConnectionFactory(connectionString, SqliteDialect.Provider); List <int> stList = new List <int>(); Stopwatch st = new Stopwatch(); Heatmap ht = new Heatmap(); ht.date = "2018-06-20 10:06:14"; ht.delay = 500; ht.program_id = 12; ht.input = "Return"; using (IDbConnection db = dbFactory.OpenDbConnection()) { using (IDbTransaction trans = db.OpenTransaction()) { st.Start(); // db.BeginTransaction(); for (int i = 0; i < 500000; i++) { db.Insert(ht); } trans.Commit(); st.Stop(); stList.Add((int)st.ElapsedMilliseconds); }; }; /* using (var db = dbFactory.Open()) * { * for (int i = 0; i < 100; i++) * { * db.ExecuteNonQuery("BEGIN"); * db.Insert(new Heatmap { input = "Return", delay = 500, date = "2018-06-20 10:06:14", program_id = 12 }); * db.ExecuteNonQuery("end"); * } * st.Stop(); * stList.Add((int)st.ElapsedMilliseconds); * }*/ DBUtils.OpenConection(); st.Restart(); for (int i = 0; i < 500000; i++) { query = "INSERT INTO Heatmap (input,delay,date,program_id) " + "VALUES ('Return', 500, '2018-06-20 10:06:1', '12')"; DBUtils.ExecuteQueries(query); } st.Stop(); stList.Add((int)st.ElapsedMilliseconds); DBUtils.CloseConnection(); string t = ""; using (var db = dbFactory.Open()) { } }
public void InitializePrograms() { DBUtils.OpenConection(); programList = DBUtils.ReadPrograms(); DBUtils.CloseConnection(); }
public void WriteToDB(string query) { DBUtils.OpenConection(); DBUtils.ExecuteQueries(query); DBUtils.CloseConnection(); }
public void SetUserLevel(int level) { DBUtils.OpenConection(); DBUtils.ExecuteQueries(string.Format("UPDATE User_level SET user_speed = {0} WHERE Id=1", level)); DBUtils.CloseConnection(); }