private void button1_Click(object sender, EventArgs e)
{
Test1.Utilities util = new Test1.Utilities();
SqlConnection conn = new SqlConnection(util.GetConnectionString());
string query = "Select * From Users WHERE usern = '" + textBox1.Text + "'and passw='" + textBox2.Text + "'";
SqlCommand cmdq = new SqlCommand(query, conn);
SqlDataReader rdr;
try
{
conn.Open();
Console.WriteLine("connected");
rdr = cmdq.ExecuteReader();
Console.WriteLine("tamam");
while (rdr.Read())
{
int id = (Int32)rdr.GetValue(0);
x = rdr.GetString(1);
y = rdr["passw"].ToString();
this.Hide();
Main mainmenu = new Main(id, x);
mainmenu.Show();
Console.WriteLine(id + x + y);
}
// Call Close when done reading.
rdr.Close();
}
catch
{
MessageBox.Show("no");
}
finally
{
conn.Close();
}
// SqlDataAdapter sd = new SqlDataAdapter("Select Count(*) From Users Where usern = '"+ textBox1.Text + " ' and passw= ' " + textBox2.Text + " ' ", conn);
// DataTable dt = new DataTable();
// sd.Fill(dt);
// DataRow drow = dt.Rows[1];
// string value = drow.Field<string>("Users");
// Console.WriteLine(value);
// if (dt.Rows[0][0].ToString() == "1")
// {
// this.Hide();
// Main mainmenu = new Main();
// mainmenu.Show();
// }
// else
// {
// MessageBox.Show("ERRRRRR!");
// }
// }
}
private void button1_Click(object sender, EventArgs e)
{
user input = new user(999, textBox1.Text, textBox2.Text, textBox4.Text);
if (textBox2.Text != textBox3.Text)
{
MessageBox.Show("Passwords don't match");
return;
}
Test1.Utilities util = new Test1.Utilities();
SqlConnection conn = new SqlConnection(util.GetConnectionString());
string query = "Select * From Users";
string command = "insert into Users (usern,passw,privileges) values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox4.Text + "')";
SqlCommand cmdq = new SqlCommand(query, conn);
SqlCommand cmdw = new SqlCommand(command, conn);
SqlDataReader rdr;
try
{
conn.Open();
rdr = cmdq.ExecuteReader();
while (rdr.Read())
{
users.Add(new user((Int32)rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3)));
}
if (users.Exists(r => r.name.ToLower() == input.name.ToLower()))
{
MessageBox.Show("Duplicate user");
return;
}
rdr.Close();
conn.Close();
conn.Open();
cmdw.ExecuteNonQuery();
MessageBox.Show("User added successfully");
this.Close();
}
catch
{
MessageBox.Show("A7a");
}
}