API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2016
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 118.03 KB | None | 0 0
raw download clone embed print report
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using MySql.Data.MySqlClient;
  8. using System.Data;
  9.  
  10. public partial class _Default : System.Web.UI.Page
  11. {
  12. MySqlConnection con = new MySqlConnection("server=localhost;database=luckylips;uid=root;password=''");
  13. static MySqlDataReader dr;
  14. bool admin;
  15.  
  16.  
  17. String[] mndnavn = { "Error", "Januar", "Februar", "Mars", "April", "Mai", "Juni", "Juli", "August", "September", "Oktober", "Novemberl", "Desember" };
  18. string[] farger = { "#1abc9c", "#2ecc71", "#3498db", "#9b59b6", "#34495e" };
  19.  
  20.  
  21. int smnd_id;
  22. int smndstart;
  23.  
  24. string s1_1;
  25. string s1_2;
  26. string s2_1;
  27. string s2_2;
  28. string s3_1;
  29. string s3_2;
  30. string s4_1;
  31. string s4_2;
  32. string s5_1;
  33. string s5_2;
  34. string s6_1;
  35. string s6_2;
  36. string s7_1;
  37. string s7_2;
  38. string s8_1;
  39. string s8_2;
  40. string s9_1;
  41. string s9_2;
  42. string s10_1;
  43. string s10_2;
  44. string s11_1;
  45. string s11_2;
  46. string s12_1;
  47. string s12_2;
  48. string s13_1;
  49. string s13_2;
  50. string s14_1;
  51. string s14_2;
  52. string s15_1;
  53. string s15_2;
  54. string s16_1;
  55. string s16_2;
  56. string s17_1;
  57. string s17_2;
  58. string s18_1;
  59. string s18_2;
  60. string s19_1;
  61. string s19_2;
  62. string s20_1;
  63. string s20_2;
  64. string s21_1;
  65. string s21_2;
  66. string s22_1;
  67. string s22_2;
  68. string s23_1;
  69. string s23_2;
  70. string s24_1;
  71. string s24_2;
  72. string s25_1;
  73. string s25_2;
  74. string s26_1;
  75. string s26_2;
  76. string s27_1;
  77. string s27_2;
  78. string s28_1;
  79. string s28_2;
  80. string s29_1;
  81. string s29_2;
  82. string s30_1;
  83. string s30_2;
  84. string s31_1;
  85. string s31_2;
  86.  
  87.  
  88.  
  89. protected void Page_Load(object sender, EventArgs e)
  90. {
  91.  
  92. DateTime now = DateTime.Now;
  93. int currentmonth = now.Month;
  94. int currentday = now.Day;
  95. int currentyear = now.Year;
  96. getcalendar();
  97.  
  98. string mndid = currentmonth.ToString() + currentyear.ToString();
  99.  
  100. lbl_info.Text = mndnavn[currentmonth] + " " + currentyear.ToString();
  101.  
  102.  
  103. //Setter bruker
  104. string username = "sahar";
  105.  
  106. //Sjekker om brukeren er admin og setter admin accordingly
  107. con.Open();
  108. MySqlCommand cmd = con.CreateCommand();
  109. cmd.CommandType = CommandType.Text;
  110. cmd.CommandText = "SELECT admin FROM Ansatte WHERE Navn='" + username + "';";
  111. dr = cmd.ExecuteReader();
  112. dr.Read();
  113. if (dr[0].ToString() == "1")
  114. {
  115. admin = true;
  116. }
  117. else
  118. {
  119. admin = false;
  120. }
  121. con.Close();
  122.  
  123. //Markerer hvilken dag som er i dag
  124. if (smndstart == 0)
  125. {
  126. if (currentday == Convert.ToInt32(date_spot0.Text))
  127. {
  128. spot0.Attributes.Add("style", "border: solid; border-color: #2c3e50; background-color: #bdc3c7;");
  129. }
  130. }
  131. else if (smndstart >= 1)
  132. {
  133. if (currentday == Convert.ToInt32(date_spot1.Text))
  134. {
  135. spot1.Attributes.Add("style", "border: solid; border-color: #2c3e50; background-color: #bdc3c7;");
  136. }
  137. }
  138. else
  139. {
  140.  
  141. }
  142.  
  143.  
  144. //Legger til ansatte i drop down listene
  145. con.Open();
  146. var query = "SELECT Navn FROM Ansatte";
  147. using (var command = new MySqlCommand(query, con))
  148. {
  149. using (var reader = command.ExecuteReader())
  150. {
  151. //Iterate through the rows and add it to the combobox's items
  152. while (reader.Read())
  153. {
  154. ddl_spot0_0.Items.Add(reader.GetString("Navn"));
  155. ddl_spot0_1.Items.Add(reader.GetString("Navn"));
  156. ddl_spot1_0.Items.Add(reader.GetString("Navn"));
  157. ddl_spot1_1.Items.Add(reader.GetString("Navn"));
  158. ddl_spot2_0.Items.Add(reader.GetString("Navn"));
  159. ddl_spot2_1.Items.Add(reader.GetString("Navn"));
  160. ddl_spot3_0.Items.Add(reader.GetString("Navn"));
  161. ddl_spot3_1.Items.Add(reader.GetString("Navn"));
  162. ddl_spot4_0.Items.Add(reader.GetString("Navn"));
  163. ddl_spot4_1.Items.Add(reader.GetString("Navn"));
  164. ddl_spot5_0.Items.Add(reader.GetString("Navn"));
  165. ddl_spot5_1.Items.Add(reader.GetString("Navn"));
  166. ddl_spot6_0.Items.Add(reader.GetString("Navn"));
  167. ddl_spot6_1.Items.Add(reader.GetString("Navn"));
  168. ddl_spot7_0.Items.Add(reader.GetString("Navn"));
  169. ddl_spot7_1.Items.Add(reader.GetString("Navn"));
  170. ddl_spot8_0.Items.Add(reader.GetString("Navn"));
  171. ddl_spot8_1.Items.Add(reader.GetString("Navn"));
  172. ddl_spot9_0.Items.Add(reader.GetString("Navn"));
  173. ddl_spot9_1.Items.Add(reader.GetString("Navn"));
  174. ddl_spot10_0.Items.Add(reader.GetString("Navn"));
  175. ddl_spot10_1.Items.Add(reader.GetString("Navn"));
  176. ddl_spot11_0.Items.Add(reader.GetString("Navn"));
  177. ddl_spot11_1.Items.Add(reader.GetString("Navn"));
  178. ddl_spot12_0.Items.Add(reader.GetString("Navn"));
  179. ddl_spot12_1.Items.Add(reader.GetString("Navn"));
  180. ddl_spot13_0.Items.Add(reader.GetString("Navn"));
  181. ddl_spot13_1.Items.Add(reader.GetString("Navn"));
  182. ddl_spot14_0.Items.Add(reader.GetString("Navn"));
  183. ddl_spot14_1.Items.Add(reader.GetString("Navn"));
  184. ddl_spot15_0.Items.Add(reader.GetString("Navn"));
  185. ddl_spot15_1.Items.Add(reader.GetString("Navn"));
  186. ddl_spot16_0.Items.Add(reader.GetString("Navn"));
  187. ddl_spot16_1.Items.Add(reader.GetString("Navn"));
  188. ddl_spot17_0.Items.Add(reader.GetString("Navn"));
  189. ddl_spot17_1.Items.Add(reader.GetString("Navn"));
  190. ddl_spot18_0.Items.Add(reader.GetString("Navn"));
  191. ddl_spot18_1.Items.Add(reader.GetString("Navn"));
  192. ddl_spot19_0.Items.Add(reader.GetString("Navn"));
  193. ddl_spot19_1.Items.Add(reader.GetString("Navn"));
  194. ddl_spot20_0.Items.Add(reader.GetString("Navn"));
  195. ddl_spot20_1.Items.Add(reader.GetString("Navn"));
  196. ddl_spot21_0.Items.Add(reader.GetString("Navn"));
  197. ddl_spot21_1.Items.Add(reader.GetString("Navn"));
  198. ddl_spot22_0.Items.Add(reader.GetString("Navn"));
  199. ddl_spot22_1.Items.Add(reader.GetString("Navn"));
  200. ddl_spot23_0.Items.Add(reader.GetString("Navn"));
  201. ddl_spot23_1.Items.Add(reader.GetString("Navn"));
  202. ddl_spot24_0.Items.Add(reader.GetString("Navn"));
  203. ddl_spot24_1.Items.Add(reader.GetString("Navn"));
  204. ddl_spot25_0.Items.Add(reader.GetString("Navn"));
  205. ddl_spot25_1.Items.Add(reader.GetString("Navn"));
  206. ddl_spot26_0.Items.Add(reader.GetString("Navn"));
  207. ddl_spot26_1.Items.Add(reader.GetString("Navn"));
  208. ddl_spot27_0.Items.Add(reader.GetString("Navn"));
  209. ddl_spot27_1.Items.Add(reader.GetString("Navn"));
  210. ddl_spot28_0.Items.Add(reader.GetString("Navn"));
  211. ddl_spot28_1.Items.Add(reader.GetString("Navn"));
  212. ddl_spot29_0.Items.Add(reader.GetString("Navn"));
  213. ddl_spot29_1.Items.Add(reader.GetString("Navn"));
  214. ddl_spot30_0.Items.Add(reader.GetString("Navn"));
  215. ddl_spot30_1.Items.Add(reader.GetString("Navn"));
  216.  
  217. }
  218. }
  219. }
  220. con.Close();
  221.  
  222. if (admin == true)
  223. {
  224. if (spot0_0.Text == "" && smndstart == 0)
  225. {
  226. ddl_spot0_0.Visible = true;
  227. btn_spot0_0.Visible = true;
  228. }
  229. else if (smndstart == 0)
  230. {
  231. btn_removespot0_0.Visible = true;
  232. }
  233.  
  234. if (spot0_1.Text == "")
  235. {
  236. ddl_spot0_1.Visible = true;
  237. btn_spot0_1.Visible = true;
  238. }
  239. else
  240. {
  241. btn_removespot0_1.Visible = true;
  242. }
  243.  
  244. if (spot1_0.Text == "")
  245. {
  246. ddl_spot1_0.Visible = true;
  247. btn_spot1_0.Visible = true;
  248. }
  249. else
  250. {
  251. btn_removespot1_0.Visible = true;
  252. }
  253.  
  254. if (spot1_1.Text == "")
  255. {
  256. ddl_spot1_1.Visible = true;
  257. btn_spot1_1.Visible = true;
  258. }
  259. else
  260. {
  261. btn_removespot1_1.Visible = true;
  262. }
  263. if (spot2_0.Text == "")
  264. {
  265. ddl_spot2_0.Visible = true;
  266. btn_spot2_0.Visible = true;
  267. }
  268. else
  269. {
  270. btn_removespot2_0.Visible = true;
  271. }
  272. if (spot2_1.Text == "")
  273. {
  274. ddl_spot2_1.Visible = true;
  275. btn_spot2_1.Visible = true;
  276. }
  277. else
  278. {
  279. btn_removespot2_1.Visible = true;
  280. }
  281. if (spot3_0.Text == "")
  282. {
  283. ddl_spot3_0.Visible = true;
  284. btn_spot3_0.Visible = true;
  285. }
  286. else
  287. {
  288. btn_removespot3_0.Visible = true;
  289. }
  290. if (spot3_1.Text == "")
  291. {
  292. ddl_spot3_1.Visible = true;
  293. btn_spot3_1.Visible = true;
  294. }
  295. else
  296. {
  297. btn_removespot3_1.Visible = true;
  298. }
  299. if (spot4_0.Text == "")
  300. {
  301. ddl_spot4_0.Visible = true;
  302. btn_spot4_0.Visible = true;
  303. }
  304. else
  305. {
  306. btn_removespot4_0.Visible = true;
  307. }
  308. if (spot4_1.Text == "")
  309. {
  310. ddl_spot4_1.Visible = true;
  311. btn_spot4_1.Visible = true;
  312. }
  313. else
  314. {
  315. btn_removespot4_1.Visible = true;
  316. }
  317. if (spot5_0.Text == "")
  318. {
  319. ddl_spot5_0.Visible = true;
  320. btn_spot5_0.Visible = true;
  321. }
  322. else
  323. {
  324. btn_removespot5_0.Visible = true;
  325. }
  326. if (spot5_1.Text == "")
  327. {
  328. ddl_spot5_1.Visible = true;
  329. btn_spot5_1.Visible = true;
  330. }
  331. else
  332. {
  333. btn_removespot5_1.Visible = true;
  334. }
  335. if (spot6_0.Text == "")
  336. {
  337. ddl_spot6_0.Visible = true;
  338. btn_spot6_0.Visible = true;
  339. }
  340. else
  341. {
  342. btn_removespot6_0.Visible = true;
  343. }
  344. if (spot6_1.Text == "")
  345. {
  346. ddl_spot6_1.Visible = true;
  347. btn_spot6_1.Visible = true;
  348. }
  349. else
  350. {
  351. btn_removespot6_1.Visible = true;
  352. }
  353. if (spot7_0.Text == "")
  354. {
  355. ddl_spot7_0.Visible = true;
  356. btn_spot7_0.Visible = true;
  357. }
  358. else
  359. {
  360. btn_removespot7_0.Visible = true;
  361. }
  362. if (spot7_1.Text == "")
  363. {
  364. ddl_spot7_1.Visible = true;
  365. btn_spot7_1.Visible = true;
  366. }
  367. else
  368. {
  369. btn_removespot7_1.Visible = true;
  370. }
  371. if (spot8_0.Text == "")
  372. {
  373. ddl_spot8_0.Visible = true;
  374. btn_spot8_0.Visible = true;
  375. }
  376. else
  377. {
  378. btn_removespot8_0.Visible = true;
  379. }
  380. if (spot8_1.Text == "")
  381. {
  382. ddl_spot8_1.Visible = true;
  383. btn_spot8_1.Visible = true;
  384. }
  385. else
  386. {
  387. btn_removespot8_1.Visible = true;
  388. }
  389. if (spot9_0.Text == "")
  390. {
  391. ddl_spot9_0.Visible = true;
  392. btn_spot9_0.Visible = true;
  393. }
  394. else
  395. {
  396. btn_removespot9_0.Visible = true;
  397. }
  398. if (spot9_1.Text == "")
  399. {
  400. ddl_spot9_1.Visible = true;
  401. btn_spot9_1.Visible = true;
  402. }
  403. else
  404. {
  405. btn_removespot9_1.Visible = true;
  406. }
  407. if (spot10_0.Text == "")
  408. {
  409. ddl_spot10_0.Visible = true;
  410. btn_spot10_0.Visible = true;
  411. }
  412. else
  413. {
  414. btn_removespot10_0.Visible = true;
  415. }
  416. if (spot10_1.Text == "")
  417. {
  418. ddl_spot10_1.Visible = true;
  419. btn_spot10_1.Visible = true;
  420. }
  421. else
  422. {
  423. btn_removespot10_1.Visible = true;
  424. }
  425. if (spot11_0.Text == "")
  426. {
  427. ddl_spot11_0.Visible = true;
  428. btn_spot11_0.Visible = true;
  429. }
  430. else
  431. {
  432. btn_removespot11_0.Visible = true;
  433. }
  434. if (spot11_1.Text == "")
  435. {
  436. ddl_spot11_1.Visible = true;
  437. btn_spot11_1.Visible = true;
  438. }
  439. else
  440. {
  441. btn_removespot11_1.Visible = true;
  442. }
  443. if (spot12_0.Text == "")
  444. {
  445. ddl_spot12_0.Visible = true;
  446. btn_spot12_0.Visible = true;
  447. }
  448. else
  449. {
  450. btn_removespot12_0.Visible = true;
  451. }
  452. if (spot12_1.Text == "")
  453. {
  454. ddl_spot12_1.Visible = true;
  455. btn_spot12_1.Visible = true;
  456. }
  457. else
  458. {
  459. btn_removespot12_1.Visible = true;
  460. }
  461. if (spot13_0.Text == "")
  462. {
  463. ddl_spot13_0.Visible = true;
  464. btn_spot13_0.Visible = true;
  465. }
  466. else
  467. {
  468. btn_removespot13_0.Visible = true;
  469. }
  470. if (spot13_1.Text == "")
  471. {
  472. ddl_spot13_1.Visible = true;
  473. btn_spot13_1.Visible = true;
  474. }
  475. else
  476. {
  477. btn_removespot13_1.Visible = true;
  478. }
  479. if (spot14_0.Text == "")
  480. {
  481. ddl_spot14_0.Visible = true;
  482. btn_spot14_0.Visible = true;
  483. }
  484. else
  485. {
  486. btn_removespot14_0.Visible = true;
  487. }
  488. if (spot14_1.Text == "")
  489. {
  490. ddl_spot14_1.Visible = true;
  491. btn_spot14_1.Visible = true;
  492. }
  493. else
  494. {
  495. btn_removespot14_1.Visible = true;
  496. }
  497. if (spot15_0.Text == "")
  498. {
  499. ddl_spot15_0.Visible = true;
  500. btn_spot15_0.Visible = true;
  501. }
  502. else
  503. {
  504. btn_removespot15_0.Visible = true;
  505. }
  506. if (spot15_1.Text == "")
  507. {
  508. ddl_spot15_1.Visible = true;
  509. btn_spot15_1.Visible = true;
  510. }
  511. else
  512. {
  513. btn_removespot15_1.Visible = true;
  514. }
  515. if (spot16_0.Text == "")
  516. {
  517. ddl_spot16_0.Visible = true;
  518. btn_spot16_0.Visible = true;
  519. }
  520. else
  521. {
  522. btn_removespot16_0.Visible = true;
  523. }
  524. if (spot16_1.Text == "")
  525. {
  526. ddl_spot16_1.Visible = true;
  527. btn_spot16_1.Visible = true;
  528. }
  529. else
  530. {
  531. btn_removespot16_1.Visible = true;
  532. }
  533. if (spot17_0.Text == "")
  534. {
  535. ddl_spot17_0.Visible = true;
  536. btn_spot17_0.Visible = true;
  537. }
  538. else
  539. {
  540. btn_removespot17_0.Visible = true;
  541. }
  542. if (spot17_1.Text == "")
  543. {
  544. ddl_spot17_1.Visible = true;
  545. btn_spot17_1.Visible = true;
  546. }
  547. else
  548. {
  549. btn_removespot17_1.Visible = true;
  550. }
  551. if (spot18_0.Text == "")
  552. {
  553. ddl_spot18_0.Visible = true;
  554. btn_spot18_0.Visible = true;
  555. }
  556. else
  557. {
  558. btn_removespot18_0.Visible = true;
  559. }
  560. if (spot18_1.Text == "")
  561. {
  562. ddl_spot18_1.Visible = true;
  563. btn_spot18_1.Visible = true;
  564. }
  565. else
  566. {
  567. btn_removespot18_1.Visible = true;
  568. }
  569. if (spot19_0.Text == "")
  570. {
  571. ddl_spot19_0.Visible = true;
  572. btn_spot19_0.Visible = true;
  573. }
  574. else
  575. {
  576. btn_removespot19_0.Visible = true;
  577. }
  578. if (spot19_1.Text == "")
  579. {
  580. ddl_spot19_1.Visible = true;
  581. btn_spot19_1.Visible = true;
  582. }
  583. else
  584. {
  585. btn_removespot19_1.Visible = true;
  586. }
  587. if (spot20_0.Text == "")
  588. {
  589. ddl_spot20_0.Visible = true;
  590. btn_spot20_0.Visible = true;
  591. }
  592. else
  593. {
  594. btn_removespot20_0.Visible = true;
  595. }
  596. if (spot20_1.Text == "")
  597. {
  598. ddl_spot20_1.Visible = true;
  599. btn_spot20_1.Visible = true;
  600. }
  601. else
  602. {
  603. btn_removespot20_1.Visible = true;
  604. }
  605. if (spot21_0.Text == "")
  606. {
  607. ddl_spot21_0.Visible = true;
  608. btn_spot21_0.Visible = true;
  609. }
  610. else
  611. {
  612. btn_removespot21_0.Visible = true;
  613. }
  614. if (spot21_1.Text == "")
  615. {
  616. ddl_spot21_1.Visible = true;
  617. btn_spot21_1.Visible = true;
  618. }
  619. else
  620. {
  621. btn_removespot21_1.Visible = true;
  622. }
  623. if (spot22_0.Text == "")
  624. {
  625. ddl_spot22_0.Visible = true;
  626. btn_spot22_0.Visible = true;
  627. }
  628. else
  629. {
  630. btn_removespot22_0.Visible = true;
  631. }
  632. if (spot22_1.Text == "")
  633. {
  634. ddl_spot22_1.Visible = true;
  635. btn_spot22_1.Visible = true;
  636. }
  637. else
  638. {
  639. btn_removespot22_1.Visible = true;
  640. }
  641. if (spot23_0.Text == "")
  642. {
  643. ddl_spot23_0.Visible = true;
  644. btn_spot23_0.Visible = true;
  645. }
  646. else
  647. {
  648. btn_removespot23_0.Visible = true;
  649. }
  650. if (spot23_1.Text == "")
  651. {
  652. ddl_spot23_1.Visible = true;
  653. btn_spot23_1.Visible = true;
  654. }
  655. else
  656. {
  657. btn_removespot23_1.Visible = true;
  658. }
  659. if (spot24_0.Text == "")
  660. {
  661. ddl_spot24_0.Visible = true;
  662. btn_spot24_0.Visible = true;
  663. }
  664. else
  665. {
  666. btn_removespot24_0.Visible = true;
  667. }
  668. if (spot24_1.Text == "")
  669. {
  670. ddl_spot24_1.Visible = true;
  671. btn_spot24_1.Visible = true;
  672. }
  673. else
  674. {
  675. btn_removespot24_1.Visible = true;
  676. }
  677. if (spot25_0.Text == "")
  678. {
  679. ddl_spot25_0.Visible = true;
  680. btn_spot25_0.Visible = true;
  681. }
  682. else
  683. {
  684. btn_removespot25_0.Visible = true;
  685. }
  686. if (spot25_1.Text == "")
  687. {
  688. ddl_spot25_1.Visible = true;
  689. btn_spot25_1.Visible = true;
  690. }
  691. else
  692. {
  693. btn_removespot25_1.Visible = true;
  694. }
  695. if (spot26_0.Text == "")
  696. {
  697. ddl_spot26_0.Visible = true;
  698. btn_spot26_0.Visible = true;
  699. }
  700. else
  701. {
  702. btn_removespot26_0.Visible = true;
  703. }
  704. if (spot26_1.Text == "")
  705. {
  706. ddl_spot26_1.Visible = true;
  707. btn_spot26_1.Visible = true;
  708. }
  709. else
  710. {
  711. btn_removespot26_1.Visible = true;
  712. }
  713. if (spot27_0.Text == "")
  714. {
  715. ddl_spot27_0.Visible = true;
  716. btn_spot27_0.Visible = true;
  717. }
  718. else
  719. {
  720. btn_removespot27_0.Visible = true;
  721. }
  722. if (spot27_1.Text == "")
  723. {
  724. ddl_spot27_1.Visible = true;
  725. btn_spot27_1.Visible = true;
  726. }
  727. else
  728. {
  729. btn_removespot27_1.Visible = true;
  730. }
  731. if (spot28_0.Text == "")
  732. {
  733. ddl_spot28_0.Visible = true;
  734. btn_spot28_0.Visible = true;
  735. }
  736. else
  737. {
  738. btn_removespot28_0.Visible = true;
  739. }
  740. if (spot28_1.Text == "")
  741. {
  742. ddl_spot28_1.Visible = true;
  743. btn_spot28_1.Visible = true;
  744. }
  745. else
  746. {
  747. btn_removespot28_1.Visible = true;
  748. }
  749. if (spot29_0.Text == "")
  750. {
  751. ddl_spot29_0.Visible = true;
  752. btn_spot29_0.Visible = true;
  753. }
  754. else
  755. {
  756. btn_removespot29_0.Visible = true;
  757. }
  758. if (spot29_1.Text == "")
  759. {
  760. ddl_spot29_1.Visible = true;
  761. btn_spot29_1.Visible = true;
  762. }
  763. else
  764. {
  765. btn_removespot29_1.Visible = true;
  766. }
  767. if (spot30_0.Text == "")
  768. {
  769. ddl_spot30_0.Visible = true;
  770. btn_spot30_0.Visible = true;
  771. }
  772. else
  773. {
  774. btn_removespot30_0.Visible = true;
  775. }
  776. if (spot30_1.Text == "")
  777. {
  778. ddl_spot30_1.Visible = true;
  779. btn_spot30_1.Visible = true;
  780. }
  781. else
  782. {
  783. btn_removespot30_1.Visible = true;
  784. }
  785. }
  786.  
  787. if (spot0_0.Text != "")
  788. {
  789. ddl_spot0_0.Visible = false;
  790. btn_spot0_0.Visible = false;
  791.  
  792. con.Open();
  793. cmd.CommandType = CommandType.Text;
  794. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot0_0.Text + "';";
  795. //cmd.ExecuteNonQuery();
  796. dr = cmd.ExecuteReader();
  797. dr.Read();
  798. bgspot0_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  799. con.Close();
  800. }
  801.  
  802. if (spot0_1.Text != "")
  803. {
  804. ddl_spot0_1.Visible = false;
  805. btn_spot0_1.Visible = false;
  806.  
  807. con.Open();
  808. cmd.CommandType = CommandType.Text;
  809. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot0_1.Text + "';";
  810. //cmd.ExecuteNonQuery();
  811. dr = cmd.ExecuteReader();
  812. dr.Read();
  813. bgspot0_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  814. con.Close();
  815. }
  816.  
  817. if (spot1_0.Text != "")
  818. {
  819. ddl_spot1_0.Visible = false;
  820. btn_spot1_0.Visible = false;
  821.  
  822. con.Open();
  823. cmd.CommandType = CommandType.Text;
  824. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot1_0.Text + "';";
  825. //cmd.ExecuteNonQuery();
  826. dr = cmd.ExecuteReader();
  827. dr.Read();
  828. bgspot1_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  829. con.Close();
  830. }
  831.  
  832. if (spot1_1.Text != "")
  833. {
  834. ddl_spot1_1.Visible = false;
  835. btn_spot1_1.Visible = false;
  836.  
  837. con.Open();
  838. cmd.CommandType = CommandType.Text;
  839. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot1_1.Text + "';";
  840. //cmd.ExecuteNonQuery();
  841. dr = cmd.ExecuteReader();
  842. dr.Read();
  843. bgspot1_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  844. con.Close();
  845. }
  846. if (spot2_0.Text != "")
  847. {
  848. ddl_spot2_0.Visible = false;
  849. btn_spot2_0.Visible = false;
  850.  
  851. con.Open();
  852. cmd.CommandType = CommandType.Text;
  853. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot2_0.Text + "';";
  854. //cmd.ExecuteNonQuery();
  855. dr = cmd.ExecuteReader();
  856. dr.Read();
  857. bgspot2_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  858. con.Close();
  859. }
  860. if (spot2_1.Text != "")
  861. {
  862. ddl_spot2_1.Visible = false;
  863. btn_spot2_1.Visible = false;
  864.  
  865. con.Open();
  866. cmd.CommandType = CommandType.Text;
  867. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot2_1.Text + "';";
  868. //cmd.ExecuteNonQuery();
  869. dr = cmd.ExecuteReader();
  870. dr.Read();
  871. bgspot2_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  872. con.Close();
  873. }
  874. if (spot3_0.Text != "")
  875. {
  876. ddl_spot3_0.Visible = false;
  877. btn_spot3_0.Visible = false;
  878.  
  879. con.Open();
  880. cmd.CommandType = CommandType.Text;
  881. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot3_0.Text + "';";
  882. //cmd.ExecuteNonQuery();
  883. dr = cmd.ExecuteReader();
  884. dr.Read();
  885. bgspot3_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  886. con.Close();
  887. }
  888. if (spot3_1.Text != "")
  889. {
  890. ddl_spot3_1.Visible = false;
  891. btn_spot3_1.Visible = false;
  892.  
  893. con.Open();
  894. cmd.CommandType = CommandType.Text;
  895. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot3_1.Text + "';";
  896. //cmd.ExecuteNonQuery();
  897. dr = cmd.ExecuteReader();
  898. dr.Read();
  899. bgspot3_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  900. con.Close();
  901. }
  902. if (spot4_0.Text != "")
  903. {
  904. ddl_spot4_0.Visible = false;
  905. btn_spot4_0.Visible = false;
  906.  
  907. con.Open();
  908. cmd.CommandType = CommandType.Text;
  909. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot4_0.Text + "';";
  910. //cmd.ExecuteNonQuery();
  911. dr = cmd.ExecuteReader();
  912. dr.Read();
  913. bgspot4_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  914. con.Close();
  915. }
  916. if (spot4_1.Text != "")
  917. {
  918. ddl_spot4_1.Visible = false;
  919. btn_spot4_1.Visible = false;
  920.  
  921. con.Open();
  922. cmd.CommandType = CommandType.Text;
  923. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot4_1.Text + "';";
  924. //cmd.ExecuteNonQuery();
  925. dr = cmd.ExecuteReader();
  926. dr.Read();
  927. bgspot4_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  928. con.Close();
  929. }
  930. if (spot5_0.Text != "")
  931. {
  932. ddl_spot5_0.Visible = false;
  933. btn_spot5_0.Visible = false;
  934.  
  935. con.Open();
  936. cmd.CommandType = CommandType.Text;
  937. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot5_0.Text + "';";
  938. //cmd.ExecuteNonQuery();
  939. dr = cmd.ExecuteReader();
  940. dr.Read();
  941. bgspot5_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  942. con.Close();
  943. }
  944. if (spot5_1.Text != "")
  945. {
  946. ddl_spot5_1.Visible = false;
  947. btn_spot5_1.Visible = false;
  948.  
  949. con.Open();
  950. cmd.CommandType = CommandType.Text;
  951. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot5_1.Text + "';";
  952. //cmd.ExecuteNonQuery();
  953. dr = cmd.ExecuteReader();
  954. dr.Read();
  955. bgspot5_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  956. con.Close();
  957. }
  958. if (spot6_0.Text != "")
  959. {
  960. ddl_spot6_0.Visible = false;
  961. btn_spot6_0.Visible = false;
  962.  
  963. con.Open();
  964. cmd.CommandType = CommandType.Text;
  965. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot6_0.Text + "';";
  966. //cmd.ExecuteNonQuery();
  967. dr = cmd.ExecuteReader();
  968. dr.Read();
  969. bgspot6_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  970. con.Close();
  971. }
  972. if (spot6_1.Text != "")
  973. {
  974. ddl_spot6_1.Visible = false;
  975. btn_spot6_1.Visible = false;
  976.  
  977. con.Open();
  978. cmd.CommandType = CommandType.Text;
  979. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot6_1.Text + "';";
  980. //cmd.ExecuteNonQuery();
  981. dr = cmd.ExecuteReader();
  982. dr.Read();
  983. bgspot6_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  984. con.Close();
  985. }
  986. if (spot7_0.Text != "")
  987. {
  988. ddl_spot7_0.Visible = false;
  989. btn_spot7_0.Visible = false;
  990.  
  991. con.Open();
  992. cmd.CommandType = CommandType.Text;
  993. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot7_0.Text + "';";
  994. //cmd.ExecuteNonQuery();
  995. dr = cmd.ExecuteReader();
  996. dr.Read();
  997. bgspot7_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  998. con.Close();
  999. }
  1000. if (spot7_1.Text != "")
  1001. {
  1002. ddl_spot7_1.Visible = false;
  1003. btn_spot7_1.Visible = false;
  1004.  
  1005. con.Open();
  1006. cmd.CommandType = CommandType.Text;
  1007. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot7_1.Text + "';";
  1008. //cmd.ExecuteNonQuery();
  1009. dr = cmd.ExecuteReader();
  1010. dr.Read();
  1011. bgspot7_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1012. con.Close();
  1013. }
  1014. if (spot8_0.Text != "")
  1015. {
  1016. ddl_spot8_0.Visible = false;
  1017. btn_spot8_0.Visible = false;
  1018.  
  1019. con.Open();
  1020. cmd.CommandType = CommandType.Text;
  1021. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot8_0.Text + "';";
  1022. //cmd.ExecuteNonQuery();
  1023. dr = cmd.ExecuteReader();
  1024. dr.Read();
  1025. bgspot8_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1026. con.Close();
  1027. }
  1028. if (spot8_1.Text != "")
  1029. {
  1030. ddl_spot8_1.Visible = false;
  1031. btn_spot8_1.Visible = false;
  1032.  
  1033. con.Open();
  1034. cmd.CommandType = CommandType.Text;
  1035. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot8_1.Text + "';";
  1036. //cmd.ExecuteNonQuery();
  1037. dr = cmd.ExecuteReader();
  1038. dr.Read();
  1039. bgspot8_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1040. con.Close();
  1041. }
  1042. if (spot9_0.Text != "")
  1043. {
  1044. ddl_spot9_0.Visible = false;
  1045. btn_spot9_0.Visible = false;
  1046.  
  1047. con.Open();
  1048. cmd.CommandType = CommandType.Text;
  1049. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot9_0.Text + "';";
  1050. //cmd.ExecuteNonQuery();
  1051. dr = cmd.ExecuteReader();
  1052. dr.Read();
  1053. bgspot9_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1054. con.Close();
  1055. }
  1056. if (spot9_1.Text != "")
  1057. {
  1058. ddl_spot9_1.Visible = false;
  1059. btn_spot9_1.Visible = false;
  1060.  
  1061. con.Open();
  1062. cmd.CommandType = CommandType.Text;
  1063. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot9_1.Text + "';";
  1064. //cmd.ExecuteNonQuery();
  1065. dr = cmd.ExecuteReader();
  1066. dr.Read();
  1067. bgspot9_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1068. con.Close();
  1069. }
  1070. if (spot10_0.Text != "")
  1071. {
  1072. ddl_spot10_0.Visible = false;
  1073. btn_spot10_0.Visible = false;
  1074.  
  1075. con.Open();
  1076. cmd.CommandType = CommandType.Text;
  1077. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot10_0.Text + "';";
  1078. //cmd.ExecuteNonQuery();
  1079. dr = cmd.ExecuteReader();
  1080. dr.Read();
  1081. bgspot10_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1082. con.Close();
  1083. }
  1084. if (spot10_1.Text != "")
  1085. {
  1086. ddl_spot10_1.Visible = false;
  1087. btn_spot10_1.Visible = false;
  1088.  
  1089. con.Open();
  1090. cmd.CommandType = CommandType.Text;
  1091. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot10_1.Text + "';";
  1092. //cmd.ExecuteNonQuery();
  1093. dr = cmd.ExecuteReader();
  1094. dr.Read();
  1095. bgspot10_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1096. con.Close();
  1097. }
  1098. if (spot11_0.Text != "")
  1099. {
  1100. ddl_spot11_0.Visible = false;
  1101. btn_spot11_0.Visible = false;
  1102.  
  1103. con.Open();
  1104. cmd.CommandType = CommandType.Text;
  1105. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot11_0.Text + "';";
  1106. //cmd.ExecuteNonQuery();
  1107. dr = cmd.ExecuteReader();
  1108. dr.Read();
  1109. bgspot11_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1110. con.Close();
  1111. }
  1112. if (spot11_1.Text != "")
  1113. {
  1114. ddl_spot11_1.Visible = false;
  1115. btn_spot11_1.Visible = false;
  1116.  
  1117. con.Open();
  1118. cmd.CommandType = CommandType.Text;
  1119. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot11_1.Text + "';";
  1120. //cmd.ExecuteNonQuery();
  1121. dr = cmd.ExecuteReader();
  1122. dr.Read();
  1123. bgspot11_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1124. con.Close();
  1125. }
  1126. if (spot12_0.Text != "")
  1127. {
  1128. ddl_spot12_0.Visible = false;
  1129. btn_spot12_0.Visible = false;
  1130.  
  1131. con.Open();
  1132. cmd.CommandType = CommandType.Text;
  1133. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot12_0.Text + "';";
  1134. //cmd.ExecuteNonQuery();
  1135. dr = cmd.ExecuteReader();
  1136. dr.Read();
  1137. bgspot12_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1138. con.Close();
  1139. }
  1140. if (spot12_1.Text != "")
  1141. {
  1142. ddl_spot12_1.Visible = false;
  1143. btn_spot12_1.Visible = false;
  1144.  
  1145. con.Open();
  1146. cmd.CommandType = CommandType.Text;
  1147. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot12_1.Text + "';";
  1148. //cmd.ExecuteNonQuery();
  1149. dr = cmd.ExecuteReader();
  1150. dr.Read();
  1151. bgspot12_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1152. con.Close();
  1153. }
  1154. if (spot13_0.Text != "")
  1155. {
  1156. ddl_spot13_0.Visible = false;
  1157. btn_spot13_0.Visible = false;
  1158.  
  1159. con.Open();
  1160. cmd.CommandType = CommandType.Text;
  1161. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot13_0.Text + "';";
  1162. //cmd.ExecuteNonQuery();
  1163. dr = cmd.ExecuteReader();
  1164. dr.Read();
  1165. bgspot13_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1166. con.Close();
  1167. }
  1168. if (spot13_1.Text != "")
  1169. {
  1170. ddl_spot13_1.Visible = false;
  1171. btn_spot13_1.Visible = false;
  1172.  
  1173. con.Open();
  1174. cmd.CommandType = CommandType.Text;
  1175. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot13_1.Text + "';";
  1176. //cmd.ExecuteNonQuery();
  1177. dr = cmd.ExecuteReader();
  1178. dr.Read();
  1179. bgspot13_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1180. con.Close();
  1181. }
  1182. if (spot14_0.Text != "")
  1183. {
  1184. ddl_spot14_0.Visible = false;
  1185. btn_spot14_0.Visible = false;
  1186.  
  1187. con.Open();
  1188. cmd.CommandType = CommandType.Text;
  1189. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot14_0.Text + "';";
  1190. //cmd.ExecuteNonQuery();
  1191. dr = cmd.ExecuteReader();
  1192. dr.Read();
  1193. bgspot14_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1194. con.Close();
  1195. }
  1196. if (spot14_1.Text != "")
  1197. {
  1198. ddl_spot14_1.Visible = false;
  1199. btn_spot14_1.Visible = false;
  1200.  
  1201. con.Open();
  1202. cmd.CommandType = CommandType.Text;
  1203. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot14_1.Text + "';";
  1204. //cmd.ExecuteNonQuery();
  1205. dr = cmd.ExecuteReader();
  1206. dr.Read();
  1207. bgspot14_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1208. con.Close();
  1209. }
  1210. if (spot15_0.Text != "")
  1211. {
  1212. ddl_spot15_0.Visible = false;
  1213. btn_spot15_0.Visible = false;
  1214.  
  1215. con.Open();
  1216. cmd.CommandType = CommandType.Text;
  1217. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot15_0.Text + "';";
  1218. //cmd.ExecuteNonQuery();
  1219. dr = cmd.ExecuteReader();
  1220. dr.Read();
  1221. bgspot15_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1222. con.Close();
  1223. }
  1224. if (spot15_1.Text != "")
  1225. {
  1226. ddl_spot15_1.Visible = false;
  1227. btn_spot15_1.Visible = false;
  1228.  
  1229. con.Open();
  1230. cmd.CommandType = CommandType.Text;
  1231. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot15_1.Text + "';";
  1232. //cmd.ExecuteNonQuery();
  1233. dr = cmd.ExecuteReader();
  1234. dr.Read();
  1235. bgspot15_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1236. con.Close();
  1237. }
  1238. if (spot16_0.Text != "")
  1239. {
  1240. ddl_spot16_0.Visible = false;
  1241. btn_spot16_0.Visible = false;
  1242.  
  1243. con.Open();
  1244. cmd.CommandType = CommandType.Text;
  1245. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot16_0.Text + "';";
  1246. //cmd.ExecuteNonQuery();
  1247. dr = cmd.ExecuteReader();
  1248. dr.Read();
  1249. bgspot16_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1250. con.Close();
  1251. }
  1252. if (spot16_1.Text != "")
  1253. {
  1254. ddl_spot16_1.Visible = false;
  1255. btn_spot16_1.Visible = false;
  1256.  
  1257. con.Open();
  1258. cmd.CommandType = CommandType.Text;
  1259. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot16_1.Text + "';";
  1260. //cmd.ExecuteNonQuery();
  1261. dr = cmd.ExecuteReader();
  1262. dr.Read();
  1263. bgspot16_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1264. con.Close();
  1265. }
  1266. if (spot17_0.Text != "")
  1267. {
  1268. ddl_spot17_0.Visible = false;
  1269. btn_spot17_0.Visible = false;
  1270.  
  1271. con.Open();
  1272. cmd.CommandType = CommandType.Text;
  1273. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot17_0.Text + "';";
  1274. //cmd.ExecuteNonQuery();
  1275. dr = cmd.ExecuteReader();
  1276. dr.Read();
  1277. bgspot17_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1278. con.Close();
  1279. }
  1280. if (spot17_1.Text != "")
  1281. {
  1282. ddl_spot17_1.Visible = false;
  1283. btn_spot17_1.Visible = false;
  1284.  
  1285. con.Open();
  1286. cmd.CommandType = CommandType.Text;
  1287. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot17_1.Text + "';";
  1288. //cmd.ExecuteNonQuery();
  1289. dr = cmd.ExecuteReader();
  1290. dr.Read();
  1291. bgspot17_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1292. con.Close();
  1293. }
  1294. if (spot18_0.Text != "")
  1295. {
  1296. ddl_spot18_0.Visible = false;
  1297. btn_spot18_0.Visible = false;
  1298.  
  1299. con.Open();
  1300. cmd.CommandType = CommandType.Text;
  1301. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot18_0.Text + "';";
  1302. //cmd.ExecuteNonQuery();
  1303. dr = cmd.ExecuteReader();
  1304. dr.Read();
  1305. bgspot18_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1306. con.Close();
  1307. }
  1308. if (spot18_1.Text != "")
  1309. {
  1310. ddl_spot18_1.Visible = false;
  1311. btn_spot18_1.Visible = false;
  1312.  
  1313. con.Open();
  1314. cmd.CommandType = CommandType.Text;
  1315. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot18_1.Text + "';";
  1316. //cmd.ExecuteNonQuery();
  1317. dr = cmd.ExecuteReader();
  1318. dr.Read();
  1319. bgspot18_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1320. con.Close();
  1321. }
  1322. if (spot19_0.Text != "")
  1323. {
  1324. ddl_spot19_0.Visible = false;
  1325. btn_spot19_0.Visible = false;
  1326.  
  1327. con.Open();
  1328. cmd.CommandType = CommandType.Text;
  1329. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot19_0.Text + "';";
  1330. //cmd.ExecuteNonQuery();
  1331. dr = cmd.ExecuteReader();
  1332. dr.Read();
  1333. bgspot19_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1334. con.Close();
  1335. }
  1336. if (spot19_1.Text != "")
  1337. {
  1338. ddl_spot19_1.Visible = false;
  1339. btn_spot19_1.Visible = false;
  1340.  
  1341. con.Open();
  1342. cmd.CommandType = CommandType.Text;
  1343. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot19_1.Text + "';";
  1344. //cmd.ExecuteNonQuery();
  1345. dr = cmd.ExecuteReader();
  1346. dr.Read();
  1347. bgspot19_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1348. con.Close();
  1349. }
  1350. if (spot20_0.Text != "")
  1351. {
  1352. ddl_spot20_0.Visible = false;
  1353. btn_spot20_0.Visible = false;
  1354.  
  1355. con.Open();
  1356. cmd.CommandType = CommandType.Text;
  1357. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot20_0.Text + "';";
  1358. //cmd.ExecuteNonQuery();
  1359. dr = cmd.ExecuteReader();
  1360. dr.Read();
  1361. bgspot20_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1362. con.Close();
  1363. }
  1364. if (spot20_1.Text != "")
  1365. {
  1366. ddl_spot20_1.Visible = false;
  1367. btn_spot20_1.Visible = false;
  1368.  
  1369. con.Open();
  1370. cmd.CommandType = CommandType.Text;
  1371. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot20_1.Text + "';";
  1372. //cmd.ExecuteNonQuery();
  1373. dr = cmd.ExecuteReader();
  1374. dr.Read();
  1375. bgspot20_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1376. con.Close();
  1377. }
  1378. if (spot21_0.Text != "")
  1379. {
  1380. ddl_spot21_0.Visible = false;
  1381. btn_spot21_0.Visible = false;
  1382.  
  1383. con.Open();
  1384. cmd.CommandType = CommandType.Text;
  1385. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot21_0.Text + "';";
  1386. //cmd.ExecuteNonQuery();
  1387. dr = cmd.ExecuteReader();
  1388. dr.Read();
  1389. bgspot21_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1390. con.Close();
  1391. }
  1392. if (spot21_1.Text != "")
  1393. {
  1394. ddl_spot21_1.Visible = false;
  1395. btn_spot21_1.Visible = false;
  1396.  
  1397. con.Open();
  1398. cmd.CommandType = CommandType.Text;
  1399. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot21_1.Text + "';";
  1400. //cmd.ExecuteNonQuery();
  1401. dr = cmd.ExecuteReader();
  1402. dr.Read();
  1403. bgspot21_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1404. con.Close();
  1405. }
  1406. if (spot22_0.Text != "")
  1407. {
  1408. ddl_spot22_0.Visible = false;
  1409. btn_spot22_0.Visible = false;
  1410.  
  1411. con.Open();
  1412. cmd.CommandType = CommandType.Text;
  1413. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot22_0.Text + "';";
  1414. //cmd.ExecuteNonQuery();
  1415. dr = cmd.ExecuteReader();
  1416. dr.Read();
  1417. bgspot22_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1418. con.Close();
  1419. }
  1420. if (spot22_1.Text != "")
  1421. {
  1422. ddl_spot22_1.Visible = false;
  1423. btn_spot22_1.Visible = false;
  1424.  
  1425. con.Open();
  1426. cmd.CommandType = CommandType.Text;
  1427. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot22_1.Text + "';";
  1428. //cmd.ExecuteNonQuery();
  1429. dr = cmd.ExecuteReader();
  1430. dr.Read();
  1431. bgspot22_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1432. con.Close();
  1433. }
  1434. if (spot23_0.Text != "")
  1435. {
  1436. ddl_spot23_0.Visible = false;
  1437. btn_spot23_0.Visible = false;
  1438.  
  1439. con.Open();
  1440. cmd.CommandType = CommandType.Text;
  1441. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot23_0.Text + "';";
  1442. //cmd.ExecuteNonQuery();
  1443. dr = cmd.ExecuteReader();
  1444. dr.Read();
  1445. bgspot23_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1446. con.Close();
  1447. }
  1448. if (spot23_1.Text != "")
  1449. {
  1450. ddl_spot23_1.Visible = false;
  1451. btn_spot23_1.Visible = false;
  1452.  
  1453. con.Open();
  1454. cmd.CommandType = CommandType.Text;
  1455. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot23_1.Text + "';";
  1456. //cmd.ExecuteNonQuery();
  1457. dr = cmd.ExecuteReader();
  1458. dr.Read();
  1459. bgspot23_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1460. con.Close();
  1461. }
  1462. if (spot24_0.Text != "")
  1463. {
  1464. ddl_spot24_0.Visible = false;
  1465. btn_spot24_0.Visible = false;
  1466.  
  1467. con.Open();
  1468. cmd.CommandType = CommandType.Text;
  1469. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot24_0.Text + "';";
  1470. //cmd.ExecuteNonQuery();
  1471. dr = cmd.ExecuteReader();
  1472. dr.Read();
  1473. bgspot24_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1474. con.Close();
  1475. }
  1476. if (spot24_1.Text != "")
  1477. {
  1478. ddl_spot24_1.Visible = false;
  1479. btn_spot24_1.Visible = false;
  1480.  
  1481. con.Open();
  1482. cmd.CommandType = CommandType.Text;
  1483. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot24_1.Text + "';";
  1484. //cmd.ExecuteNonQuery();
  1485. dr = cmd.ExecuteReader();
  1486. dr.Read();
  1487. bgspot24_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1488. con.Close();
  1489. }
  1490. if (spot25_0.Text != "")
  1491. {
  1492. ddl_spot25_0.Visible = false;
  1493. btn_spot25_0.Visible = false;
  1494.  
  1495. con.Open();
  1496. cmd.CommandType = CommandType.Text;
  1497. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot25_0.Text + "';";
  1498. //cmd.ExecuteNonQuery();
  1499. dr = cmd.ExecuteReader();
  1500. dr.Read();
  1501. bgspot25_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1502. con.Close();
  1503. }
  1504. if (spot25_1.Text != "")
  1505. {
  1506. ddl_spot25_1.Visible = false;
  1507. btn_spot25_1.Visible = false;
  1508.  
  1509. con.Open();
  1510. cmd.CommandType = CommandType.Text;
  1511. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot25_1.Text + "';";
  1512. //cmd.ExecuteNonQuery();
  1513. dr = cmd.ExecuteReader();
  1514. dr.Read();
  1515. bgspot25_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1516. con.Close();
  1517. }
  1518. if (spot26_0.Text != "")
  1519. {
  1520. ddl_spot26_0.Visible = false;
  1521. btn_spot26_0.Visible = false;
  1522.  
  1523. con.Open();
  1524. cmd.CommandType = CommandType.Text;
  1525. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot26_0.Text + "';";
  1526. //cmd.ExecuteNonQuery();
  1527. dr = cmd.ExecuteReader();
  1528. dr.Read();
  1529. bgspot26_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1530. con.Close();
  1531. }
  1532. if (spot26_1.Text != "")
  1533. {
  1534. ddl_spot26_1.Visible = false;
  1535. btn_spot26_1.Visible = false;
  1536.  
  1537. con.Open();
  1538. cmd.CommandType = CommandType.Text;
  1539. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot26_1.Text + "';";
  1540. //cmd.ExecuteNonQuery();
  1541. dr = cmd.ExecuteReader();
  1542. dr.Read();
  1543. bgspot26_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1544. con.Close();
  1545. }
  1546. if (spot27_0.Text != "")
  1547. {
  1548. ddl_spot27_0.Visible = false;
  1549. btn_spot27_0.Visible = false;
  1550.  
  1551. con.Open();
  1552. cmd.CommandType = CommandType.Text;
  1553. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot27_0.Text + "';";
  1554. //cmd.ExecuteNonQuery();
  1555. dr = cmd.ExecuteReader();
  1556. dr.Read();
  1557. bgspot27_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1558. con.Close();
  1559. }
  1560. if (spot27_1.Text != "")
  1561. {
  1562. ddl_spot27_1.Visible = false;
  1563. btn_spot27_1.Visible = false;
  1564.  
  1565. con.Open();
  1566. cmd.CommandType = CommandType.Text;
  1567. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot27_1.Text + "';";
  1568. //cmd.ExecuteNonQuery();
  1569. dr = cmd.ExecuteReader();
  1570. dr.Read();
  1571. bgspot27_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1572. con.Close();
  1573. }
  1574. if (spot28_0.Text != "")
  1575. {
  1576. ddl_spot28_0.Visible = false;
  1577. btn_spot28_0.Visible = false;
  1578.  
  1579. con.Open();
  1580. cmd.CommandType = CommandType.Text;
  1581. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot28_0.Text + "';";
  1582. //cmd.ExecuteNonQuery();
  1583. dr = cmd.ExecuteReader();
  1584. dr.Read();
  1585. bgspot28_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1586. con.Close();
  1587. }
  1588. if (spot28_1.Text != "")
  1589. {
  1590. ddl_spot28_1.Visible = false;
  1591. btn_spot28_1.Visible = false;
  1592.  
  1593. con.Open();
  1594. cmd.CommandType = CommandType.Text;
  1595. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot28_1.Text + "';";
  1596. //cmd.ExecuteNonQuery();
  1597. dr = cmd.ExecuteReader();
  1598. dr.Read();
  1599. bgspot28_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1600. con.Close();
  1601. }
  1602. if (spot29_0.Text != "")
  1603. {
  1604. ddl_spot29_0.Visible = false;
  1605. btn_spot29_0.Visible = false;
  1606.  
  1607. con.Open();
  1608. cmd.CommandType = CommandType.Text;
  1609. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot29_0.Text + "';";
  1610. //cmd.ExecuteNonQuery();
  1611. dr = cmd.ExecuteReader();
  1612. dr.Read();
  1613. bgspot29_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1614. con.Close();
  1615. }
  1616. if (spot29_1.Text != "")
  1617. {
  1618. ddl_spot29_1.Visible = false;
  1619. btn_spot29_1.Visible = false;
  1620.  
  1621. con.Open();
  1622. cmd.CommandType = CommandType.Text;
  1623. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot29_1.Text + "';";
  1624. //cmd.ExecuteNonQuery();
  1625. dr = cmd.ExecuteReader();
  1626. dr.Read();
  1627. bgspot29_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1628. con.Close();
  1629. }
  1630. if (spot30_0.Text != "")
  1631. {
  1632. ddl_spot30_0.Visible = false;
  1633. btn_spot30_0.Visible = false;
  1634.  
  1635. con.Open();
  1636. cmd.CommandType = CommandType.Text;
  1637. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot30_0.Text + "';";
  1638. //cmd.ExecuteNonQuery();
  1639. dr = cmd.ExecuteReader();
  1640. dr.Read();
  1641. bgspot30_0.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1642. con.Close();
  1643. }
  1644. if (spot30_1.Text != "")
  1645. {
  1646. ddl_spot30_1.Visible = false;
  1647. btn_spot30_1.Visible = false;
  1648.  
  1649. con.Open();
  1650. cmd.CommandType = CommandType.Text;
  1651. cmd.CommandText = "SELECT Farge FROM Ansatte WHERE Navn='" + spot30_1.Text + "';";
  1652. //cmd.ExecuteNonQuery();
  1653. dr = cmd.ExecuteReader();
  1654. dr.Read();
  1655. bgspot30_1.Attributes.Add("style", "background-color: " + farger[Convert.ToInt32(dr[0])]);
  1656. con.Close();
  1657. }
  1658.  
  1659.  
  1660.  
  1661.  
  1662. }
  1663.  
  1664. protected void btn_spot0_0_Click(object sender, EventArgs e)
  1665. {
  1666. spot0_0.Text = ddl_spot0_0.SelectedItem.Text;
  1667. con.Open();
  1668. MySqlCommand cmd = con.CreateCommand();
  1669. cmd.CommandType = CommandType.Text;
  1670. cmd.CommandText = "UPDATE kalender SET " + date_spot0.Text +"_1='" + spot0_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  1671. cmd.ExecuteNonQuery();
  1672. spot0_0.Text = "";
  1673. con.Close();
  1674. Response.Redirect("default.aspx");
  1675. }
  1676.  
  1677. protected void btn_nyansatt_Click(object sender, EventArgs e)
  1678. {
  1679. Response.Redirect("nyansatt.aspx");
  1680. }
  1681.  
  1682.  
  1683. public void getcalendar()
  1684. {
  1685. con.Open();
  1686. MySqlCommand cmd = con.CreateCommand();
  1687. cmd.CommandType = CommandType.Text;
  1688. cmd.CommandText = "SELECT mnd_id, mndstart, 1_1, 1_2, 2_1, 2_2, 3_1, 3_2, 4_1, 4_2, 5_1, 5_2, 6_1, 6_2, 7_1, 7_2, 8_1, 8_2, 9_1, 9_2, 10_1, 10_2, 11_1, 11_2, 12_1, 12_2, 13_1, 13_2, 14_1, 14_2, 15_1, 15_2, 16_1, 16_2, 17_1, 17_2, 18_1, 18_2, 19_1, 19_2, 20_1, 20_2, 21_1, 21_2, 22_1, 22_2, 23_1, 23_2, 24_1, 24_2, 25_1, 25_2, 26_1, 26_2, 27_1, 27_2, 28_1, 28_2, 29_1, 29_2, 30_1, 30_2, 31_1, 31_2 FROM kalender WHERE mnd_id='" + "72016" + "';";
  1689. cmd.ExecuteNonQuery();
  1690. dr = cmd.ExecuteReader();
  1691. dr.Read();
  1692. smnd_id = Convert.ToInt32(dr[0]);
  1693. smndstart = Convert.ToInt32(dr[1]);
  1694. s1_1 = Convert.ToString(dr[2]);
  1695. s1_2 = Convert.ToString(dr[3]);
  1696. s2_1 = Convert.ToString(dr[4]);
  1697. s2_2 = Convert.ToString(dr[5]);
  1698. s3_1 = Convert.ToString(dr[6]);
  1699. s3_2 = Convert.ToString(dr[7]);
  1700. s4_1 = Convert.ToString(dr[8]);
  1701. s4_2 = Convert.ToString(dr[9]);
  1702. s5_1 = Convert.ToString(dr[10]);
  1703. s5_2 = Convert.ToString(dr[11]);
  1704. s6_1 = Convert.ToString(dr[12]);
  1705. s6_2 = Convert.ToString(dr[13]);
  1706. s7_1 = Convert.ToString(dr[14]);
  1707. s7_2 = Convert.ToString(dr[15]);
  1708. s8_1 = Convert.ToString(dr[16]);
  1709. s8_2 = Convert.ToString(dr[17]);
  1710. s9_1 = Convert.ToString(dr[18]);
  1711. s9_2 = Convert.ToString(dr[19]);
  1712. s10_1 = Convert.ToString(dr[20]);
  1713. s10_2 = Convert.ToString(dr[21]);
  1714. s11_1 = Convert.ToString(dr[22]);
  1715. s11_2 = Convert.ToString(dr[23]);
  1716. s12_1 = Convert.ToString(dr[24]);
  1717. s12_2 = Convert.ToString(dr[25]);
  1718. s13_1 = Convert.ToString(dr[26]);
  1719. s13_2 = Convert.ToString(dr[27]);
  1720. s14_1 = Convert.ToString(dr[28]);
  1721. s14_2 = Convert.ToString(dr[29]);
  1722. s15_1 = Convert.ToString(dr[30]);
  1723. s15_2 = Convert.ToString(dr[31]);
  1724. s16_1 = Convert.ToString(dr[32]);
  1725. s16_2 = Convert.ToString(dr[33]);
  1726. s17_1 = Convert.ToString(dr[34]);
  1727. s17_2 = Convert.ToString(dr[35]);
  1728. s18_1 = Convert.ToString(dr[36]);
  1729. s18_2 = Convert.ToString(dr[37]);
  1730. s19_1 = Convert.ToString(dr[38]);
  1731. s19_2 = Convert.ToString(dr[39]);
  1732. s20_1 = Convert.ToString(dr[40]);
  1733. s20_2 = Convert.ToString(dr[41]);
  1734. s21_1 = Convert.ToString(dr[42]);
  1735. s21_2 = Convert.ToString(dr[43]);
  1736. s22_1 = Convert.ToString(dr[44]);
  1737. s22_2 = Convert.ToString(dr[45]);
  1738. s23_1 = Convert.ToString(dr[46]);
  1739. s23_2 = Convert.ToString(dr[47]);
  1740. s24_1 = Convert.ToString(dr[48]);
  1741. s24_2 = Convert.ToString(dr[49]);
  1742. s25_1 = Convert.ToString(dr[50]);
  1743. s25_2 = Convert.ToString(dr[51]);
  1744. s26_1 = Convert.ToString(dr[52]);
  1745. s26_2 = Convert.ToString(dr[53]);
  1746. s27_1 = Convert.ToString(dr[54]);
  1747. s27_2 = Convert.ToString(dr[55]);
  1748. s28_1 = Convert.ToString(dr[56]);
  1749. s28_2 = Convert.ToString(dr[57]);
  1750. s29_1 = Convert.ToString(dr[58]);
  1751. s29_2 = Convert.ToString(dr[59]);
  1752. s30_1 = Convert.ToString(dr[60]);
  1753. s30_2 = Convert.ToString(dr[61]);
  1754. s31_1 = Convert.ToString(dr[62]);
  1755. s31_2 = Convert.ToString(dr[63]);
  1756. con.Close();
  1757.  
  1758. spot0_0.Text = s1_1;
  1759. spot0_1.Text = s1_2;
  1760. spot1_0.Text = s2_1;
  1761. spot1_1.Text = s2_2;
  1762. spot2_0.Text = s3_1;
  1763. spot2_1.Text = s3_2;
  1764. spot3_0.Text = s4_1;
  1765. spot3_1.Text = s4_2;
  1766. spot4_0.Text = s5_1;
  1767. spot4_1.Text = s5_2;
  1768. spot5_0.Text = s6_1;
  1769. spot5_1.Text = s6_2;
  1770. spot6_0.Text = s7_1;
  1771. spot6_1.Text = s7_2;
  1772. spot7_0.Text = s8_1;
  1773. spot7_1.Text = s8_2;
  1774. spot8_0.Text = s9_1;
  1775. spot8_1.Text = s9_2;
  1776. spot9_0.Text = s10_1;
  1777. spot9_1.Text = s10_2;
  1778. spot10_0.Text = s11_1;
  1779. spot10_1.Text = s11_2;
  1780. spot11_0.Text = s12_1;
  1781. spot11_1.Text = s12_2;
  1782. spot12_0.Text = s13_1;
  1783. spot12_1.Text = s13_2;
  1784. spot13_0.Text = s14_1;
  1785. spot13_1.Text = s14_2;
  1786. spot14_0.Text = s15_1;
  1787. spot14_1.Text = s15_2;
  1788. spot15_0.Text = s16_1;
  1789. spot15_1.Text = s16_2;
  1790. spot16_0.Text = s17_1;
  1791. spot16_1.Text = s17_2;
  1792. spot17_0.Text = s18_1;
  1793. spot17_1.Text = s18_2;
  1794. spot18_0.Text = s19_1;
  1795. spot18_1.Text = s19_2;
  1796. spot19_0.Text = s20_1;
  1797. spot19_1.Text = s20_2;
  1798. spot20_0.Text = s21_1;
  1799. spot20_1.Text = s21_2;
  1800. spot21_0.Text = s22_1;
  1801. spot21_1.Text = s22_2;
  1802. spot22_0.Text = s23_1;
  1803. spot22_1.Text = s23_2;
  1804. spot23_0.Text = s24_1;
  1805. spot23_1.Text = s24_2;
  1806. spot24_0.Text = s25_1;
  1807. spot24_1.Text = s25_2;
  1808. spot25_0.Text = s26_1;
  1809. spot25_1.Text = s26_2;
  1810. spot26_0.Text = s27_1;
  1811. spot26_1.Text = s27_2;
  1812. spot27_0.Text = s28_1;
  1813. spot27_1.Text = s28_2;
  1814. spot28_0.Text = s29_1;
  1815. spot28_1.Text = s29_2;
  1816. spot29_0.Text = s30_1;
  1817. spot29_1.Text = s30_2;
  1818. spot30_0.Text = s31_1;
  1819. spot30_1.Text = s31_2;
  1820.  
  1821.  
  1822.  
  1823. }
  1824.  
  1825.  
  1826. protected void btn_removespot0_0_Click(object sender, EventArgs e)
  1827. {
  1828. con.Open();
  1829. MySqlCommand cmd = con.CreateCommand();
  1830. cmd.CommandType = CommandType.Text;
  1831. cmd.CommandText = "UPDATE kalender SET 1_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  1832. cmd.ExecuteNonQuery();
  1833. spot0_0.Text = "";
  1834. con.Close();
  1835. Response.Redirect("default.aspx");
  1836. }
  1837.  
  1838. protected void btn_spot0_1_Click(object sender, EventArgs e)
  1839. {
  1840. spot0_1.Text = ddl_spot0_1.SelectedItem.Text;
  1841. con.Open();
  1842. MySqlCommand cmd = con.CreateCommand();
  1843. cmd.CommandType = CommandType.Text;
  1844. cmd.CommandText = "UPDATE kalender SET 1_2='" + spot0_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  1845. cmd.ExecuteNonQuery();
  1846. spot0_0.Text = "";
  1847. con.Close();
  1848. Response.Redirect("default.aspx");
  1849. }
  1850.  
  1851. protected void btn_removespot0_1_Click(object sender, EventArgs e)
  1852. {
  1853. con.Open();
  1854. MySqlCommand cmd = con.CreateCommand();
  1855. cmd.CommandType = CommandType.Text;
  1856. cmd.CommandText = "UPDATE kalender SET 1_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  1857. cmd.ExecuteNonQuery();
  1858. spot0_1.Text = "";
  1859. con.Close();
  1860. Response.Redirect("default.aspx");
  1861. }
  1862.  
  1863. protected void btn_spot1_0_Click(object sender, EventArgs e)
  1864. {
  1865. spot1_0.Text = ddl_spot1_0.SelectedItem.Text;
  1866. con.Open();
  1867. MySqlCommand cmd = con.CreateCommand();
  1868. cmd.CommandType = CommandType.Text;
  1869. cmd.CommandText = "UPDATE kalender SET 2_1='" + spot1_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  1870. cmd.ExecuteNonQuery();
  1871. spot1_0.Text = "";
  1872. con.Close();
  1873. Response.Redirect("default.aspx");
  1874. }
  1875.  
  1876. protected void btn_removespot1_0_Click(object sender, EventArgs e)
  1877. {
  1878. con.Open();
  1879. MySqlCommand cmd = con.CreateCommand();
  1880. cmd.CommandType = CommandType.Text;
  1881. cmd.CommandText = "UPDATE kalender SET 2_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  1882. cmd.ExecuteNonQuery();
  1883. spot1_0.Text = "";
  1884. con.Close();
  1885. Response.Redirect("default.aspx");
  1886. }
  1887.  
  1888. protected void btn_spot1_1_Click(object sender, EventArgs e)
  1889. {
  1890. spot1_1.Text = ddl_spot1_1.SelectedItem.Text;
  1891. con.Open();
  1892. MySqlCommand cmd = con.CreateCommand();
  1893. cmd.CommandType = CommandType.Text;
  1894. cmd.CommandText = "UPDATE kalender SET 2_2='" + spot1_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  1895. cmd.ExecuteNonQuery();
  1896. spot1_1.Text = "";
  1897. con.Close();
  1898. Response.Redirect("default.aspx");
  1899. }
  1900.  
  1901. protected void btn_removespot1_1_Click(object sender, EventArgs e)
  1902. {
  1903. con.Open();
  1904. MySqlCommand cmd = con.CreateCommand();
  1905. cmd.CommandType = CommandType.Text;
  1906. cmd.CommandText = "UPDATE kalender SET 2_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  1907. cmd.ExecuteNonQuery();
  1908. spot1_1.Text = "";
  1909. con.Close();
  1910. Response.Redirect("default.aspx");
  1911. }
  1912.  
  1913. protected void btn_spot2_0_Click(object sender, EventArgs e)
  1914. {
  1915. spot2_0.Text = ddl_spot2_0.SelectedItem.Text;
  1916. con.Open();
  1917. MySqlCommand cmd = con.CreateCommand();
  1918. cmd.CommandType = CommandType.Text;
  1919. cmd.CommandText = "UPDATE kalender SET 3_1='" + spot2_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  1920. cmd.ExecuteNonQuery();
  1921. spot2_0.Text = "";
  1922. con.Close();
  1923. Response.Redirect("default.aspx");
  1924. }
  1925.  
  1926. protected void btn_removespot2_0_Click(object sender, EventArgs e)
  1927. {
  1928. con.Open();
  1929. MySqlCommand cmd = con.CreateCommand();
  1930. cmd.CommandType = CommandType.Text;
  1931. cmd.CommandText = "UPDATE kalender SET 3_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  1932. cmd.ExecuteNonQuery();
  1933. spot2_0.Text = "";
  1934. con.Close();
  1935. Response.Redirect("default.aspx");
  1936. }
  1937.  
  1938. protected void btn_spot2_1_Click(object sender, EventArgs e)
  1939. {
  1940. spot2_1.Text = ddl_spot2_1.SelectedItem.Text;
  1941. con.Open();
  1942. MySqlCommand cmd = con.CreateCommand();
  1943. cmd.CommandType = CommandType.Text;
  1944. cmd.CommandText = "UPDATE kalender SET 3_2='" + spot2_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  1945. cmd.ExecuteNonQuery();
  1946. spot2_1.Text = "";
  1947. con.Close();
  1948. Response.Redirect("default.aspx");
  1949. }
  1950.  
  1951. protected void btn_removespot2_1_Click(object sender, EventArgs e)
  1952. {
  1953. con.Open();
  1954. MySqlCommand cmd = con.CreateCommand();
  1955. cmd.CommandType = CommandType.Text;
  1956. cmd.CommandText = "UPDATE kalender SET 3_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  1957. cmd.ExecuteNonQuery();
  1958. spot2_1.Text = "";
  1959. con.Close();
  1960. Response.Redirect("default.aspx");
  1961. }
  1962.  
  1963. protected void btn_spot3_0_Click(object sender, EventArgs e)
  1964. {
  1965. spot3_0.Text = ddl_spot3_0.SelectedItem.Text;
  1966. con.Open();
  1967. MySqlCommand cmd = con.CreateCommand();
  1968. cmd.CommandType = CommandType.Text;
  1969. cmd.CommandText = "UPDATE kalender SET 4_1='" + spot3_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  1970. cmd.ExecuteNonQuery();
  1971. spot3_0.Text = "";
  1972. con.Close();
  1973. Response.Redirect("default.aspx");
  1974. }
  1975.  
  1976. protected void btn_removespot3_0_Click(object sender, EventArgs e)
  1977. {
  1978. con.Open();
  1979. MySqlCommand cmd = con.CreateCommand();
  1980. cmd.CommandType = CommandType.Text;
  1981. cmd.CommandText = "UPDATE kalender SET 4_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  1982. cmd.ExecuteNonQuery();
  1983. spot3_0.Text = "";
  1984. con.Close();
  1985. Response.Redirect("default.aspx");
  1986. }
  1987.  
  1988. protected void btn_spot3_1_Click(object sender, EventArgs e)
  1989. {
  1990. spot3_1.Text = ddl_spot3_1.SelectedItem.Text;
  1991. con.Open();
  1992. MySqlCommand cmd = con.CreateCommand();
  1993. cmd.CommandType = CommandType.Text;
  1994. cmd.CommandText = "UPDATE kalender SET 4_2='" + spot3_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  1995. cmd.ExecuteNonQuery();
  1996. spot3_1.Text = "";
  1997. con.Close();
  1998. Response.Redirect("default.aspx");
  1999. }
  2000.  
  2001. protected void btn_removespot3_1_Click(object sender, EventArgs e)
  2002. {
  2003. con.Open();
  2004. MySqlCommand cmd = con.CreateCommand();
  2005. cmd.CommandType = CommandType.Text;
  2006. cmd.CommandText = "UPDATE kalender SET 4_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2007. cmd.ExecuteNonQuery();
  2008. spot3_1.Text = "";
  2009. con.Close();
  2010. Response.Redirect("default.aspx");
  2011. }
  2012.  
  2013. protected void btn_spot4_0_Click(object sender, EventArgs e)
  2014. {
  2015. spot4_0.Text = ddl_spot4_0.SelectedItem.Text;
  2016. con.Open();
  2017. MySqlCommand cmd = con.CreateCommand();
  2018. cmd.CommandType = CommandType.Text;
  2019. cmd.CommandText = "UPDATE kalender SET 5_1='" + spot4_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2020. cmd.ExecuteNonQuery();
  2021. spot4_0.Text = "";
  2022. con.Close();
  2023. Response.Redirect("default.aspx");
  2024. }
  2025.  
  2026. protected void btn_removespot4_0_Click(object sender, EventArgs e)
  2027. {
  2028. con.Open();
  2029. MySqlCommand cmd = con.CreateCommand();
  2030. cmd.CommandType = CommandType.Text;
  2031. cmd.CommandText = "UPDATE kalender SET 5_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2032. cmd.ExecuteNonQuery();
  2033. spot4_0.Text = "";
  2034. con.Close();
  2035. Response.Redirect("default.aspx");
  2036. }
  2037.  
  2038. protected void btn_spot4_1_Click(object sender, EventArgs e)
  2039. {
  2040. spot4_1.Text = ddl_spot4_1.SelectedItem.Text;
  2041. con.Open();
  2042. MySqlCommand cmd = con.CreateCommand();
  2043. cmd.CommandType = CommandType.Text;
  2044. cmd.CommandText = "UPDATE kalender SET 5_2='" + spot4_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2045. cmd.ExecuteNonQuery();
  2046. spot4_1.Text = "";
  2047. con.Close();
  2048. Response.Redirect("default.aspx");
  2049. }
  2050.  
  2051. protected void btn_removespot4_1_Click(object sender, EventArgs e)
  2052. {
  2053. con.Open();
  2054. MySqlCommand cmd = con.CreateCommand();
  2055. cmd.CommandType = CommandType.Text;
  2056. cmd.CommandText = "UPDATE kalender SET 5_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2057. cmd.ExecuteNonQuery();
  2058. spot4_1.Text = "";
  2059. con.Close();
  2060. Response.Redirect("default.aspx");
  2061. }
  2062.  
  2063. protected void btn_spot5_0_Click(object sender, EventArgs e)
  2064. {
  2065. spot5_0.Text = ddl_spot5_0.SelectedItem.Text;
  2066. con.Open();
  2067. MySqlCommand cmd = con.CreateCommand();
  2068. cmd.CommandType = CommandType.Text;
  2069. cmd.CommandText = "UPDATE kalender SET 6_1='" + spot5_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2070. cmd.ExecuteNonQuery();
  2071. spot5_0.Text = "";
  2072. con.Close();
  2073. Response.Redirect("default.aspx");
  2074. }
  2075.  
  2076. protected void btn_removespot5_0_Click(object sender, EventArgs e)
  2077. {
  2078. con.Open();
  2079. MySqlCommand cmd = con.CreateCommand();
  2080. cmd.CommandType = CommandType.Text;
  2081. cmd.CommandText = "UPDATE kalender SET 6_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2082. cmd.ExecuteNonQuery();
  2083. spot5_0.Text = "";
  2084. con.Close();
  2085. Response.Redirect("default.aspx");
  2086. }
  2087.  
  2088. protected void btn_spot5_1_Click(object sender, EventArgs e)
  2089. {
  2090. spot5_1.Text = ddl_spot5_1.SelectedItem.Text;
  2091. con.Open();
  2092. MySqlCommand cmd = con.CreateCommand();
  2093. cmd.CommandType = CommandType.Text;
  2094. cmd.CommandText = "UPDATE kalender SET 6_2='" + spot5_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2095. cmd.ExecuteNonQuery();
  2096. spot5_1.Text = "";
  2097. con.Close();
  2098. Response.Redirect("default.aspx");
  2099. }
  2100.  
  2101. protected void btn_removespot5_1_Click(object sender, EventArgs e)
  2102. {
  2103. con.Open();
  2104. MySqlCommand cmd = con.CreateCommand();
  2105. cmd.CommandType = CommandType.Text;
  2106. cmd.CommandText = "UPDATE kalender SET 6_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2107. cmd.ExecuteNonQuery();
  2108. spot5_1.Text = "";
  2109. con.Close();
  2110. Response.Redirect("default.aspx");
  2111. }
  2112.  
  2113. protected void btn_spot6_0_Click(object sender, EventArgs e)
  2114. {
  2115. spot6_0.Text = ddl_spot6_0.SelectedItem.Text;
  2116. con.Open();
  2117. MySqlCommand cmd = con.CreateCommand();
  2118. cmd.CommandType = CommandType.Text;
  2119. cmd.CommandText = "UPDATE kalender SET 7_1='" + spot6_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2120. cmd.ExecuteNonQuery();
  2121. spot6_0.Text = "";
  2122. con.Close();
  2123. Response.Redirect("default.aspx");
  2124. }
  2125.  
  2126. protected void btn_removespot6_0_Click(object sender, EventArgs e)
  2127. {
  2128. con.Open();
  2129. MySqlCommand cmd = con.CreateCommand();
  2130. cmd.CommandType = CommandType.Text;
  2131. cmd.CommandText = "UPDATE kalender SET 7_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2132. cmd.ExecuteNonQuery();
  2133. spot6_0.Text = "";
  2134. con.Close();
  2135. Response.Redirect("default.aspx");
  2136. }
  2137.  
  2138. protected void btn_spot6_1_Click(object sender, EventArgs e)
  2139. {
  2140. spot6_1.Text = ddl_spot6_1.SelectedItem.Text;
  2141. con.Open();
  2142. MySqlCommand cmd = con.CreateCommand();
  2143. cmd.CommandType = CommandType.Text;
  2144. cmd.CommandText = "UPDATE kalender SET 7_2='" + spot6_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2145. cmd.ExecuteNonQuery();
  2146. spot6_1.Text = "";
  2147. con.Close();
  2148. Response.Redirect("default.aspx");
  2149. }
  2150.  
  2151. protected void btn_removespot6_1_Click(object sender, EventArgs e)
  2152. {
  2153. con.Open();
  2154. MySqlCommand cmd = con.CreateCommand();
  2155. cmd.CommandType = CommandType.Text;
  2156. cmd.CommandText = "UPDATE kalender SET 7_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2157. cmd.ExecuteNonQuery();
  2158. spot6_1.Text = "";
  2159. con.Close();
  2160. Response.Redirect("default.aspx");
  2161. }
  2162.  
  2163. protected void btn_spot7_0_Click(object sender, EventArgs e)
  2164. {
  2165. spot7_0.Text = ddl_spot7_0.SelectedItem.Text;
  2166. con.Open();
  2167. MySqlCommand cmd = con.CreateCommand();
  2168. cmd.CommandType = CommandType.Text;
  2169. cmd.CommandText = "UPDATE kalender SET 8_1='" + spot7_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2170. cmd.ExecuteNonQuery();
  2171. spot7_0.Text = "";
  2172. con.Close();
  2173. Response.Redirect("default.aspx");
  2174. }
  2175.  
  2176. protected void btn_removespot7_0_Click(object sender, EventArgs e)
  2177. {
  2178. con.Open();
  2179. MySqlCommand cmd = con.CreateCommand();
  2180. cmd.CommandType = CommandType.Text;
  2181. cmd.CommandText = "UPDATE kalender SET 8_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2182. cmd.ExecuteNonQuery();
  2183. spot7_0.Text = "";
  2184. con.Close();
  2185. Response.Redirect("default.aspx");
  2186. }
  2187.  
  2188. protected void btn_spot7_1_Click(object sender, EventArgs e)
  2189. {
  2190. spot7_1.Text = ddl_spot7_1.SelectedItem.Text;
  2191. con.Open();
  2192. MySqlCommand cmd = con.CreateCommand();
  2193. cmd.CommandType = CommandType.Text;
  2194. cmd.CommandText = "UPDATE kalender SET 8_2='" + spot7_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2195. cmd.ExecuteNonQuery();
  2196. spot7_1.Text = "";
  2197. con.Close();
  2198. Response.Redirect("default.aspx");
  2199. }
  2200.  
  2201. protected void btn_removespot7_1_Click(object sender, EventArgs e)
  2202. {
  2203. con.Open();
  2204. MySqlCommand cmd = con.CreateCommand();
  2205. cmd.CommandType = CommandType.Text;
  2206. cmd.CommandText = "UPDATE kalender SET 8_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2207. cmd.ExecuteNonQuery();
  2208. spot7_1.Text = "";
  2209. con.Close();
  2210. Response.Redirect("default.aspx");
  2211. }
  2212.  
  2213. protected void btn_spot8_0_Click(object sender, EventArgs e)
  2214. {
  2215. spot8_0.Text = ddl_spot8_0.SelectedItem.Text;
  2216. con.Open();
  2217. MySqlCommand cmd = con.CreateCommand();
  2218. cmd.CommandType = CommandType.Text;
  2219. cmd.CommandText = "UPDATE kalender SET 9_1='" + spot8_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2220. cmd.ExecuteNonQuery();
  2221. spot8_0.Text = "";
  2222. con.Close();
  2223. Response.Redirect("default.aspx");
  2224. }
  2225.  
  2226. protected void btn_removespot8_0_Click(object sender, EventArgs e)
  2227. {
  2228. con.Open();
  2229. MySqlCommand cmd = con.CreateCommand();
  2230. cmd.CommandType = CommandType.Text;
  2231. cmd.CommandText = "UPDATE kalender SET 9_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2232. cmd.ExecuteNonQuery();
  2233. spot8_0.Text = "";
  2234. con.Close();
  2235. Response.Redirect("default.aspx");
  2236. }
  2237.  
  2238. protected void btn_spot8_1_Click(object sender, EventArgs e)
  2239. {
  2240. spot8_1.Text = ddl_spot8_1.SelectedItem.Text;
  2241. con.Open();
  2242. MySqlCommand cmd = con.CreateCommand();
  2243. cmd.CommandType = CommandType.Text;
  2244. cmd.CommandText = "UPDATE kalender SET 9_2='" + spot8_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2245. cmd.ExecuteNonQuery();
  2246. spot8_1.Text = "";
  2247. con.Close();
  2248. Response.Redirect("default.aspx");
  2249. }
  2250.  
  2251. protected void btn_removespot8_1_Click(object sender, EventArgs e)
  2252. {
  2253. con.Open();
  2254. MySqlCommand cmd = con.CreateCommand();
  2255. cmd.CommandType = CommandType.Text;
  2256. cmd.CommandText = "UPDATE kalender SET 9_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2257. cmd.ExecuteNonQuery();
  2258. spot8_1.Text = "";
  2259. con.Close();
  2260. Response.Redirect("default.aspx");
  2261. }
  2262.  
  2263. protected void btn_spot9_0_Click(object sender, EventArgs e)
  2264. {
  2265. spot9_0.Text = ddl_spot9_0.SelectedItem.Text;
  2266. con.Open();
  2267. MySqlCommand cmd = con.CreateCommand();
  2268. cmd.CommandType = CommandType.Text;
  2269. cmd.CommandText = "UPDATE kalender SET 10_1='" + spot9_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2270. cmd.ExecuteNonQuery();
  2271. spot9_0.Text = "";
  2272. con.Close();
  2273. Response.Redirect("default.aspx");
  2274. }
  2275.  
  2276. protected void btn_removespot9_0_Click(object sender, EventArgs e)
  2277. {
  2278. con.Open();
  2279. MySqlCommand cmd = con.CreateCommand();
  2280. cmd.CommandType = CommandType.Text;
  2281. cmd.CommandText = "UPDATE kalender SET 10_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2282. cmd.ExecuteNonQuery();
  2283. spot9_0.Text = "";
  2284. con.Close();
  2285. Response.Redirect("default.aspx");
  2286. }
  2287.  
  2288. protected void btn_spot9_1_Click(object sender, EventArgs e)
  2289. {
  2290. spot9_1.Text = ddl_spot9_1.SelectedItem.Text;
  2291. con.Open();
  2292. MySqlCommand cmd = con.CreateCommand();
  2293. cmd.CommandType = CommandType.Text;
  2294. cmd.CommandText = "UPDATE kalender SET 10_2='" + spot9_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2295. cmd.ExecuteNonQuery();
  2296. spot9_1.Text = "";
  2297. con.Close();
  2298. Response.Redirect("default.aspx");
  2299. }
  2300.  
  2301. protected void btn_removespot9_1_Click(object sender, EventArgs e)
  2302. {
  2303. con.Open();
  2304. MySqlCommand cmd = con.CreateCommand();
  2305. cmd.CommandType = CommandType.Text;
  2306. cmd.CommandText = "UPDATE kalender SET 10_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2307. cmd.ExecuteNonQuery();
  2308. spot9_1.Text = "";
  2309. con.Close();
  2310. Response.Redirect("default.aspx");
  2311. }
  2312.  
  2313. protected void btn_spot10_0_Click(object sender, EventArgs e)
  2314. {
  2315. spot10_0.Text = ddl_spot10_0.SelectedItem.Text;
  2316. con.Open();
  2317. MySqlCommand cmd = con.CreateCommand();
  2318. cmd.CommandType = CommandType.Text;
  2319. cmd.CommandText = "UPDATE kalender SET 11_1='" + spot10_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2320. cmd.ExecuteNonQuery();
  2321. spot10_0.Text = "";
  2322. con.Close();
  2323. Response.Redirect("default.aspx");
  2324. }
  2325.  
  2326. protected void btn_removespot10_0_Click(object sender, EventArgs e)
  2327. {
  2328. con.Open();
  2329. MySqlCommand cmd = con.CreateCommand();
  2330. cmd.CommandType = CommandType.Text;
  2331. cmd.CommandText = "UPDATE kalender SET 11_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2332. cmd.ExecuteNonQuery();
  2333. spot10_0.Text = "";
  2334. con.Close();
  2335. Response.Redirect("default.aspx");
  2336. }
  2337.  
  2338. protected void btn_spot10_1_Click(object sender, EventArgs e)
  2339. {
  2340. spot10_1.Text = ddl_spot10_1.SelectedItem.Text;
  2341. con.Open();
  2342. MySqlCommand cmd = con.CreateCommand();
  2343. cmd.CommandType = CommandType.Text;
  2344. cmd.CommandText = "UPDATE kalender SET 11_2='" + spot10_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2345. cmd.ExecuteNonQuery();
  2346. spot10_1.Text = "";
  2347. con.Close();
  2348. Response.Redirect("default.aspx");
  2349. }
  2350.  
  2351. protected void btn_removespot10_1_Click(object sender, EventArgs e)
  2352. {
  2353. con.Open();
  2354. MySqlCommand cmd = con.CreateCommand();
  2355. cmd.CommandType = CommandType.Text;
  2356. cmd.CommandText = "UPDATE kalender SET 11_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2357. cmd.ExecuteNonQuery();
  2358. spot10_1.Text = "";
  2359. con.Close();
  2360. Response.Redirect("default.aspx");
  2361. }
  2362.  
  2363. protected void btn_spot11_0_Click(object sender, EventArgs e)
  2364. {
  2365. spot11_0.Text = ddl_spot11_0.SelectedItem.Text;
  2366. con.Open();
  2367. MySqlCommand cmd = con.CreateCommand();
  2368. cmd.CommandType = CommandType.Text;
  2369. cmd.CommandText = "UPDATE kalender SET 12_1='" + spot11_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2370. cmd.ExecuteNonQuery();
  2371. spot11_0.Text = "";
  2372. con.Close();
  2373. Response.Redirect("default.aspx");
  2374. }
  2375.  
  2376. protected void btn_removespot11_0_Click(object sender, EventArgs e)
  2377. {
  2378. con.Open();
  2379. MySqlCommand cmd = con.CreateCommand();
  2380. cmd.CommandType = CommandType.Text;
  2381. cmd.CommandText = "UPDATE kalender SET 12_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2382. cmd.ExecuteNonQuery();
  2383. spot11_0.Text = "";
  2384. con.Close();
  2385. Response.Redirect("default.aspx");
  2386. }
  2387.  
  2388. protected void btn_spot11_1_Click(object sender, EventArgs e)
  2389. {
  2390. spot11_1.Text = ddl_spot11_1.SelectedItem.Text;
  2391. con.Open();
  2392. MySqlCommand cmd = con.CreateCommand();
  2393. cmd.CommandType = CommandType.Text;
  2394. cmd.CommandText = "UPDATE kalender SET 12_2='" + spot11_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2395. cmd.ExecuteNonQuery();
  2396. spot11_1.Text = "";
  2397. con.Close();
  2398. Response.Redirect("default.aspx");
  2399. }
  2400.  
  2401. protected void btn_removespot11_1_Click(object sender, EventArgs e)
  2402. {
  2403. con.Open();
  2404. MySqlCommand cmd = con.CreateCommand();
  2405. cmd.CommandType = CommandType.Text;
  2406. cmd.CommandText = "UPDATE kalender SET 12_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2407. cmd.ExecuteNonQuery();
  2408. spot11_1.Text = "";
  2409. con.Close();
  2410. Response.Redirect("default.aspx");
  2411. }
  2412.  
  2413. protected void btn_spot12_0_Click(object sender, EventArgs e)
  2414. {
  2415. spot12_0.Text = ddl_spot12_0.SelectedItem.Text;
  2416. con.Open();
  2417. MySqlCommand cmd = con.CreateCommand();
  2418. cmd.CommandType = CommandType.Text;
  2419. cmd.CommandText = "UPDATE kalender SET 13_1='" + spot12_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2420. cmd.ExecuteNonQuery();
  2421. spot12_0.Text = "";
  2422. con.Close();
  2423. Response.Redirect("default.aspx");
  2424. }
  2425.  
  2426. protected void btn_removespot12_0_Click(object sender, EventArgs e)
  2427. {
  2428. con.Open();
  2429. MySqlCommand cmd = con.CreateCommand();
  2430. cmd.CommandType = CommandType.Text;
  2431. cmd.CommandText = "UPDATE kalender SET 13_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2432. cmd.ExecuteNonQuery();
  2433. spot12_0.Text = "";
  2434. con.Close();
  2435. Response.Redirect("default.aspx");
  2436. }
  2437.  
  2438. protected void btn_spot12_1_Click(object sender, EventArgs e)
  2439. {
  2440. spot12_1.Text = ddl_spot12_1.SelectedItem.Text;
  2441. con.Open();
  2442. MySqlCommand cmd = con.CreateCommand();
  2443. cmd.CommandType = CommandType.Text;
  2444. cmd.CommandText = "UPDATE kalender SET 13_2='" + spot12_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2445. cmd.ExecuteNonQuery();
  2446. spot12_1.Text = "";
  2447. con.Close();
  2448. Response.Redirect("default.aspx");
  2449. }
  2450.  
  2451. protected void btn_removespot12_1_Click(object sender, EventArgs e)
  2452. {
  2453. con.Open();
  2454. MySqlCommand cmd = con.CreateCommand();
  2455. cmd.CommandType = CommandType.Text;
  2456. cmd.CommandText = "UPDATE kalender SET 13_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2457. cmd.ExecuteNonQuery();
  2458. spot12_1.Text = "";
  2459. con.Close();
  2460. Response.Redirect("default.aspx");
  2461. }
  2462.  
  2463. protected void btn_spot13_0_Click(object sender, EventArgs e)
  2464. {
  2465. spot13_0.Text = ddl_spot13_0.SelectedItem.Text;
  2466. con.Open();
  2467. MySqlCommand cmd = con.CreateCommand();
  2468. cmd.CommandType = CommandType.Text;
  2469. cmd.CommandText = "UPDATE kalender SET 14_1='" + spot13_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2470. cmd.ExecuteNonQuery();
  2471. spot13_0.Text = "";
  2472. con.Close();
  2473. Response.Redirect("default.aspx");
  2474. }
  2475.  
  2476. protected void btn_removespot13_0_Click(object sender, EventArgs e)
  2477. {
  2478. con.Open();
  2479. MySqlCommand cmd = con.CreateCommand();
  2480. cmd.CommandType = CommandType.Text;
  2481. cmd.CommandText = "UPDATE kalender SET 14_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2482. cmd.ExecuteNonQuery();
  2483. spot13_0.Text = "";
  2484. con.Close();
  2485. Response.Redirect("default.aspx");
  2486. }
  2487.  
  2488. protected void btn_spot13_1_Click(object sender, EventArgs e)
  2489. {
  2490. spot13_1.Text = ddl_spot13_1.SelectedItem.Text;
  2491. con.Open();
  2492. MySqlCommand cmd = con.CreateCommand();
  2493. cmd.CommandType = CommandType.Text;
  2494. cmd.CommandText = "UPDATE kalender SET 14_2='" + spot13_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2495. cmd.ExecuteNonQuery();
  2496. spot13_1.Text = "";
  2497. con.Close();
  2498. Response.Redirect("default.aspx");
  2499. }
  2500.  
  2501. protected void btn_removespot13_1_Click(object sender, EventArgs e)
  2502. {
  2503. con.Open();
  2504. MySqlCommand cmd = con.CreateCommand();
  2505. cmd.CommandType = CommandType.Text;
  2506. cmd.CommandText = "UPDATE kalender SET 14_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2507. cmd.ExecuteNonQuery();
  2508. spot13_1.Text = "";
  2509. con.Close();
  2510. Response.Redirect("default.aspx");
  2511. }
  2512.  
  2513. protected void btn_spot14_0_Click(object sender, EventArgs e)
  2514. {
  2515. spot14_0.Text = ddl_spot14_0.SelectedItem.Text;
  2516. con.Open();
  2517. MySqlCommand cmd = con.CreateCommand();
  2518. cmd.CommandType = CommandType.Text;
  2519. cmd.CommandText = "UPDATE kalender SET 15_1='" + spot14_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2520. cmd.ExecuteNonQuery();
  2521. spot14_0.Text = "";
  2522. con.Close();
  2523. Response.Redirect("default.aspx");
  2524. }
  2525.  
  2526. protected void btn_removespot14_0_Click(object sender, EventArgs e)
  2527. {
  2528. con.Open();
  2529. MySqlCommand cmd = con.CreateCommand();
  2530. cmd.CommandType = CommandType.Text;
  2531. cmd.CommandText = "UPDATE kalender SET 15_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2532. cmd.ExecuteNonQuery();
  2533. spot14_0.Text = "";
  2534. con.Close();
  2535. Response.Redirect("default.aspx");
  2536. }
  2537.  
  2538.  
  2539. protected void btn_spot14_1_Click(object sender, EventArgs e)
  2540. {
  2541. spot14_1.Text = ddl_spot14_1.SelectedItem.Text;
  2542. con.Open();
  2543. MySqlCommand cmd = con.CreateCommand();
  2544. cmd.CommandType = CommandType.Text;
  2545. cmd.CommandText = "UPDATE kalender SET 15_2='" + spot14_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2546. cmd.ExecuteNonQuery();
  2547. spot14_1.Text = "";
  2548. con.Close();
  2549. Response.Redirect("default.aspx");
  2550. }
  2551.  
  2552. protected void btn_removespot14_1_Click(object sender, EventArgs e)
  2553. {
  2554. con.Open();
  2555. MySqlCommand cmd = con.CreateCommand();
  2556. cmd.CommandType = CommandType.Text;
  2557. cmd.CommandText = "UPDATE kalender SET 15_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2558. cmd.ExecuteNonQuery();
  2559. spot14_1.Text = "";
  2560. con.Close();
  2561. Response.Redirect("default.aspx");
  2562. }
  2563.  
  2564. protected void btn_spot15_0_Click(object sender, EventArgs e)
  2565. {
  2566. spot15_0.Text = ddl_spot15_0.SelectedItem.Text;
  2567. con.Open();
  2568. MySqlCommand cmd = con.CreateCommand();
  2569. cmd.CommandType = CommandType.Text;
  2570. cmd.CommandText = "UPDATE kalender SET 16_1='" + spot15_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2571. cmd.ExecuteNonQuery();
  2572. spot15_0.Text = "";
  2573. con.Close();
  2574. Response.Redirect("default.aspx");
  2575. }
  2576.  
  2577. protected void btn_removespot15_0_Click(object sender, EventArgs e)
  2578. {
  2579. con.Open();
  2580. MySqlCommand cmd = con.CreateCommand();
  2581. cmd.CommandType = CommandType.Text;
  2582. cmd.CommandText = "UPDATE kalender SET 16_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2583. cmd.ExecuteNonQuery();
  2584. spot15_0.Text = "";
  2585. con.Close();
  2586. Response.Redirect("default.aspx");
  2587. }
  2588.  
  2589. protected void btn_spot15_1_Click(object sender, EventArgs e)
  2590. {
  2591. spot15_1.Text = ddl_spot15_1.SelectedItem.Text;
  2592. con.Open();
  2593. MySqlCommand cmd = con.CreateCommand();
  2594. cmd.CommandType = CommandType.Text;
  2595. cmd.CommandText = "UPDATE kalender SET 16_2='" + spot15_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2596. cmd.ExecuteNonQuery();
  2597. spot15_1.Text = "";
  2598. con.Close();
  2599. Response.Redirect("default.aspx");
  2600. }
  2601.  
  2602. protected void btn_removespot15_1_Click(object sender, EventArgs e)
  2603. {
  2604. con.Open();
  2605. MySqlCommand cmd = con.CreateCommand();
  2606. cmd.CommandType = CommandType.Text;
  2607. cmd.CommandText = "UPDATE kalender SET 16_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2608. cmd.ExecuteNonQuery();
  2609. spot15_1.Text = "";
  2610. con.Close();
  2611. Response.Redirect("default.aspx");
  2612. }
  2613.  
  2614. protected void btn_spot16_0_Click(object sender, EventArgs e)
  2615. {
  2616. spot16_0.Text = ddl_spot16_0.SelectedItem.Text;
  2617. con.Open();
  2618. MySqlCommand cmd = con.CreateCommand();
  2619. cmd.CommandType = CommandType.Text;
  2620. cmd.CommandText = "UPDATE kalender SET 17_1='" + spot16_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2621. cmd.ExecuteNonQuery();
  2622. spot16_0.Text = "";
  2623. con.Close();
  2624. Response.Redirect("default.aspx");
  2625. }
  2626.  
  2627. protected void btn_removespot16_0_Click(object sender, EventArgs e)
  2628. {
  2629. con.Open();
  2630. MySqlCommand cmd = con.CreateCommand();
  2631. cmd.CommandType = CommandType.Text;
  2632. cmd.CommandText = "UPDATE kalender SET 17_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2633. cmd.ExecuteNonQuery();
  2634. spot16_0.Text = "";
  2635. con.Close();
  2636. Response.Redirect("default.aspx");
  2637. }
  2638.  
  2639. protected void btn_spot16_1_Click(object sender, EventArgs e)
  2640. {
  2641. spot16_1.Text = ddl_spot16_1.SelectedItem.Text;
  2642. con.Open();
  2643. MySqlCommand cmd = con.CreateCommand();
  2644. cmd.CommandType = CommandType.Text;
  2645. cmd.CommandText = "UPDATE kalender SET 17_2='" + spot16_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2646. cmd.ExecuteNonQuery();
  2647. spot16_1.Text = "";
  2648. con.Close();
  2649. Response.Redirect("default.aspx");
  2650. }
  2651.  
  2652. protected void btn_removespot16_1_Click(object sender, EventArgs e)
  2653. {
  2654. con.Open();
  2655. MySqlCommand cmd = con.CreateCommand();
  2656. cmd.CommandType = CommandType.Text;
  2657. cmd.CommandText = "UPDATE kalender SET 17_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2658. cmd.ExecuteNonQuery();
  2659. spot16_1.Text = "";
  2660. con.Close();
  2661. Response.Redirect("default.aspx");
  2662. }
  2663.  
  2664. protected void btn_spot17_0_Click(object sender, EventArgs e)
  2665. {
  2666. spot17_0.Text = ddl_spot17_0.SelectedItem.Text;
  2667. con.Open();
  2668. MySqlCommand cmd = con.CreateCommand();
  2669. cmd.CommandType = CommandType.Text;
  2670. cmd.CommandText = "UPDATE kalender SET 18_1='" + spot17_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2671. cmd.ExecuteNonQuery();
  2672. spot17_0.Text = "";
  2673. con.Close();
  2674. Response.Redirect("default.aspx");
  2675. }
  2676.  
  2677. protected void btn_removespot17_0_Click(object sender, EventArgs e)
  2678. {
  2679. con.Open();
  2680. MySqlCommand cmd = con.CreateCommand();
  2681. cmd.CommandType = CommandType.Text;
  2682. cmd.CommandText = "UPDATE kalender SET 18_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2683. cmd.ExecuteNonQuery();
  2684. spot17_0.Text = "";
  2685. con.Close();
  2686. Response.Redirect("default.aspx");
  2687. }
  2688.  
  2689. protected void btn_spot17_1_Click(object sender, EventArgs e)
  2690. {
  2691. spot17_1.Text = ddl_spot17_1.SelectedItem.Text;
  2692. con.Open();
  2693. MySqlCommand cmd = con.CreateCommand();
  2694. cmd.CommandType = CommandType.Text;
  2695. cmd.CommandText = "UPDATE kalender SET 18_2='" + spot17_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2696. cmd.ExecuteNonQuery();
  2697. spot17_1.Text = "";
  2698. con.Close();
  2699. Response.Redirect("default.aspx");
  2700. }
  2701.  
  2702. protected void btn_removespot17_1_Click(object sender, EventArgs e)
  2703. {
  2704. con.Open();
  2705. MySqlCommand cmd = con.CreateCommand();
  2706. cmd.CommandType = CommandType.Text;
  2707. cmd.CommandText = "UPDATE kalender SET 18_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2708. cmd.ExecuteNonQuery();
  2709. spot17_1.Text = "";
  2710. con.Close();
  2711. Response.Redirect("default.aspx");
  2712. }
  2713.  
  2714. protected void btn_spot18_0_Click(object sender, EventArgs e)
  2715. {
  2716. spot18_0.Text = ddl_spot18_0.SelectedItem.Text;
  2717. con.Open();
  2718. MySqlCommand cmd = con.CreateCommand();
  2719. cmd.CommandType = CommandType.Text;
  2720. cmd.CommandText = "UPDATE kalender SET 19_1='" + spot18_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2721. cmd.ExecuteNonQuery();
  2722. spot18_0.Text = "";
  2723. con.Close();
  2724. Response.Redirect("default.aspx");
  2725. }
  2726.  
  2727. protected void btn_removespot18_0_Click(object sender, EventArgs e)
  2728. {
  2729. con.Open();
  2730. MySqlCommand cmd = con.CreateCommand();
  2731. cmd.CommandType = CommandType.Text;
  2732. cmd.CommandText = "UPDATE kalender SET 19_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2733. cmd.ExecuteNonQuery();
  2734. spot18_0.Text = "";
  2735. con.Close();
  2736. Response.Redirect("default.aspx");
  2737. }
  2738.  
  2739. protected void btn_spot18_1_Click(object sender, EventArgs e)
  2740. {
  2741. spot18_1.Text = ddl_spot18_1.SelectedItem.Text;
  2742. con.Open();
  2743. MySqlCommand cmd = con.CreateCommand();
  2744. cmd.CommandType = CommandType.Text;
  2745. cmd.CommandText = "UPDATE kalender SET 19_2='" + spot18_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2746. cmd.ExecuteNonQuery();
  2747. spot18_1.Text = "";
  2748. con.Close();
  2749. Response.Redirect("default.aspx");
  2750. }
  2751.  
  2752. protected void btn_removespot18_1_Click(object sender, EventArgs e)
  2753. {
  2754. con.Open();
  2755. MySqlCommand cmd = con.CreateCommand();
  2756. cmd.CommandType = CommandType.Text;
  2757. cmd.CommandText = "UPDATE kalender SET 19_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2758. cmd.ExecuteNonQuery();
  2759. spot18_1.Text = "";
  2760. con.Close();
  2761. Response.Redirect("default.aspx");
  2762. }
  2763.  
  2764. protected void btn_spot19_0_Click(object sender, EventArgs e)
  2765. {
  2766. spot19_0.Text = ddl_spot19_0.SelectedItem.Text;
  2767. con.Open();
  2768. MySqlCommand cmd = con.CreateCommand();
  2769. cmd.CommandType = CommandType.Text;
  2770. cmd.CommandText = "UPDATE kalender SET 20_1='" + spot19_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2771. cmd.ExecuteNonQuery();
  2772. spot19_0.Text = "";
  2773. con.Close();
  2774. Response.Redirect("default.aspx");
  2775. }
  2776.  
  2777. protected void btn_removespot19_0_Click(object sender, EventArgs e)
  2778. {
  2779. con.Open();
  2780. MySqlCommand cmd = con.CreateCommand();
  2781. cmd.CommandType = CommandType.Text;
  2782. cmd.CommandText = "UPDATE kalender SET 20_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2783. cmd.ExecuteNonQuery();
  2784. spot19_0.Text = "";
  2785. con.Close();
  2786. Response.Redirect("default.aspx");
  2787. }
  2788.  
  2789. protected void btn_spot19_1_Click(object sender, EventArgs e)
  2790. {
  2791. spot19_1.Text = ddl_spot19_1.SelectedItem.Text;
  2792. con.Open();
  2793. MySqlCommand cmd = con.CreateCommand();
  2794. cmd.CommandType = CommandType.Text;
  2795. cmd.CommandText = "UPDATE kalender SET 20_2='" + spot19_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2796. cmd.ExecuteNonQuery();
  2797. spot19_1.Text = "";
  2798. con.Close();
  2799. Response.Redirect("default.aspx");
  2800. }
  2801.  
  2802. protected void btn_removespot19_1_Click(object sender, EventArgs e)
  2803. {
  2804. con.Open();
  2805. MySqlCommand cmd = con.CreateCommand();
  2806. cmd.CommandType = CommandType.Text;
  2807. cmd.CommandText = "UPDATE kalender SET 20_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2808. cmd.ExecuteNonQuery();
  2809. spot19_1.Text = "";
  2810. con.Close();
  2811. Response.Redirect("default.aspx");
  2812. }
  2813.  
  2814. protected void btn_spot20_0_Click(object sender, EventArgs e)
  2815. {
  2816. spot20_0.Text = ddl_spot20_0.SelectedItem.Text;
  2817. con.Open();
  2818. MySqlCommand cmd = con.CreateCommand();
  2819. cmd.CommandType = CommandType.Text;
  2820. cmd.CommandText = "UPDATE kalender SET 21_1='" + spot20_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2821. cmd.ExecuteNonQuery();
  2822. spot20_0.Text = "";
  2823. con.Close();
  2824. Response.Redirect("default.aspx");
  2825. }
  2826.  
  2827. protected void btn_removespot20_0_Click(object sender, EventArgs e)
  2828. {
  2829. con.Open();
  2830. MySqlCommand cmd = con.CreateCommand();
  2831. cmd.CommandType = CommandType.Text;
  2832. cmd.CommandText = "UPDATE kalender SET 21_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2833. cmd.ExecuteNonQuery();
  2834. spot20_0.Text = "";
  2835. con.Close();
  2836. Response.Redirect("default.aspx");
  2837. }
  2838.  
  2839. protected void btn_spot20_1_Click(object sender, EventArgs e)
  2840. {
  2841. spot20_1.Text = ddl_spot20_1.SelectedItem.Text;
  2842. con.Open();
  2843. MySqlCommand cmd = con.CreateCommand();
  2844. cmd.CommandType = CommandType.Text;
  2845. cmd.CommandText = "UPDATE kalender SET 21_2='" + spot20_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2846. cmd.ExecuteNonQuery();
  2847. spot20_1.Text = "";
  2848. con.Close();
  2849. Response.Redirect("default.aspx");
  2850. }
  2851.  
  2852. protected void btn_removespot20_1_Click(object sender, EventArgs e)
  2853. {
  2854. con.Open();
  2855. MySqlCommand cmd = con.CreateCommand();
  2856. cmd.CommandType = CommandType.Text;
  2857. cmd.CommandText = "UPDATE kalender SET 21_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2858. cmd.ExecuteNonQuery();
  2859. spot20_1.Text = "";
  2860. con.Close();
  2861. Response.Redirect("default.aspx");
  2862. }
  2863.  
  2864. protected void btn_spot21_0_Click(object sender, EventArgs e)
  2865. {
  2866. spot21_0.Text = ddl_spot21_0.SelectedItem.Text;
  2867. con.Open();
  2868. MySqlCommand cmd = con.CreateCommand();
  2869. cmd.CommandType = CommandType.Text;
  2870. cmd.CommandText = "UPDATE kalender SET 22_1='" + spot21_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2871. cmd.ExecuteNonQuery();
  2872. spot21_0.Text = "";
  2873. con.Close();
  2874. Response.Redirect("default.aspx");
  2875. }
  2876.  
  2877. protected void btn_removespot21_0_Click(object sender, EventArgs e)
  2878. {
  2879. con.Open();
  2880. MySqlCommand cmd = con.CreateCommand();
  2881. cmd.CommandType = CommandType.Text;
  2882. cmd.CommandText = "UPDATE kalender SET 22_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2883. cmd.ExecuteNonQuery();
  2884. spot21_0.Text = "";
  2885. con.Close();
  2886. Response.Redirect("default.aspx");
  2887. }
  2888.  
  2889. protected void btn_spot21_1_Click(object sender, EventArgs e)
  2890. {
  2891. spot21_1.Text = ddl_spot21_1.SelectedItem.Text;
  2892. con.Open();
  2893. MySqlCommand cmd = con.CreateCommand();
  2894. cmd.CommandType = CommandType.Text;
  2895. cmd.CommandText = "UPDATE kalender SET 22_2='" + spot21_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2896. cmd.ExecuteNonQuery();
  2897. spot21_1.Text = "";
  2898. con.Close();
  2899. Response.Redirect("default.aspx");
  2900. }
  2901.  
  2902. protected void btn_removespot21_1_Click(object sender, EventArgs e)
  2903. {
  2904. con.Open();
  2905. MySqlCommand cmd = con.CreateCommand();
  2906. cmd.CommandType = CommandType.Text;
  2907. cmd.CommandText = "UPDATE kalender SET 22_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2908. cmd.ExecuteNonQuery();
  2909. spot21_1.Text = "";
  2910. con.Close();
  2911. Response.Redirect("default.aspx");
  2912. }
  2913.  
  2914. protected void btn_spot22_0_Click(object sender, EventArgs e)
  2915. {
  2916. spot22_0.Text = ddl_spot22_0.SelectedItem.Text;
  2917. con.Open();
  2918. MySqlCommand cmd = con.CreateCommand();
  2919. cmd.CommandType = CommandType.Text;
  2920. cmd.CommandText = "UPDATE kalender SET 23_1='" + spot22_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2921. cmd.ExecuteNonQuery();
  2922. spot22_0.Text = "";
  2923. con.Close();
  2924. Response.Redirect("default.aspx");
  2925. }
  2926.  
  2927. protected void btn_removespot22_0_Click(object sender, EventArgs e)
  2928. {
  2929. con.Open();
  2930. MySqlCommand cmd = con.CreateCommand();
  2931. cmd.CommandType = CommandType.Text;
  2932. cmd.CommandText = "UPDATE kalender SET 23_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2933. cmd.ExecuteNonQuery();
  2934. spot22_0.Text = "";
  2935. con.Close();
  2936. Response.Redirect("default.aspx");
  2937. }
  2938.  
  2939. protected void btn_spot22_1_Click(object sender, EventArgs e)
  2940. {
  2941. spot22_1.Text = ddl_spot22_1.SelectedItem.Text;
  2942. con.Open();
  2943. MySqlCommand cmd = con.CreateCommand();
  2944. cmd.CommandType = CommandType.Text;
  2945. cmd.CommandText = "UPDATE kalender SET 23_2='" + spot22_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2946. cmd.ExecuteNonQuery();
  2947. spot22_1.Text = "";
  2948. con.Close();
  2949. Response.Redirect("default.aspx");
  2950. }
  2951.  
  2952. protected void btn_removespot22_1_Click(object sender, EventArgs e)
  2953. {
  2954. con.Open();
  2955. MySqlCommand cmd = con.CreateCommand();
  2956. cmd.CommandType = CommandType.Text;
  2957. cmd.CommandText = "UPDATE kalender SET 23_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2958. cmd.ExecuteNonQuery();
  2959. spot22_1.Text = "";
  2960. con.Close();
  2961. Response.Redirect("default.aspx");
  2962. }
  2963.  
  2964. protected void btn_spot23_0_Click(object sender, EventArgs e)
  2965. {
  2966. spot23_0.Text = ddl_spot23_0.SelectedItem.Text;
  2967. con.Open();
  2968. MySqlCommand cmd = con.CreateCommand();
  2969. cmd.CommandType = CommandType.Text;
  2970. cmd.CommandText = "UPDATE kalender SET 24_1='" + spot23_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  2971. cmd.ExecuteNonQuery();
  2972. spot23_0.Text = "";
  2973. con.Close();
  2974. Response.Redirect("default.aspx");
  2975. }
  2976.  
  2977. protected void btn_removespot23_0_Click(object sender, EventArgs e)
  2978. {
  2979. con.Open();
  2980. MySqlCommand cmd = con.CreateCommand();
  2981. cmd.CommandType = CommandType.Text;
  2982. cmd.CommandText = "UPDATE kalender SET 24_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  2983. cmd.ExecuteNonQuery();
  2984. spot23_0.Text = "";
  2985. con.Close();
  2986. Response.Redirect("default.aspx");
  2987. }
  2988.  
  2989. protected void btn_spot23_1_Click(object sender, EventArgs e)
  2990. {
  2991. spot23_1.Text = ddl_spot23_1.SelectedItem.Text;
  2992. con.Open();
  2993. MySqlCommand cmd = con.CreateCommand();
  2994. cmd.CommandType = CommandType.Text;
  2995. cmd.CommandText = "UPDATE kalender SET 24_2='" + spot23_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  2996. cmd.ExecuteNonQuery();
  2997. spot23_1.Text = "";
  2998. con.Close();
  2999. Response.Redirect("default.aspx");
  3000. }
  3001.  
  3002. protected void btn_removespot23_1_Click(object sender, EventArgs e)
  3003. {
  3004. con.Open();
  3005. MySqlCommand cmd = con.CreateCommand();
  3006. cmd.CommandType = CommandType.Text;
  3007. cmd.CommandText = "UPDATE kalender SET 24_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3008. cmd.ExecuteNonQuery();
  3009. spot23_1.Text = "";
  3010. con.Close();
  3011. Response.Redirect("default.aspx");
  3012. }
  3013.  
  3014. protected void btn_spot24_0_Click(object sender, EventArgs e)
  3015. {
  3016. spot24_0.Text = ddl_spot24_0.SelectedItem.Text;
  3017. con.Open();
  3018. MySqlCommand cmd = con.CreateCommand();
  3019. cmd.CommandType = CommandType.Text;
  3020. cmd.CommandText = "UPDATE kalender SET 25_1='" + spot24_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  3021. cmd.ExecuteNonQuery();
  3022. spot24_0.Text = "";
  3023. con.Close();
  3024. Response.Redirect("default.aspx");
  3025. }
  3026.  
  3027. protected void btn_removespot24_0_Click(object sender, EventArgs e)
  3028. {
  3029. con.Open();
  3030. MySqlCommand cmd = con.CreateCommand();
  3031. cmd.CommandType = CommandType.Text;
  3032. cmd.CommandText = "UPDATE kalender SET 25_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3033. cmd.ExecuteNonQuery();
  3034. spot24_0.Text = "";
  3035. con.Close();
  3036. Response.Redirect("default.aspx");
  3037. }
  3038.  
  3039. protected void btn_spot24_1_Click(object sender, EventArgs e)
  3040. {
  3041. spot24_1.Text = ddl_spot24_1.SelectedItem.Text;
  3042. con.Open();
  3043. MySqlCommand cmd = con.CreateCommand();
  3044. cmd.CommandType = CommandType.Text;
  3045. cmd.CommandText = "UPDATE kalender SET 25_2='" + spot24_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  3046. cmd.ExecuteNonQuery();
  3047. spot24_1.Text = "";
  3048. con.Close();
  3049. Response.Redirect("default.aspx");
  3050. }
  3051.  
  3052. protected void btn_removespot24_1_Click(object sender, EventArgs e)
  3053. {
  3054. con.Open();
  3055. MySqlCommand cmd = con.CreateCommand();
  3056. cmd.CommandType = CommandType.Text;
  3057. cmd.CommandText = "UPDATE kalender SET 25_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3058. cmd.ExecuteNonQuery();
  3059. spot24_1.Text = "";
  3060. con.Close();
  3061. Response.Redirect("default.aspx");
  3062. }
  3063.  
  3064. protected void btn_spot25_0_Click(object sender, EventArgs e)
  3065. {
  3066. spot25_0.Text = ddl_spot25_0.SelectedItem.Text;
  3067. con.Open();
  3068. MySqlCommand cmd = con.CreateCommand();
  3069. cmd.CommandType = CommandType.Text;
  3070. cmd.CommandText = "UPDATE kalender SET 26_1='" + spot25_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  3071. cmd.ExecuteNonQuery();
  3072. spot25_0.Text = "";
  3073. con.Close();
  3074. Response.Redirect("default.aspx");
  3075. }
  3076.  
  3077. protected void btn_removespot25_0_Click(object sender, EventArgs e)
  3078. {
  3079. con.Open();
  3080. MySqlCommand cmd = con.CreateCommand();
  3081. cmd.CommandType = CommandType.Text;
  3082. cmd.CommandText = "UPDATE kalender SET 26_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3083. cmd.ExecuteNonQuery();
  3084. spot25_0.Text = "";
  3085. con.Close();
  3086. Response.Redirect("default.aspx");
  3087. }
  3088.  
  3089. protected void btn_spot25_1_Click(object sender, EventArgs e)
  3090. {
  3091. spot25_1.Text = ddl_spot25_1.SelectedItem.Text;
  3092. con.Open();
  3093. MySqlCommand cmd = con.CreateCommand();
  3094. cmd.CommandType = CommandType.Text;
  3095. cmd.CommandText = "UPDATE kalender SET 26_2='" + spot25_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  3096. cmd.ExecuteNonQuery();
  3097. spot25_1.Text = "";
  3098. con.Close();
  3099. Response.Redirect("default.aspx");
  3100. }
  3101.  
  3102. protected void btn_removespot25_1_Click(object sender, EventArgs e)
  3103. {
  3104. con.Open();
  3105. MySqlCommand cmd = con.CreateCommand();
  3106. cmd.CommandType = CommandType.Text;
  3107. cmd.CommandText = "UPDATE kalender SET 26_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3108. cmd.ExecuteNonQuery();
  3109. spot25_1.Text = "";
  3110. con.Close();
  3111. Response.Redirect("default.aspx");
  3112. }
  3113.  
  3114. protected void btn_spot26_0_Click(object sender, EventArgs e)
  3115. {
  3116. spot26_0.Text = ddl_spot26_0.SelectedItem.Text;
  3117. con.Open();
  3118. MySqlCommand cmd = con.CreateCommand();
  3119. cmd.CommandType = CommandType.Text;
  3120. cmd.CommandText = "UPDATE kalender SET 27_1='" + spot26_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  3121. cmd.ExecuteNonQuery();
  3122. spot26_0.Text = "";
  3123. con.Close();
  3124. Response.Redirect("default.aspx");
  3125. }
  3126.  
  3127. protected void btn_removespot26_0_Click(object sender, EventArgs e)
  3128. {
  3129. con.Open();
  3130. MySqlCommand cmd = con.CreateCommand();
  3131. cmd.CommandType = CommandType.Text;
  3132. cmd.CommandText = "UPDATE kalender SET 27_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3133. cmd.ExecuteNonQuery();
  3134. spot26_0.Text = "";
  3135. con.Close();
  3136. Response.Redirect("default.aspx");
  3137. }
  3138.  
  3139. protected void btn_spot26_1_Click(object sender, EventArgs e)
  3140. {
  3141. spot26_1.Text = ddl_spot26_1.SelectedItem.Text;
  3142. con.Open();
  3143. MySqlCommand cmd = con.CreateCommand();
  3144. cmd.CommandType = CommandType.Text;
  3145. cmd.CommandText = "UPDATE kalender SET 27_2='" + spot26_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  3146. cmd.ExecuteNonQuery();
  3147. spot26_1.Text = "";
  3148. con.Close();
  3149. Response.Redirect("default.aspx");
  3150. }
  3151.  
  3152. protected void btn_removespot26_1_Click(object sender, EventArgs e)
  3153. {
  3154. con.Open();
  3155. MySqlCommand cmd = con.CreateCommand();
  3156. cmd.CommandType = CommandType.Text;
  3157. cmd.CommandText = "UPDATE kalender SET 27_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3158. cmd.ExecuteNonQuery();
  3159. spot26_1.Text = "";
  3160. con.Close();
  3161. Response.Redirect("default.aspx");
  3162. }
  3163.  
  3164. protected void btn_spot27_0_Click(object sender, EventArgs e)
  3165. {
  3166. spot27_0.Text = ddl_spot27_0.SelectedItem.Text;
  3167. con.Open();
  3168. MySqlCommand cmd = con.CreateCommand();
  3169. cmd.CommandType = CommandType.Text;
  3170. cmd.CommandText = "UPDATE kalender SET 28_1='" + spot27_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  3171. cmd.ExecuteNonQuery();
  3172. spot27_0.Text = "";
  3173. con.Close();
  3174. Response.Redirect("default.aspx");
  3175. }
  3176.  
  3177. protected void btn_removespot27_0_Click(object sender, EventArgs e)
  3178. {
  3179. con.Open();
  3180. MySqlCommand cmd = con.CreateCommand();
  3181. cmd.CommandType = CommandType.Text;
  3182. cmd.CommandText = "UPDATE kalender SET 28_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3183. cmd.ExecuteNonQuery();
  3184. spot27_0.Text = "";
  3185. con.Close();
  3186. Response.Redirect("default.aspx");
  3187. }
  3188.  
  3189. protected void btn_spot27_1_Click(object sender, EventArgs e)
  3190. {
  3191. spot27_1.Text = ddl_spot27_1.SelectedItem.Text;
  3192. con.Open();
  3193. MySqlCommand cmd = con.CreateCommand();
  3194. cmd.CommandType = CommandType.Text;
  3195. cmd.CommandText = "UPDATE kalender SET 28_2='" + spot27_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  3196. cmd.ExecuteNonQuery();
  3197. spot27_1.Text = "";
  3198. con.Close();
  3199. Response.Redirect("default.aspx");
  3200. }
  3201.  
  3202. protected void btn_removespot27_1_Click(object sender, EventArgs e)
  3203. {
  3204. con.Open();
  3205. MySqlCommand cmd = con.CreateCommand();
  3206. cmd.CommandType = CommandType.Text;
  3207. cmd.CommandText = "UPDATE kalender SET 28_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3208. cmd.ExecuteNonQuery();
  3209. spot27_1.Text = "";
  3210. con.Close();
  3211. Response.Redirect("default.aspx");
  3212. }
  3213.  
  3214. protected void btn_spot28_0_Click(object sender, EventArgs e)
  3215. {
  3216. spot28_0.Text = ddl_spot28_0.SelectedItem.Text;
  3217. con.Open();
  3218. MySqlCommand cmd = con.CreateCommand();
  3219. cmd.CommandType = CommandType.Text;
  3220. cmd.CommandText = "UPDATE kalender SET 29_1='" + spot28_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  3221. cmd.ExecuteNonQuery();
  3222. spot28_0.Text = "";
  3223. con.Close();
  3224. Response.Redirect("default.aspx");
  3225. }
  3226.  
  3227. protected void btn_removespot28_0_Click(object sender, EventArgs e)
  3228. {
  3229. con.Open();
  3230. MySqlCommand cmd = con.CreateCommand();
  3231. cmd.CommandType = CommandType.Text;
  3232. cmd.CommandText = "UPDATE kalender SET 29_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3233. cmd.ExecuteNonQuery();
  3234. spot28_0.Text = "";
  3235. con.Close();
  3236. Response.Redirect("default.aspx");
  3237. }
  3238.  
  3239. protected void btn_spot28_1_Click(object sender, EventArgs e)
  3240. {
  3241. spot28_1.Text = ddl_spot28_1.SelectedItem.Text;
  3242. con.Open();
  3243. MySqlCommand cmd = con.CreateCommand();
  3244. cmd.CommandType = CommandType.Text;
  3245. cmd.CommandText = "UPDATE kalender SET 29_2='" + spot28_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  3246. cmd.ExecuteNonQuery();
  3247. spot28_1.Text = "";
  3248. con.Close();
  3249. Response.Redirect("default.aspx");
  3250. }
  3251.  
  3252. protected void btn_removespot28_1_Click(object sender, EventArgs e)
  3253. {
  3254. con.Open();
  3255. MySqlCommand cmd = con.CreateCommand();
  3256. cmd.CommandType = CommandType.Text;
  3257. cmd.CommandText = "UPDATE kalender SET 29_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3258. cmd.ExecuteNonQuery();
  3259. spot28_1.Text = "";
  3260. con.Close();
  3261. Response.Redirect("default.aspx");
  3262. }
  3263.  
  3264. protected void btn_spot29_0_Click(object sender, EventArgs e)
  3265. {
  3266. spot29_0.Text = ddl_spot29_0.SelectedItem.Text;
  3267. con.Open();
  3268. MySqlCommand cmd = con.CreateCommand();
  3269. cmd.CommandType = CommandType.Text;
  3270. cmd.CommandText = "UPDATE kalender SET 30_1='" + spot29_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  3271. cmd.ExecuteNonQuery();
  3272. spot29_0.Text = "";
  3273. con.Close();
  3274. Response.Redirect("default.aspx");
  3275. }
  3276.  
  3277. protected void btn_removespot29_0_Click(object sender, EventArgs e)
  3278. {
  3279. con.Open();
  3280. MySqlCommand cmd = con.CreateCommand();
  3281. cmd.CommandType = CommandType.Text;
  3282. cmd.CommandText = "UPDATE kalender SET 30_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3283. cmd.ExecuteNonQuery();
  3284. spot29_0.Text = "";
  3285. con.Close();
  3286. Response.Redirect("default.aspx");
  3287. }
  3288.  
  3289. protected void btn_spot29_1_Click(object sender, EventArgs e)
  3290. {
  3291. spot29_1.Text = ddl_spot29_1.SelectedItem.Text;
  3292. con.Open();
  3293. MySqlCommand cmd = con.CreateCommand();
  3294. cmd.CommandType = CommandType.Text;
  3295. cmd.CommandText = "UPDATE kalender SET 30_2='" + spot29_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  3296. cmd.ExecuteNonQuery();
  3297. spot29_1.Text = "";
  3298. con.Close();
  3299. Response.Redirect("default.aspx");
  3300. }
  3301.  
  3302. protected void btn_removespot29_1_Click(object sender, EventArgs e)
  3303. {
  3304. con.Open();
  3305. MySqlCommand cmd = con.CreateCommand();
  3306. cmd.CommandType = CommandType.Text;
  3307. cmd.CommandText = "UPDATE kalender SET 30_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3308. cmd.ExecuteNonQuery();
  3309. spot29_1.Text = "";
  3310. con.Close();
  3311. Response.Redirect("default.aspx");
  3312. }
  3313.  
  3314. protected void btn_spot30_0_Click(object sender, EventArgs e)
  3315. {
  3316. spot30_0.Text = ddl_spot30_0.SelectedItem.Text;
  3317. con.Open();
  3318. MySqlCommand cmd = con.CreateCommand();
  3319. cmd.CommandType = CommandType.Text;
  3320. cmd.CommandText = "UPDATE kalender SET 31_1='" + spot30_0.Text + "' WHERE mnd_id='" + "72016" + "';";
  3321. cmd.ExecuteNonQuery();
  3322. spot30_0.Text = "";
  3323. con.Close();
  3324. Response.Redirect("default.aspx");
  3325. }
  3326.  
  3327. protected void btn_removespot30_0_Click(object sender, EventArgs e)
  3328. {
  3329. con.Open();
  3330. MySqlCommand cmd = con.CreateCommand();
  3331. cmd.CommandType = CommandType.Text;
  3332. cmd.CommandText = "UPDATE kalender SET 31_1='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3333. cmd.ExecuteNonQuery();
  3334. spot30_0.Text = "";
  3335. con.Close();
  3336. Response.Redirect("default.aspx");
  3337. }
  3338.  
  3339. protected void btn_spot30_1_Click(object sender, EventArgs e)
  3340. {
  3341. spot30_1.Text = ddl_spot30_1.SelectedItem.Text;
  3342. con.Open();
  3343. MySqlCommand cmd = con.CreateCommand();
  3344. cmd.CommandType = CommandType.Text;
  3345. cmd.CommandText = "UPDATE kalender SET 31_2='" + spot30_1.Text + "' WHERE mnd_id='" + "72016" + "';";
  3346. cmd.ExecuteNonQuery();
  3347. spot30_1.Text = "";
  3348. con.Close();
  3349. Response.Redirect("default.aspx");
  3350. }
  3351.  
  3352. protected void btn_removespot30_1_Click(object sender, EventArgs e)
  3353. {
  3354. con.Open();
  3355. MySqlCommand cmd = con.CreateCommand();
  3356. cmd.CommandType = CommandType.Text;
  3357. cmd.CommandText = "UPDATE kalender SET 31_2='" + "" + "' WHERE mnd_id='" + "72016" + "';";
  3358. cmd.ExecuteNonQuery();
  3359. spot30_1.Text = "";
  3360. con.Close();
  3361. Response.Redirect("default.aspx");
  3362. }
  3363. }
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!