public static bool IsUserIDExists(string UserID) { BLLQuery DB = new BLLQuery(); SqlParameter[] SqlParam = { new SqlParameter("@UserID", UserID) }; int Status = 0; try { Status = Convert.ToInt32(DB.ExecScalerSP_Object(CommandType.StoredProcedure, "SP_User_CheckDuplicateUserId", SqlParam)); } catch { Status = 0; } if (Status > 0) { return(true); } return(false); }