private void MbtnLoginIn_Click(object sender, EventArgs e) { //User has clicked the sign up button MySqlConnection con = new MySqlConnection("Server=172.17.100.2;Port=3306;database=testrivshdb;User Id=mysql;Password=mysql;charset=utf8;Connect Timeout=300"); try { if (con.State == ConnectionState.Closed) { if (etLogin.Text != "" && etPass.Text != "") { con.Open(); DataSet tickets = new DataSet(); string userName = AesCryp.Encrypt(etLogin.Text); string password = AesCryp.Encrypt(etPass.Text); string queryString = "SELECT * from User WHERE userlogin='******' and userpass='******'"; MySqlDataAdapter cmd = new MySqlDataAdapter(queryString, con); cmd.Fill(tickets, "userlogin"); if (tickets.Tables["userlogin"].Rows.Count > 0) { Activity.StartActivity(typeof(DetailActivity)); MySqlCommand cmdsel = new MySqlCommand(queryString, con); MySqlDataReader reader = cmdsel.ExecuteReader(); while (reader.Read()) { Repository.UserId = (int)(reader["Id_User"]); string result = System.Text.Encoding.UTF8.GetString((byte[])reader["userimg"]); Repository.UserImg = Convert.FromBase64String(result); Repository.CurrUserName = (string)(reader["username"]); } reader.Close(); queryString = "Select SUM(Rez) from ListPassedTest where Id_User = "******"Select Count(Rez) from ListPassedTest where Id_User = "******"Неверный логин или пароль", ToastLength.Long).Show(); } } else { Toast.MakeText(this.Activity, "Все поля должны быть заполнены", ToastLength.Long).Show(); } } } catch (MySqlException) { Toast.MakeText(Activity, "Ошибка, проверье своё интернет соединение", ToastLength.Long).Show(); } catch (TimeoutException) { Toast.MakeText(Activity, "Ошибка, проверье своё интернет соединение", ToastLength.Long).Show(); } catch (ArgumentNullException) { Toast.MakeText(Activity, "Ошибка, проверье своё интернет соединение", ToastLength.Long).Show(); } finally { con.Close(); } this.Dismiss(); }
private void BtnSignUp_Click(object sender, EventArgs e) { //User has clicked the sign up button //Используйте 10.0.2.2 для AVD по умолчанию и 10.0.3.2 для genymotion. MySqlConnection con = new MySqlConnection("Server=172.17.100.2;Port=3306;database=testrivshdb;User Id=mysql;Password=mysql;charset=utf8;Connect Timeout=300"); try { if (con.State == ConnectionState.Closed) { if (etUsername.Text != "" && etPassword.Text != "" && etName.Text != "" && etImg.Text != "") { if (etPassword.Text.Length > 5 && etPassword.Text.Length < 31) { con.Open(); con.Open(); string enclog = AesCryp.Encrypt(etName.Text); string encpass = AesCryp.Encrypt(etPassword.Text); DataSet tickets = new DataSet(); string queryString = "SELECT * from User WHERE userlogin='******'"; MySqlDataAdapter comn = new MySqlDataAdapter(queryString, con); comn.Fill(tickets, "userlogin"); if (tickets.Tables["userlogin"].Rows.Count == 0) { MySqlCommand cmd = new MySqlCommand("INSERT INTO User(userlogin,userpass,username,userimg) VALUES(@userlogin,@userpass,@username,@userimg)", con); cmd.Parameters.AddWithValue("@userlogin", enclog); cmd.Parameters.AddWithValue("@userpass", encpass); cmd.Parameters.AddWithValue("@username", etUsername.Text); cmd.Parameters.AddWithValue("@userimg", etImg.Text); cmd.ExecuteNonQuery(); this.Dismiss(); mActionBtnClikced.Invoke((Button)sender); } else { Toast.MakeText(this.Activity, "Такой логин уже существует", ToastLength.Long).Show(); } } else { Toast.MakeText(this.Activity, "Размер пароля от 6 до 30 символов", ToastLength.Long).Show(); } } else { Toast.MakeText(this.Activity, "Все поля должны быть заполнены", ToastLength.Long).Show(); } } } catch (MySqlException ex) { string deb = ex.ToString(); Toast.MakeText(Activity, "Ошибка, проверье своё интернет соединение", ToastLength.Long).Show(); } catch (TimeoutException) { Toast.MakeText(Activity, "Ошибка, проверье своё интернет соединение", ToastLength.Long).Show(); } catch (ArgumentNullException) { Toast.MakeText(Activity, "Ошибка, проверье своё интернет соединение", ToastLength.Long).Show(); } finally { con.Close(); } }