Kotlin Android App with SQL Server
Budget: $10 – $30 USD
Create android application in kotlin.
application has 3 screens: login screen, main screen, result screen.
1. Application starts with login screen. which creates connection to MS SQL Server (using jtds).
after submitting create connection:
Data Source=192.168.125.71
Initial Catalog=BSalesAkcia
User ID = usertxtbox.value
Password = passwordtxtbox.value
If the connection is successful go to the main screen, if not stay on login screen and display connection error text.
2. main screen
2.1. In the beginning of the main screen display ShopName connected to database. ShopName will be provided by following select query:
SELECT Proek.proek
FROM params
INNER JOIN proek ON params.IDProek = proek.IDProek
WHERE params.UN = User ID;
2.2. Display textbox (called barcodefield), where user types or scans barcode of product using camera. Below barcodefield display submit button.
after pressing submit run following select on MS SQL server and get result in bellow field called ProdTfield: SELECT ProdT FROM Prodview WHERE IDProd = barcodefield.value
Below ProdTfield should be button called "check stock".
3. After pressing button “check stock” go to "result screen" & run MS SQL stored procedure called checkstock. This procedure needs variable from ProdTfield and gives data with following fields: ShopName, Size and Quantity. Display data in matrix table: horizontally (headers) Size, vertically (on rows) ShopName, and Quantity between them. in beginning of screen display "go back" button, pressing it should go back to main screen.
application has 3 screens: login screen, main screen, result screen.
1. Application starts with login screen. which creates connection to MS SQL Server (using jtds).
after submitting create connection:
Data Source=192.168.125.71
Initial Catalog=BSalesAkcia
User ID = usertxtbox.value
Password = passwordtxtbox.value
If the connection is successful go to the main screen, if not stay on login screen and display connection error text.
2. main screen
2.1. In the beginning of the main screen display ShopName connected to database. ShopName will be provided by following select query:
SELECT Proek.proek
FROM params
INNER JOIN proek ON params.IDProek = proek.IDProek
WHERE params.UN = User ID;
2.2. Display textbox (called barcodefield), where user types or scans barcode of product using camera. Below barcodefield display submit button.
after pressing submit run following select on MS SQL server and get result in bellow field called ProdTfield: SELECT ProdT FROM Prodview WHERE IDProd = barcodefield.value
Below ProdTfield should be button called "check stock".
3. After pressing button “check stock” go to "result screen" & run MS SQL stored procedure called checkstock. This procedure needs variable from ProdTfield and gives data with following fields: ShopName, Size and Quantity. Display data in matrix table: horizontally (headers) Size, vertically (on rows) ShopName, and Quantity between them. in beginning of screen display "go back" button, pressing it should go back to main screen.