public void LoadOperatii() { if (_operatii != null) { _operatii.Clear(); } const string stringSql = "SELECT * FROM Operatii"; using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = new SqlCommand(stringSql, connection); using (SqlDataReader sqlReader = command.ExecuteReader()) { while (sqlReader.Read()) { int id = (int)sqlReader["Id"]; string nume = (string)sqlReader["Nume"]; if (nume.Contains("Inchidere")) { InchidereCont inchidere = new InchidereCont(id, nume); _operatii.Add(inchidere); } else { ModificaSuma modifica = new ModificaSuma(id, nume); _operatii.Add(modifica); } } } } }
private void BtnClose_Click(object sender, EventArgs e) { string nume = "Inchidere " + _cont.Id.ToString() + tbNumeOp.Text; long suma = 0; InitOperatie(nume); InchidereCont inchidere = new InchidereCont(); const string stringSql = " SELECT Id FROM Operatii WHERE nume = @nume "; using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = new SqlCommand(stringSql, connection); command.Parameters.AddWithValue("@nume", nume); using (SqlDataReader sqlReader = command.ExecuteReader()) { while (sqlReader.Read()) { int id = (int)sqlReader["Id"]; inchidere.Id = id; } } connection.Close(); } inchidere.nume = nume; inchidere.EfOperatie(nume, _cont, suma); }