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

<h1 style="text-align: center;">[ CLASS App_Code/Community.cs ]</h1>
<h2>[WHAT]</h2>
<ol>
<li>[ def ] class to work with Community objects</li>
<li>[ args ] none, id&nbsp;</li>
<li>*]&nbsp;</li>
</ol>
<h2>[WHY]</h2>
<ol>
<li><strong>[Properties]</strong></li>
<ol>
<li>] public int id_community;</li>
<li>] public string name_community;&nbsp;</li>
<li>] public string description_community;&nbsp;</li>
<li>] private const string qryGetCommunities = "...qry..."</li>
<li>] private const string qryGetCommunity = "...qry..."</li>
<li>] private const string qryGetCommunityNamed = "SELECT * FROM communities WHERE name_community=@0";</li>
<li>] private const string qryAddCommunity = "...qry..."</li>
<li>] private const string qryDeleteCommunity = "...qry..."</li>
<li>] private const stringqryUpdateCommunity = "...qry..."</li>
<li>] public static Database sospep&nbsp;</li>
<li>{</li>
<li>&nbsp;get</li>
<li>}</li>
</ol>
<li><strong>[Constructors]</strong></li>
<ol>
<li>] Community();</li>
<li>] Community(string name, string description);</li>
<li>] Community(int id);</li>
<li>] Community(string name_community);</li>
</ol>
<li><strong>??[Methods] ??</strong></li>
<ol>
<li>] public static IEnumberable&lt;Community&gt;GetCommunities()</li>
<li>] public static IEnumberable&lt;Community&gt;GetCommunities(int start, int quantity)</li>
<li>] public void add()</li>
<li>] public static void add(string name, string description)</li>
<li>] public void delete()</li>
<li>] public static void delete(id_coummunity)</li>
<li>] public void edit()</li>
<li>] public static void edit(string name, string description, int id)</li>
<li>] public static int getMaxId()&nbsp;</li>
<li>] public static long recordCount()</li>
<li>] public static void import(string src_db, string dest_db, int src_community_id)</li>
<li>] public static int copy(string src_db, int id_community)</li>
</ol></ol>
<h2>[WHERE]</h2>
<ol>
<li><strong>[ called from]&nbsp;</strong></li>
<ol>
<li>] PAGE - view/communities -</li>
<li>]&nbsp;PAGE -&nbsp;view/community -</li>
<li>]&nbsp;PAGE -&nbsp;edit/community -</li>
<li>]&nbsp;PAGE -&nbsp;add/community -&nbsp;</li>
</ol></ol>
<h2>[WHEN]</h2>
<ol>
<li>] 2017-05-03 - created documentation PAGE record for class, PREV documentation record = # 2308 (as pre REF in SRC)</li>
</ol>
<h2>[EXAMPLE]</h2>
<ol>
<li>]&nbsp;</li>
</ol>
<h2>[HOW-TO]</h2>
<ol>
<li>]</li>
</ol>
<h2>[REFERENCE]</h2>
<ol>
<li>] CLASS Community.cs</li>
</ol><hr />
<h1 style="text-align: center;">developer implementation</h1>
<h2>[.process]</h2>
<ol>
<li>&nbsp;</li>
</ol>
<h2>[.notes]</h2>
<ol>
<li>&nbsp;</li>
</ol>
<h2>[.by_date]</h2>
<ol>
<li>[YYYY-mm-DD]</li>
</ol><hr />
<h1 style="text-align: center;">status<span style="font-size: 10px;">&nbsp;</span></h1>
<h2>[previously]</h2>
<div><ol>
<li><strong>[2013-05-26][00:00] NEW task IN&nbsp;</strong></li>
<ol>
<li>x] # # - CREATE new class,&nbsp;</li>
<li>x] used Warehouse.cs as template</li>
<li>x] REPLACING the LibraryData methods class&nbsp;</li>
</ol>
<li><strong>[00:00] NEW task IN</strong></li>
<ol>
<li><strong>x] Validation - w3c</strong></li>
<li>x] PAGE view/libraries - generated by class</li>
</ol>
<li><strong>[2017-04-10][00:00] NEW task</strong></li>
<ol>
<li>x] # # - FIX-PRB-7140 - adding explicit db.close.connection, db.close statements to all methods that open connections, call db</li>
<li>x] # # - adding explicit db.Dispose()</li>
<li>] EXCEPT methods where code is return db.call&nbsp;</li>
</ol>
<li><strong>[2017-05-03][13:00] NEW task</strong></li>
<ol>
<li>] adding expliciti db.Close, db.ConnectionClose and db.Dispose() statements to&nbsp;</li>
</ol></ol></div>
<h2>[currently]</h2>
<ol>
<li>]&nbsp;</li>
</ol>
<h2>[next]</h2>
<ol>
<li>]</li>
</ol>

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