public bool Update(Caracteristici_Autoturisme ca) { bool succes = false; SqlConnection conn = new SqlConnection(CONNECTION_STRING); try { //are dreptul de a modifica doar valoarea de exmplu daca Masina cu id X pre caracteristica cu id Y (ABS) - si are dreptul de a //modifica acea carac prezinta sau nu mai prezinta ABS string sql = "Update caracteristici_autoturisme set valoare= @valoare WHERE id_Carac_Auto= @id_Carac_Auto"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@valoare", ca.Valoare); cmd.Parameters.AddWithValue("@id_Carac_Auto", ca.Id_Carac_Auto); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { //query succes succes = true; } else { //query failed succes = false; } } catch (Exception ex) { MessageBox.Show("Exceptie" + ex.Message); } finally { conn.Close(); } return(succes); }
public bool Insert(Caracteristici_Autoturisme ca) { bool succes = false; SqlConnection conn = new SqlConnection(CONNECTION_STRING); try { string sql = "Insert into caracteristici_autoturisme (id_Auto, id_Caracteristici, valoare) values (@id_Auto, @id_Caracteristici, @valoare)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id_Auto", ca.Id_auto); cmd.Parameters.AddWithValue("@id_Caracteristici", ca.Id_carac); cmd.Parameters.AddWithValue("@valoare", ca.Valoare); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { //queryy succes succes = true; } else { //query failed succes = false; } } catch (Exception ex) { MessageBox.Show("Exceptie" + ex.Message); } finally { conn.Close(); } return(succes); }
public bool Delete(Caracteristici_Autoturisme ca) { bool succes = false; SqlConnection conn = new SqlConnection(CONNECTION_STRING); try { string sql = "Delete from caracteristici_autoturisme WHERE id_Carac_Auto = @id_Carac_Auto"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id_Carac_Auto", ca.Id_Carac_Auto); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { succes = true; } else { succes = false; } } catch (Exception ex) { MessageBox.Show("Exceptie" + ex.Message); } finally { conn.Close(); } return(succes); }