hlo
i have one table t_country_label
in these table we insert the value
insert into t_country_label values(1,-1,'Massage Provider/Owner','Massage Parlor/Owner','Home Page'),
(1,100,'Massage Provider/Owner','Massage Provider/Owner','Home Page'),
(1,224,'Massage Provider/Owner','Massage Therapist/Owner','Home Page');
i created one procedure
ALTER PROC [dbo].[p_g_country_label]
@country_sk int
as
begin
if exists (select 1 from t_country_label where country_sk=@country_sk )
BEGIN
select label_name from t_country_label where country_sk=@country_sk
END
ELSE
BEGIN
select 'Massage Parlor/Owner'
END
END
i have one BussinessRegistration.cs
i wrote the code like that
public DataSet get_dynamic_label(int country_sk)
{
DataSet ds = new DataSet();
ds= objRegistrationFactory.get_dynamic_label(c ...
Go to the complete details ...