Create a very simple application to keep a todo list using an access database.
Very simple application, 3 interfaces, database and queries provided
Program must be done in Visual C# 2008
## Deliverables
Hi,
here are the requirements:
The solution name should be Todo
The application should contain a tabcontrol taking 100% of the interface.
When the application starts, there should be a single tab named "Urgent"
In this tab, there should be a? list of elements with multiple columns taking 100% of the tabPage
Columns will be:
Priority => iTaskPriority
Category => sCategoryName
Name => sTaskName
Detail => (YES or nothing)
reated? => dtTaskDate (Show date as 2010-06-30)
Completed => Should contain a checkbox
The query to fill the data of the first tab should be:
~~~~~~~~~~~
SELECT
? ? ? ? [login to view URL],
? ? ? ? [login to view URL],
? ? ? ? [login to view URL],
? ? ? ? [login to view URL],
? ? ? ? IF(
? ? ? ? ? ? ? ? [login to view URL] !=? "",
? ? ? ? ? ? ? ? "YES",
? ? ? ? ? ? ? ? ""
? ? ? ? ),
? ? ? ? [login to view URL],
? ? ? ? [login to view URL]
FROM
? ? ? ? tCategory,
? ? ? ? tTask
WHERE
? ? ? ? [login to view URL] = [login to view URL]
AND
? ? ? ? [login to view URL] = 1
AND
? ? ? ? [login to view URL] = 0
ORDER BY
? ? ? ? [login to view URL]
~~~~~~~~~~~
Then, you should query the database:
~~~~
SELECT
? ? ? ? pkiCategoryID,
? ? ? ? sCategoryName
From
? ? ? ? tCategory
ORDER BY
? ? ? ? sCategoryName
~~~~
For each of these categories, create a new Tab with the name sCategoryName. (Keep the pkiCategoryID value, we'll need it later
All of the tabs will contain a list of elements with multiple columns taking 100% of the tabPage
Columns will be:
Priority => iTaskPriority
Name => sTaskName
Detail => (YES or nothing)
Created? => dtTaskDate (Show date as 2010-06-30)
Completed => Should contain a checkbox
The query to fill the data of? all the other tabs should be:
~~~~~~~~~~~
SELECT
? ? ? ? [login to view URL],
? ? ? ? [login to view URL],
? ? ? ? [login to view URL],
? ? ? ? IF(
? ? ? ? ? ? ? ? [login to view URL] !=? "",
? ? ? ? ? ? ? ? "YES",
? ? ? ? ? ? ? ? ""
? ? ? ? ),
? ? ? ? [login to view URL],
? ? ? ? [login to view URL]
FROM
? ? ? ? tTask
WHERE
? ? ? ? [login to view URL] =XXXXXXXX (The category ID of the currently selected TAB
AND
? ? ? ? [login to view URL] = 0
ORDER BY
? ? ? ? [login to view URL],
? ? ? ? [login to view URL]
~~~~~~~~~~~
In all the tabs, clicking on the "Completed" checkbox should send this query to the database
~~~~
UPDATE
? ? ? ? tTask
SET
? ? ? ? bTaskCompleted = 1
WHERE
? ? ? ? pkiTaskID = XXXXXXXXXXX
~~~~
Double clicking on a task in the list should open a popup with basic editing capabilities. All fields should be updatable except the pkiTaskID which should be shown only. You can use the automatic dataset editing functionality so it should take 2 minutes to develop.
Finally, Adding a task should be possible by either using "New Task" from the system menu, or pressing "Control-N" on the keyboard. After saving to the database, the form? should be cleared and we should be able to create a new task. (The pkiTaskID is autoincrement so no need to display, the dtTaskDate should contain today's date by default, category should be a dropdown, tTaskContent should be a richtextbox)
Everytime we update a task, create a task or change tab, the list content should be refreshed from the database
Thanks