PageRenderTime 29ms CodeModel.GetById 0ms RepoModel.GetById 0ms app.codeStats 0ms

/db/admin/store_edit.asp

https://github.com/semious/dynacomcorp
ASP | 242 lines | 232 code | 9 blank | 1 comment | 18 complexity | e3320d1b2fd1476a1bff1e43935c20c1 MD5 | raw file
    

  1. <!--#include file="conn.asp"-->
    2. 

  2. <!--#include file="IsAdmin.asp" -->
    3. 

  3. <html>
    4. 

  4. <head>
    5. 

  5. <title>Edit Store</title>
    6. 

  6. <link rel="stylesheet" href="css/style.css">
    7. 

  7. </head>
    8. 

  8. <body>
    9. 

  9. <%
    10. 

  10. Response.Buffer = True 
    11. 

  11. Response.ExpiresAbsolute = Now() - 1 
    12. 

  12. Response.Expires = 0 
    13. 

  13. Response.CacheControl = no-cache 	
    14. 

  14. 

  15. dim edit,id,sql
    16. 

  16. dim rs
    17. 

  17. dim flag
    18. 

  18. flag=0
    19. 

  19. set rs =server.createobject("adodb.recordset")
    20. 

  20. edit=trim(request("action"))
    21. 

  21. id=trim(cstr(request("id")))
    22. 

  22. 'delete item
    23. 

  23. if edit = "delete" then
    24. 

  24. 	sql = "delete from distributor where id = " & id
    25. 

  25. 	conn.execute sql
    26. 

  26. 	response.Write("<div style='margin:50px 0 0 200px;font-weight:bold;'>This Store has been deleted.</div>")
    27. 

  27. 	response.End()
    28. 

  28. end if
    29. 

  29. 

  30. %> 
    31. 

  31. <script language="javascript">
    32. 

  32. function confirmDel(id,page){
    33. 

  33. if (confirm("Are you sure?")){
    34. 

  34. 	window.location.href = "store_edit.asp?action=delete&id=" + id+ "&page="+page ;
    35. 

  35.   	}
    36. 

  36. }
    37. 

  37. function checkdata() {
    38. 

  38.      if (document.DocForm.name.value.length ==0 ) {
    39. 

  39.        alert("Store should not be left blank!")
    40. 

  40.        document.DocForm.name.focus()
    41. 

  41.        return false;
    42. 

  42.       }
    43. 

  43.      if (document.DocForm.address.value.length ==0) {
    44. 

  44.        alert("address should not be left blank!")
    45. 

  45.        document.DocForm.address.focus()
    46. 

  46.        return false;
    47. 

  47.       }
    48. 

  48.      if (document.DocForm.pic.value.length ==0 ) {
    49. 

  49.        alert("You must have a picture !")
    50. 

  50.        document.DocForm.pic.focus()
    51. 

  51.        return false;
    52. 

  52.       }
    53. 

  53.      if (document.DocForm.tel.value.length ==0) {
    54. 

  54.        alert("telephone number should not be left blank!")
    55. 

  55.        document.DocForm.tel.focus()
    56. 

  56.        return false;
    57. 

  57.       }
    58. 

  58.      if (document.DocForm.zone.value.length ==0) {
    59. 

  59.        alert("zone should not be left blank!")
    60. 

  60.        document.DocForm.zone.focus()
    61. 

  61.        return false;
    62. 

  62.       }
    63. 

  63. 

  64.      return true;
    65. 

  65. }
    66. 

  66. //window.onload = function(){
    67. 

  67. ////	document.forms[0]["des"].value = unescape(document.forms[0]["des"].value);
    68. 

  68. //}
    69. 

  69. </script>
    70. 

  70. <div align="center">
    71. 

  71.     <p><font size="4"><b>Store Information</b></font></p>
    72. 

  72. </div> 
    73. 

  73. 

  74. <div>
    75. 

  75.  <%
    76. 

  76. 	if edit="edit" then
    77. 

  77. 		sql="select * from distributor where id = " & id
    78. 

  78. 	else
    79. 

  79. 		sql="select top 1 * from distributor"
    80. 

  80. 	end if
    81. 

  81. 	rs.open sql,conn,1,3
    82. 

  82. 	
    83. 

  83. 	if rs.eof and rs.bof then
    84. 

  84. 		response.write "No Information"
    85. 

  85. 		response.End()
    86. 

  86. 	else
    87. 

  87. %>
    88. 

  88.       <table border="1px" cellspacing="0" width="754" bordercolor="#000000" cellpadding="0" align="left" style="margin:0 0 0 10px; font-size:14px;">
    89. 

  89.         <tr> 
    90. 

  90.         	<td width="161" align="center" bgcolor="#FEEC85" style="border:1px #000000 solid">
    91. 

  91. 		  		<strong>Store Name</strong>	</td>
    92. 

  92.        	  	<td width="241" align="center" bgcolor="#FEEC85" style="border:1px #000000 solid">
    93. 

  93. 				<strong>Address</strong></td>
    94. 

  94.        	  	<td width="120" align="center" bgcolor="#FEEC85" style="border:1px #000000 solid">
    95. 

  95. 				<b>Telephone</b></td>
    96. 

  96.        	  	<td width="80" align="center" bgcolor="#FEEC85" style="border:1px #000000 solid">
    97. 

  97. 				<b>Zone</b></td>
    98. 

  98.        	  	<td width="40" align="center" bgcolor="#FEEC85" style="border:1px #000000 solid">
    99. 

  99. 				<b>Del</b></td>
    100. 

  100.           	<td width="40" align="center" bgcolor="#FEEC85" style="border:1px #000000 solid">
    101. 

  101. 				<b>View</b></td>
    102. 

  102.         </tr>
    103. 

  103. <%         
    104. 

  104. 	dim curpage,i  
    105. 

  105. 	if request("page")="" then 
    106. 

  106. 		curpage = 1        
    107. 

  107. 	else                        
    108. 

  108. 		curpage = cint(request("page"))         
    109. 

  109. 	end if                                   
    110. 

  110. 		rs.pagesize = 12                 
    111. 

  111. 		rs.absolutepage = curpage         
    112. 

  112. 		for i = 1 to rs.pagesize    
    113. 

  113. %> 
    114. 

  114.         <tr> 
    115. 

  115.           	<td bgcolor="#FFFCD9" style="border:1px #000000 solid"> 
    116. 

  116.             	<p align="center" bgcolor="#E8E8E8"><%=rs("name")%>
    117. 

  117.           	</td>
    118. 

  118.           	<td bgcolor="#FFFCD9" style="border:1px #000000 solid"> 
    119. 

  119.             	<p align="center"><%=rs("address")%>
    120. 

  120.           	</td>
    121. 

  121.           	<td bgcolor="#FFFCD9" style="border:1px #000000 solid"> 
    122. 

  122.             	<p align="center"><%=rs("tel")%>
    123. 

  123.           	</td>
    124. 

  124.           	<td bgcolor="#FFFCD9" style="border:1px #000000 solid"> 
    125. 

  125.             	<p align="center"><%=rs("zone")%>
    126. 

  126.           	</td>
    127. 

  127.           	<td bgcolor="#FFFCD9" style="border:1px #000000 solid"> 
    128. 

  128.             	<p align="center"><a href='javascript:confirmDel(<%= rs("id")%>,<%=cstr(curpage)%>)'>Del</a>
    129. 

  129.        	  	</td>
    130. 

  130.           	<td bgcolor="#FFFCD9" style="border:1px #000000 solid"> 
    131. 

  131.             	<p align="center"><a href="../distributors.asp#<%=rs("name")%>" target="_blank">View</a> 
    132. 

  132.           	</td>
    133. 

  133.         </tr>
    134. 

  134.  
    135. 

  135.       <%
    136. 

  136. 			rs.movenext
    137. 

  137. 			if rs.eof then       
    138. 

  138. 				i = i + 1              
    139. 

  139. 				exit for               
    140. 

  140. 			end if                      
    141. 

  141. 		next
    142. 

  142. %> 
    143. 

  143. 	</table> 
    144. 

  144. </div>
    145. 

  145. <p>
    146. 

  146.   <%                                                           
    147. 

  147. 	rs.close 
    148. 

  148.  end if  
    149. 

  149. 	if edit="edit" then
    150. 

  150. 		set fs=server.createobject("adodb.recordset")
    151. 

  151. 		sql="select * from distributor where id = " & id
    152. 

  152. 		fs.open sql,conn,1,3
    153. 

  153. %>
    154. 

  154. </p>
    155. 

  155. <p>&nbsp;</p>
    156. 

  156. <p>&nbsp;</p>
    157. 

  157. <form onSubmit="return checkdata()" name="DocForm" action="store_add2.asp">
    158. 

  158.     <table border="1" cellspacing="0" width="668" bordercolor="#000000" cellpadding="1" style="margin:0 0 0 20px;font-size:14px;">
    159. 

  159. 		<tr>
    160. 

  160. 			<td width="15%"></td>
    161. 

  161. 			<td width="35%"></td>
    162. 

  162. 			<td width="15%"></td>
    163. 

  163. 			<td width="35%"></td>		
    164. 

  164. 		</tr>
    165. 

  165.       <tr align="center"> 
    166. 

  166.         <td colspan="4" height="20" style="border:1px solid #000000; background-color:FEEC85"> 
    167. 

  167.           <div align="center"><font color="#FF0000"><b>Detail Information</b></font></div> 
    168. 

  168.         </td>
    169. 

  169.       </tr>
    170. 

  170.       <tr align="center"> 
    171. 

  171.         <td width="110" style="border:1px solid #000000"> 
    172. 

  172.           	<div align="right">Store Name:</div>
    173. 

  173.         </td>
    174. 

  174.         <td colspan="3" style="border:1px solid #000000;padding:0 0 0 10px;">
    175. 

  175. 			<div align="left"><input name="name" value="<%=fs("name")%>" size="60" /></div>
    176. 

  176.         </td>
    177. 

  177.       </tr>
    178. 

  178. 	   <tr>
    179. 

  179. 		<td width="94" style="border:1px solid #000000"> 
    180. 

  180.           <div align="right">Address1:</div>
    181. 

  181.         </td>
    182. 

  182.         <td style="border:1 solid #000000;padding:0 0 0 10px;" colspan="3" align="left"> 
    183. 

  183.           	<div align="left"><textarea name="address" cols="60" rows="1"><%=fs("address")%></textarea></div>
    184. 

  184.         </td>
    185. 

  185.       </tr>
    186. 

  186. 	   <tr>
    187. 

  187. 		<td width="94" style="border:1px solid #000000"> 
    188. 

  188.           <div align="right">Address2:</div>
    189. 

  189.         </td>
    190. 

  190.         <td style="border:1 solid #000000;padding:0 0 0 10px;" colspan="3" align="left"> 
    191. 

  191.           	<div align="left"><textarea name="address1" cols="60" rows="1"><%=fs("address1")%></textarea></div>
    192. 

  192.         </td>
    193. 

  193.       </tr>
    194. 

  194. 	   <tr>
    195. 

  195. 		<td width="94" style="border:1px solid #000000"> 
    196. 

  196.           <div align="right">Address3:</div>
    197. 

  197.         </td>
    198. 

  198.         <td style="border:1 solid #000000;padding:0 0 0 10px;" colspan="3" align="left"> 
    199. 

  199.           	<div align="left"><textarea name="address2" cols="60" rows="1"><%=fs("address2")%></textarea></div>
    200. 

  200.         </td>
    201. 

  201.       </tr>
    202. 

  202.       <tr> 
    203. 

  203. 		<td width="110" style="border:1px solid #000000"> 
    204. 

  204. 			  <div align="right">Picture:</div>
    205. 

  205. 		</td>
    206. 

  206.         <td width="210" style="border:1px solid #000000;padding:0 0 0 10px;"> 
    207. 

  207.           	<div align="left"><input name="pic" value="<%=fs("pic")%>" size="20" /></div>
    208. 

  208.         </td>
    209. 

  209.         <td width="94" style="border:1px solid #000000"> 
    210. 

  210.           <div align="right">Telephone:</div>
    211. 

  211.         </td>
    212. 

  212.         <td width="244" style="border:1px solid #000000;padding:0 0 0 10px;"> 
    213. 

  213.           <div align="left"><input name="tel" value="<%=fs("tel")%>" size="20" /></div>
    214. 

  214.         </td>
    215. 

  215.       </tr>
    216. 

  216.       <tr> 
    217. 

  217.         <td width="110" style="border:1px solid #000000"> 
    218. 

  218.           <div align="right">Zone:</div>
    219. 

  219.         </td>
    220. 

  220.         <td width="210" style="border:1px solid #000000;padding:0 0 0 10px;" colspan="3"> 
    221. 

  221.           <div align="left"><input name="zone" value="<%=fs("zone")%>" size="20" />&nbsp;</div>
    222. 

  222.         </td>
    223. 

  223.       </tr>
    224. 

  224.       <tr> 
    225. 

  225.         <td colspan="4" width="664" style="border:1px solid #000000;padding:0 0 0 10px;"> 
    226. 

  226.           <div align="center"> 
    227. 

  227.             <input type="hidden" name="action" value="editsave">
    228. 

  228.             <input type="hidden" name="id" value=<%=id%>>
    229. 

  229.             <input type="hidden" name="page" value="<%=curpage%>">
    230. 

  230.             <input type="submit" name="Submit" value=" Done">
    231. 

  231.           </div>
    232. 

  232.         </td>
    233. 

  233.       </tr>
    234. 

  234.     </table>
    235. 

  235. </form>
    236. 

  236. 	
    237. 

  237. </div> 
    238. 

  238.  
    239. 

  239. <%end if%>
    240. 

  240. 

  241. </body>
    242. 

  242. </html>
    243.