--- Aikhane apni connect er ip likhben r ai block chalaben
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[USP_Channel_Customer_List]
@ChID INT
AS
BEGIN
if @ChID!=0
BEGIN
IF @ChID=109
BEGIN
UPDATE SYSSETTING SET Channel_POS_BILL_OLD = Channel_POS_BILL, Channel_POS_BILL = 1
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [POSX].[dbo].[PARTNER_MASTER]Where [ChID]=@ChID
END
ELSE
BEGIN
UPDATE SYSSETTING SET Channel_POS_BILL = Channel_POS_BILL_OLD
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [dbo].[PARTNER_MASTER]Where [ChID]=@ChID
END
--109
--[SYSSETTING]
END
ELSE if @ChID=0
BEGIN
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [dbo].[PARTNER_MASTER]Where [ChID] not in(0)
END
END
--uporer ta chalano hole chicher ta chalaben
--
--- Aikhane apni connect er ip likhben
AS
BEGIN
if @ChID!=0
BEGIN
IF @ChID=109
BEGIN
UPDATE SYSSETTING SET Channel_POS_BILL_OLD = Channel_POS_BILL, Channel_POS_BILL = 1
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [POSX].[dbo].[PARTNER_MASTER]Where [ChID]=@ChID
END
ELSE
BEGIN
UPDATE SYSSETTING SET Channel_POS_BILL = Channel_POS_BILL_OLD
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [dbo].[PARTNER_MASTER]Where [ChID]=@ChID
END
--109
--[SYSSETTING]
END
ELSE if @ChID=0
BEGIN
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [dbo].[PARTNER_MASTER]Where [ChID] not in(0)
END
END
--uporer ta chalano hole chicher ta chalaben
--
--- Aikhane apni connect er ip likhben
ALTER TABLE dbo.BILLING_HEADER
ALTER COLUMN INVOICENO nvarchar(100)
----DONE