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

<h1 style="text-align: center;">[ /App_Code/MemberGroup.cs ]</h1>
<h2>[what]</h2>
<ol style="font-size: 10px; font-weight: normal; text-align: start;">
<li>] MemberGroup.cs - documenting properties, constructors, methods and ... for this application component ] a container class for Members&nbsp;</li>
<li>] ARGS = none, id,&nbsp;</li>
</ol>
<h2>[why]</h2>
<ol>
<li>]&nbsp;</li>
</ol>
<h2>[where]&nbsp;</h2>
<ol>
<li><strong>[USING]</strong></li>
<ol>
<li>x] System - console &amp; ...&nbsp;</li>
<li>x] System.Collections - for ArrayList</li>
<li>x] System.Collections.Generic - for ieNumerable, used by ...</li>
<li>x] System Dynamic - for Dynamic types, used by ..</li>
<li>x] System.Web - for httpContext, used by ... to access Session var ( get current_db)</li>
<li>x] WebMatrix.Data - for Database methods, used by ... ] all</li>
<li>x] WebMatrix.Data.StronglyTyped - for data library ST that converts dynamics to ST objects</li>
</ol>
<li><strong>[PROPERTIES]</strong></li>
<ol>
<li>] public int id_group -</li>
<li>] public string name_group -&nbsp;</li>
<li>] public string description_group -</li>
<li>] public int parent_id -</li>
<li>] public static Database sospep {</li>
<li>get&nbsp;</li>
<li>}-&nbsp;</li>
<li>] private const string qryGetMemberGroups - qry to return all membergroups</li>
<li>] private const string&nbsp;qryGetMemberGroupsInMember&nbsp;- qry to return&nbsp;all membergroups&nbsp;in a given Member</li>
<li>] private const string&nbsp;qryGetMemberGroup - qry to return&nbsp;a single membergroup by a given id</li>
<li>] private const string&nbsp;qryAddMemberGroup - qry that inserts a new membergroups&nbsp;record</li>
<li>] private const string&nbsp;qryDeleteMemberGroup - qry that deletes a single membergroup&nbsp;record</li>
<li>] private const string&nbsp;qryUpdateMemberGroup - qry that updates a single membergroup&nbsp;record&nbsp;</li>
</ol>
<li><strong>[PROPERTIES.objects]</strong></li>
<ol>
<li>] public Community community -</li>
<li>] public Member member -</li>
</ol>
<li><strong>[CONSTRUCTORS]</strong></li>
<ol>
<li>] MemberGroup() - default, empty&nbsp;</li>
<li>] MemberGroup(int id) - takes id of existing MemberGroup, instantiates this.MemberGroup with the properties of an existing MemberGroup</li>
<li>] MemberGroup(string name, string description, int parent_id) - takes name and description args of MemberGroup to create a new membergroup</li>
<ol>
<li>* OR] MemberGroup(string name) - instantiates a new instance of MemberGroup object - based on lookup of existing MemberGroup by name</li>
</ol>
<li>] MemberGroup(int id, string src_db,) - instantiates a new instance of MemberGroup object</li>
</ol>
<li><strong>[METHODS-]</strong></li>
<ol>
<li>]&nbsp;public static IEnumerable&lt;MemberGroup&gt;GetMemberGroups()</li>
<li>]&nbsp;public static IEnumerable&lt;MemberGroup&gt;GetMemberGroupsInMember(int id)&nbsp;</li>
<li>]&nbsp;public static IEnumerable&lt;MemberGroup&gt;GetMemberGroupsInMember(string src_db, int id_member)&nbsp;</li>
<li>]&nbsp;public void add()&nbsp;</li>
<li>]&nbsp;public static void add(string name, string description, int parent_id)&nbsp;</li>
<li>] public void delete()</li>
<li>]&nbsp;public static void delete(int id)</li>
<li>]&nbsp;public void edit()&nbsp;</li>
<li>]&nbsp;public static void edit(string name, string description, int parent_id, int id )</li>
<li>] public static int getMaxId()&nbsp;</li>
<li>]&nbsp;public static void import(string src_db,string dest_db,int srcMemberGroupId, int destMemberId)&nbsp;</li>
<li>]&nbsp;&nbsp;public static int GetDefaultMemberGroupId()&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>] 2012-mm-dd - MemberGroup.cs - NEW FILE REF #&nbsp;</li>
<li>] 2012-11-19 - MemberGroup.cs - PRB import task fail&nbsp;</li>
</ol>
<h2>[related]</h2>
<div><ol>
<li>]&nbsp;</li>
</ol></div>
<hr />
<h1 style="text-align: center;">developer implementation</h1>
<h2>[-process]</h2>
<ol>
<li>
<div><strong>&nbsp;[00:00] NEW tak</strong></div>
</li>
<ol>
<li><strong>+++ = properties</strong></li>
<li>] count - non-persistent -</li>
<li>] lastIn</li>
</ol></ol>
<h2>[-notes]</h2>
<ol>
<li><strong>[METHODS-STATIC]</strong></li>
<ol>
<li>&nbsp;ListAll()&nbsp;</li>
<li><span style="background-color: #888888;">] ById()&nbsp;</span></li>
</ol>
<li><span style="background-color: #888888;"><strong>[METHODS-</strong><strong>OTHER</strong><strong>]</strong></span></li>
<ol>
<li><span style="text-decoration: line-through; background-color: #888888;">] setItemsStatus(status, ids) - sets all items to the given status</span></li>
<li><span style="text-decoration: line-through; background-color: #888888;">] setItemsName(name, ids) - sets all user selected items "names" to the given name</span></li>
<li><span style="text-decoration: line-through; background-color: #888888;">] setItemsDescription(description, ids) - sets all user selected items "descriptions" to the given description</span></li>
<li><span style="text-decoration: line-through; background-color: #888888;">] setItemsCOGS(cogs, ids) - sets all user selected items "cogs" to the given value</span></li>
<li><span style="text-decoration: line-through; background-color: #888888;">] setItemsQuantity(quantity, ids) - sets all user selected items "quantity" to the given value</span></li>
<li><span style="text-decoration: line-through; background-color: #888888;">] setItemsUnit(unit, ids) - sets all user selected items "unit" to the give value</span></li>
</ol></ol><hr />
<h1 style="text-align: center;">status</h1>
<h2>[-previous-]</h2>
<ol>
<li><strong>[2017-05-04] NEW task</strong></li>
<ol>
<li>x] # 7297 - CREATE-doc - MemberGroup.cs (this)</li>
</ol>
<li><strong>[2017-05-04] NEW task</strong></li>
<ol>
<li>x] FIX-PRB-7140 - x] addED explicit &nbsp;db connection close, db close and db Dispose() statement to methods</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