Item-Sale-Information

This is a Item sale Information App. It also display year wise Sales data.
An Apk file is also attached with this project.

Don't Forget to Subscribe My Channel , like video and share to your friends. If you want to learn any new things then comment over that. We will make new video on that As soon As Possible.

Task:

Consider the following database tables for the application.

Database Table:

Name of the table: Sales

Column Names
Item Name	Year	Sale Price	Date
Data type with Constraints
Text, Not Null	Integer,Not Null	Real, Not Null Non-Zero,Nonnegative	Text, Not Null DD/MM/YYYY
Sample Data
TV	2019	57000	05/05/2019
AC	2020	28000	10/05/2020
TV	2019	45000	14/05/2019

Database Table:

Name of the table: SalesYear

Column Names
Item Name	Year	TotalSalePriceYearWise
Data type with Constraints
Text, Not Null	Integer,Not Null	Real, Not Null Non-Zero,Nonnegative
Sample Data
TV	2019	102000
AC	2020	28000

Following functionalities in app:

1. First activity is asked item sale details according to table Sales. As soon as owner clicks the submit button, update information in Sales table. Validate the fields for appropriate data type i.e Item Name is Text type, Year is Integer type, etc. Also while updating data in Sales table, update the TotalSalePriceYearWise column for specific item.
   
2. Second activity will display the data of SalesYear table using RecyclerView.
   
   Use Next and Previous button for navigation between activities.

Images of Output