public void Create(Product entity)
{
using (SqlConnection connection = conn.OpenConnection())
{
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "Insert into ProductDB (Name, Price, Description, Stock, Sold ) values (@Name, @Price, @Description, @Stock, @Sold)";
cmd.Parameters.AddWithValue("Name", entity.Name);
cmd.Parameters.AddWithValue("Price", entity.Price);
cmd.Parameters.AddWithValue("Description", entity.Description);
cmd.Parameters.AddWithValue("Stock", entity.Stock);
cmd.Parameters.AddWithValue("Sold", entity.Sold);
cmd.ExecuteNonQuery();
}
connection.Close();
}
}
public void Create(Customer entity)
{
using (SqlConnection connection = conn.OpenConnection())
{
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "Insert into CustomerDB (Phone, FName, LName, City, ZipCode, Email, CVR, CustomerType) values (@Phone, @FName, @LName, @City, @ZipCode, @Email, @CVR, @CustomerType)";
cmd.Parameters.AddWithValue("Phone", entity.Phone);
cmd.Parameters.AddWithValue("FName", entity.FName);
cmd.Parameters.AddWithValue("LName", entity.LName);
cmd.Parameters.AddWithValue("City", entity.City);
cmd.Parameters.AddWithValue("ZipCode", entity.ZipCode);
cmd.Parameters.AddWithValue("Email", entity.Email);
cmd.Parameters.AddWithValue("CVR", entity.CVR);
cmd.Parameters.AddWithValue("CustomerType", entity.CustomerType);
cmd.ExecuteNonQuery();
}
connection.Close();
}
}