// MAIN CODE BODY BEGIN
// Guard is a rough, prototype application for tracking addiction or other habits
// that a user might wish to be rid of. It is a simple program that tracks dates
// on which a user might "cave in" to a craving and then assists by allowing them
// a date on which they are allowed to partake in a craving. The time spans
// gradually move farther apart based on user settings - allowing for an easier time
// of quitting.
private void MainWindow_Load(object sender, EventArgs e)
{
// CREATE & CONNECT TO DB
//
// First we need to create our tables if they don't exist.
// We use the SQLize class and create some objects first.
SQLize datesTable = new SQLize("CREATE TABLE IF NOT EXISTS Dates (date_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, datetime INTEGER NOT NULL)");
SQLize achTable = new SQLize("CREATE TABLE IF NOT EXISTS Achievements (ach_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, best_time INTEGER NOT NULL)");
SQLize gregTable = new SQLize("CREATE TABLE IF NOT EXISTS Gregorian (greg_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, month STRING NOT NULL," +
" day STRING NOT NULL, day_of_week STRING NOT NULL, year STRING NOT NULL, timestamp STRING NOT NULL)");
// Next we use the Run_Command for the SQLize class to run the commands.
datesTable.Run_Command();
achTable.Run_Command();
gregTable.Run_Command();
// Call RefreshData function to refresh the data
RefreshData();
// RUN THE TIMERS
RefreshGoalDate();
RefreshCountdown();
RefreshElapsed();
}
// ADD NOW BUTTON
//
// When a user clicks the 'Add Now' button, the current date and
// time are entered into the Dates table as a unix timestamp.
private void addNowButton_Click(object sender, EventArgs e)
{
// Delcare some variables we need
Int64 unixTimeThen = 0;
Int64 compare = 0;
Int64 highest = 0;
// When button is clicked
Int64 unixTimeNow = DateTimeOffset.Now.ToUnixTimeSeconds();
// Create a new SQLize instance to get the last date
SQLize retrieveDate = new SQLize("SELECT * FROM Dates ORDER BY datetime DESC LIMIT 1");
// Store this data briefly with the Read_OneDateInt function of SQLizer
unixTimeThen = retrieveDate.Read_OneDateInt();
// Check the difference between unixTimeNow and unixTimeThen with GuardTime
// But ONLY if the value of unixTimeThen is not 0 which would indicate
// that there are no records. We need at least one date entry in the dates
// table to perform calculations!
if (unixTimeThen != 0)
{
GuardTime guard = new GuardTime();
compare = guard.CalcUnixTimeSpan(unixTimeThen, unixTimeNow);
// Create one more SQLize instance to grab the last time span from the achievements table
SQLize retrieveBest = new SQLize("SELECT * FROM Achievements ORDER BY best_time DESC LIMIT 1");
highest = retrieveBest.Read_OneDateInt();
// If the the highest time is 0, then there are no records which means we should add one!
if (highest == 0)
{
// Create a new SQLize instance
SQLize add = new SQLize("INSERT INTO Achievements (best_time) VALUES(" + compare + ")");
// Run that command
add.Run_Command();
}
// If the highest time is not 0, then determine if we should insert a new best time.
if (compare > highest && highest != 0)
{
// Create a new SQLize instance
SQLize add = new SQLize("INSERT INTO Achievements (best_time) VALUES(" + compare + ")");
// Run that command
add.Run_Command();
}
}
// Issue an Insert statement to the Dates table.
SQLize insert = new SQLize("INSERT INTO Dates (datetime) VALUES (" + unixTimeNow + ")");
// Tell SQLize to run the command.
insert.Run_Command();
// Call Refresh Data
RefreshData();
// Refresh our timers
RefreshGoalDate();
RefreshCountdown();
RefreshElapsed();
}
// ADD BUTTON
//
// When a user clicks this button a new record containing a custom date and time
// is inserted into the database and the database is refreshed.
private void addButton_Click(object sender, EventArgs e)
{
// Declare some variables we need
Int64 unixTimeThen = 0;
Int64 compare = 0;
Int64 highest = 0;
// Begin by creating a new SQLize instance to get the last date
SQLize retrieveDate = new SQLize("SELECT * FROM Dates ORDER BY datetime DESC LIMIT 1");
// Store this data briefly with the Read_OneDateInt function of SQLizer
unixTimeThen = retrieveDate.Read_OneDateInt();
// Grab our values from the text box
// Day
string day = dayComboBox.Text;
// Month
string month = monthComboBox.Text;
// Year
string year = yearPicker.Text;
// Time
string time = timePicker.Text;
// Parse these values into Guards date format.
string dateStringRaw = day + " " + month + " " + year + " " + time;
DateTime inputDate = DateTime.Parse(dateStringRaw);
// Get ourselves a datetime offset.
DateTimeOffset dto = new DateTimeOffset(inputDate);
// Turn this into a unix timestamp!
Int64 unixTimeNow = dto.ToUnixTimeSeconds();
// Check the difference between unixTimeNow and unixTimeThen with GuardTime
// But ONLY if the value of unixTimeThen is not 0 which would indicate
// that there are no records. We need at least one date entry in the dates
// table to perform calculations!
if (unixTimeThen != 0)
{
// Check the difference between unixTimeNow and unixTimeThen with GuardTime
GuardTime guard = new GuardTime();
compare = guard.CalcUnixTimeSpan(unixTimeThen, unixTimeNow);
// Create one more SQLize instance to grab the last time span from the achievements table
SQLize retrieveBest = new SQLize("SELECT * FROM Achievements ORDER BY best_time DESC LIMIT 1");
highest = retrieveBest.Read_OneDateInt();
// If the highest time is 0, then there are no records whcih means we should add one!
if (highest == 0)
{
// Create a new SQLize instance
SQLize add = new SQLize("INSERT INTO Achievements (best_time) VALUES(" + compare + ")");
// Run that command
add.Run_Command();
}
// Determine if we should insert a new best time
// If the highest time is not 0, then determine if we should insert a new best time!
if (compare > highest && highest != 0)
{
// Create a new SQLize instance
SQLize add = new SQLize("INSERT INTO Achievements (best_time) VALUES(" + compare + ")");
// Run that command
add.Run_Command();
}
}
// Create our date
//string dateStringNew = "\'" + unixTimeNow.ToString() + "\'";
// Issue an insert statement to the Dates table
SQLize insert = new SQLize("INSERT INTO Dates (datetime) VALUES (" + unixTimeNow + ")");
// Tell SQLize to run the command.
insert.Run_Command();
}