public void Incomplete(dto.TaskIdentifier input)
{
var cmd = this.MySqlDatabase.Connection.CreateCommand() as MySqlCommand;
cmd.CommandText = @"UPDATE Tasks SET Completed = NULL WHERE TaskId = @TaskId;";
cmd.Parameters.AddWithValue("@TaskId", input.TaskId);
var recs = cmd.ExecuteNonQuery();
}
public void Archive(dto.TaskIdentifier input)
{
var cmd = this.MySqlDatabase.Connection.CreateCommand() as MySqlCommand;
cmd.CommandText = @"UPDATE Tasks SET Archived = STR_TO_DATE(@Date, '%Y/%m/%d') WHERE TaskId = @TaskId;";
cmd.Parameters.AddWithValue("@TaskId", input.TaskId);
cmd.Parameters.AddWithValue("@Date", DateTime.Now.ToString("yyyy/MM/dd"));
var recs = cmd.ExecuteNonQuery();
}