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