<!--#include file="sifre.asp"-->
<!--#include file="bag.asp"-->

<head>
<meta http-equiv="Content-Language" content="tr">
<style type="text/css">
A:link {
	COLOR: #000033; TEXT-DECORATION: none
}
A:visited {
	COLOR: #000033; TEXT-DECORATION: none
}
A:active {
	TEXT-DECORATION: none
}
A:hover {
	COLOR: red; TEXT-DECORATION: underline
}
BODY {
	FONT-SIZE: 10px; FONT-FAMILY: Arial;
}
</style>
</head>

<body>

<div align="center">
	<table width="80%" height="276" border="0" align="center" cellpadding="0" cellspacing="0" id="table1">
  <tr>
			<td height="47" align="center" bgcolor="#F7F7F7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
			<b><font face="Arial"><a href="anketadmin.asp">Yönetim Bölümü</a> </font></b>			</td>
		  <td bgcolor="#F7F7F7" align="center" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" height="47">
			<font color="#008000"><a href="anketadmin.asp?shn=yeni">Yeni Anket Ekle!</a></font></td>
	  </tr>
		<tr>
			<td bgcolor="#FBFBFB" align="center" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px" valign="top" width="46%">
			<div id="11pt">
				<div style="background-color: #FBFBFB">
					<%
					shn = request.querystring("shn")
					if shn="" then
					call ana
					elseif shn="ana" then
					call ana
					elseif shn="guncelle" then
					call guncelle
					elseif shn="gekle" then
					call gekle
					elseif shn="sguncelle" then
					call sguncelle
					elseif shn="sguncellendi" then
					call sguncellendi
elseif shn="soruguncelle" then
call soruguncelle
elseif shn="soruguncellendi" then
call soruguncellendi
elseif shn="skeklendi" then
call skeklendi
elseif shn="soruguncelle" then
call soruguncelle
elseif shn="soruguncellendi" then
call soruguncellendi
elseif shn="ssil" then
call ssil
elseif shn="sil1" then
call sil1
elseif shn="sil2" then
call sil2
elseif shn="yeni" then
call yeni
elseif shn="yeklendi" then
call yeklendi

					
					else
					call ana
					end if
					sub yeklendi
		set rs = server.createobject("ADODB.recordset")
		sql="select * from asoru"
		rs.open sql,baglantim,1,3
		if request.form("soru")="" then
		Response.WRite "Bo? Byrakmayynyz!! <a href=javascript:history.back(1)>Geri Dön!</a>"
		response.end
		end if
		
	rs.addnew
	rs("soru")=request.form("soru")
	rs("tarih")=date()
	rs.update
	%>
<meta http-equiv='refresh' content='0; url=anketadmin.asp?shn=guncelle&id=<%=rs("id")%>'>
			
	<%				end sub
					sub yeni
					%>
					<form method="post" action="anketadmin.asp?shn=yeklendi">
					<table border="0" width="100%" cellspacing="0" cellpadding="3">
		<tr>
			<td width="147">Anket Sorusu</td>
			<td width="269">
			<input type="text" name="soru" size="35"></td>
		</tr>
		<tr>
			<td width="147"><font face="Arial" style="font-size: 8pt">Soruyu ekledikten sonra cevaplarını ekleyebilirsiniz</font></td>
			<td><input type="submit" value="Ekle"></td>
		</tr>
		</table>
					</form>
					
				<%	end sub
					
					
					sub sil2
id = request.querystring("id")
set rs = server.createobject("ADODB.recordset")
sql="delete * from asoru where id="&id&""
rs.open sql,baglantim,1,3
Response.Write "Anket Silindi.."

					
					end sub
					
					sub sil1
								id = request.querystring("id")
set rs = server.createobject("ADODB.recordset")
sql="Select * from asoru where id="&id&""
rs.open sql,baglantim,1,3
Response.Write "Bu Anketi Silmek İstiyor Musunuz?"
		%>
					<br><font face="Arial" style="font-size: 8pt"><%=rs("soru")%><br>
					</font><b>
	<a href="anketadmin.asp?shn=sil2&id=<%=rs("id")%>"><font color="#FF0000">EVET!</font></a></b>   -   <a href="anketadmin.asp">
					<font color="#000080">HAYIR</font></a><b><font color="#000080">				
					
				<%	end sub
					sub ssil
					id = request.querystring("id")
set rs = server.createobject("ADODB.recordset")
sql="Delete * from acevap where id="&id&""
rs.open sql,baglantim,1,3
Response.Write "Şık Silindi..."

end sub
					sub soruguncellendi

id = request.querystring("id")
set rs = server.createobject("ADODB.recordset")
sql="select * from asoru where id="&id&""
rs.open sql,baglantim,1,3
if rs("soru")="" then
Response.Write "Boş Bırakmayınız!.. <a href=javascript:history.back(1)>Geri Dön</a>"
response.end
end if

