public bool Update(Import_Autoturisme ia) { bool succes = false; SqlConnection conn = new SqlConnection(CONNECTION_STRING); try { string sql = "Update import_autoturisme set id_Auto= @id_Auto, denumire_tara= @denumire_tara WHERE id_Import= @id_Import"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id_Auto", ia.id_Auto); cmd.Parameters.AddWithValue("@denumire_tara", ia.Denumire_tara); cmd.Parameters.AddWithValue("@id_Import", ia.Id_import); 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 Delete(Import_Autoturisme ia) { bool succes = false; SqlConnection conn = new SqlConnection(CONNECTION_STRING); try { string sql = "Delete from import_autoturisme WHERE id_Import = @id_Import"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id_Import", ia.Id_import); 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); }