NextReport Update Table

 declare @sql varchar(max);

DECLARE @DateName nvarchar(100)

SET @DateName=  '[NextReport].[dbo].NXTRPTEmployeeProfile' + CAST( GetDate()  as NVARCHAR(12) );

SELECT @DateName = REPLACE(@DateName, ' ', '')

 --SELECT @DateName

 Set @sql = 'SELECT * INTO ' +  @DateName +' FROM [NextReport].[dbo].NXTRPTEmployeeProfile ';

 EXECUTE(@sql)

 

Backup Tables by Date

 

declare @sql varchar(max);

DECLARE @DateName nvarchar(100)

SET @DateName=  'NXTRPTEmployeeProfile' + CAST( GetDate()  as NVARCHAR(12) );

SELECT @DateName = REPLACE(@DateName, ' ', '')

 

 Set @sql = 'SELECT * INTO ' +  @DateName +' FROM NXTRPTEmployeeProfile ';

 EXECUTE(@sql)

httpclient request with Access Token and payloads:

 httpclient request with Access Token and payloads:

 var param = new

            {

                documentNumber = "1317915213594",

                motherName = "Amena",

                dateOfBirth = "01/23/1985"

            };

var dataString = JsonConvert.SerializeObject(param);

            string accessToken_ = userDatas.accessToken;

            var client = new HttpClient();

            var request = new HttpRequestMessage(HttpMethod.Post, "http://104.198.53.36:8080/UW/app/erp/duplicationCheck");

            request.Headers.Add("Authorization", accessToken_);

            var content_ = new StringContent(dataString, null, "application/json");

            request.Content = content_;

            var response_ = await client.SendAsync(request);

            response_.EnsureSuccessStatusCode();

Knowledge

 Knowledge itself is a potential power. Knowledge combined with action is real power. 

yarn

 b> npm install --global yarn

yarn install

yarn start

Dev Ops

 

kitten