Instructions
This application creates some files. It is best if this application is run in a directory dedicated for this application.
When the application is run for the first time, it starts with a set up. You will have to enter a username, password, name, GMail EmailID, and the Company details. A user is uniquely identified by the username. When these details are entered, the set up continues. The details you entered are used to create a user with admin priviliges. The Email ID isused to connect to smtp.gmail.com to send emails. When the set up is completed, a login screen will appear.
The login screen will require you to enter your username and password. Fill the fields with the correct details and click on Login to continue.
Once you are successfully logged in, you the Home Screen will be displayed. Here, you can choose the operation to perform.
When you click the Add Product button on the Home Screen, you will be redirected to the Add product screen. The Products are uniquely identified by the ID which is auto-generated and cannot be edited. Fill in the other Details. The No.s field when check means that the product is sold in numbers and not weight. When all the details are filled in, click on the Add button. If your product is successfull added to the database, the fields will be cleared and the ID will be updated.
When you click on the Delete Product button on the Home Screen, you will be redirected to the Delete Product Screen. In this screen you have to enter the ID of the product you want to delete. Then, click on the Get Product button to verify the name of the product and click on Delete to delete the product.
When you click on the Update Product button on the Home Screen, you will be redirected to the Update Product Screen. In this screen fill in the ID attribute alone of the product whose details you want to update. Then click on the Get Product button to get its details. Change the required details and click on the Update button to make the changes. If successfully updated, the fields will get cleared.
When you click on the Search Product button on the Home Screen, you will be redirected to the Search Product Screen. Here, fill in the ID or the Name of the product to search for. If both the fields are filled, the ID field will be given more priority and only the products with matching ID will be retrieved. If only the Name field is filled, all the record having that name as a substring will be retrieved and displayed.
When you click on the Billing button on the Home Screen, you will be redirected to the Billing Screen. Here, fill in the ID and the Qty fields and click on the get product button to get the details of the product. If the Qty is not entered, it will be taken as '1' by default. Click on the Add button to add the item to the bill. To delete an item from the bill, click on that item and click on the Delete button. Finally, fill in the Customer's Name and Email and click on the Generate button to the generate the bill. Your Gmail password will be requested. This password will be used with the Email ID entered during set up to connect to smpt.gmail.com for sending emails. The password is not stored. The bill will be stored as a file in the bills directory with bill number as the file name. A copy of the bill will be mailed to the customer.
When you click on the Stock Statement button on the Home screen, you will get a message saying that the Stock statement generation has started. Click on OK to start the generation. You will get a message saying that the generation is complete. Keep the application open until you get this message.
When an admin is logged in, an extra button appears on the Home Screen, the User Handling button. When this button is clicked, the User Handling Screen is shown. Click on the buttons to perform the corresponding tasks.
Do not add Spaces in Text Fields in the application unless absolutely necessary.