e8bba4484a
Fix publish URL
2021-02-20 19:36:18 -08:00
52d201e8ee
Publish field testing version 1.0
2021-02-20 19:31:40 -08:00
24321c1573
Update frmChildCrud.cs
...
Add guard on "photo from cam" to ensure the child already exist in db before taking photo from camera.
Implement workaround functionality to populate the child crud form with the new photo from cam.
2021-02-19 22:21:40 -08:00
9f1dd00cc8
Add: GetChildPhoto
2021-02-19 22:21:31 -08:00
72ab02cbfe
Remove unused button
2021-02-19 22:20:34 -08:00
2fab77e079
Merge branch 'main' of https://github.com/kougyokugentou/GreatHomeChildcare into main
2021-02-17 17:56:00 -08:00
61b11bc9ee
Changed final statements on Bitmap conversion to allow for memory stream
2021-02-17 17:55:43 -08:00
4d13eba475
Implement printing functionality by stealing excel.
2021-02-14 21:11:34 -08:00
0be3d95598
Update frmReports.cs
...
Make separate function to save a csv file so printing can do that too.
Decide to write a csv file and use excel interop to actually do the printing as a cheap hack.
2021-02-13 17:25:10 -08:00
a3c86d44e8
Change size mode on frmChildCrud
2021-02-10 21:55:28 -08:00
eec15df542
vs doing its thing
2021-02-10 21:55:15 -08:00
ebd60afd5f
Clean up to-dos, they are done.
2021-02-10 21:55:07 -08:00
31f6bd7ef6
Bugfix: frmChildCrud.cs
...
Bugfix: Attaching an existing guardian to a new child now works correctly.
Remove: Messagebox for to-do on deleting a child is removed.
2021-02-10 21:41:38 -08:00
db0bc9dfaa
vs doing its thing
2021-02-10 21:40:45 -08:00
33a3d78fee
Bugfix frmChildCrud.cs
...
Bugfix: Add existing guardian to new child not working correctly. It was using the click when a guardian had already been assigned and erroneously causing a pop-up message.
2021-02-10 21:20:03 -08:00
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
f8e64956a4
Bugfix: Fill in guardian combo box after deleting a guardian.
2021-02-10 20:31:12 -08:00
0062df0bbc
Find bug
2021-02-10 14:42:24 -08:00
34019b1743
Mock Data.
2021-02-10 14:41:41 -08:00
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
d90a4fd64e
Migrate AttendenceSingleInOutData to the Reports region.
...
Add: GetReportData
2021-02-05 23:01:48 -08:00
20da3f24e9
Reports class
2021-02-05 23:01:12 -08:00
b9fae0ef1e
add print icon
2021-02-05 23:00:49 -08:00
30b4d6a657
Add some constants.
...
Clear the columns from dgv on formload, we don't need those.
Refresh the report datagrid view on date change.
Implement the logic to show datagrid view for all children.
Break out the ReportScreen data into a seperate function.
Implement save to CSV.
2021-02-05 23:00:37 -08:00
23846a673e
Update capitalziation in AttendenceSingleInOutData
2021-02-05 22:52:02 -08:00
fabc9b6865
Update the from/to max and min dates away from the designer.cs
2021-02-05 20:14:05 -08:00
c17a463a05
Merge branch 'main' of https://github.com/kougyokugentou/GreatHomeChildcare into main
2021-02-05 17:10:32 -08:00
f2c3db3239
Added Db functionality to SnapshotWin. Will need to test if BitmapToByteArray conversions match up ImageToByteArray or changes need to be made on that front.
2021-02-05 17:09:56 -08:00
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
4e1c10d297
This fuckign query took 2 hours to write/debug/think about, so commit it.
2021-02-04 22:11:26 -08:00
2cce2560a6
Add trigger to update CURRENT_TIMESTAMP to local time upon insert to Attendance table
2021-02-04 22:11:03 -08:00
6f2a63af4f
Add AttendenceSingleInOutData to get the data for a single instance of "in" or "out", so I can send it to the report form.
2021-02-04 22:10:23 -08:00
852b671725
Move the allChildren list up to the form global for possible future iteration on the report view.
...
Add shell code to refresh datagridview.
2021-02-03 14:19:24 -08:00
9cf3a6fd7a
report datagrid view
2021-02-03 14:18:43 -08:00
470d95c716
Add: To and From date time pickers, with validation that the To date is never before the From date. Max date you can pick is Today.
2021-02-03 10:21:00 -08:00
6a0fef9309
Add filter combobox for child selection.
2021-02-03 09:10:30 -08:00
6f11dcb497
Found a possible bug.
2021-02-03 09:09:12 -08:00
5a8a98b7c1
Update: DisplayName property for get/set for the report site.
2021-02-03 09:08:47 -08:00
b6391b03f3
Add: reports form
2021-02-02 22:07:17 -08:00
f6a28cbd66
Add: Delete button
...
Move: Last admin check to bool CheckIfLastAdmin
2021-02-02 22:07:04 -08:00
bd1d904ec2
Add delete button
2021-02-02 22:06:25 -08:00
3a6f186455
VS does its thing
2021-02-02 22:06:17 -08:00
953954d712
Add reporting form
2021-02-02 22:05:58 -08:00
d8790966b7
Add: DeleteChild
...
Add: GetOrphanedGuardians (Query Needs Testing w/More Data)
Add: DeleteAttendenceForChild
2021-02-02 22:05:40 -08:00
186fef3656
Add: Capitalization of guardian's name
...
FIX: forgot to collect isAdmin.
2021-02-02 21:14:47 -08:00
525b7b97e2
Add: Form validation before adding a guardian, either existing or new
...
Add: Capitalization of children's names and race.
2021-02-02 21:14:08 -08:00
861da85079
VS doing its thing
2021-02-02 21:13:25 -08:00
e9c5ae8c38
Remove no children label, it was not showing up over the tablegridview. Instead, just change the existing lblInstructions text to "you have no children"
2021-02-02 21:13:11 -08:00
16b38c05ec
Remove no children label.
2021-02-02 21:12:34 -08:00
fb7b68e773
Move FirstTimeRun to the shown event. Ref: Microsoft
2021-02-02 21:12:18 -08:00
kougyokugentou
Ted Pickard