DB Creation & Code Movement

Sub Domain Creation:

To create a new region we have to raise a ticket to ctrls with the below details:

Email Content: In the below content change the subdomain name while creating it for new client and check server credentials in which server we have to get the subdomain created.

We request you to create Subdomain:https://procurement.prm360.com and add DNS routing and do the needful mentioned below.

1. Activate DNS

2. Add SSL

3. Add default redirection rule from Http to https

4. Add default index.html

5. Create in this file location : D:\Inetpub

Server credentials:

Hostname:ACADS360C08690

IP:45.127.102.158

User: administrator

Password: C$FRK4Zhn_BT54c$

RDP:33893

Note: Do not do any modifications to the server for existing sites/subdomain sites.

DB Creation with default data

1)Cloning the existing DB: To clone the DB use the below query

DBCC CLONEDATABASE ('olddatabasename', 'newdatabasename') WITH VERIFY_CLONEDB, BACKUP_CLONEDB;    

GO

After executing the query refresh the database then we can see the newdatabasename

2) Insert tables with default data

Replace database names before executing

SET IDENTITY_INSERT ajanthaprod.dbo.appversioninfo ON insert into ajanthaprod.dbo.appversioninfo(APP_NAME,APP_VERSION,APP_VERSION_DETAILS,APP_IS_MANDATORY,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY,av_id,APP_VERSION_CODE,END_USER,ROLE_ID)select APP_NAME,APP_VERSION,APP_VERSION_DETAILS,APP_IS_MANDATORY,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY,av_id,APP_VERSION_CODE,END_USER,ROLE_ID from syngenetestdb.dbo.appversioninfo;SET IDENTITY_INSERT ajanthaprod.dbo.appversioninfo OFF

SET IDENTITY_INSERT ajanthaprod.dbo.categories ON insert into ajanthaprod.dbo.categories(CAT_ID,CATEGORY,SUBCATEGORY,COMP_ID) select CAT_ID,CATEGORY,SUBCATEGORY,COMP_ID from syngenetestdb.dbo.categories; SET IDENTITY_INSERT ajanthaprod.dbo.categories OFF

SET IDENTITY_INSERT ajanthaprod.dbo.currencies ON insert into ajanthaprod.dbo.currencies(CURR_NAME,CURR_UNICODE,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY,CURR_ID) select CURR_NAME,CURR_UNICODE,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY,CURR_ID from syngenetestdb.dbo.currencies; SET IDENTITY_INSERT ajanthaprod.dbo.currencies OFF

 SET IDENTITY_INSERT ajanthaprod.dbo.companytypes ON insert into ajanthaprod.dbo.companytypes(COMP_TYPE_ID,COMPANY_TYPE) select COMP_TYPE_ID,COMPANY_TYPE from syngenetestdb.dbo.companytypes; SET IDENTITY_INSERT ajanthaprod.dbo.companytypes OFF

SET IDENTITY_INSERT ajanthaprod.dbo.companyconfiguration ON insert into ajanthaprod.dbo.companyconfiguration(C_CONFIG_ID,COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED, CREATED_BY,MODIFIED_BY)select C_CONFIG_ID,COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY from syngenetestdb.dbo.companyconfiguration;SET IDENTITY_INSERT ajanthaprod.dbo.companyconfiguration OFF

SET IDENTITY_INSERT ajanthaprod.dbo.timezones ON insert into ajanthaprod.dbo.timezones(ZONE_ID,ZONE_NAME,ZONE_ID_MICROSOFT,ZONE_DETAIL_NAME,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)select ZONE_ID,ZONE_NAME,ZONE_ID_MICROSOFT,ZONE_DETAIL_NAME,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY from syngenetestdb.dbo.timezones; SET IDENTITY_INSERT ajanthaprod.dbo.timezones OFF

SET IDENTITY_INSERT ajanthaprod.dbo.parameters ON

insert into ajanthaprod.dbo.parameters(PARAM_ID,PARAM_CODE,PARAM_COMMENT,PARAM_TYPE,PARAM_VALUE,PARAM_VALID,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY,U_VER_PARAMETER,IS_MANDATORY)select PARAM_ID,PARAM_CODE,PARAM_COMMENT,PARAM_TYPE,PARAM_VALUE,PARAM_VALID,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY,U_VER_PARAMETER,IS_MANDATORY from syngenetestdb.dbo.parameters; SET IDENTITY_INSERT ajanthaprod.dbo.parameters OFF

