Adding New Client

Add DNS in cloudflare

Insert Client in Master

DECLARE @title AS VARCHAR(100);
DECLARE @code AS VARCHAR(100);
DECLARE @description AS VARCHAR(100);
DECLARE @weburl AS VARCHAR(100);
DECLARE @apiurl AS VARCHAR(100);
DECLARE @connection_payload AS VARCHAR(100);

DECLARE @clientId AS INT;


SET @title = 'RN PHARMACEUTICALS';
SET @code = 'PCTX-RNPH';
SET @description = @title;
SET @weburl = '*.xeonsoftware.com';
SET @apiurl = 'api-*.xeonsoftware.com';
SET @connection_payload = '';


INSERT INTO Clients(Title,Code, Description, ApiUrl, WebUrl, Status, SecurityStamp, GlobalId, DatabaseType)   
values(@title, @code, @description, @apiurl, @weburl, 2, NEWID(),NEWID(),2);

SET @clientId = 0;

INSERT INTO Configurations(ClientId, Name, TypeId, Payload, PayloadType, Active, GlobalId) 
VALUES(@clientId, @connection_payload,1, @connection_payload, 9, 1, NEWID());

INSERT INTO Configurations(ClientId, Name, TypeId, Payload, PayloadType, Active, GlobalId) 
VALUES(@clientId, 'Sales Invoice Print',10, 'thermal', 12, 1, NEWID()); 

Xeon Default Super Addmin Restore

UPDATE users SET UserName = 'admin@xeon.tech', NormalizedUsername = 'ADMIN@XEON.TECH', email = 'admin@xeon.tech', NormalizedEmail = 'ADMIN@XEON.TECH', 
PasswordHash = 'AQAAAAEAACcQAAAAEOXWw0C9gdTrM2bR70JMMCKsrdaTVpUwKKUZ5jtJ2e/yyT0xcxGlSrxrjbsOj4nfHg==' 
WHERE Id = -1;

Default PocketX Super Addmin Restore

UPDATE users SET UserName = 'pct-admin', NormalizedUsername = 'PCT-ADMIN', email = 'admin@xeon.tech', NormalizedEmail = 'ADMIN@XEON.TECH', 
PasswordHash = 'AQAAAAEAACcQAAAAEEMnMqleVCJ7jZPi98fovQLhDWOPohKztJnkSZiFnIpdIHhEP0WJfLSGkm31daQwkg==' 
WHERE Id = -1;