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