INSERT INTO ajanthaprod.dbo.accesslevels

SELECT * FROM syngenetestdb.dbo.accesslevels;

INSERT INTO ajanthaprod.dbo.companytypes

SELECT * FROM syngenetestdb.dbo.companytypes;

INSERT INTO ajanthaprod.dbo.companydepartmenttypes

SELECT * FROM syngenetestdb.dbo.companydepartmenttypes;

INSERT INTO ajanthaprod.dbo.companydesignationtypes

SELECT * FROM syngenetestdb.dbo.companydesignationtypes;

insert into   companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'REQ_SERIAL_NUM','1','1','1',GETDATE(),GETDATE(),'0','0');

insert into companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'REQ_SERIAL_NUM_PREFIX','PRM','PRM','1',GETDATE(),GETDATE(),'0','0');

insert into companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'DISABLE_LOCAL_GST_FEATURE','1','1','1',GETDATE(),GETDATE(),'0','0');

insert into companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'BEST_PRICE_FROM','2023-08-01','2066-01-01','1',GETDATE(),GETDATE(),'0','0');

insert into companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'BEST_PRICE_TO','2023-08-01','2066-01-01','1',GETDATE(),GETDATE(),'0','0');

INSERT INTO rainbowauctionsdb.dbo.prmtemplatefields

SELECT 5,FIELD_NAME,FIELD_LABEL, FIELD_PLACEHOLDER , FIELD_DATA_TYPE ,

 FIELD_DEFAULT_VALUE , FIELD_OPTIONS , FIELD_READ_ONLY , FIELD_IS_VENDOR , FIELD_IS_CUSTOMER , DATE_CREATED , DATE_MODIFIED , CREATED_BY , MODIFIED_BY 

FROM heromotocorpproddb.dbo.prmtemplatefields;

3) Creating SuperUser

TO CREATE SUPERUSER change values and execute:

EXEC cp_Register

0, 'Automation', 'Customer', '4466227863',

'automationcustomer360@gmail.com',

'',

'',

'',

'', '',

'automationcustomer', 'automationcustomer1',

'Automation CUSTOMER PVT LTD',

'',

'CUSTOMER',

0,

'',

0,

1, 51,

'', '',

 '',

 'Hyderabad', 'Telangana',

 '',

 '',

 'INDIA',

 'TELANGANA', '500049',

 'HYDERABAD', '', '', '',

 '', '', '', '',

 '', '', '', 0,

 4, '','', '',

 '', '', '',

 '', 'automationcustomer', 'automationcustomer1',

 0, '', '','','','','','','','';

Once super user is created cross-check and verify the following

select * from [user];

a)      Need to enable the catalog

select * from company;

           update company set IS_CATALOG_ENABLED=1 where comp_id=14271;

b)     Userverification

select * from userverification;

update userverification set U_IS_VERIFIED=1 where U_ID=14271;

c)      Emailotpverification

select * from userdata;

update userdata set isEmailOTPVerified=1 where U_ID=14271;

d)Accesslevel

