Database

Quote:

Have you contacted the manufacturer of said scanner and asked them how to interact with it programmatically? Probably through an API that they would have to provide.

CREATE TABLE ControlNumbers (
LastNumber Varchar(50)
)

Hotaxion wrote:

CREATE TABLE ControlNumbers (
LastNumber Varchar(50)
)

CREATE TABLE ControlNumbers (
LastNumber Int IDENTITY(1,1)
)

CREATE TABLE IdsList(id INT IDENTITY(1,1), datum CHAR(1));
-- datum is an arbitrary column 

INSERT #IdsList(datum) VALUES('x');
declare @lastnum int  = (SELECT SCOPE_IDENTITY())

ALTER PROCEDURE [dbo].[sp_HeaderSave] (@Lastnumber int OUTPUT) AS

BEGIN

  BEGIN TRANSACTION [MyTrans]

  BEGIN TRY

    INSERT #IdsList(datum) VALUES('x');
    SET @lastnumber int  = (SELECT SCOPE_IDENTITY())

    INSERT INTO Header (DOCNo, VersionNo, NoteDate)
    VALUES (@Lastnumber,'VersionNo',GETDATE())

    COMMIT TRANSACTION [MyTran]

  END TRY

  BEGIN CATCH

    ROLLBACK TRANSACTION [MyTran]

  END CATCH  
END

[BsonId(IdGenerator = typeof(ObjectIdGenerator)]
public ObjectId Id { get; set; }

{
    "_id" : "5bae68208301500628d80f8c",
    "TimeStamp" : ISODate("2018-09-28T17:42:57.068Z"),
    "Name" : "Long Beach Grand Prix 2008",
    "Description" : "I took this photo at the Long Beach Grand Prix",
    "CreatedBy" : "admin",
    "HTML" : "",
    "AvatarB64" : "data:image/jpeg;base64, data string.
    "AvatarName" : "5bae68208301500628d80f8c.jpg",
    "AvatarType" : "image/jpeg",
    "AvatarUrl" : "<a href="https://localhost:44367/content/images/avatars/portfolios/5bae68208301500628d80f8c.jpg">https://localhost:44367/content/images/avatars/portfolios/5bae68208301500628d80f8c.jpg</a>",
    "AvatarX" : 256,
    "AvatarY" : 256,
    "AvatarStatus" : true
}

jkirkerx wrote:

ObjectId....HTTP...application/json