private void btnTorles_Click(object sender, EventArgs e) { if (MessageBox.Show("Biztosan törli a kijelölt könyvet ? ", "Kérdés", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { UserRegisztracio u = null; int index = -1; string a; int firstIndex = listView1.SelectedIndices[0]; a = listView1.Items[firstIndex].SubItems[0].Text; index = Convert.ToInt32(a); if (index > -1) { foreach (UserRegisztracio item in lista) { if (item.ID == index) { u = item; } } lista.Remove(u); ABKezeloUser.Torles(u); LV(); } } }
public static void Torles(UserRegisztracio u) { SqlTransaction tr = con.BeginTransaction(); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.Transaction = tr; cmd.CommandText = "DELETE FROM UserBelepesIdo WHERE(IdUser = @Id)"; cmd.Parameters.Add(new SqlParameter("@Id", u.ID)); cmd.ExecuteNonQuery(); SqlCommand cmd1 = new SqlCommand(); cmd1.Connection = con; cmd1.Transaction = tr; cmd1.CommandText = "DELETE FROM UserAdatok WHERE(IdUser = @id)"; cmd1.Parameters.Add(new SqlParameter("@id", u.ID)); cmd1.ExecuteNonQuery(); SqlCommand cmd2 = new SqlCommand("DELETE FROM UserRegisztracio WHERE (UserID = @id)", con); cmd2.Parameters.Add(new SqlParameter("@id", u.ID)); cmd2.Transaction = tr; cmd2.ExecuteNonQuery(); tr.Commit(); } catch (SqlException ex) { tr.Rollback(); MessageBox.Show("Hibás tranzakció !", ex.Message); } }
public static void Regisztral(UserRegisztracio ur) { SqlTransaction tr = con.BeginTransaction(); try { SqlCommand cmd = new SqlCommand("INSERT INTO UserRegisztracio(RegisztracioLogin, RegisztracioJelszo, Jogosultsag, RegisztraltDatum)OUTPUT INSERTED.[UserID] VALUES(@log, HASHBYTES('SHA1', @jel), @jog, GETDATE())", con); cmd.Parameters.Add(new SqlParameter("@log", ur.RegisztracioLogin)); cmd.Parameters.Add(new SqlParameter("@jel", ur.RegisztracioJelszo)); cmd.Parameters.Add(new SqlParameter("@jog", ur.Jogosultsag)); cmd.Transaction = tr; int id = (int)cmd.ExecuteScalar(); ur.ID = id; SqlCommand cmd2 = new SqlCommand(); cmd2.Connection = con; cmd2.Transaction = tr; if (ur is UserAdatok ua) { cmd2.CommandText = "INSERT INTO UserAdatok(IdUser,Nev, Email, Telefon)VALUES(@id,@nev,@em,@tel)"; cmd2.Parameters.Add(new SqlParameter("@id", id)); cmd2.Parameters.Add(new SqlParameter("@nev", ua.Nev)); cmd2.Parameters.Add(new SqlParameter("@em", ua.Email)); cmd2.Parameters.Add(new SqlParameter("@tel", ua.Telefon)); } cmd2.ExecuteNonQuery(); tr.Commit(); } catch (SqlException ex) { tr.Rollback(); MessageBox.Show("Hibás tranzakció !", ex.Message); } }
public static UserLista Feltolt() { UserLista belep = new UserLista(); try { cmd = new SqlCommand("SELECT * FROM [UserRegisztracio] LEFT OUTER JOIN [UserAdatok] ON [UserRegisztracio].[UserID] = [UserAdatok].[IdUser]", con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UserRegisztracio u = null; u = new UserAdatok((int)reader["UserID"], reader["RegisztracioLogin"].ToString(), reader["RegisztracioJelszo"].ToString(), (JogosultsagTipus)Convert.ToUInt32(reader["Jogosultsag"]), (DateTime)reader["RegisztraltDatum"], reader["Nev"].ToString(), reader["Email"].ToString(), reader["Telefon"].ToString()); belep.Add(u); } reader.Close(); } catch (Exception ex) { MessageBox.Show("Hiba a feltöltés során !", ex.Message); } return(belep); }