f2fe8c592f
Fixed a bug that caused the ModifyRecord form to crash on load if the cursor was over the top left hand header cell. Set a timeout for the restore SQL statement to hopefully prevent a timeout exception from being thrown. Minor code clean up.
glm942018-04-04 01:47:02 -05:00
65dd82cd31
Forgot to update the behavior of the Integerity form, repair button is now disabled if no errors are found. The menu item for the Integrety form is now on the login and main menu forms. Security is not a huge concern at the moment.
glm942018-02-10 21:51:48 -06:00
36bbd29917
Changed the requirements of the integrity checking form to need a connection string. The login form willl now attempt to use the connection string setting but failing that it will use the server name in the combo box. The main form will use the app's connection string setting.
glm942018-02-10 21:39:09 -06:00
2dd754ed29
Created a new form to allow the user to check the database for internal errors. Needs more testing so this build will have the option not visible. Modified the login form to display database tools.
glm942018-01-13 03:24:59 -06:00
6ec32afc92
Fixed a bug preventing the user from moving a member of the ad special group on to the ad special row. Prevented the ad special row from being moved by drag and drop.
glm942017-12-11 19:55:46 -06:00
13af4ff791
Purged the row grouping code from the modify record form as it is no longer needed as well a moving all the main control events into their own toggle functions to make event enabling/disabling more consistent.
glm942017-12-10 23:53:34 -06:00
e37b8c840a
Fixed the minor issue of no CHECKSUM checking... The main reason for the overhaul no less. All older database backups will cannot be restored since they don't have checksum data.
glm942017-12-10 02:33:15 -06:00
46bddc7c5f
Updated the backup and restore functions to be more verbose and stable. Changed the version number slightly for appearance reasons. Fixed a bug on the Main Form that prevented it from refreshing the controls properly after all years have been wiped and after a database restore.
glm942017-12-10 02:07:52 -06:00
4b96f6c1fa
Moved the text formatting class to the data table parsing class. Slightly organized the code in the NewModifyRecord form.
glm942017-11-12 02:27:22 -06:00
4e807e03b9
Updated the modify record form to calculate the total profit return for projections and actual sales. Removed the Access database as it is no longer supported or needed.
glm942017-10-20 23:24:49 -05:00
650014076a
Updated the Wix installer to automatically grab the application core's version number. Set the Access database to not copy, keeping it purely for legacy reasons.
glm942017-09-26 19:50:09 -05:00
db555d80fe
Fixed some crash bugs related to the front page renderer recieving empty (null) table records. Twaeked both renderers' formatting.
glm942017-09-26 13:59:50 -05:00
945324f418
Updated the Inventory table's parsing engine, now correctly copies a reference table's grouping info. Updated the New Modify Record form to group rows in the Inventory table based on the Actual Sales table before insertion into the database.
glm942017-09-18 22:02:19 -05:00
de1ba4af10
First stages of a new logging system being put in place. Updated the group parsing engine for the Projections and Actual Sales tables, and removed the method. Fixed the issue where changes to groups didn't mark the record manipulation form as dirty.
glm942017-09-18 11:36:23 -05:00
ac9f464cf3
Updated the behavior of the Inventory data table to reflect the row attributes of the Actual Sales table. Minor tweaks to the Manage Ad Items form.
glm942017-07-14 18:23:00 -05:00
3b36476a6c
Updated the ad item manager form to allow the user to replace one item with another item. Fixed a crash bug in the Global Class logger functions.
glm942017-07-12 16:40:41 -05:00
fd47690224
Moved group table and row parsing into a separate DLL to clean up the main binary a bit. Added custom engine to detect for bin counts and updated the record form to total the bins for the user automatically. Updated the .gitignore file to include the necessary DLLs for the projects.
glm942017-07-02 20:59:33 -05:00
12a6b36370
Implemented database backups and restores into the AdvertisingProfitControlData DLL and added a form, DatabaseRecovery, to manage the backups and restores. Updated the installer to include the data DLL file into the install bundle.
glm942017-06-23 03:12:51 -05:00
308b60bd84
Split the database objects out into a seperate project. Needs renaming in some areas and updates in the installer. Otherwise first version of a proper data DLL file.
glm942017-06-22 17:02:01 -05:00
fc472928cc
Setting Git to ignore the Packages folder.
glm942017-05-10 22:58:20 -05:00
26705bbd7e
Fixed a bug in the report settings that stopped the back page's height from being saved.
glm942017-05-10 22:57:00 -05:00
a569a21294
Implemented the first version of the report settings to help compensate for the screen resolution dependence the PDF engines seem to have.
glm942017-05-10 02:05:51 -05:00
4c6b79aea1
Updated the application version number. Anchored the generate report button to the bottom right hand side of the main form.
glm942017-05-08 19:59:12 -05:00
718562222d
First version of the report generating engine finished, Both front and back pages are merged into one PDF. Seems the user's screen resolution and/or size affect the size of the PDF document, I feel this is a sort of bug that must be fixed at some point.
glm942017-05-08 19:51:45 -05:00
15abab5f50
Finished initial build of the back page generator. Unable to properly merge the two tables with Pechkin so far.
glm942017-05-06 01:08:38 -05:00
218d5be4d6
Created the first version of HTML code for the front form. Changed to the Pechkin HTML to PDF library. Removed the string tester. Fixed a bug with the main form where the APC tables would not be sorted by row position.
glm942017-05-02 23:38:00 -05:00
ba5808443b
Added a shrink changing form but the math seems to be off so it is disabled for the time being. Updated the interface on the main form and the modify record form to include the log viewer and the log console.
glm942017-04-18 01:51:51 -05:00
c72fbf88cf
Removed the Invoice Net Amount Extended Retail column from the Invoice table DataGridViews. Fixed a crash bug on the main form caused by an empty department sales variable. Small refactoring on the main form's calculation methods.
glm942017-04-17 02:01:31 -05:00
61f369f7fe
Fixed a bug where ad specials wasn't being processed properly. Updated the main form to add up all data in the Invoice Net Amount at Cost column instead of the Extended Retail column. Minor behavior fixes.
glm942017-04-15 12:38:55 -05:00
c334c9aa53
Added a debug tool to view and manage log files. Slight tweaks to the main form as well as the thread exception methods.
glm942017-04-14 01:24:50 -05:00
7b2a93cbf6
Renamed the database selector form to "Login Form" and updated its UI. Moved database initialization to the login form. Made the exit file menu option on the main form functional.
glm942017-04-13 02:59:34 -05:00
a67dd966bd
Created a "login" dialog form to grab the server name from the user. Now a valid connection must be made before the Main form loads.
glm942017-04-12 20:01:32 -05:00
2e19bba711
Minor UI tweaks to prevent the labels from over lapping the textboxes on smaller DPI screens.
glm942017-04-12 17:49:37 -05:00
6b2ed9d3d7
Updated the images in the installer and added a way for the installer to detect SQL (Tested on 64-bit) and .NET 4.5 (Untested).
glm942017-04-12 17:26:11 -05:00
3567727caa
Updated the main form's tools to include an option to delete the entire active year. Tweaked the ListViews in the three tool forms to disallow multi-select and made a slight change to the behavior of the filter combo box.
glm942017-04-12 03:36:05 -05:00
932ee01bf3
Configured the installer to display the program's icons, changed the banners on the install form and renamed the set up file's name. Very minor cleanup to the modify record's code.
glm942017-04-11 23:22:44 -05:00
973f72a523
Updated installer to place all dependencies into the install directory.
glm942017-04-11 19:56:46 -05:00
0b7b14df5f
First test with the Wix Installer, writes a shortcut to the Start Menu and drops the exe into the Program Files (x86) folder.
glm942017-04-11 15:55:37 -05:00
62a2c0f80e
Created forms to allow the management of ad items, suppliers and ad special keywords. Updated the database migration tool to include the ad special table. Cleaned up the main form's code and did a slight touch up of the interface.
glm942017-04-11 02:26:04 -05:00
09508aa16c
Updated the table class files to allow a nullable ad special ID and changed the enum in the new modify record form to a boolean. Added a form to manage ad special keywords, still needs to handle removing them properly.
glm942017-04-10 16:42:21 -05:00
d4d0a62eba
Cleaned up the code in the main form but only a little.
glm942017-04-07 05:51:07 -05:00
2106879ee8
Completely removed all the old database interaction code, save the database converter form. Updated the formatting in the weekly and taxable areas on the modify record form. Re-enabled holiday checking on the main form.
glm942017-04-07 04:50:02 -05:00
e5fa0a8238
Fixed a crash bug in the modify records form. Fixed behavioral issue with marking all rows in the DataGridViews as saved after updating regardless of whether or not the row was untouched from the database.
glm942017-04-04 19:33:25 -05:00
89b45d34ab
Updated the Main Form to read from the SQL database exclusively. Modify record form now writes exclusively to the SQL database, and reads the main APC tables from SQL. New bug with row validation, but only on records with ad specials.
glm942017-04-04 15:36:04 -05:00
9da9540969
First version of the Main form that is able to pull all the required data from the SQL database. Holiday detection is disabled for this build. Fixed some bugs with the debug database conversion code. Still missing Ad Special data in the conversion code.
glm942017-03-27 14:39:42 -05:00
36fe75d761
Updated the SQL script to hold Invoice Numbers as text as this may cause issues using int in c#. Finished the debug Access to SQL code form. Pushing this purely to have the code for reference at another time.
glm942017-03-22 22:36:51 -05:00
f554d37fb1
Updated the SQL script to work better with Entity Framework and to eliminate issues with naming objects in the generated C# code such as "AdItem1". Updated the primary key fields to auto-increment their values and forced a NOT NULL constraint on the foreign keys where needed.
glm942017-03-22 04:08:39 -05:00
c131dd2eb4
Removed AditemCollectionModel as the code was never used. I don't even remember how I thought it would be useful.
glm942017-02-20 18:20:12 -06:00
02fbc253d6
Updated the SaveRecord method to detect if a date is already in the database. It now selects the next available week after prompting the user. Changed the behavior of the create new record menu item to select the week after the most recent date based on the year that is being worked on.
glm942017-02-18 02:33:57 -06:00
b580e48c26
Updated how the record manipulation form behaves when adding new records, allowing the user to select a new date freely. May be the final update before the Entity Update.
glm942017-02-17 04:51:25 -06:00
76e0f7079f
Small modifications made to the SQL template script in preparation for the Entity Framework update.
glm942017-02-15 14:30:08 -06:00
41ac2cfa62
Updated the APC table builder so zeros won't show in some columns. Changed the ad special index setting to the cell validation event, and stabilized the user changing an ad item to an ad special keyword. Fixed a bug where saying no to deleting a row wouldn't work.
glm942017-02-12 20:49:13 -06:00
5bd80f0dce
Added a check for if the user changes an ad item to an ad special item. Fixed a bug that caused a crash when deleting a row in the APC tables (finally!).
glm942017-02-12 00:52:04 -06:00
13f0e5df35
Created the first version of the table normalizing function to correct unbalanced tables. Can only add or update rows by scanning downward from the top of a table; cannot detect fragmentation in the middle of a table. (Think Drag and Drop/row position update fails.)
glm942017-02-07 02:46:15 -06:00
2657523888
Added a tool to remove an entire date and all records associated with it. Updated row deletion code to handle unbalanced tables or missing row IDs.
glm942017-01-24 13:45:25 -06:00
d7229c9499
Minor UI changes after testing on the laptop. The add record form now selects Saturday based on the current date on start up.
glm942017-01-23 03:41:47 -06:00
739c4c179d
Fixed a bug in the row parsing engine related to ad special rows. Move all data from the old format to the new format. Updated the main form's UI.
glm942017-01-23 00:26:46 -06:00
9f045175ed
Added a temporary form to convert the old database format. Updated the row parsing engine to handle ad special rows more effectively. Fixed a few bugs with the parsing engine not flagging member rows as dirty. Upped the character limit of the ad item and supplier columns.
glm942017-01-22 20:46:07 -06:00
ac16bbc05c
Add and modify forms texted with real data. Fixed a few crash bugs and precision errors. Fixed the Actual Sales table in Access was missing a row. Add sample data to the database.
glm942017-01-21 23:20:59 -06:00
e7d719b1ba
Created a new cleaned up APC database and a back up template to use. Finalized the new main form. Preparing to enter real data in the next session.
glm942017-01-21 20:13:23 -06:00
db200e31b2
Updated the main form to allow the user to be able to select dates from the database. Updated information displaying on the main form.
glm942017-01-21 19:15:26 -06:00
96e61546c3
Updated the main form with a slightly new look. Finished all the code for the main for to pull in all the data from the database and perform calculations on it. Currently can only load the most recent date. Added detection for holidays in the weekly and taxable lists.
glm942017-01-21 18:38:19 -06:00
d429f2b931
Fixed a bug with the invoice table failing to save an invoice number longer then 9 characters.
glm942017-01-21 04:17:09 -06:00
f9968942ea
Finished the APC table saving code. Fixed a bug with the row parsing engine.
glm942017-01-21 03:43:31 -06:00
12239bce23
Fixed more bugs with the parsing engine, a crash bug in the update inventory method, and a crash bug in the trimming operations. Deleting a row now marks all rows under it as dirty.
glm942017-01-21 01:39:28 -06:00
ab00ad2598
Quick crash bug fix with the row parsing engine where an existing, unchanged, header row is marked as dirty by the engine.
glm942017-01-20 23:51:33 -06:00
43bf07c212
Cleaned up the table trimming methods. Group creation now proper marks rows as dirty when row attribute changes. Projections table processes successfully on the new modify record form.
glm942017-01-20 22:46:48 -06:00
9fa2e3c44a
Cleaned up the code in the new modify record form and changed the return value from string to integer in the date ID get method. Fixed a crash bug in the new add record form and fixed the row number bug in both forms.
glm942017-01-20 18:30:36 -06:00
84f43538d1
Modify record now fills in used ad items on data load. Fixed a bug where changing the ad special group name would mark the other table's ad special row as pending edit. Removed marking the ad special row as dirty, only its members are marked as such; this goes for color coding the heard cells too.
glm942017-01-20 16:21:06 -06:00
22b9ba4334
Organized the code a bit, and fixed a bug where selecting a new date wouldn't update the modify record form. Prettied up the formatting for the invoices table.
glm942017-01-18 01:46:39 -06:00
a57ef93add
Added code to pull in all items in the new modify record form. Updated the database reader code and broke the main form. Fixed a bug where weekly sales and taxable would not set the dirty flag if text was cleared from a text box after pulling from the database. Known bug: when an ad special row's group is changed to another ad special group, i.e. "Weekend Ad" to "New Years Ad", the pending edit color is not shown in the header cells of the members and only the ad special row.
glm942017-01-18 00:43:20 -06:00
2b3c234aaa
Fixed a bug on the modify record form where updating an existing row's ad item wouldn't mark the other APC tables as dirty.
glm942017-01-17 14:15:21 -06:00
c9d8186d75
Added the new modify record form, can only pull in the Projections table and parse it. Fixed a bug in the modify record form where the first row would be marked as pending edit due to not checking the beginning cell variable correctly.
glm942017-01-17 12:20:48 -06:00
bd586580e6
Added support for deleting records from the APC and invoice tables that have been committed to the database. Fixed the color coding bug where the Ad Special row would get the pending edit color instead of no coloring.
glm942016-12-16 15:41:17 -06:00
91c2326db2
Updated the UI of the add record form. Added support to clear the APC tables if even one fails to be added to the database. Fixed a crash bug with the trimming operations where Header and Member Booleans would be null.
glm942016-12-08 01:02:01 -06:00
0bf2290ab0
Fixe a crash bug when trying to add APC tables to the database.
glm942016-12-06 12:55:44 -06:00
9ef133a825
Hidden check boxes now update to reflect whether or not they are in need of updating or not.
glm942016-12-06 12:44:08 -06:00
1398ecd1ab
Finished and tested database writing code for non table entities. Improved information reporting to the user, and created a new DbWriter object for table operations only.
glm942016-12-06 12:39:38 -06:00
d8c753f788
Added support for color coding the DataGridViews' header cells based on row state (saved, pending edit, row error) and finished writing the last database writer function for cost analysis.
glm942016-12-04 01:27:25 -06:00
6813bbb341
Finished validation code for the cost analysis, weekly sales and taxable. Fixed a bug with the update flag not being set if an ID number was set. Wrote comment and weekly sales database writing functions; untested.
glm942016-12-02 23:12:05 -06:00
8dcc290aef
Added dirty flags to the comments, cost analysis, weekly sales and taxable, as well as formatting, validation and auto summing for the latter two. The Tag properties of the check boxes for the dirty flags will contain the IDs.
glm942016-12-02 18:45:31 -06:00
1907ce1702
Added the methods to insert and update invoice records in the database, as well as fixing a bug where the Invoice Notes would disappear on row validation.
glm942016-11-26 00:37:42 -06:00
6d54ac3bff
Removed unneeded packages from the solution.
glm942016-11-15 22:15:56 -06:00
1f700869c7
Improved information and error feedback to the user.
glm942016-11-11 17:42:59 -06:00
ad3fa573b8
Fixed a bug in the Inventory and Actual Sales tables where the user could leave a row without an ad item. Fixed data type mismatch with the database insertion methods.
glm942016-11-11 17:09:43 -06:00
35e90a6f86
Removed a few unused columns and flags that didn't help improve the performance of the form or just made its code more cluttered. Created a separate method to handle calling the database writing code for the Sales Tables.
glm942016-11-11 15:21:04 -06:00
9105429fcb
Fixed a bug where the row row would get reported as the last row processed in all the database insert and update methods. Fixed a bug where the NewRow would get set as dirty if an ad special row was renamed with no members in it. Sales table compression and database methods tested and working.
glm942016-11-11 12:43:47 -06:00
d0c6ce5e42
First version of the Inventory insertion and update methods, untested.
glm942016-11-10 13:35:47 -06:00
5d387caecb
Created a container object to house messages, operation status and the rows added for the methods that add new items and update existing items in the database.
glm942016-11-10 00:02:15 -06:00
8e140a7131
Set up Invoice DataGridView event handlers to validate user input and provide basic formatting for the contents of the cells. Updated the week ending masked text box to get a parsed DateTime value, just to make it look pretty.
glm942016-11-08 02:24:58 -06:00
f60cc5ab8b
First implementation of ad item repeat detection for all APC tables. Still need to update comments in inventory and actual sales methods. No testing done as of now.
glm942016-11-06 22:51:36 -06:00
6e45121c1f
Began implementing ad item repeat detection in the new Add Record Form but for the Projections table only.
glm942016-11-05 14:38:21 -05:00
95d5cd9943
Fixed a bug when deleting non ad special rows the ad special index flag wouldn't get updated.
glm942016-11-05 13:33:25 -05:00
6385ed283f
Added Access database to the solution properly.
glm942016-11-05 12:09:50 -05:00
98b3626154
Initial commit of version 0.9.5.2; no older versions exist for this repo.
glm942016-11-05 12:02:02 -05:00
ea2f5b8a59
Initial commit with contributors
glm942016-11-05 11:59:09 -05:00
glm94