Skip to content

This is a Item sale Information App. It also display year wise Sales data.

Notifications You must be signed in to change notification settings

krishkamani/Item-Sale-Information

Repository files navigation

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

1

2

3

4