public void Login_Click(object sender, RoutedEventArgs e)
{
string user = UserLogintxt.Text;
string passwd = UserPassword.Password;
SqlConnection conn = new SqlConnection
{
ConnectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=F:\FIRMAAPPEXE\FIRMAAPP\BIN\DEBUG\SMADB.MDF;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"
};
conn.Open();
SqlDataReader read;
string query2 = ("SELECT Id from Uzytkownicy WHERE Login=@user");
SqlCommand com = new SqlCommand(query2, conn);
com.Parameters.AddWithValue("@user", user);
read = com.ExecuteReader();
if (read.Read())
{
id = read.GetInt32(0);
}
read.Close();
conn.Close();
conn.Open();
string query3 = ("SELECT Stanowiska.Stanowisko from Stanowiska INNER JOIN Uzytkownicy ON Stanowiska.Id_stanowiska=Uzytkownicy.Id WHERE Uzytkownicy.Login=@user");
SqlCommand com2 = new SqlCommand(query3, conn);
com2.Parameters.AddWithValue("@user", user);
read = com2.ExecuteReader();
if (read.Read())
{
Stanowisko = read.GetString(0);
}
read.Close();
conn.Close();
conn.Open();
string query = "SELECT * FROM Uzytkownicy WHERE Login=@user AND Haslo=@passwd";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@passwd", passwd);
cmd.Parameters.AddWithValue("@user", user);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
MessageBox.Show("Zalogowano poprawnie \n Stanowisko: " + Stanowisko + "\n Twoje id : " + id);
Panel_glowny menu = new Panel_glowny();
menu.Show();
this.Close();
}
else
{
FailMsg.Visibility = Visibility.Visible;
}
}
private void Back_Click(object sender, RoutedEventArgs e)
{
Panel_glowny back = new Panel_glowny();
back.Show();
this.Close();
}
public void Login_Click(object sender, RoutedEventArgs e)
{
string user = UserLogintxt.Text;
string passwd = UserPassword.Password;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|SMA.mdf;Integrated Security=True;Connect Timeout=30";
conn.Open();
SqlDataReader read = (null);
string query2 = ("SELECT Stanowisko,Id from Uzytkownicy WHERE Login=@user");
SqlCommand com = new SqlCommand(query2, conn);
com.Parameters.AddWithValue("@user", user);
read = com.ExecuteReader();
if (read.Read())
{
Stanowisko = read.GetString(0);
id = read.GetInt32(1);
}
read.Close();
conn.Close();
conn.Open();
string query = "SELECT * FROM Uzytkownicy WHERE Login=@user AND Haslo=@passwd";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@passwd", passwd);
cmd.Parameters.AddWithValue("@user", user);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
MessageBox.Show("Zalogowano poprawnie \n Stanowisko: " + Stanowisko + "\n Twoje id : " + id);
Panel_glowny menu = new Panel_glowny();
menu.Show();
this.Close();
}
else
{
FailMsg.Visibility = Visibility.Visible;
}
}