storeprocedure

ALTER PROCEDURE USP_IDFU_Customers
(@CustomerId int = null,
@Name varchar(30) = null,
@PhoneNo varchar(50)=null,
@EmailId Varchar(30)=null,
@Address varchar(50)=null,
@City varchar(30)=null,
@state varchar(30)=null,
@Pincode varchar(30)=null,
@IsActive bit = null,
@Type char(1)
)
as
if(@Type = 'I')
begin
insert into Customer(Name,PhoneNo,EmailId,Address,City,State,PinCode,IsActive)values(@Name,@PhoneNo,@EmailId,@Address,@City,@State,@PinCode,@IsActive)
end
if(@Type = 'D')
begin
Delete from Customer where CustomerId=@CustomerId
end
if(@Type = 'F')
begin
select * from Customer
end
if(@Type = 'U')
begin
update Customer set Name=@Name,PhoneNo=@PhoneNo,EmailId=@EmailId,Address=@Address,City=@City,State=@State,PinCode=@PinCode,IsActive=@IsActive where CustomerId=@CustomerId
end