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