edit-task

Task Name:

Task Description:

TaskGroup ID:

Start Date:

Start Time:

Duration:

Priority:

Status:

Add Photo:

Owner ID:

Content: use HTML Edit Content

<h1 style="text-align: center;">[ TaskGroup.cs ]</h1>
<h2>[what]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li>] Taskgroup.cs - documenting properties, constructors, methods and ... for this application component</li>
<li>] a container class for tasks</li>
</ol>
<h2>[why]</h2>
<ol>
<li>]&nbsp;</li>
</ol>
<h2>[where]&nbsp;</h2>
<ol>
<li><strong>[USING]</strong></li>
<ol>
<li>] System - console &amp; ...&nbsp;</li>
<li>] System.Collections - for ArrayList</li>
<li>] System.Collections.Generic - for ieNumerable, used by ...</li>
<li>] System Dynamic - for Dynamic types, used by ..</li>
<li>] System.Web - for httpContext, used by ... to access Session var ( get current_db)</li>
<li>] WebMatrix.Data - for Database methods, used by ... ] all</li>
<li>] WebMatrix.Data.StronglyTyped - for data library ST that converts dynamics to ST objects</li>
</ol>
<li><strong>[PROPERTIES]</strong></li>
<ol>
<li>] id_taskgroup -</li>
<li>] name_taskgroup -&nbsp;</li>
<li>] description_taskgroup -</li>
<li>] parent_id -</li>
<li>] database -&nbsp;</li>
<li>] qryGetTaskGroups - qry to return all taskgroup</li>
<li>] qryGetTaskGroup - qry to return&nbsp;a single taskgroup</li>
<li>] qryGetTaskGroupsInPlan - qry to return&nbsp;all taskgroups in a given Plan</li>
<li>] qryAddTaskGroup - qry that inserts a new taskgroup record</li>
<li>] qryDeleteTaskGroup - qry that deletes a single taskgroup record</li>
<li>] qryUpdateTaskGroup - qry that updates a single taskgroup record&nbsp;</li>
<li><strong>+++&nbsp;</strong></li>
<li>] count - non-persistent -</li>
<li>] lastIn</li>
</ol>
<li><strong>[PROPERTIES.objects]</strong></li>
<ol>
<li>] calendar cal -</li>
<li>] plan pln -</li>
</ol>
<li><strong>[CONSTRUCTORS]</strong></li>
<ol>
<li>] TaskGroup() - default, empty&nbsp;</li>
<li>] TaskGroup(int id) - takes id of existing TaskGroup, instantiates this.TaskGroup with properties of existing TaskGroup</li>
<li>] TaskGroup(string name, string description, int parent_id)- takes name and description args of TaskGroup to create a new taskgroup</li>
<ol>
<li>OR] TaskGroup(string name) - instantiates a new instance of TaskGroup object - based on lookup of existing TaskGroup by name</li>
</ol>
<li>] TaskGroup(int id_tgr, string src_db,) - instantiates a new instance of TaskGroup object</li>
</ol>
<li><strong>[METHODS-]</strong></li>
<ol>
<li>x] add()</li>
<li>x] delete()</li>
<li>x] edit()</li>
</ol>
<li><strong>[METHODS-STATIC]</strong></li>
<ol>
<li>x] add(name,parent,description) - adds record to&nbsp;db&nbsp;using the currently instantiated instance</li>
<li>x] delete(id)</li>
<li>x] edit(name, description)</li>
<li>x] GetTaskGroups() -&nbsp;</li>
<li>x] GetDefaultTaskGroupId() - returns the id of the default || user specified 'default taskgroup'</li>
<li>x] GetTaskGroupsInPlan(id)&nbsp;</li>
<li>x] GetTaskGroupsInPlan(id, src_db)&nbsp;</li>
<li>x] getMaxId()- returns the id of the last record inserted into the&nbsp;</li>
<li>x] import()</li>
<li>***</li>
<li>] ListAll()&nbsp;</li>
<li>] ById()&nbsp;</li>
</ol>
<li><strong>[METHODS-</strong><strong>OTHER</strong><strong>]</strong></li>
<ol>
<li><span style="text-decoration: line-through;">] setItemsStatus(status, ids) - sets all items to the given status</span></li>
<li><span style="text-decoration: line-through;">] setItemsName(name, ids) - sets all user selected items "names" to the given name</span></li>
<li><span style="text-decoration: line-through;">] setItemsDescription(description, ids) - sets all user selected items "descriptions" to the given description</span></li>
<li><span style="text-decoration: line-through;">] setItemsCOGS(cogs, ids) - sets all user selected items "cogs" to the given value</span></li>
<li><span style="text-decoration: line-through;">] setItemsQuantity(quantity, ids) - sets all user selected items "quantity" to the given value</span></li>
<li><span style="text-decoration: line-through;">] setItemsUnit(unit, ids) - sets all user selected items "unit" to the give value</span></li>
</ol></ol>
<h2>[when]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li>]</li>
</ol>
<h2>[example]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li>]</li>
</ol>
<h2>[how-to]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li>]</li>
</ol>
<h2>[reference]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li>] 2012-06-17 - TaskGroup.cs - NEW FILE REF #&nbsp;</li>
<li>] 2012-11-19 - TaskGroup.cs - PRB import task fail&nbsp;</li>
</ol><hr />
<h1 style="text-align: center;">developer implementation</h1>
<h2>[-process]</h2>
<ol>
<li>
<div>&nbsp;</div>
</li>
</ol>
<h2>[-notes]</h2>
<ol>
<li>
<div>&nbsp;</div>
</li>
</ol><hr />
<h1 style="text-align: center;">status</h1>
<h2>[-previous-]</h2>
<ol>
<li><strong>[2017-03-15] NEW task</strong></li>
<ol>
<li>x] FIX-PRB-7140 - add explicit db connection close, db close statements</li>
</ol>
<li><strong>[2017-04-11] NEW task</strong></li>
<ol>
<li>x] FIX-PRB-7140 - add explicit db Dispose() statement</li>
</ol></ol>
<h2>[-current-]</h2>
<ol>
<li>
<div>&nbsp;]</div>
</li>
</ol>
<h2>[-next-]</h2>
<ol>
<li>
<div>]</div>
</li>
</ol>
<p>&nbsp;</p>
<p>&nbsp;</p>