task

[ CLASS App_Code/Community.cs ]

[WHAT]

  1. [ def ] class to work with Community objects
  2. [ args ] none, id 
  3. *] 

[WHY]

  1. [Properties]
    1. ] public int id_community;
    2. ] public string name_community; 
    3. ] public string description_community; 
    4. ] private const string qryGetCommunities = "...qry..."
    5. ] private const string qryGetCommunity = "...qry..."
    6. ] private const string qryGetCommunityNamed = "SELECT * FROM communities WHERE name_community=@0";
    7. ] private const string qryAddCommunity = "...qry..."
    8. ] private const string qryDeleteCommunity = "...qry..."
    9. ] private const stringqryUpdateCommunity = "...qry..."
    10. ] public static Database sospep 
    11. {
    12.  get
    13. }
  2. [Constructors]
    1. ] Community();
    2. ] Community(string name, string description);
    3. ] Community(int id);
    4. ] Community(string name_community);
  3. ??[Methods] ??
    1. ] public static IEnumberable<Community>GetCommunities()
    2. ] public static IEnumberable<Community>GetCommunities(int start, int quantity)
    3. ] public void add()
    4. ] public static void add(string name, string description)
    5. ] public void delete()
    6. ] public static void delete(id_coummunity)
    7. ] public void edit()
    8. ] public static void edit(string name, string description, int id)
    9. ] public static int getMaxId() 
    10. ] public static long recordCount()
    11. ] public static void import(string src_db, string dest_db, int src_community_id)
    12. ] public static int copy(string src_db, int id_community)

[WHERE]

  1. [ called from] 
    1. ] PAGE - view/communities -
    2. ] PAGE - view/community -
    3. ] PAGE - edit/community -
    4. ] PAGE - add/community - 

[WHEN]

  1. ] 2017-05-03 - created documentation PAGE record for class, PREV documentation record = # 2308 (as pre REF in SRC)

[EXAMPLE]

  1. ] 

[HOW-TO]

  1. ]

[REFERENCE]

  1. ] CLASS Community.cs

developer implementation

[.process]

  1.  

[.notes]

  1.  

[.by_date]

  1. [YYYY-mm-DD]

status 

[previously]

  1. [2013-05-26][00:00] NEW task IN 
    1. x] # # - CREATE new class, 
    2. x] used Warehouse.cs as template
    3. x] REPLACING the LibraryData methods class 
  2. [00:00] NEW task IN
    1. x] Validation - w3c
    2. x] PAGE view/libraries - generated by class
  3. [2017-04-10][00:00] NEW task
    1. x] # # - FIX-PRB-7140 - adding explicit db.close.connection, db.close statements to all methods that open connections, call db
    2. x] # # - adding explicit db.Dispose()
    3. ] EXCEPT methods where code is return db.call 
  4. [2017-05-03][13:00] NEW task
    1. ] adding expliciti db.Close, db.ConnectionClose and db.Dispose() statements to 

[currently]

  1. ] 

[next]

  1. ]
Details Photos Edit more

Details

ID: 7292

NAME: CLASS-Community

DESCRIPTION: CLASS Community - (based on Library)

START DATE TIME: 2017-05-03 11:00:00

EST DURATION: 03:00:00

END DATE TIME: 2017-05-03 14:00:00

STATUS: Completed

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities