BarCodeReader

An application to run on iOs and Android and possibly windows 10. The app is to read bar codes into an SQL server database. 3 fields to be read in at the moment.

Firstly EmployeeID from a bar code employee badge.

Second a batch number bar code from a pre-printed work instruction card. This bar code cannot be read if the first is not present

Third a process name bar code from the instruction card. This bar code cannot be scanned if the second is not present

Lastly a quantity button to be selected on screen 0-9. Total quantity could be any number of digits. e.g 9 or 57 or 483 or 1233 etc. This option can only be made available if the other data has already been scanned. It should time out after 30 seconds and all fields (apart from Employee) should be cleared.

The first bar code (Employee) needs to be held in memory for 8 hours and then deleted forcing it to be re-scanned. A facility is also needed to re-scan the employee bar code at any time.

The scanned data will be held in one SQL table, which will be polled at regular intervals by another application. The transactions being processed by this other application and the [Processed] and [ProcessedDateTime] fields then being set by this other app.

The app will obviously need to connect to the SQL database.

I have attached a couple of images to help. They are just ideas and not written in stone.

Wifi connection please. 4G & 5G if possible although can discuss this.

I am ope to the idea of the app reading data from the SQL server also. i.e. quantity available to process. Work instructions, next production process. etc.

I am open as to what programming language to use. It must be understood that I want a correctly functioning app and the source code for that app. Copyright will always remain my property.

Table Spec:

/****** Object: Table [dbo].[Booking_Transaction] Script Date: 27/02/2019 18:01:03 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Booking_Transaction](

[Booking_TransactionID] [int] IDENTITY(1,1) NOT NULL,

[EmployeeID] [int] NOT NULL,

[BatchID] [int] NOT NULL,

[Part_ProcessID] [int] NOT NULL,

[Quantity] [int] NOT NULL,

[Processed] [bit] NOT NULL,

[TransactionDateTime] [datetime] NOT NULL,

[ProcessedDateTime] [datetime] NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Booking_Transaction] ADD CONSTRAINT [DF_Table_1_EmployeeID] DEFAULT ((0)) FOR [EmployeeID]

GO

ALTER TABLE [dbo].[Booking_Transaction] ADD CONSTRAINT [DF_Booking_Transaction_BatchID] DEFAULT ((0)) FOR [BatchID]

GO

ALTER TABLE [dbo].[Booking_Transaction] ADD CONSTRAINT [DF_Booking_Transaction_Part_ProcessID] DEFAULT ((0)) FOR [Part_ProcessID]

GO

ALTER TABLE [dbo].[Booking_Transaction] ADD CONSTRAINT [DF_Booking_Transaction_Quantity] DEFAULT ((0)) FOR [Quantity]

GO

ALTER TABLE [dbo].[Booking_Transaction] ADD CONSTRAINT [DF_Booking_Transaction_Processed] DEFAULT ((0)) FOR [Processed]

GO

ALTER TABLE [dbo].[Booking_Transaction] ADD CONSTRAINT [DF_Booking_Transaction_TimeStamp] DEFAULT (getdate()) FOR [TransactionDateTime]

GO

.NET Programación en C# Servidor de Microsoft SQL Arquitectura de software SQL

Nº del proyecto: #18829017

Sobre el proyecto