rs("soru")=request.form("soru")
rs.update
%>
					
		<meta http-equiv='refresh' content='0; url=anketadmin.asp?shn=guncelle&id=<%=rs("id")%>'>
			
					<%end sub
					sub soruguncelle
					id = request.querystring("id")
set rs = server.createobject("ADODB.recordset")
sql="select * from asoru where id="&id&""
rs.open sql,baglantim,1,3
%>
</font></b>
<form method="post" action="anketadmin.asp?shn=soruguncellendi&id=<%=rs("id")%>">
<table border="0" width="100%" cellspacing="0" cellpadding="3">
	<tr>
		<td width="147">Anket Sorusu</td>
		<td>
			<input type="text" name="soru" value="<%=rs("soru")%>" size="35"></td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="submit" value="Güncelle"></td>
	</tr>
</table>
</form>
<%
end sub
					
					sub skeklendi
id = request.querystring("id")
set rs = server.createobject("ADODB.recordset")
sql="select * from asoru where id="&id&""
rs.open sql,baglantim,1,3

					set rsx=server.createobject("ADODB.recordset")
					sql="select * from acevap where sid="&rs("id")
					rsx.open sql,baglantim,1,3
					
				cevap = request.form("cevap")
		if cevap="" then
		Response.Write "Boş Alan Bırakmayınız! <a href=javascript:history.back(1)>Geri Dön</a>"
		Response.End
		end if

rsx.addnew
		rsx("cevap")=cevap
		rsx("sid")=rs("id")
rsx.update
%>

<meta http-equiv='refresh' content='0; url=anketadmin.asp?shn=guncelle&id=<%=rsx("sid")%>'>


<%
	end sub
					sub sguncellendi
					id = request.querystring("id")
set rsx = server.createobject("ADODB.recordset")
sql="select * from acevap where id="&id&""
rsx.open sql,baglantim,1,3

cevap = request.form("cevap")
if cevap = "" then
Response.Write "Boş Bırakmayınız!! <a href=javascript:history.back(1)>Geri Dön</a>"
Response.end
end if

rsx("cevap") = cevap
rsx.update
%>
<meta http-equiv='refresh' content='0; url=anketadmin.asp?shn=guncelle&id=<%=rsx("sid")%>'>
<%
end sub : sub sguncelle	
									id = request.querystring("id")
sk = request.querystring("sk")
					set rs = server.createobject("ADODB.recordset")
sql="select * from acevap where id="&id&""
rs.open sql,baglantim,1,3

				%>
					
					<form method="post" action="anketadmin.asp?shn=sguncellendi&id=<%=rs("id")%>">
					
				<table border="0" width="100%" cellspacing="0" cellpadding="3">
		<tr>
			<td width="149">Anket Şıkkı(<%=sk%>)</td>
			<td width="267">
			<input type="text" name="cevap" value="<%=rs("cevap")%>" size="35"></td>
		</tr>
		<tr>
			<td width="149">&nbsp;</td>
			<td><input type="submit" value="Güncelle"></td>
		</tr>
	</table>	
					</form>
					<%
					end sub :sub ana
					%>
					<br>
					<b>
					<font size="2" color="#FF0000" face="Arial">Bu Anda Geçerli Olan Anket</font></b><font size="2"><br>
					</font>	<hr style="border: 1px dotted #C0C0C0" size="1">
<%
				set rh = server.createobject("ADODB.recordset")
				SQL="select TOP 1 * from asoru order by id desc"
				rh.open sql,baglantim,1,3
				if rh.eof then
				Response.Write "Anket Eklenmemiş! <a href=anketadmin.asp?shn=yeni>Yeni Anket Ekle!</a>"
				response.end
				end if
				%>
				</div>
				
<table border="0" width="100%" id="table2" cellspacing="0" cellpadding="0" height="44">
					<tr>
						<td height="22" colspan="2"><div id="9pt"><%=rh("soru")%></div></td>
					</tr>
				<%
set rsx = server.createobject("ADODB.recordset")
sql="select * from acevap where sid= "&rh("id")
rsx.open sql,baglantim,1,3
if rsx.eof then
%>
					<span style="font-size: 8pt">Bu Ankete Şık Eklenmemiş..</span> <a href="anketadmin.asp?shn=gekle&id=<%=rs("id")%>">
					<font color="#0000FF">Yeni Ekle!</font></a>
<%
else
while not rsx.eof
%>	<tr>
						<td width="9%" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dotted #C0C0C0">
						<p align="center">
						<img border="0" src="hg3.gif" width="6" height="6"></td>
						<td width="91%" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dotted #C0C0C0">
						
<div id="9pt"><%=rsx("cevap")%></div>						</td>
					</tr>
					<%
