USE Build_file
GO

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'dbo' AND ROUTINE_NAME = 'sp_Bui_Update_Doctor_Details')
EXEC ('CREATE PROC dbo.sp_Bui_Update_Doctor_Details AS SELECT 1')
GO



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[sp_Bui_Update_Doctor_Details]

 --UPDATE TBCODOCTOR--

 @DoctorId as int, 
 @CommonCode as varchar(4),  
 @LastName as varchar(40), 
 @FirstName as varchar(30), 
 @MiddleName as varchar(30),
 @Sex as varchar(1), 
 @Address as varchar(200), 
 @Telephone as varchar(20), 
 @PMCC as varchar(20), 
 @TaxNumber as varchar(20),
 @status as varchar(1),
 @title as varchar(20),
 @Visiting varchar(1), 
 @isForOpdCheckup as varchar(1),
 @HouseCase as varchar(1), 
 @License as varchar(12), 
 @BankAccount as varchar(20), 
 @SpecializationID as varchar(2), 
 @SpecializationID2 as varchar(2), 
 @SpecializationID3 as varchar(2),
 @DeptCode as varchar(2),
 @Department as varchar(50),
 @DrClinic as varchar(70) = null, 
 @CategoryID as varchar(1) = null, 
 @ClinicInfo as varchar(250) = null,
 @BirthDay as varchar(11) = null, 
 @EmailAdd as varchar(40) = null, 
 @PhilHealthNum as varchar(20) = null, 
 @PMANum as varchar(35) = null, 
 @TinNum as varchar(30) = null, 
 @CellNum as varchar(15) = null,
 @SchedDay1 as varchar(20) = null,  
 @SchedDay2 as varchar(20) = null,  
 @SchedDay3 as varchar(20) = null,
 @SchedDay4 as varchar(20) = null, 
 @SchedDay5 as varchar(20) = null, 
 @SchedDay6 as varchar(20) = null,  
 @SchedDay7 as varchar(20) = null, 
 @WithHoldingTax as float = null, 
 @CardCode as varchar(15) = null, 
 @DoctorInfo as varchar(50) = null,
 @RateA as float = null, 
 @RateB as float = null, 
 @RateC as float = null, 
 @RateD as float = null, 
 @RateE as float = null, 
 @RateF as float = null, 
 @RateG as float = null, 
 @RateH as float = null, 
 @RateI as float = null, 
 @RateJ as float = null,
 @CapitalStock as money = null,
 @Vat as float = null, 
 @ShareofStock as money = null,
 @GrossRental as float = null, 
 @MonthlyDues as float = null,
 @CCTV as float = null,
 @TelBill as float = null,
 @LightBill as float = null, 
 @WaterBill as float = null, 
 @Cable as float = null

	AS
UPDATE tbCoDoctor

		SET
		CommonCode=@CommonCode, 
		LastName=@LastName, 
		FirstName=@FirstName, 
		MiddleName=@MiddleName, 
		Sex=@Sex, 
		DoctorAddress=@Address, 
		TelNo=@Telephone, 
		PMCC=@PMCC, 
		TaxNumber=@TaxNumber,
		status=@status, 
		title=@title, 
		Visiting=@visiting, 
		isForOpdCheckup=@isForOpdCheckup, 
		HouseCase=@HouseCase, 
		License=@License, 
		BankAccount=@BankAccount, 
		SpecializationID=@SpecializationID, 
		SpecializationID2=@SpecializationID2,
		SpecializationID3=@SpecializationID3,
		DeptCode=@DeptCode,
		Department=@Department, 
		DrClinic=@DrClinic, 
		Birthday=@Birthday, 
		EmailAdd=@EmailAdd, 
		PhilHealthNum=@PhilHealthNum, 
		PMANum=@PMANuM, 
		TinNum=@TinNum, 
		CellNum=@CellNum, 
		CategoryID=@CategoryID, 
		ClinicInfo=@ClinicInfo, 
		SchedDay1=@SchedDay1,	
		SchedDay2=@SchedDay2, 
		SchedDay3=@SchedDay3, 
		SchedDay4=@SchedDay4, 
		SchedDay5=@SchedDay5, 
		SchedDay6=@SchedDay6, 
		SchedDay7=@SchedDay7, 
		TaxWithHeld=@WithHoldingTax, 
		CardCode=@CardCode, 
		DoctorInfo=@DoctorInfo, 
		WithHoldingTax=@WithHoldingTax, 
		RateA=@RateA, 
		RateB=@RateB, 
		RateC=@RateC, 
		RateD=@RateD, 
		RateE=@RateE, 
		RateF=@RateF, 
		RateG=@RateG, 
		RateH=@RateH, 
		RateI=@RateI, 
		RateJ=@RateJ, 
		CapitalStock=@CapitalStock, 
		Vat=@Vat, 
		SharesofStock=@ShareofStock, 
		GrossRental=@GrossRental, 
		MonthlyDues=@MonthlyDues, 
		CCTV=@CCTV, 
		TelBill=@TelBill, 
		LightBill=@LightBill, 
		WaterBill=@WaterBill, 
		Cable=@Cable

    WHERE DoctorID=@DoctorID
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO