private void Setdata_Click(object sender, RoutedEventArgs e)
{
setdata.Cursor = Cursors.Wait;
try {
if ((password.Text == repeatpassword.Text) && (login.Text != ""))
{
string hash = GetMD.Getmd(GetMD.Getmd(GetMD.Getmd(GetMD.Getmd(password.Text))));
string sqlchek = "Select id from userdata where username='******'";
string insert = "insert into userdata (username,password) values ('{0}','{1}')";
string formatedinsert = string.Format(insert, login.Text, hash);
SqlCommand ins = new SqlCommand(formatedinsert, Connection.MyConnection);
SqlCommand cmd = new SqlCommand(sqlchek, Connection.MyConnection);
Connection.On(0);
SqlDataReader rd = cmd.ExecuteReader();
int chek = 0;
while (rd.Read())
{
chek = rd.GetInt32(0);
}
if (chek == 0)
{
setdata.Cursor = Cursors.Arrow;
ins.ExecuteNonQuery();
Connection.Off();
bdrWelcomeMessage.Visibility = Visibility.Visible;
UserName.Text = login.Text;
}
else
{
setdata.Cursor = Cursors.Arrow;
Connection.Off();
ettention.Content = "This username is taken";
}
}
else
{
setdata.Cursor = Cursors.Arrow;
ettention.Content = "Passwords must match";
}
}
catch (System.InvalidOperationException) {
setdata.Cursor = Cursors.Arrow;
ettentions.Text = "No connection established, but you can use offline mod from login menu";
bdrEttentionMessage.Visibility = Visibility.Visible;
}
}
public void butlog_Click(object sender, RoutedEventArgs e)
{
butlog.Cursor = Cursors.Wait;
try{
if (login.Text != "")
{
string hash = GetMD.Getmd(GetMD.Getmd(GetMD.Getmd(GetMD.Getmd(password.Text))));
string sqlchek = "Select id from userdata where username='******' and password='******'";
SqlCommand cmd = new SqlCommand(sqlchek, Connection.MyConnection);
Connection.On(0);
int chek = 0;
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
chek = rd.GetInt32(0);
}
Connection.Off();
if (chek != 0)
{
butlog.Cursor = Cursors.Arrow;
ettentions.Text = "Сonnection is ok, you can enter online mod by using this account";
UserName.Text = login.Text;
bdrWelcomeMessage.Visibility = Visibility.Visible;
}
else
{
butlog.Cursor = Cursors.Arrow;
ettention.Content = "wrong username / password";
}
}
else
{
butlog.Cursor = Cursors.Arrow;
ettention.Content = "login string is empty!";
}
}
catch (System.InvalidOperationException) {
butlog.Cursor = Cursors.Arrow;
ettentions.Text = "Сonnection is not established, but you can enter offline mod by using entered username";
UserName.Text = login.Text;
bdrWelcomeMessage.Visibility = Visibility.Visible;
}
}