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