rsx.movenext
wend
end if
%>
			  </table>
				<p align="right"><span style="font-size: 9pt"><a href="anketadmin.asp?shn=guncelle&id=<%=rh("id")%>">Düzenle</a>	</span>	</div></td><% end sub %>
		  <% sub guncelle 
				id = request.querystring("id")
				set rs = server.createobject("ADODB.recordset")
				sql="select * from asoru where id="&id&""
				rs.open sql,baglantim,1,3
				if rs.eof then
				Response.WRite "Geçerli ID Bulunamıyor.."
				else
				
				
				%>
				<br>
					<font face="Arial" size="2" color="#FF0000"><a title="Soruyu Güncelle!" href="anketadmin.asp?shn=soruguncelle&id=<%=rs("id")%>"><%=rs("soru")%> (+)</a></font><hr style="border: 1px dotted #C0C0C0" size="1">
<%
set rsx = server.createobject("ADODB.recordset")
sql="select * from acevap where sid= "&rs("id")
rsx.open sql,baglantim,1,3
if rsx.eof then
%>
					<span style="font-size: 8pt">Bu Ankete Şık Eklenmemiş..</span> <a href="anketadmin.asp?shn=gekle&id=<%=rs("id")%>">
					<font color="#0000FF">Yeni Ekle!</font></a>

<%
else
while not rsx.eof
a=a+1
%>
<table border="0" width="100%" cellspacing="0" cellpadding="3">
	<tr>
		<td width="118" bgcolor="#FBFBFB" style="border-bottom:1px dotted #808080; border-left-width: 1px; border-top-width: 1px"><font face="Arial" style="font-size: 9pt">Şık <%=a%>: </font> </td>
		<td width="635" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dotted #808080">
		<%=rsx("cevap")%></td>
		<td width="12" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dotted #808080">
		<a title="Bu Şıkkı Güncelle" href="anketadmin.asp?shn=sguncelle&id=<%=rsx("id")%>&sk=<%=a%>">
		<font color="#008000">+</font></a></td>
		<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dotted #808080">
	<a title="Bu Şıkkı Sil!" href="anketadmin.asp?shn=ssil&id=<%=rsx("id")%>"><font color="#FF0000">x</font></td>
	</tr>
</table>

		<%
				rsx.movenext
				wend
				end if 
				%>
		<br>
<font face="Arial" style="font-size: 9pt"><a href="anketadmin.asp?shn=gekle&id=<%=rs("id")%>">Yeni Şık Ekle!</a></font>
 <%end if : end sub 
 sub gekle
 id = request.querystring("id")
				set rs = server.createobject("ADODB.recordset")
				sql="select * from asoru where id="&id&""
				rs.open sql,baglantim,1,3
if rs.eof then
Response.WRite "ID Bulunamyyor..!"
else
%>

<br>
					<font face="Arial" size="2" color="#FF0000">Yeni Şık Ekle</font><hr style="border: 1px dotted #C0C0C0" size="1"><br>
		<i>Eklenecek Anket: </i> <font color="#008000">
		<a href="anketadmin.asp?shn=guncelle&id=<%=rs("id")%>"><%=rs("soru")%></a></font>
		
		<form method="post" action="anketadmin.asp?shn=skeklendi&id=<%=rs("id")%>">
		
		<table border="0" width="100%" cellspacing="0" cellpadding="3">
																				<tr>
																					<td width="30%">Eklenecek Şık</td>
																					<td width="68%"><input type="text" name="cevap"></td>
																				</tr>
																				<tr>
																					<td colspan="2">
																					<p align="center"><input type="submit" value="  Ekle  "></td>
																				</tr>
		  </table>
		</form>
	
<% end if : end sub %>
			<td bgcolor="#FBFBFB" align="center" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-left-style:dotted" valign="top" width="54%">
					<br>
					<font face="Arial" size="2" color="#FF0000">Tüm Anketler</font><hr style="border: 1px dotted #C0C0C0" size="1">
					<%
					set rs = server.createobject("ADODB.recordset")
					sql="select * from asoru order by id desc"
					rs.open sql,baglantim,1,3
					if rs.eof then
					Response.WRite "Anket Eklenmemi?..."
					else
					while not rs.eof
					%>
					<table border="0" width="100%" id="table3" cellspacing="0" cellpadding="2">
						<tr>
							<td width="16" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dashed #C0C0C0">
							<p align="center"><img border="0" src="hg3.gif" width="6" height="6"></td>
							<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dashed #C0C0C0"><font face="Arial" style="font-size: 8pt"><%=rs("soru")%>  
							<font color="#C0C0C0">(<%=rs("tarih")%>)</font></font> </td>
							<td width="16" align="center" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dashed #C0C0C0">
							<font face="Arial" style="font-size: 10pt"><a href="anketadmin.asp?shn=guncelle&id=<%=rs("id")%>" title="Anketi Düzenle">
							<font color="#008000">+</font></a></font></td>
							<td width="18" align="center" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px dashed #C0C0C0">
							<font face="Arial" style="font-size: 10pt"><a href="anketadmin.asp?shn=sil1&id=<%=rs("id")%>" title="Anketi Sil: Adym 1">
							<font color="#FF0000">x</font></a></font></td>
						</tr>
					</table><% rs.movenext
					wend
					end if
					%>			</td>
		</tr>
  </table>
</div>