insert into useraccess(U_ID,ACS_ID,IS_VALID,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

select 12,ACS_ID,1,GETUTCDATE(),GETUTCDATE(),0,0 from accesslevels 

Then check the parameters

Select * from parameters

update parameters set param_value='720' where param_id='7'

Insert the local gst,req details,comp_id etc…….

Select * from company //Change the comp_id and execute the query

Create access level for the admin to create RFQ

SET IDENTITY_INSERT vasudhapharmadevdb.dbo.useraccess ON insert into vasudhapharmadevdb.dbo.useraccess(UACS_ID,U_ID,ACS_ID,IS_VALID,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)select UACS_ID,U_ID,ACS_ID,IS_VALID,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY from neulandprod.dbo.useraccess  where u_id='12789' ;SET IDENTITY_INSERT vasudhapharmadevdb.dbo.useraccess OFF

INSERT INTO cm_product (CompanyId,ProductCode,ProductName,ProductDesc,ProductNo,ProdQty,IsValid,DateCreated,DateModified,CreatedBy,ModifiedBy)VALUES(17726,'Packaging and forward charges','Packaging and forward charges','','Packaging and forward charges','Numbers',1,GETUTCDATE(),

GETUTCDATE(),17344,17344);

INSERT INTO cm_product (CompanyId,ProductCode,ProductName,ProductDesc,ProductNo,ProdQty,IsValid,DateCreated,DateModified,CreatedBy,ModifiedBy)VALUES(17726,'Freight charges','Freight charges','','Freight charges','Numbers',1,GETUTCDATE(),

GETUTCDATE(),17344,17344);

INSERT INTO cm_product (CompanyId,ProductCode,ProductName,ProductDesc,ProductNo,ProdQty,IsValid,DateCreated,DateModified,CreatedBy,ModifiedBy)VALUES(17726,'Insurance Charges','Insurance Charges','','Insurance Charges','Numbers',1,GETUTCDATE(),

GETUTCDATE(),17344,17344);

INSERT INTO cm_product (CompanyId,ProductCode,ProductName,ProductDesc,ProductNo,ProdQty,IsValid,DateCreated,DateModified,CreatedBy,ModifiedBy)VALUES(17726,'Miscellaneous Charges','Miscellaneous Charges','','Miscellaneous Charges','Numbers',1,GETUTCDATE(),

GETUTCDATE(),17344,17344);

Create categories as Sourcing-PRM360 and RequirementItems

update cm_Category set is_core='0' where CategoryId='23919';--requirementitems

 SET IDENTITY_INSERT prmtemplatefields ON;

INSERT INTO prmtemplatefields (

    TEMPLATE_FIELD_ID, TEMPLATE_ID, FIELD_NAME, FIELD_LABEL, FIELD_PLACEHOLDER, FIELD_DATA_TYPE, 

    FIELD_DEFAULT_VALUE, FIELD_OPTIONS, FIELD_READ_ONLY, FIELD_IS_VENDOR, FIELD_IS_CUSTOMER, 

    DATE_CREATED, DATE_MODIFIED, CREATED_BY, MODIFIED_BY

)

SELECT 

    TEMPLATE_FIELD_ID, TEMPLATE_ID, FIELD_NAME, FIELD_LABEL, FIELD_PLACEHOLDER, FIELD_DATA_TYPE, 

    FIELD_DEFAULT_VALUE, FIELD_OPTIONS, FIELD_READ_ONLY, FIELD_IS_VENDOR, FIELD_IS_CUSTOMER, 

    DATE_CREATED, DATE_MODIFIED, CREATED_BY, MODIFIED_BY 

FROM 

    glenmarkdb.dbo.prmtemplatefields 

WHERE 

    TEMPLATE_ID=143

SET IDENTITY_INSERT prmtemplatefields OFF;

Code movement and default data creation

1)      Copy the existing client web folder from

D://Intehub//neulandlaboratories.prm360.com//web

Paste the web folder to the new client

D://Intehub//vasudhapharma.com//web

And rename web folder as dev

Once the web file is placed then we need to open dev->web.config file and replace the old client name with the new one

a)      Replace Neuland with Vasudhapharma

b)      DB name

c)       Website URL

d)      Company_name

e)      Company_id: super user u_id

In order to change logo:

D://Intehub//vasudhapharma.com//dev//js//resources//images

The image should be named as : client_logo.png

2)      Create a newfolder in vasudhapharma ->services

D://Intehub//neulandlaboratories.prm360.com//services

Paste the auctionfiles ,devattachments,templateattachments folder to the new client

D://Intehub//vasudhapharma.com//services

3)      Change web.config data

Copy the data from D://Intehub//neulandlaboratories.prm360.com//web.config

And replace it in D://Intehub//vasudhapharma.prm360.com//web.config-> change the URL and save

4)      Open IIS Manager

Acads->Sites->Vasudhapharma.com->dev->rightclick -> convert to application

Application has been created

URL: https://vasudhapharma.prm360.com/dev/prm360.html#/login/

5)      Login to the portal

a)      Create a Department and designation

b)      Create Currency

c)      Create categories as Sourcing-PRM360 and RequirementItems

update cm_Category set is_core='0' where CategoryId='23919';

d)      Create 4 products and category as requirement items (Packaging and forwading charges,Insurance charges, Miscellaneous charges,Freight charges)

e)      Insert Incoterms based on the productid

f)       Create PRM-DEFAULT template

g)      Create PRICE CAP in my vendors comp_name:PRICE_CAP