Commit Graph

25 Commits

Author SHA1 Message Date
kougyokugentou 9f1dd00cc8 Add: GetChildPhoto 2021-02-19 22:21:31 -08:00
Ted Pickard 2fab77e079 Merge branch 'main' of https://github.com/kougyokugentou/GreatHomeChildcare into main 2021-02-17 17:56:00 -08:00
Ted Pickard 61b11bc9ee Changed final statements on Bitmap conversion to allow for memory stream 2021-02-17 17:55:43 -08:00
kougyokugentou d04cc9a2e7 Bugfix: SignChildInOut
Bugfix: StudentStatus is null if the student is a new child; so account for that when signing a new child in for the first time by setting strInOut to IN:
2021-02-10 20:32:56 -08:00
kougyokugentou 0062df0bbc Find bug 2021-02-10 14:42:24 -08:00
Ted Pickard d98547c786 Fixed numerous bugs and added function to convert bitmap images to Image data type. Need to work on sql retention to have web-cam images show up. 2021-02-10 14:12:47 -08:00
kougyokugentou d90a4fd64e Migrate AttendenceSingleInOutData to the Reports region.
Add: GetReportData
2021-02-05 23:01:48 -08:00
kougyokugentou 1554dd4abc Add some more code, thinking to do along the lines of "for each day, pull the students first and last in/out record and display it. Forget about if the student checks in or out multiple times, that's too hard.
TODO: for each day, make a new class to display the records in the dgvReport with child displayname, in+in_time, guardian_in, out+out_time, guardian_out, duration.
2021-02-04 22:16:12 -08:00
kougyokugentou d8790966b7 Add: DeleteChild
Add: GetOrphanedGuardians (Query Needs Testing w/More Data)
Add: DeleteAttendenceForChild
2021-02-02 22:05:40 -08:00
kougyokugentou cea0c8b81c Add: GetNextChildID to attach guardian to new child. 2021-01-30 12:52:08 -08:00
kougyokugentou e2f50bec03 fix: update children query 2021-01-29 22:11:34 -08:00
kougyokugentou 9c4fa611af Clean up unneeded usings 2021-01-29 21:17:51 -08:00
kougyokugentou 8c0b4adc12 Update: InsertNewChild -- correct table
Add: InsertNewGuardian
Add: UpdateGuardian
2021-01-27 14:56:17 -08:00
kougyokugentou 3a6f7cfee6 Add: GetGuardianByID
Add: DeleteGuardian
Change: RemoveGuardianFromChild to RemoveGuardianFromAllChildren
Add: DeleteAttendenceForGuardian
2021-01-25 21:19:14 -08:00
kougyokugentou 6d748c37c1 ADD: GetAllGuardians
ADD: AddNewGuardianToChild
ADD: CheckForOctomom
ADD: RemoveGuardianFromChild (Not sure if needed)
2021-01-24 22:49:00 -08:00
kougyokugentou 15015c68da Add code to:
InsertNewChild
UpdateChild
2021-01-22 23:16:32 -08:00
kougyokugentou 6ca8d8453e Add: GetChildByID
Add: GetGuardiansByChild() //MAY NEED DEBUGGING
2021-01-21 22:56:50 -08:00
kougyokugentou 972898ccfa Select all children and order by last name 2021-01-20 16:11:09 -08:00
kougyokugentou 02b4a958f3 Add query to get all children from DB from admin form 2021-01-18 20:43:26 -08:00
kougyokugentou 3da46bdba1 Add comments to the source code. 2021-01-17 17:57:46 -08:00
kougyokugentou cd7523c38b Update GetChildInOut and SignChildInOut to use Attendence model so the button on the main sign/in out form can display the timestamp as well as the status. 2021-01-17 15:19:03 -08:00
kougyokugentou 3af94d7f92 Add comment (not region) for crud operations within each region.
Add code to sign a student in or out.
Add code to get a student sign in/out status.
2021-01-14 21:38:58 -08:00
kougyokugentou ca702e1ca2 Add query to get guardian object by pin#
Add query to get children by guardian object.
2021-01-13 20:15:20 -08:00
kougyokugentou 0cf477b63d first time run code
shell: GetChildrenByGuardianID
2021-01-12 22:24:27 -08:00
kougyokugentou 1feab9721c initial commit 2021-01-11 22:34:14 -08:00