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);
}
