//******************* Verifica_DEX_DB end *****************
//******************* View_lista_useri_SQL *****************
public void View_lista_useri_DEX_DB(string tip_utilizator_selected)
{
try {
// https://stackoverflow.com/questions/3558945/populating-a-wpf-listbox-with-items-from-an-sql-sdf-database
// https://www.c-sharpcorner.com/UploadFile/mahesh/data-binding-in-wpf/
using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) {
connection.Open();
sb.Clear();
sb.Append("USE " + db_name + "; ");
sb.Append("SELECT Nume FROM Utilizatori ");
sb.Append(" INNER JOIN Utilizatori_Tip ON Utilizatori.Id_tip_utilizator=Utilizatori_Tip.Id_tip_utilizator");
sb.Append(" WHERE Utilizatori_Tip.Tip_utilizator = @0");
sql = sb.ToString();
DataSet dataSet = new DataSet();
using (SqlCommand command = new SqlCommand(sql, connection)) {
SqlDataAdapter adapter = new SqlDataAdapter();
command.Parameters.AddWithValue("@0", tip_utilizator_selected);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
Lista_utilizatori.DataContext = dataSet;
}
connection.Close();
Lista_utilizatori.UnselectAll();
}
}
catch (SqlException e) {
Afiseaza_mesaj_SQL(e);
}
}
private void btn_DelAutorizati_Click(object sender, RoutedEventArgs e)
{
if (Lista_utilizatori.SelectedItem == null)
{
MessageBox.Show("Selectati o optiune din lista.", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
StringBuilder user_selectat = new StringBuilder();
foreach (DataRowView objDataRowView in Lista_utilizatori.SelectedItems)
{
user_selectat.Append(objDataRowView[0].ToString());
Delete_user_DEX_DB(user_selectat.ToString());
user_selectat.Clear();
}
View_lista_useri_DEX_DB("utilizator autentificat"); //face refresh la lista curenta
Lista_utilizatori.UnselectAll(); // deselecteaza orice optiune
}
}
