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;">[ CLASS app_code/Library.cs ]</h1>
<h2>[WHAT]</h2>
<ol>
<li>[ def ] class to work with Library objects</li>
<li>[ args ] none &nbsp;</li>
</ol>
<h2>[WHY]</h2>
<ol>
<li><strong>[Properties]</strong></li>
<ol>
<li>] public int id_library;</li>
<li>] public string name_library;&nbsp;</li>
<li>] public string description_library;&nbsp;</li>
<li>] private const string qryGetLibraries = "...qry..."</li>
<li>] private const string qryGetLibrary = "...qry..."</li>
<li>] private const string qryGetLibraryNamed = "...qry...";</li>
<li>] private const string qryAddLibrary = "...qry..."</li>
<li>] private const string qryDeleteLibrary = "...qry..."</li>
<li>] private const stringqryUpdateLibrary = "...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>] Library()</li>
<li>] Library(string name, string description)</li>
<li>] Library(int id_library)</li>
<li>] Library(string name_library)</li>
</ol>
<li><strong>[Methods]</strong></li>
<ol>
<li>] public static IEnumberable&lt;Library&gt;GetLibraries()</li>
<li>] public static IEnumberable&lt;Library&gt;GetLibraries(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>] publis static void delete(int id_library)</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_library_id)</li>
<li>] public static int copy(string src_db, int id_community)</li>
</ol></ol>
<h2>[WHERE]</h2>
<ol>
<li>[ called from]&nbsp;</li>
<ol>
<li>] PAGE - view/libraries -</li>
<li>]&nbsp;PAGE -&nbsp;view/library -</li>
<li>]&nbsp;PAGE -&nbsp;edit/library -</li>
<li>]&nbsp;PAGE -&nbsp;add/library -&nbsp;</li>
</ol></ol>
<h2>[WHEN]</h2>
<ol>
<li>]</li>
</ol>
<h2>[EXAMPLE]</h2>
<ol>
<li>]&nbsp;</li>
</ol>
<h2>[HOW-TO]</h2>
<ol>
<li>]</li>
</ol>
<h2>[REFERENCE]</h2>
<ol>
<li>] CLASS Warehouse.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></ol></div>
<h2>[currently]</h2>
<ol>
<li>]&nbsp;</li>
</ol>
<h2>[next]</h2>
<ol>
<li>]</li>
</ol>