API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 15th, 2016
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.59 KB | None | 0 0
raw download clone embed print report
  1. <%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" %>
  2. <%@ Import Namespace="System.Data.SqlClient" %>
  3. <script runat="server">
  4. string note = "";
  5. bool IsExists(string name)
  6. {
  7.  
  8. bool flag = false;
  9. string connString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
  10. SqlConnection conn = new SqlConnection(connString);
  11. string cmdString = string.Format("SELECT * FROM myTable WHERE (UserName = N'{0}')", name);
  12. SqlCommand cmd = new SqlCommand(cmdString, conn);
  13. conn.Open();
  14. SqlDataReader dr = cmd.ExecuteReader();
  15. if (dr.HasRows)
  16. flag = true;
  17. conn.Close();
  18. return flag;
  19. }
  20. protected void Page_Load(object sender, EventArgs e)
  21. {
  22. if (Request.Form["sub"] != null)
  23. {
  24. string userName = Request.Form["txtUser"];
  25. if (IsExists(userName))
  26. {
  27. note = "שם משתמש זה כבר תפוס ! אנא הכנס שם משתמש אחר";
  28. }
  29. else
  30. {
  31. string user = Request.Form["txtUser"].ToString();
  32. string pass = Request.Form["txtPass"].ToString();
  33. string email = Request.Form["txtMail"].ToString();
  34. string year = Request.Form["yearBirth"].ToString();
  35. string month = Request.Form["monthBirth"].ToString();
  36. string day = Request.Form["dayBirth"].ToString();
  37. string mail = Request.Form["txtMail"].ToString();
  38. string city = Request.Form["city"].ToString();
  39. string shop = Request.Form["Shop"].ToString();
  40. string outfit = Request.Form["outfit"].ToString();
  41. string fashionItem = Request.Form["fashionItem"].ToString();
  42. string shopVisit = Request.Form["shopVisit"].ToString();
  43. string Love = Request.Form["Love"].ToString();
  44. string conStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
  45. string cmdStr = string.Format("INSERT INTO myTable(username, password, email, yearB, monthB, dayB, cityAddress, favShop, favOutfit, favFashionItem, ShopVisit, Love, Notes) VALUES (N'{0}', N'{1}', N'{2}', N'{3}', N'{4}', N'{5}', N'{6}', N'{7}', N'{8}', N'{9}', N'{10}', N'{11}', N'{12}')", user, pass, email, year, month, day, city, shop, outfit, fashionItem, shopVisit, Love, Request.Form["notes"].ToString());
  46. SqlConnection conObject = new SqlConnection(conStr);
  47. conObject.Open();
  48. SqlCommand cmdObject = new SqlCommand(cmdStr, conObject);
  49. cmdObject.ExecuteNonQuery();
  50. conObject.Close();
  51. }
  52. }
  53. }
  54.  
  55. </script>
  56.  
  57. <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  58. <script type="text/javascript">
  59. function username() {
  60. if (document.getElementById("txtUser").value == "") {
  61. document.getElementById("user").innerHTML = "הכנס שם משתמש";
  62. return false;
  63. }
  64.  
  65. document.getElementById("user").innerHTML = "";
  66. return true;
  67. }
  68. function password() {
  69. if (document.getElementById("txtPass").value == "") {
  70. document.getElementById("pass").innerHTML = "הכנס סיסמא";
  71. return false;
  72. }
  73. document.getElementById("pass").innerHTML = "";
  74. return true;
  75. }
  76. function passConfirmation() {
  77. if (document.getElementById("txtPassConfirm").value == "") {
  78. document.getElementById("passConfirm").innerHTML = "הכנס אימות סיסמא";
  79. return false;
  80. }
  81. document.getElementById("passConfirm").innerHTML = "";
  82. return true;
  83. }
  84. function passSimilar() {
  85. if (document.getElementById("txtPassConfirm").value == document.getElementById("txtPass").value) {
  86. document.getElementById("passConfirm").innerHTML = "";
  87. return true;
  88. }
  89. document.getElementById("passConfirm").innerHTML = "הסיסמאות אינן זהות";
  90. return false;
  91. }
  92. function year() {
  93. if (document.getElementById("yearSelect").selectedIndex == 0) {
  94. document.getElementById("yearCheck").innerHTML = "בחר שנת לידה";
  95. return false;
  96. }
  97. document.getElementById("yearCheck").innerHTML = "";
  98. return true;
  99. }
  100. function month() {
  101. if (document.getElementById("monthSelect").selectedIndex == 0) {
  102. document.getElementById("monthCheck").innerHTML = "בחר חודש";
  103. return false;
  104. }
  105. document.getElementById("monthCheck").innerHTML = "";
  106. return true;
  107. }
  108. function day() {
  109. if (document.getElementById("daySelect").selectedIndex == 0) {
  110. document.getElementById("dayCheck").innerHTML = "בחר יום";
  111. return false;
  112. }
  113. document.getElementById("dayCheck").innerHTML = "";
  114. return true;
  115. }
  116.  
  117. function email() {
  118. var check = document.getElementById("txtMail").value;
  119. for (var i = 0; i < check.length; i++) {
  120. if (check.charAt(i) == "@" && check.charAt(0) != "@" && check.indexOf("@") == check.lastIndexOf("@") && check.indexOf(".") > check.indexOf("@") && check.charAt((check.length) - 1) != ".") {
  121. document.getElementById("mailCheck").innerHTML = "";
  122. return true;
  123. }
  124. }
  125. document.getElementById("mailCheck").innerHTML = "אימייל לא תקין";
  126. return false;
  127. }
  128. function city() {
  129. if (document.getElementById("citySelect").selectedIndex == 0) {
  130. document.getElementById("cityCheck").innerHTML = "בחר עיר";
  131. return false;
  132. }
  133. document.getElementById("cityCheck").innerHTML = "";
  134. return true;
  135. }
  136. function shops() {
  137. if (document.getElementById("Shop").value == "") {
  138. document.getElementById("favShop").innerHTML = "לא בחרת חנות מועדפת";
  139. return false;
  140. }
  141. document.getElementById("favShop").innerHTML = "";
  142. return true;
  143. }
  144. function outfit() {
  145. if (document.getElementById("outfitSelect").selectedIndex == 0) {
  146. document.getElementById("favOutfit").innerHTML = "לא בחרת פריט לבוש מועדף";
  147. return false;
  148. }
  149. document.getElementById("favOutfit").innerHTML = "";
  150. return true;
  151. }
  152. function item() {
  153. if (document.getElementById("fashionItemSelect").selectedIndex == 0) {
  154. document.getElementById("favFashionItem").innerHTML = "לא בחרת אביזר אופנה מועדף";
  155. return false;
  156. }
  157. document.getElementById("favFashionItem").innerHTML = "";
  158. return true;
  159. }
  160. function shopV() {
  161. if (document.getElementById("shopVisit").selectedIndex == 0) {
  162. document.getElementById("checkShopVisit").innerHTML = "לא בחרת";
  163. return false;
  164. }
  165. document.getElementById("checkShopVisit").innerHTML = "";
  166. return true;
  167. }
  168. function loveYesNO() {
  169. if (document.getElementById("yesLove").checked == true || document.getElementById("noLove").checked) {
  170. document.getElementById("shopsLike").innerHTML = "תודה על בחירתך";
  171. return true;
  172. }
  173. document.getElementById("shopsLike").innerHTML = "בחר בבקשה";
  174. return false;
  175. }
  176. function page() {
  177. a = username();
  178. b = password();
  179. c = passSimilar();
  180. d = passConfirmation();
  181. e = year();
  182. f = month();
  183. g = day();
  184. h = email();
  185. i = city();
  186. j = shops();
  187. k = outfit();
  188. l = item();
  189. m = shopV();
  190. n = loveYesNO();
  191. if (a == true && b == true && c == true && d == true && e == true && f == true && g == true && h == true && i == true && j == true && k == true && l == true && m == true && n == true) {
  192. return true;
  193. }
  194. return false;
  195.  
  196. }
  197.  
  198.  
  199. </script>
  200.  
  201. <form method="post" action="Register.aspx" dir="rtl" onsubmit="return page()" ><center>
  202. <table width="550">
  203. <tr align="center">
  204. <td colspan="2"><h1>הרשמה</h1><br /><br />
  205.  
  206. </td>
  207. </tr>
  208.  
  209. <tr>
  210. <td>שם משתמש:</td>
  211. <td><input type="text" id="txtUser" name="txtUser" /></td>
  212. <td id="user"></td>
  213. </tr>
  214.  
  215. <tr>
  216. <td>סיסמא:</td>
  217. <td><input type="password" id="txtPass" name="txtPass" /></td>
  218. <td id="pass"></td>
  219. </tr>
  220.  
  221. <tr>
  222. <td>אימות סיסמא:</td>
  223. <td><input type="password" id="txtPassConfirm" name="txtPassConfirm"/></td>
  224. <td id="passConfirm"></td>
  225. </tr>
  226.  
  227. <tr>
  228. <td>שנת לידה</td>
  229. <td><select id="yearSelect" name="yearBirth">
  230. <option>בחר שנת לידה</option>
  231. <option>1960</option>
  232. <option>1961</option>
  233. <option>1962</option>
  234. <option>1963</option>
  235. <option>1964</option>
  236. <option>1965</option>
  237. <option>1966</option>
  238. <option>1967</option>
  239. <option>1968</option>
  240. <option>1969</option>
  241. <option>1970</option>
  242. <option>1971</option>
  243. <option>1972</option>
  244. <option>1973</option>
  245. <option>1974</option>
  246. <option>1975</option>
  247. <option>1976</option>
  248. <option>1977</option>
  249. <option>1978</option>
  250. <option>1979</option>
  251. <option>1980</option>
  252. <option>1981</option>
  253. <option>1982</option>
  254. <option>1983</option>
  255. <option>1984</option>
  256. <option>1985</option>
  257. <option>1986</option>
  258. <option>1987</option>
  259. <option>1988</option>
  260. <option>1989</option>
  261. <option>1990</option>
  262. <option>1991</option>
  263. <option>1992</option>
  264. <option>1993</option>
  265. <option>1994</option>
  266. <option>1995</option>
  267. <option>1996</option>
  268. <option>1997</option>
  269. <option>1998</option>
  270. <option>1999</option>
  271. <option>2000</option>
  272. <option>2001</option>
  273. <option>2002</option>
  274. <option>2003</option>
  275. <option>2004</option>
  276. <option>2005</option>
  277. <option>2006</option>
  278. <option>2007</option>
  279. <option>2008</option>
  280. <option>2009</option>
  281. <option>2010</option>
  282. <option>2011</option>
  283. <option>2012</option>
  284. <option>2013</option>
  285. <option>2014</option>
  286. <option>2015</option>
  287. <option>2016</option>
  288. </select></td>
  289. <td id="yearCheck"></td>
  290. </tr>
  291. <tr>
  292. <td>חודש</td>
  293. <td><select id="monthSelect" name="monthBirth">
  294. <option>בחר חודש</option>
  295. <option>1</option>
  296. <option>2</option>
  297. <option>3</option>
  298. <option>4</option>
  299. <option>5</option>
  300. <option>6</option>
  301. <option>7</option>
  302. <option>8</option>
  303. <option>9</option>
  304. <option>10</option>
  305. <option>11</option>
  306. <option>12</option>
  307.  
  308. </select></td>
  309. <td id="monthCheck"></td>
  310. </tr>
  311. <tr>
  312. <td>יום</td>
  313. <td><select id="daySelect" name="dayBirth">
  314. <option>בחר יום</option>
  315. <option>1</option>
  316. <option>2</option>
  317. <option>3</option>
  318. <option>4</option>
  319. <option>5</option>
  320. <option>6</option>
  321. <option>7</option>
  322. <option>8</option>
  323. <option>9</option>
  324. <option>10</option>
  325. <option>11</option>
  326. <option>12</option>
  327. <option>13</option>
  328. <option>14</option>
  329. <option>15</option>
  330. <option>16</option>
  331. <option>17</option>
  332. <option>18</option>
  333. <option>19</option>
  334. <option>20</option>
  335. <option>21</option>
  336. <option>22</option>
  337. <option>23</option>
  338. <option>24</option>
  339. <option>25</option>
  340. <option>26</option>
  341. <option>27</option>
  342. <option>28</option>
  343. <option>29</option>
  344. <option>30</option>
  345.  
  346. </select></td>
  347. <td id="dayCheck"></td>
  348. </tr>
  349. <tr>
  350. <td>אימייל:</td>
  351. <td><input type="text" id="txtMail" name="txtMail"/></td>
  352. <td id="mailCheck"></td>
  353. </tr>
  354.  
  355.  
  356. <tr>
  357. <td>עיר:</td>
  358. <td><select id="citySelect" name="city">
  359. <option>בחר עיר</option>
  360. <option>תל אביב</option>
  361. <option>חולון</option>
  362. <option>רעננה</option>
  363. <option>חיפה</option>
  364. <option>ראשלצ</option>
  365. <option>ירושלים</option>
  366. <option>בת ים</option>
  367. <option>נתניה</option>
  368. <option>אשדוד</option>
  369. <option>אשקלון</option>
  370. <option>טבריה</option>
  371. <option>אחר</option>
  372.  
  373. </select></td>
  374. <td id="cityCheck"></td>
  375. </tr>
  376.  
  377. <tr>
  378. <td>
  379. חנות בגדים מועדפת:
  380. </td>
  381. <td>
  382. <input type="text" id="Shop" name="Shop"/>
  383. </td>
  384. <td id="favShop"></td>
  385. </tr>
  386. <tr>
  387. <td>פריט לבוש אהוב : </td>
  388. <td><select id="outfitSelect" name="outfit" >
  389. <option>בחר פריט לבוש אהוב</option>
  390. <option>חולצה</option>
  391. <option>מכנס</option>
  392. <option>חצאית</option>
  393. <option>שמלה</option>
  394. <option>ג'קט</option>
  395. <option>נעליים</option>
  396. <option>אחר</option>
  397.  
  398. </select></td>
  399. <td id="favOutfit"></td>
  400. </tr>
  401. <tr>
  402. <td>אביזר אופנה מועדף : </td>
  403. <td><select id="fashionItemSelect" name="fashionItem">
  404. <option>בחר אביזר אופנה מועדף</option>
  405. <option>תיק</option>
  406. <option>צעיף</option>
  407. <option>כובע</option>
  408. <option>טבעת</option>
  409. <option>צמיד</option>
  410. <option>שרשרת</option>
  411. <option>שעון</option>
  412. <option>אחר</option>
  413.  
  414. </select></td>
  415. <td id="favFashionItem"></td>
  416. </tr>
  417.  
  418. <tr>
  419. <td>בכמה חנויות בגדים היית בשבוע האחרון(בערך) ?</td>
  420. <td><select id="shopVisit" name="shopVisit">
  421. <option>בחר</option>
  422. <option>0</option>
  423. <option>1</option>
  424. <option>2</option>
  425. <option>3</option>
  426. <option>4</option>
  427. <option>5</option>
  428. <option>6</option>
  429. <option>7</option>
  430. <option>8</option>
  431. <option>9</option>
  432. <option>יותר</option>
  433.  
  434. </select></td>
  435. <td id="checkShopVisit"></td>
  436. </tr>
  437.  
  438. <tr>
  439. <td>האם אתה אוהב את החנויות שמפורסמות באתר זה ?</td>
  440. <td>
  441. כן<input type="radio" id="yesLove" name="Love" value="yes"/> &nbsp;&nbsp;
  442. לא<input type="radio" id="noLove" name="Love" value="no"/>
  443. </td>
  444. <td id="shopsLike"></td>
  445. </tr>
  446. <tr>
  447. <td>הערות על האתר</td>
  448. <td><textarea id="area" name="notes" rows="5" cols="25"></textarea></td>
  449. </tr>
  450. <tr align="center">
  451. <td colspan="2"><input name="sub" type="submit" id="send" value="שלח"/>&nbsp;&nbsp;<input type="reset" id="reset" /></td>
  452. </tr>
  453. <tr>
  454. <td colspan="2"><%=note %></td>
  455. </tr>
  456. </table>
  457. </center>
  458. </form>
  459.  
  460. </asp:Content>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!