Commit Graph

  • e8bba4484a Fix publish URL main kougyokugentou 2021-02-20 19:36:18 -0800
  • 52d201e8ee Publish field testing version 1.0 kougyokugentou 2021-02-20 19:31:40 -0800
  • 24321c1573 Update frmChildCrud.cs kougyokugentou 2021-02-19 22:21:40 -0800
  • 9f1dd00cc8 Add: GetChildPhoto kougyokugentou 2021-02-19 22:21:31 -0800
  • 72ab02cbfe Remove unused button kougyokugentou 2021-02-19 22:20:34 -0800
  • 2fab77e079 Merge branch 'main' of https://github.com/kougyokugentou/GreatHomeChildcare into main Ted Pickard 2021-02-17 17:56:00 -0800
  • 61b11bc9ee Changed final statements on Bitmap conversion to allow for memory stream Ted Pickard 2021-02-17 17:55:43 -0800
  • 4d13eba475 Implement printing functionality by stealing excel. kougyokugentou 2021-02-14 21:11:34 -0800
  • 0be3d95598 Update frmReports.cs kougyokugentou 2021-02-13 17:25:10 -0800
  • a3c86d44e8 Change size mode on frmChildCrud kougyokugentou 2021-02-10 21:55:28 -0800
  • eec15df542 vs doing its thing kougyokugentou 2021-02-10 21:55:15 -0800
  • ebd60afd5f Clean up to-dos, they are done. kougyokugentou 2021-02-10 21:55:07 -0800
  • 31f6bd7ef6 Bugfix: frmChildCrud.cs kougyokugentou 2021-02-10 21:41:38 -0800
  • db0bc9dfaa vs doing its thing kougyokugentou 2021-02-10 21:40:45 -0800
  • 33a3d78fee Bugfix frmChildCrud.cs kougyokugentou 2021-02-10 21:20:03 -0800
  • d04cc9a2e7 Bugfix: SignChildInOut kougyokugentou 2021-02-10 20:32:56 -0800
  • f8e64956a4 Bugfix: Fill in guardian combo box after deleting a guardian. kougyokugentou 2021-02-10 20:31:12 -0800
  • 0062df0bbc Find bug kougyokugentou 2021-02-10 14:42:24 -0800
  • 34019b1743 Mock Data. kougyokugentou 2021-02-10 14:40:06 -0800
  • 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. Ted Pickard 2021-02-10 14:12:47 -0800
  • d90a4fd64e Migrate AttendenceSingleInOutData to the Reports region. Add: GetReportData kougyokugentou 2021-02-05 23:01:48 -0800
  • 20da3f24e9 Reports class kougyokugentou 2021-02-05 23:01:12 -0800
  • b9fae0ef1e add print icon kougyokugentou 2021-02-05 23:00:49 -0800
  • 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. kougyokugentou 2021-02-05 23:00:37 -0800
  • 23846a673e Update capitalziation in AttendenceSingleInOutData kougyokugentou 2021-02-05 22:52:02 -0800
  • fabc9b6865 Update the from/to max and min dates away from the designer.cs kougyokugentou 2021-02-05 20:13:29 -0800
  • c17a463a05 Merge branch 'main' of https://github.com/kougyokugentou/GreatHomeChildcare into main Ted Pickard 2021-02-05 17:10:32 -0800
  • 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. Ted Pickard 2021-02-05 17:09:56 -0800
  • 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. kougyokugentou 2021-02-04 22:16:12 -0800
  • 4e1c10d297 This fuckign query took 2 hours to write/debug/think about, so commit it. kougyokugentou 2021-02-04 22:11:26 -0800
  • 2cce2560a6 Add trigger to update CURRENT_TIMESTAMP to local time upon insert to Attendance table kougyokugentou 2021-02-04 22:11:03 -0800
  • 6f2a63af4f Add 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
  • 852b671725 Move 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
  • 9cf3a6fd7a report datagrid view kougyokugentou 2021-02-03 14:18:43 -0800
  • 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. kougyokugentou 2021-02-03 10:21:00 -0800
  • 6a0fef9309 Add filter combobox for child selection. kougyokugentou 2021-02-03 09:10:30 -0800
  • 6f11dcb497 Found a possible bug. kougyokugentou 2021-02-03 09:09:12 -0800
  • 5a8a98b7c1 Update: DisplayName property for get/set for the report site. kougyokugentou 2021-02-03 09:08:47 -0800
  • b6391b03f3 Add: reports form kougyokugentou 2021-02-02 22:07:17 -0800
  • f6a28cbd66 Add: Delete button Move: Last admin check to bool CheckIfLastAdmin kougyokugentou 2021-02-02 22:07:04 -0800
  • bd1d904ec2 Add delete button kougyokugentou 2021-02-02 22:06:25 -0800
  • 3a6f186455 VS does its thing kougyokugentou 2021-02-02 22:06:17 -0800
  • 953954d712 Add reporting form kougyokugentou 2021-02-02 22:05:58 -0800
  • d8790966b7 Add: DeleteChild Add: GetOrphanedGuardians (Query Needs Testing w/More Data) Add: DeleteAttendenceForChild kougyokugentou 2021-02-02 22:05:40 -0800
  • 186fef3656 Add: Capitalization of guardian's name FIX: forgot to collect isAdmin. kougyokugentou 2021-02-02 21:14:47 -0800
  • 525b7b97e2 Add: 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
  • 861da85079 VS doing its thing kougyokugentou 2021-02-02 21:13:25 -0800
  • 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" kougyokugentou 2021-02-02 21:13:11 -0800
  • 16b38c05ec Remove no children label. kougyokugentou 2021-02-02 21:12:34 -0800
  • fb7b68e773 Move FirstTimeRun to the shown event. Ref: Microsoft kougyokugentou 2021-02-02 21:12:18 -0800
  • c86b9fdf0d ADD: 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
  • 16940a0ba0 remove timestamp from dob field in mockdata, we don't need that. kougyokugentou 2021-02-02 21:11:08 -0800
  • 7c76b8bf04 Bug fix: new child with no sign in/out status NO LONGER crashes program on frmMain.cs kougyokugentou 2021-01-30 13:23:27 -0800
  • e856320df9 Sloppy 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
  • a0fc5358cc Fix: Validate PIN kougyokugentou 2021-01-30 12:53:08 -0800
  • d41de3f84d Find and comment BUG on populating sign in/out form regarding new student. kougyokugentou 2021-01-30 12:52:54 -0800
  • b26114a5f4 Fix mockdata, it was bothering me. kougyokugentou 2021-01-30 12:52:24 -0800
  • cea0c8b81c Add: GetNextChildID to attach guardian to new child. kougyokugentou 2021-01-30 12:52:08 -0800
  • 86ac426176 VS doing its thing kougyokugentou 2021-01-30 12:51:40 -0800
  • 075929bbe6 Fix: 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
  • e06902330a VS doing it's strange old thing kougyokugentou 2021-01-29 22:13:04 -0800
  • 1900c18389 Revision: Change FirstTimeRun to GetNumAdmins Add: Sanity check to see if trying to remove last known admin. kougyokugentou 2021-01-29 22:12:50 -0800
  • fbbe66f99f Revision: Change firstTimeRun to GetNumAdmins kougyokugentou 2021-01-29 22:12:05 -0800
  • e2f50bec03 fix: update children query kougyokugentou 2021-01-29 22:11:34 -0800
  • 9c4fa611af Clean up unneeded usings kougyokugentou 2021-01-29 21:17:51 -0800
  • 1f62a8d06e Clean up unneeded usings Check for existing guardian on 'save and close' kougyokugentou 2021-01-29 21:17:26 -0800
  • 48a8e88bac Clean 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
  • 4948d1d7ff Clean up unneeded usings kougyokugentou 2021-01-29 21:15:38 -0800
  • 472091c1b3 Clean up unneeded usings kougyokugentou 2021-01-29 21:15:28 -0800
  • 2d02d2d1db Adjust comment kougyokugentou 2021-01-27 14:59:16 -0800
  • 5dbd4acc27 Add check if child has no guardians assigned, do not allow form closure. kougyokugentou 2021-01-27 14:59:00 -0800
  • d3390a8d74 Disable 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
  • ce60c3bdf2 Implement 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
  • 8c0b4adc12 Update: InsertNewChild -- correct table Add: InsertNewGuardian Add: UpdateGuardian kougyokugentou 2021-01-27 14:56:17 -0800
  • 1c263f475c Change 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
  • c27cd7f975 Read 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
  • 94c406b646 Change 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
  • 68e67516c0 Validate input on child save & close kougyokugentou 2021-01-27 09:20:15 -0800
  • 2b3c362ff4 no idea why VS regenerates the imagelist imagestream on building. kougyokugentou 2021-01-27 09:19:02 -0800
  • 2f5c41f880 design changes kougyokugentou 2021-01-25 22:07:45 -0800
  • 1e0ddf291b Change: 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
  • cc242d4c3f Initial swing of guardian crud form. kougyokugentou 2021-01-25 21:20:13 -0800
  • d1055ddf7d Images and design kougyokugentou 2021-01-25 21:19:46 -0800
  • 3a6f7cfee6 Add: GetGuardianByID Add: DeleteGuardian Change: RemoveGuardianFromChild to RemoveGuardianFromAllChildren Add: DeleteAttendenceForGuardian kougyokugentou 2021-01-25 21:19:14 -0800
  • 1916c27af6 Move 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
  • 93968ac789 Adjust comments. kougyokugentou 2021-01-24 22:49:52 -0800
  • 68e6ba6a85 Design and images. kougyokugentou 2021-01-24 22:49:26 -0800
  • 6d748c37c1 ADD: GetAllGuardians ADD: AddNewGuardianToChild ADD: CheckForOctomom ADD: RemoveGuardianFromChild (Not sure if needed) kougyokugentou 2021-01-24 22:49:00 -0800
  • c22b02600e Add displayname for the found guardian combobox kougyokugentou 2021-01-24 22:48:07 -0800
  • dfad7eb168 update comment kougyokugentou 2021-01-24 22:47:43 -0800
  • 3ca5028917 SHELL: Guardian crud form. kougyokugentou 2021-01-23 20:36:52 -0800
  • 0eb4c922d0 Add: photo from disk kougyokugentou 2021-01-23 20:23:06 -0800
  • 91410b809d Visual studio likes reordering the designer.cs for some reason. kougyokugentou 2021-01-23 20:22:41 -0800
  • 0890cc13cf Add program icon Remove sqliteCommand1, that was there accidentally and not needed. kougyokugentou 2021-01-23 20:21:15 -0800
  • 8d9b13af0d Add program icon. kougyokugentou 2021-01-23 20:20:36 -0800
  • 2e501e5133 Pop 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
  • e8b9d3f50e Crud form design changes kougyokugentou 2021-01-22 23:17:30 -0800
  • 25db3a9f7d Add DOB to from the datasource to the main child crud form. kougyokugentou 2021-01-22 23:17:04 -0800
  • 15015c68da Add code to: InsertNewChild UpdateChild kougyokugentou 2021-01-22 23:16:32 -0800
  • 5ad5e4578c change 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