public static int AddTech_data(Tech_Data tech_Data)
{
// название процедуры
string sqlExpression = "addTech_data";
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlExpression, connection)
{
// указываем, что команда представляет хранимую процедуру
CommandType = System.Data.CommandType.StoredProcedure
};
// параметр для ввода
SqlParameter Carcase_param = new SqlParameter
{
ParameterName = "@cracase_id",
Value = tech_Data.Car_case.Id
}; SqlParameter Doors_param = new SqlParameter
{
ParameterName = "@doors_count",
Value = tech_Data.Doors_count
}; SqlParameter Seats_param = new SqlParameter
{
ParameterName = "@seats_count",
Value = tech_Data.Seats_count
}; SqlParameter Engine_param = new SqlParameter
{
ParameterName = "@engine_id",
Value = tech_Data.Engine.Id
};
// добавляем параметр
command.Parameters.Add(Carcase_param);
command.Parameters.Add(Doors_param);
command.Parameters.Add(Seats_param);
command.Parameters.Add(Engine_param);
return((int)command.ExecuteScalar());
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
private void AddProduct_Click(object sender, EventArgs e)
{
Engine engine = new Engine((DB_Element)comboxTypeEngine.SelectedItem, ((DB_Element)comBoxPlace.SelectedItem),
float.Parse(comboxEngineCapacity.SelectedItem.ToString()));
engine.Id = DB_TechData_Query.AddEngine(engine);
Tech_Data tech_Data = new Tech_Data((DB_Element)comboxCarcase.SelectedItem, engine, (int)comboxDoors.SelectedItem,
(int)comboxSeats.SelectedItem);
tech_Data.Id = DB_TechData_Query.AddTech_data(tech_Data);
Product product = new Product(InputVIN.Text, (DB_Element)comboxCountry.SelectedItem,
engine, (Model)comboxModel.SelectedItem, tech_Data, true, decimal.Parse(InputPrice.Text));
DB_Product_Query.AddProduct(product);
Update();
}
