(public).sospep.events ~ view task ~ CLASS-Plan

<h1 style="text-align: center;">[ Plan.cs ]</h1>
<h2>[what]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li>]&nbsp;CLASS Plan - documenting properties, constructors, methods and ... for this application component</li>
</ol>
<h2>[why]</h2>
<ol>
<li>]&nbsp;</li>
</ol>
<h2>[where]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li style="font-size: 10px; font-weight: normal;"><strong>[USING]</strong></li>
<ol style="font-size: 10px; font-weight: normal;">
<li>] System - console &amp; ...</li>
<li>] System.Collections - for ArrayList,&nbsp;</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 style="font-size: 10px; font-weight: normal;"><strong>[PROPERTIES]&nbsp;</strong>&nbsp;</li>
<ol style="font-size: 10px; font-weight: normal;">
<li>] id_plan -&nbsp;</li>
<li>] name_plan -&nbsp;</li>
<li>] description_plan -</li>
<li>] parent_id -&nbsp;</li>
<li>] database -&nbsp;</li>
<li>] qryGetPlans - all plans</li>
<li>] qryGetPlansInCalendar - all plans in a given warehouse</li>
<li>] qryAddPlan</li>
<li>] qryDeletePlan&nbsp;</li>
<li>] qryUpdatePlan</li>
<li>+++]&nbsp;</li>
<li>] count - non-persistent -</li>
<li>] lastIn -&nbsp;</li>
<li>[objects]</li>
<li>] Calendar&nbsp;</li>
</ol>
<li style="font-size: 10px; font-weight: normal;"><strong>[CONSTRUCTORS]&nbsp;</strong></li>
<ol style="font-size: 10px; font-weight: normal;">
<li style="font-size: 10px; font-weight: normal;">] Plan() - default, empty&nbsp;</li>
<li style="font-size: 10px; font-weight: normal;">] Plan(int id) - takes id of existing Plan, instantiates this.Plan with the properties of existing Plan</li>
<li style="font-size: 10px; font-weight: normal;">] Plan(string name, string description)- takes name and description args of Plan to create a new Plan object</li>
<li style="font-size: 10px; font-weight: normal;">] Plan(string name) - instantiates a new instance of Plan object - based on lookup of existing Plan&nbsp;</li>
<li style="font-size: 10px; font-weight: normal;">+++</li>
<li style="font-size: 10px; font-weight: normal;">] Plan(int id,string name, ...) - instantiates a new instance of Calendar object</li>
</ol>
<li style="font-size: 10px; font-weight: normal;"><strong>[METHODS]</strong></li>
<ol style="font-size: 10px; font-weight: normal;">
<li style="font-size: 10px; font-weight: normal;">] GetPlans() -</li>
<li style="font-size: 10px; font-weight: normal;">] ListAll() -</li>
<li style="font-size: 10px; font-weight: normal;">] ById() -&nbsp;</li>
<li style="font-size: 10px; font-weight: normal;">] GetPlansInCalendar(id_calendar)</li>
<li style="font-size: 10px; font-weight: normal;">] GetPlansInCalendar(src_db, id_calendar)</li>
<li style="font-size: 10px; font-weight: normal;">] add () - add using the currently instantiated instance&nbsp;</li>
<li style="font-size: 10px; font-weight: normal;">] add (name,description) - STATIC where=?, change to&nbsp;</li>
<li style="font-size: 10px; font-weight: normal;">] delete() -&nbsp;</li>
<li style="font-size: 10px; font-weight: normal;">] delete(id) - &nbsp;STATIC</li>
<li style="font-size: 10px; font-weight: normal;">] edit()&nbsp;</li>
<li style="font-size: 10px; font-weight: normal;">] edit(name,description ,..., id) - STATIC</li>
<li style="font-size: 10px; font-weight: normal;">] edit ()</li>
<li style="font-size: 10px; font-weight: normal;"><strong>[STATIC]</strong></li>
<li style="font-size: 10px; font-weight: normal;">] setItemsStatus(status, ids) - sets all items to the given status</li>
<li style="font-size: 10px; font-weight: normal;">] setItemsName(name, ids) - sets all user selected items "names" to the given name</li>
<li style="font-size: 10px; font-weight: normal;">] setItemsDescription(description, ids) - sets all user selected items "descriptions" to the given description</li>
<li style="font-size: 10px; font-weight: normal;">] setItemsCOGS(cogs, ids) - sets all user selected items "cogs" to the given value</li>
<li style="font-size: 10px; font-weight: normal;">] setItemsQuantity(quantity, ids) - sets all user selected items "quantity" to the given value</li>
<li style="font-size: 10px; font-weight: normal;">] setItemsUnit(unit, ids) - sets all user selected items "unit" to the give value&nbsp;</li>
<li style="font-size: 10px; font-weight: normal;"><strong>[ADD]</strong></li>
<li style="font-size: 10px;">]</li>
<li style="font-size: 10px;"><strong style="font-weight: normal;">[EDITS]</strong></li>
<li style="font-size: 10px; font-weight: normal;">]</li>
<li style="font-size: 10px; font-weight: normal;"><strong>[OTHER]</strong></li>
<li style="font-size: 10px; font-weight: normal;">] &nbsp;getMaxId - returns the id of the last record inserted into the&nbsp;</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>]</li>
</ol><hr />
<h1 style="text-align: center;">developer implementation</h1>
<h2>[-process]</h2>
<ol>
<li>
<div>&nbsp;]&nbsp;</div>
</li>
</ol>
<h2>[-notes]</h2>
<ol>
<li>
<div>&nbsp;]&nbsp;</div>
</li>
</ol><hr />
<h1 style="text-align: center;">status</h1>
<h2>[-previous-]</h2>
<ol>
<li><strong>[2017-04-11] NEW task&nbsp;</strong></li>
<ol>
<li>x] # 7223 - <a href="/view/task?id=7223" target="_blank">CREATE-task# #</a> - Plan.cs - documentation for the Plan class, copied&nbsp;</li>
</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>

~ view task ~ TaskGroup] CLASSES FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep