Make little bit change in your posted code.
ALTER procedure [dbo].[spadminreg]
@UserName nvarchar(50),
@Password nvarchar(50),
@UserTypeID int,
@DepID int,
@DesigID int,
@emailaddress nvarchar(50),
@PhoneNumber nvarchar(50),
@action nvarchar(50)
AS
BEGIN
if(@action='CheckDuplicate')
BEGIN
Select count(*) from Userss where UserTypeID=@UserTypeID AND DepID=@DepID And DesigID=@DesigID;
END
if(@action='Insert')
BEGIN
insert into [Userss](UserName,Password,UserTypeID,DepID,CreateDate,DesigID,Email ,PhoneNumber)
values
(@UserName,@Password,@UserTypeID,@DepID,GETDATE(),@DesigID,@emailaddress,@PhoneNumber)
END
end
GO
& in c# code ..
public void AdminSignUp(string Username, string Password, int UserTypeID, int DepID, int desigid, string emailaddress, string PhoneNumber)
{
try{
int count= Convert.toInt32( db.ExecuteScalar("spadminreg", new object[] { Username, Password, UserTypeID, DepID, desigid, emailaddress, PhoneNumber ,"CheckDuplicate"}));
if(count>0)
{
}
else
{
}
}
catch(Exception)
{
}
}