Email

30              void load()
31         {
32             sqlcmd = new SqlCommand("select * from sinhvien ", sqlcon);
33             SqlDataReader sqlreader = sqlcmd.ExecuteReader();
34             listView1.Items.Clear();
35             while (sqlreader.Read())
36             {
37                 ListViewItem lvitem = new ListViewItem();
38                 //lvitem.Text = sqlreader["MaCH"].ToString();
39                 //lvitem.SubItems.Add(sqlreader["cauhoi"].ToString());
40
41                 //string sMaCH = sqlreader["mach"].ToString();
42
43                 lvitem.Text = sqlreader["mats"].ToString();
44                 lvitem.SubItems.Add(sqlreader["hoten"].ToString());
45                 lvitem.SubItems.Add(sqlreader["ngaysinh"].ToString());
46                 lvitem.SubItems.Add(sqlreader["gioitinh"].ToString());
47                 lvitem.SubItems.Add(sqlreader["quequan"].ToString());
48                 lvitem.SubItems.Add(sqlreader["sodienthoai"].ToString());
49                 lvitem.SubItems.Add(sqlreader["email"].ToString());
50
51                 //lvitem.SubItems.Add(sqlreader["n"].ToString());
52
53                 listView1.Items.Add(lvitem);
54             }
55             sqlreader.Close();
56         }

67         private void btnthem_Click(object sender, EventArgs e)
68         {
69             try
70             {
71             string mats = textBox1.Text;
72             string hoten = textBox2.Text;
73             string ngaysinh = textBox3.Text;
74             string gioitinh = textBox4.Text;
75             string quequan = textBox5.Text;
76             string sodt = textBox6.Text;
77             string email = textBox7.Text;
78
79             string strSQL = "insert SINHVIEN values('" + mats + "','" + hoten + "','" + ngaysinh + "','" + gioitinh + "','" + quequan + "','" + sodt + "','" + email + "')";
80             sqlcmd = new SqlCommand(strSQL, sqlcon);
81             sqlcmd.ExecuteNonQuery();
82             MessageBox.Show("B?n dã dang ký thành công");
83             load();
84             }
85                 catch
86             {
87                 MessageBox.Show("Trùng mã sinh viên !!!");
88                 }
89
90         }

97         private void btnsua_Click(object sender, EventArgs e)
98         {
99             try
100             {
101                 string mats = textBox1.Text;
102                 string hoten = textBox2.Text;
103                 string ngaysinh = textBox3.Text;
104                 string gioitinh = textBox4.Text;
105                 string quequan = textBox5.Text;
106                 string sodt = textBox6.Text;
107                 string email = textBox7.Text;
108                 sqlcmd = new SqlCommand("update sinhvien set mats='" + mats + "',hoten='" + hoten + "',ngaysinh='" + ngaysinh + "',gioitinh='" + gioitinh + "',quequan='" + quequan + "',sodienthoai='" + sodt + "',email'" + email + "' ", sqlcon);
109                 sqlcmd.ExecuteNonQuery();
110
111                 load();
112             }
113             catch
114             {
115                 MessageBox.Show("Loi");
116             }
117         }

59     public void RegisterByEmail(string email, Origin origin)
60     {
61         this.registrationCallback = null;
62         this.AppId = string.Empty;
63         this.Message = string.Empty;
64         this.ReturnCode = -1;
65
66         string result;
67         try
68         {
69             WebRequest req = HttpWebRequest.Create(this.RegistrationUri(email, (byte)origin));
70             HttpWebResponse resp = req.GetResponse() as HttpWebResponse;
71
72             // now read result
73             StreamReader reader = new StreamReader(resp.GetResponseStream());
74             result = reader.ReadToEnd();
75         }
76         catch (Exception ex)
77         {
78             this.Message = "Failed to connect to Cloud Account Service. Please register via account website.";
79             this.Exception = ex;
80             return;
81         }
82
83         this.ParseResult(result);
84     }

93     public void RegisterByEmailAsync(string email, Origin origin, Action callback = null)
94     {
95         this.registrationCallback = callback;
96         this.AppId = string.Empty;
97         this.Message = string.Empty;
98         this.ReturnCode = -1;
99
100         try
101         {
102             HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(this.RegistrationUri(email, (byte)origin));
103             req.Timeout = 5000;
104             req.BeginGetResponse(this.OnRegisterByEmailCompleted, req);
105         }
106         catch (Exception ex)
107         {
108             this.Message = "Failed to connect to Cloud Account Service. Please register via account website.";
109             this.Exception = ex;
110             if (this.registrationCallback != null)
111             {
112                 this.registrationCallback(this);
113             }
114         }
115     }

