d98547c786Fixed 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.
Ted Pickard
2021-02-10 14:12:47 -0800
d90a4fd64eMigrate AttendenceSingleInOutData to the Reports region. Add: GetReportData
kougyokugentou
2021-02-05 23:01:48 -0800
20da3f24e9Reports class
kougyokugentou
2021-02-05 23:01:12 -0800
30b4d6a657Add 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.
kougyokugentou
2021-02-05 23:00:37 -0800
23846a673eUpdate capitalziation in AttendenceSingleInOutData
kougyokugentou
2021-02-05 22:52:02 -0800
fabc9b6865Update the from/to max and min dates away from the designer.cs
kougyokugentou
2021-02-05 20:13:29 -0800
f2c3db3239Added Db functionality to SnapshotWin. Will need to test if BitmapToByteArray conversions match up ImageToByteArray or changes need to be made on that front.
Ted Pickard
2021-02-05 17:09:56 -0800
1554dd4abcAdd 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.
kougyokugentou
2021-02-04 22:16:12 -0800
4e1c10d297This fuckign query took 2 hours to write/debug/think about, so commit it.
kougyokugentou
2021-02-04 22:11:26 -0800
2cce2560a6Add trigger to update CURRENT_TIMESTAMP to local time upon insert to Attendance table
kougyokugentou
2021-02-04 22:11:03 -0800
6f2a63af4fAdd AttendenceSingleInOutData to get the data for a single instance of "in" or "out", so I can send it to the report form.
kougyokugentou
2021-02-04 22:10:23 -0800
852b671725Move the allChildren list up to the form global for possible future iteration on the report view. Add shell code to refresh datagridview.
kougyokugentou
2021-02-03 14:19:24 -0800
470d95c716Add: 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.
kougyokugentou
2021-02-03 10:21:00 -0800
6a0fef9309Add filter combobox for child selection.
kougyokugentou
2021-02-03 09:10:30 -0800
6f11dcb497Found a possible bug.
kougyokugentou
2021-02-03 09:09:12 -0800
5a8a98b7c1Update: DisplayName property for get/set for the report site.
kougyokugentou
2021-02-03 09:08:47 -0800
b6391b03f3Add: reports form
kougyokugentou
2021-02-02 22:07:17 -0800
f6a28cbd66Add: Delete button Move: Last admin check to bool CheckIfLastAdmin
kougyokugentou
2021-02-02 22:07:04 -0800
186fef3656Add: Capitalization of guardian's name FIX: forgot to collect isAdmin.
kougyokugentou
2021-02-02 21:14:47 -0800
525b7b97e2Add: Form validation before adding a guardian, either existing or new Add: Capitalization of children's names and race.
kougyokugentou
2021-02-02 21:14:08 -0800
861da85079VS doing its thing
kougyokugentou
2021-02-02 21:13:25 -0800
e9c5ae8c38Remove no children label, it was not showing up over the tablegridview. Instead, just change the existing lblInstructions text to "you have no children"
kougyokugentou
2021-02-02 21:13:11 -0800
16b38c05ecRemove no children label.
kougyokugentou
2021-02-02 21:12:34 -0800
fb7b68e773Move FirstTimeRun to the shown event. Ref: Microsoft
kougyokugentou
2021-02-02 21:12:18 -0800
c86b9fdf0dADD: Function to capitalize the first letter of a string and lowercase all other letters. Return the string.
kougyokugentou
2021-02-02 21:11:43 -0800
16940a0ba0remove timestamp from dob field in mockdata, we don't need that.
kougyokugentou
2021-02-02 21:11:08 -0800
7c76b8bf04Bug fix: new child with no sign in/out status NO LONGER crashes program on frmMain.cs
kougyokugentou
2021-01-30 13:23:27 -0800
e856320df9Sloppy hax to ensure a guardian is attached to a new child. I gave up on the all-in-one save button.
kougyokugentou
2021-01-30 12:53:48 -0800
d41de3f84dFind and comment BUG on populating sign in/out form regarding new student.
kougyokugentou
2021-01-30 12:52:54 -0800
b26114a5f4Fix mockdata, it was bothering me.
kougyokugentou
2021-01-30 12:52:24 -0800
cea0c8b81cAdd: GetNextChildID to attach guardian to new child.
kougyokugentou
2021-01-30 12:52:08 -0800
86ac426176VS doing its thing
kougyokugentou
2021-01-30 12:51:40 -0800
075929bbe6Fix: child global needs to initialize to new child object. Fix: picture box tags Add: isAdmin column to guardian datagrid view Add: Sanity check if deleting last admin BUG: program inserts new child before attaching new guardian
kougyokugentou
2021-01-29 22:13:13 -0800
e06902330aVS doing it's strange old thing
kougyokugentou
2021-01-29 22:13:04 -0800
1900c18389Revision: Change FirstTimeRun to GetNumAdmins Add: Sanity check to see if trying to remove last known admin.
kougyokugentou
2021-01-29 22:12:50 -0800
fbbe66f99fRevision: Change firstTimeRun to GetNumAdmins
kougyokugentou
2021-01-29 22:12:05 -0800
e2f50bec03fix: update children query
kougyokugentou
2021-01-29 22:11:34 -0800
9c4fa611afClean up unneeded usings
kougyokugentou
2021-01-29 21:17:51 -0800
1f62a8d06eClean up unneeded usings Check for existing guardian on 'save and close'
kougyokugentou
2021-01-29 21:17:26 -0800
48a8e88bacClean up unneeded usings Add TODO FillGuardiansComboBox after gCrudForm is closed. Move ensuring child has at least one guardian on save child button ADD: add child code
kougyokugentou
2021-01-29 21:16:59 -0800
4948d1d7ffClean up unneeded usings
kougyokugentou
2021-01-29 21:15:38 -0800
472091c1b3Clean up unneeded usings
kougyokugentou
2021-01-29 21:15:28 -0800
5dbd4acc27Add check if child has no guardians assigned, do not allow form closure.
kougyokugentou
2021-01-27 14:59:00 -0800
d3390a8d74Disable cancel button on first time run Populate the pin number textbox with * if existing guardian Validate Children upon save button Add: Code to insert or update guardian
kougyokugentou
2021-01-27 14:58:27 -0800
ce60c3bdf2Implement first-time runcode to show the new guardian form if no guardians are found in the database.
kougyokugentou
2021-01-27 14:56:59 -0800
1c263f475cChange global guardian to public static so the child crud form can snag it. Add first-time run code. Add code to collect guardian upon save button click Add form validation Implement pinpad/pin number/pin reset.
kougyokugentou
2021-01-27 14:09:40 -0800
c27cd7f975Read the guardian from the guardian crud form upon guardian form crud form close. Add some functionality to add a guardian to the child if the new guardian button was clicked. Add validation, if child has no guardians display a message.
kougyokugentou
2021-01-27 14:08:19 -0800
94c406b646Change class guardian to public so the child crud form can read the Guardian object off the Guardian crud form.
kougyokugentou
2021-01-27 14:06:59 -0800
68e67516c0Validate input on child save & close
kougyokugentou
2021-01-27 09:20:15 -0800
2b3c362ff4no idea why VS regenerates the imagelist imagestream on building.
kougyokugentou
2021-01-27 09:19:02 -0800
1e0ddf291bChange: global guardian_id to public static for access by the guardian crud form. Add: Source code comments. Add: Button to implement guardian crud form Add: Functionality to delete guardian.
kougyokugentou
2021-01-25 21:21:45 -0800
cc242d4c3fInitial swing of guardian crud form.
kougyokugentou
2021-01-25 21:20:13 -0800
d1055ddf7dImages and design
kougyokugentou
2021-01-25 21:19:46 -0800
1916c27af6Move guardian_id to global for the guardian crud form. Add a found guardian combobox to add existing guardians to a child. ADD: Code to add an existing guardian to a child ADD: Code to pluck the guardian_id out of the currently selected combobox bound list of guardians Wrap FileOK in try/catch.
kougyokugentou
2021-01-24 22:51:42 -0800
0eb4c922d0Add: photo from disk
kougyokugentou
2021-01-23 20:23:06 -0800
91410b809dVisual studio likes reordering the designer.cs for some reason.
kougyokugentou
2021-01-23 20:22:41 -0800
0890cc13cfAdd program icon Remove sqliteCommand1, that was there accidentally and not needed.
kougyokugentou
2021-01-23 20:21:15 -0800
8d9b13af0dAdd program icon.
kougyokugentou
2021-01-23 20:20:36 -0800
2e501e5133Pop child object up to global. Add DOB picker to form Add some starter code to save/update and create a new child. Update should be done since it doesn't touch guardians.
kougyokugentou
2021-01-22 23:18:39 -0800
e8b9d3f50eCrud form design changes
kougyokugentou
2021-01-22 23:17:30 -0800
25db3a9f7dAdd DOB to from the datasource to the main child crud form.
kougyokugentou
2021-01-22 23:17:04 -0800
15015c68daAdd code to: InsertNewChild UpdateChild
kougyokugentou
2021-01-22 23:16:32 -0800
5ad5e4578cchange ImageToByteArray to static. Add check to see if the imageIn equals the resource, if so returns null.
kougyokugentou
2021-01-22 23:16:08 -0800