public static void AddPart(int id, SpareParts part)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO card_parts (cardId, partId) VALUES(@cardId, @partId)", con))
{
command.Parameters.AddWithValue("@cardId", id);
command.Parameters.AddWithValue("@partId", part.Id);
command.ExecuteNonQuery();
}
}
}
public static void Add(SpareParts part)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO parts (name,number,price) VALUES(@name,@number,@price)", con))
{
command.Parameters.AddWithValue("@name", part.Name);
command.Parameters.AddWithValue("@number", part.Number);
command.Parameters.AddWithValue("@price", part.Price);
command.ExecuteNonQuery();
}
}
}
public static void Remove(SpareParts part)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand command = new SqlCommand("DELETE FROM parts WHERE id = @id", con))
{
command.Parameters.Add("@id", SqlDbType.Int);
command.Parameters["@id"].Value = part.Id;
command.ExecuteNonQuery();
}
}
}
public static void Update(SpareParts part)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand command = new SqlCommand("UPDATE parts SET name = @name, number = @number, price = @price WHERE id = @id", con))
{
command.Parameters.AddWithValue("@id", part.Id);
command.Parameters.AddWithValue("@name", part.Name);
command.Parameters.AddWithValue("@number", part.Number);
command.Parameters.AddWithValue("@price", part.Price);
command.ExecuteNonQuery();
}
}
}