121     private void OnRegisterByEmailCompleted(IAsyncResult ar)
122     {
123         try
124         {
125             HttpWebRequest request = (HttpWebRequest)ar.AsyncState;
126             HttpWebResponse response = request.EndGetResponse(ar) as HttpWebResponse;
127
128             if (response != null && response.StatusCode == HttpStatusCode.OK)
129             {
130                 // no error. use the result
131                 StreamReader reader = new StreamReader(response.GetResponseStream());
132                 string result = reader.ReadToEnd();
133
134                 this.ParseResult(result);
135             }
136             else
137             {
138                 // a response but some error on server. show message
139                 this.Message = "Failed to connect to Cloud Account Service. Please register via account website.";
140             }
141         }
142         catch (Exception ex)
143         {
144             // not even a response. show message
145             this.Message = "Failed to connect to Cloud Account Service. Please register via account website.";
146             this.Exception = ex;
147         }
148
149         if (this.registrationCallback != null)
150         {
151             this.registrationCallback(this);
152         }
153     }

161     private Uri RegistrationUri(string email, byte origin)
162     {
163         string emailEncoded = Uri.EscapeDataString(email);
164         string uriString = string.Format("{0}?email={1}&origin={2}", ServiceUrl, emailEncoded, origin);
165
166         return new Uri(uriString);
167     }

147     {
148         RegisterForPhotonCloud,
149
150         EmailAlreadyRegistered,
151
152         SetupPhotonCloud,
153
154         SetupSelfHosted
155     }

420     protected virtual void OnGuiRegisterCloudApp()
421     {
422         GUI.skin.label.wordWrap = true;
423         if (!this.isSetupWizard)
424         {
425             GUILayout.BeginHorizontal();
426             GUILayout.FlexibleSpace();
427             if (GUILayout.Button(CurrentLang.MainMenuButton, GUILayout.ExpandWidth(false)))
428             {
429                 this.SwitchMenuState(GUIState.Main);
430             }
431
432             GUILayout.EndHorizontal();
433
434             GUILayout.Space(15);
435         }
436
437         if (this.photonSetupState == PhotonSetupStates.RegisterForPhotonCloud)
438         {
439             GUI.skin.label.fontStyle = FontStyle.Bold;
440             GUILayout.Label(CurrentLang.ConnectButton);
441             EditorGUILayout.Separator();
442             GUI.skin.label.fontStyle = FontStyle.Normal;
443
444             GUILayout.Label(CurrentLang.UsePhotonLabel);
445             EditorGUILayout.Separator();
446             this.emailAddress = EditorGUILayout.TextField(CurrentLang.EmailLabel, this.emailAddress);
447
448             if (GUILayout.Button(CurrentLang.SendButton))
449             {
450                 GUIUtility.keyboardControl = 0;
451                 this.RegisterWithEmail(this.emailAddress);
452             }
453
454             GUILayout.Space(20);
455
456
457             GUILayout.Label(CurrentLang.SignedUpAlreadyLabel);
458             if (GUILayout.Button(CurrentLang.SetupButton))
459             {
460                 this.photonSetupState = PhotonSetupStates.SetupPhotonCloud;
461             }
462             EditorGUILayout.Separator();
463
464
465             GUILayout.Label(CurrentLang.RegisterByWebsiteLabel);
466             if (GUILayout.Button(CurrentLang.AccountWebsiteButton))
467             {
468                 EditorUtility.OpenWithDefaultApp(UrlAccountPage + Uri.EscapeUriString(this.emailAddress));
469             }
470
471             EditorGUILayout.Separator();
472
473             GUILayout.Label(CurrentLang.SelfHostLabel);
474
475             if (GUILayout.Button(CurrentLang.SelfHostSettingsButton))
476             {
477                 this.photonSetupState = PhotonSetupStates.SetupSelfHosted;
478             }
479
480             GUILayout.FlexibleSpace();
481
482
483             if (!InternalEditorUtility.HasAdvancedLicenseOnBuildTarget(BuildTarget.Android) || !InternalEditorUtility.HasAdvancedLicenseOnBuildTarget(BuildTarget.iOS))
484             {
485                 GUILayout.Label(CurrentLang.MobileExportNoteLabel);
486             }
487             EditorGUILayout.Separator();
488         }
489         else if (this.photonSetupState == PhotonSetupStates.EmailAlreadyRegistered)
490         {
491             GUI.skin.label.fontStyle = FontStyle.Bold;
492             GUILayout.Label(CurrentLang.OopsLabel);
493             GUI.skin.label.fontStyle = FontStyle.Normal;
494
495             GUILayout.Label(CurrentLang.EmailInUseLabel);
496
497             if (GUILayout.Button(CurrentLang.SeeMyAccountPageButton))
498             {
499                 EditorUtility.OpenWithDefaultApp(UrlCloudDashboard + Uri.EscapeUriString(this.emailAddress));
500             }
501
502             EditorGUILayout.Separator();
503
504             GUILayout.Label(CurrentLang.KnownAppIdLabel);
505             GUILayout.BeginHorizontal();
506             if (GUILayout.Button(CurrentLang.CancelButton))
507             {
508                 this.photonSetupState = PhotonSetupStates.RegisterForPhotonCloud;
509             }
510
511             if (GUILayout.Button(CurrentLang.SetupButton))
512             {
513                 this.photonSetupState = PhotonSetupStates.SetupPhotonCloud;
514             }
515
516             GUILayout.EndHorizontal();
517         }
518         else if (this.photonSetupState == PhotonSetupStates.SetupPhotonCloud)
519         {
520             // cloud setup
521             GUI.skin.label.fontStyle = FontStyle.Bold;
522             GUILayout.Label(CurrentLang.PhotonCloudConnect);
523             GUI.skin.label.fontStyle = FontStyle.Normal;
524
525             EditorGUILayout.Separator();
526             this.OnGuiSetupCloudAppId();
527             this.OnGuiCompareAndHelpOptions();
528         }
529         else if (this.photonSetupState == PhotonSetupStates.SetupSelfHosted)
530         {
531             // self-hosting setup
532             GUI.skin.label.fontStyle = FontStyle.Bold;
533             GUILayout.Label(CurrentLang.SetupOwnHostLabel);
534             GUI.skin.label.fontStyle = FontStyle.Normal;
535
536             EditorGUILayout.Separator();
537
538             this.OnGuiSetupSelfhosting();
539             this.OnGuiCompareAndHelpOptions();
540         }
541     }

