How to create a query for below situation

CREATE TABLE #CONTROL_VALUES
(
	ID INT
	, CONTROL_NAME VARCHAR(100)
	, VALUE VARCHAR(3)
);

INSERT INTO #CONTROL_VALUES(ID, CONTROL_NAME, VALUE)
VALUES(1, 'chkMaleYes', 'Yes');
INSERT INTO #CONTROL_VALUES(ID, CONTROL_NAME, VALUE)
VALUES(1, 'chkMaleNo', 'No');
INSERT INTO #CONTROL_VALUES(ID, CONTROL_NAME, VALUE)
VALUES(2, 'chkMaleYes', 'No');
INSERT INTO #CONTROL_VALUES(ID, CONTROL_NAME, VALUE)
VALUES(2, 'chkMaleNo', 'Yes');

-- Select query for your required answer
SELECT ID, CASE WHEN CONTROL_NAME = 'chkMaleYes' THEN 'Male' ELSE 'Female' END AS SEX
FROM #CONTROL_VALUES
WHERE VALUE = 'Yes';

if(chkMaleYes.Checked)
{
         //insert id 1  
}
else
{
         // insert id 2
}

enum Gender
{
Male = 1,
Female = 2
}