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