543     protected virtual void OnGuiMainWizard()
544     {
545         GUILayout.BeginHorizontal();
546         GUILayout.FlexibleSpace();
547         GUILayout.Label(WizardIcon);
548         GUILayout.FlexibleSpace();
549         GUILayout.EndHorizontal();
550
551         EditorGUILayout.Separator();
552
553         GUILayout.Label(CurrentLang.PUNWizardLabel, EditorStyles.boldLabel);
554         if (isPunPlus)
555         {
556             GUILayout.Label(CurrentLang.MobilePunPlusExportNoteLabel);
557         }
558         else if (!InternalEditorUtility.HasAdvancedLicenseOnBuildTarget(BuildTarget.Android) || !InternalEditorUtility.HasAdvancedLicenseOnBuildTarget(BuildTarget.iOS))
559         {
560             GUILayout.Label(CurrentLang.MobileExportNoteLabel);
561         }
562         EditorGUILayout.Separator();
563
564
565         // settings button
566         GUILayout.BeginHorizontal();
567         GUILayout.Label(CurrentLang.SettingsButton, EditorStyles.boldLabel, GUILayout.Width(100));
568         if (GUILayout.Button(new GUIContent(CurrentLang.SetupButton, CurrentLang.SetupServerCloudLabel)))
569         {
570             this.InitPhotonSetupWindow();
571         }
572
573         GUILayout.EndHorizontal();
574         EditorGUILayout.Separator();
575
576
577         // find / select settings asset
578         GUILayout.BeginHorizontal();
579         GUILayout.Label(CurrentLang.SettingsFileLabel, EditorStyles.boldLabel, GUILayout.Width(100));
580         if (GUILayout.Button(new GUIContent(CurrentLang.LocateSettingsButton, CurrentLang.SettingsHighlightLabel)))
581         {
582             EditorGUIUtility.PingObject(PhotonEditor.Current);
583         }
584
585         GUILayout.EndHorizontal();
586
587
588         GUILayout.FlexibleSpace();
589
590         // converter
591         GUILayout.BeginHorizontal();
592         GUILayout.Label(CurrentLang.ConverterLabel, EditorStyles.boldLabel, GUILayout.Width(100));
593         if (GUILayout.Button(new GUIContent(CurrentLang.StartButton, CurrentLang.UNtoPUNLabel)))
594         {
595             PhotonConverter.RunConversion();
596         }
597
598         GUILayout.EndHorizontal();
599         EditorGUILayout.Separator();
600
601
602         // documentation
603         GUILayout.BeginHorizontal();
604         GUILayout.Label(CurrentLang.DocumentationLabel, EditorStyles.boldLabel, GUILayout.Width(100));
605         GUILayout.BeginVertical();
606         if (GUILayout.Button(new GUIContent(CurrentLang.OpenPDFText, CurrentLang.OpenPDFTooltip)))
607         {
608             EditorUtility.OpenWithDefaultApp(DocumentationLocation);
609         }
610
611         if (GUILayout.Button(new GUIContent(CurrentLang.OpenDevNetText, CurrentLang.OpenDevNetTooltip)))
612         {
613             EditorUtility.OpenWithDefaultApp(UrlDevNet);
614         }
615
616         if (GUILayout.Button(new GUIContent(CurrentLang.OpenCloudDashboardText, CurrentLang.OpenCloudDashboardTooltip)))
617         {
618             EditorUtility.OpenWithDefaultApp(UrlCloudDashboard + Uri.EscapeUriString(this.emailAddress));
619         }
620
621         if (GUILayout.Button(new GUIContent(CurrentLang.OpenForumText, CurrentLang.OpenForumTooltip)))
622         {
623             EditorUtility.OpenWithDefaultApp(UrlForum);
624         }
625
626         GUILayout.EndVertical();
627         GUILayout.EndHorizontal();
628     }