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();
}
}
