copy කරන් තියෙන එක paste කරල යන්න

misty9051

Active member
  • Jul 25, 2011
    403
    60
    28
    Sudan
    Package Includes:

    1x UNIC Projector
    1x 3-in-1 AV Cable
    1x Warranty Card
    1x US Power Cable
    1x Remote Control
    1x User Manual
    Condition:New
    Item type:Projector
    Save ad as Favorite
    Report this ad
     

    madhawavish

    Well-known member
  • Sep 18, 2014
    6,068
    1
    3,005
    113
    the universe
    Dude Fights Giant Bird... :lol::lol::lol:
    Package Includes:

    1x UNIC Projector
    1x 3-in-1 AV Cable
    1x Warranty Card
    1x US Power Cable
    1x Remote Control
    1x User Manual
    Condition:New
    Item type:Projector
    Save ad as Favorite
    Report this ad
    :nerd::nerd:
    ඡායාවක් වී නික්මී යනවා...ඒ අහින්සක ආදරේ...
    :dull::dull:

    011-2432908
    kotuwa railway station..:cool:;)

    Armin van Buuren feat. Emma Hewitt - Forever Is Ours
    :cool::cool:
    Ash.vs.Evil.Dead.S02E10.720p.WEBRip.X264-DEFLATE
    :cool::cool:
    How to make your Headphone Wireless
    - This Is What You Came For
    ln -sf /usr/local/sbin/mount-shared-folders /root/Desktop/mount-shared-folders.sh
    gsettings set org.gnome.nautilus.preferences executable-text-activation 'ask'
    :):)
    :sorry::sorry::sorry:

    god fartherrr:cool::cool:
    කුඩ්ඩා;21012228 said:
    :lol::lol:

    Computer Science
    ;);)
     

    chanakaisuru

    Active member
  • May 20, 2009
    202
    28
    28
    kiribathgoda
    /****** Object: StoredProcedure [dbo].[Sp_REP_UPDATE] Script Date: 12/12/2016 09:32:05 ******/
    SET ANSI_NULLS OFF
    GO
    SET QUOTED_IDENTIFIER OFF
    GO



    ALTER PROCEDURE [dbo].[Sp_REP_UPDATE]
    @REP_CODE Varchar(10),
    @COUNTRY Varchar(30),
    @REP_NAME Varchar(50),
    @CONTACT_NAME Varchar(50),
    @CONTACT_NO Varchar(15),
    @ADDRESS1 Varchar(50),
    @ADDRESS2 Varchar(50),
    @ADDRESS3 Varchar(50),
    @PHONE1 Varchar(15),
    @PHONE2 Varchar(15),
    @PHONE3 Varchar(15),
    @FAX Varchar(15),
    @EMAIL Varchar(50),
    @WEB_SITE Varchar(50),
    @MODE int,
    @USER_ID Varchar(10),
    @COMM Money=0,
    @TARGET Float=0,
    @ISREP Bit=1
    AS

    IF @MODE=0
    BEGIN
    INSERT INTO TB_SALESREP ( [REP_CODE], [COUNTRY], [REP_NAME], [CONTACT_NAME], [CONTACT_NO], [ADDRESS1],
    [ADDRESS2], [ADDRESS3], [PHONE1], [PHONE2], [PHONE3], [FAX], , [WEB_SITE],
    [CDATE], [USER_ID], [COMMRATE], [TARGETAMT], [REP]) VALUES
    (@REP_CODE, @COUNTRY, @REP_NAME, @CONTACT_NAME, @CONTACT_NO,
    @ADDRESS1, @ADDRESS2, @ADDRESS3, @PHONE1, @PHONE2,
    @PHONE3, @FAX, @EMAIL, @WEB_SITE, CONVERT(DATETIME,GETDATE(),103), @USER_ID,
    @COMM ,@TARGET ,@ISREP)
    END
    ELSE
    BEGIN
    UPDATE TB_SALESREP SET [COUNTRY] =@COUNTRY,
    [REP_NAME] =@REP_NAME,
    [CONTACT_NAME] =@CONTACT_NAME,
    [CONTACT_NO] =@CONTACT_NO,
    [ADDRESS1] =@ADDRESS1,
    [ADDRESS2] =@ADDRESS2,
    [ADDRESS3] =@ADDRESS3,
    [PHONE1] =@PHONE1,
    [PHONE2] =@PHONE2,
    [PHONE3] =@PHONE3,
    [FAX] =@FAX,
    [EMAIL] =@EMAIL,
    [WEB_SITE] =@WEB_SITE,
    [COMMRATE] =@COMM,
    [TARGETAMT] =@TARGET,
    [CDATE] =CONVERT(DATETIME,GETDATE(),103),
    [USER_ID] =@USER_ID,
    [REP] =@ISREP
    WHERE REP_CODE =@REP_CODE
    END


    IF EXISTS(SELECT REP_CODE FROM TB_SALESREP_RPL WHERE REP_CODE=@REP_CODE) DELETE FROM TB_SALESREP_RPL WHERE REP_CODE=@REP_CODE

    INSERT INTO TB_SALESREP_RPL ( [REP_CODE], [COUNTRY], [REP_NAME], [CONTACT_NAME], [CONTACT_NO], [ADDRESS1],
    [ADDRESS2], [ADDRESS3], [PHONE1], [PHONE2], [PHONE3], [FAX], [EMAIL], [WEB_SITE],
    [CDATE], [USER_ID], [COMMRATE], [TARGETAMT], [REP]) VALUES
    (@REP_CODE, @COUNTRY, @REP_NAME, @CONTACT_NAME, @CONTACT_NO,
    @ADDRESS1, @ADDRESS2, @ADDRESS3, @PHONE1, @PHONE2,
    @PHONE3, @FAX, @EMAIL, @WEB_SITE, CONVERT(DATETIME,GETDATE(),103), @USER_ID,
    @COMM ,@TARGET ,@ISREP)