Develop Forms Application Using C#/.Net

Must develop a Windows Form application written in C#/.NET 4.5.2. A lab environment with Sybase is available for testing. Credentials and DSN configuration will be provided separately. Preference will be given to fast turnarounds. Source code must be provided with application. Milestone payment will be provided upon 100% completion. Partial payments will not be authorized. The windows form will have 3 tabs: 1. Beer Management a. This tab will contain a list with the available items. The columns will be defined as: i. ID (read only) ii. Name (read only) iii. Object Number (numeric entry; can be updated/saved) iv. Class (drop down menu; choices populated from DB; can be updated/saved) b. The data for the list will come from a Sybase DB query: i. SELECT beerID, beerName, microsObjNum, pourClass FROM custom.NCBP_beerDefinitions WHERE isActive = 1 ORDER BY beerName c. The choices for the class number drop down will also come from a Sybase DB query: i. SELECT beerClassID, beerClassName FROM custom.NCBP_beerPourClass WHERE isActive = 1 ORDER BY beerClassName 2. Pour Sizes a. This tab will contain a list of current items as well as provide the opportunity to modify existing items and create new items. The columns/fields will be defined as: i. ID ii. Name (text) iii. Level 1 Pour (numeric) iv. Level 2 Pour (numeric) v. Level 3 Pour (numeric) vi. Level 4 Pour (numeric) vii. Level 5 Pour (numeric) viii. Level 6 Pour (numeric) ix. Level 7 Pour (numeric) x. Level 8 Pour (numeric) xi. Level 9 Pour (numeric) xii. Level 10 Pour (numeric) xiii. Is Active? (check box, radio or similar; 1 or 0 int in DB) b. The data can be modified in a grid view or in a separate form – this is the developer’s choice of approach. There must be a way to create a new item. c. The data for the list will come from a Sybase DB query: i. SELECT beerClassID, beerClassName, level1Pour, level2Pour, level3Pour, level4Pour, level5Pour, level6Pour, level7Pour, level8Pour, level9Pour, level10Pour, isActive FROM custom.NCBP_beerPourClass WHERE isActive = 1 ORDER BY beerClassName 3. Location Configuration a. This tab will contain a single drop down that selects and makes a location active. If no location is marked as the active location in the DB, “<NO LOCATION CONFIGURED>” will be displayed. b. The data for the list will come from a Sybase DB query: i. SELECT locationID, locationNickname, isLocal FROM custom.NCBP_locationDefinitions WHERE isActive = 1 ORDER BY isLocal DESC, locationNickname c. The item selected in the drop down will be the only item where isLocal = 1. If this is changed, the existing isLocal=1 item must be set to 0, and the new selection must be set to isLocal=1.