private void add_things_button_Click(object sender, EventArgs e) { var form = new AddThings(); { var request = "SELECT * FROM Warehouse"; var adapter = new SqlDataAdapter(request, connectionString); var warehouse_table = new DataTable(); adapter.Fill(warehouse_table); var dict = new Dictionary <int, string>(); foreach (DataRow row in warehouse_table.Rows) { dict.Add((int)row["id"], row["partOfTheWarehouse"].ToString()); } form.WarehouseData = dict; } { var request = "SELECT * FROM UnitsForProduct"; var adapter = new SqlDataAdapter(request, connectionString); var units_table = new DataTable(); adapter.Fill(units_table); var dict = new Dictionary <int, string>(); foreach (DataRow row in units_table.Rows) { dict.Add((int)row["id"], row["Units"].ToString()); } form.UnitsData = dict; } var res = form.ShowDialog(); if (res == DialogResult.OK) { var name = form.add_name_textbox.Text; var count = form.add_count_textbox.Text; var temper = form.add_temp_textbox.Text; var price = form.add_price_textbox.Text; var warehouseid = form.WarehouseIdSelect; var unitsid = form.UnitsIdSelect; form.add_date_enter.CustomFormat = "yyyy-MM-dd"; form.add_date_enter.Format = DateTimePickerFormat.Custom; var date_enter = form.add_date_enter.Value; form.add_date_outtime.CustomFormat = "yyyy-MM-dd"; form.add_date_outtime.Format = DateTimePickerFormat.Custom; var date_outtime = form.add_date_outtime.Value; var connection = new SqlConnection(connectionString); connection.Open(); var request = @"INSERT INTO Product (NameOfItem, Units_id, Made, ValidUntil, Quantity, StorageTemperature, Warehouse_id, PurchasePrice) VALUES ('" + name + "','" + unitsid.ToString() + "','" + date_enter.ToString("yyyy-MM-dd") + "'," + "'" + date_outtime.ToString("yyyy-MM-dd") + "','" + count + "','" + temper + "','" + warehouseid.ToString() + "','" + price + "')"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); connection.Close(); updateWarehouseDGV(); } }
private void edit_things_button_Click(object sender, EventArgs e) { var row = warehouse_dgv.SelectedRows.Count > 0 ? warehouse_dgv.SelectedRows[0] : null; if (row == null) { MessageBox.Show("Сначала укажите строку!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var form = new AddThings(); form.add_name_textbox.Text = row.Cells["NameOfItem"].Value.ToString(); form.add_count_textbox.Text = row.Cells["Quantity"].Value.ToString(); form.add_temp_textbox.Text = row.Cells["StorageTemperature"].Value.ToString(); form.add_price_textbox.Text = row.Cells["PurchasePrice"].Value.ToString(); form.add_date_enter.Text = row.Cells["Made"].Value.ToString(); form.add_date_outtime.Text = row.Cells["ValidUntil"].Value.ToString(); { var request = "SELECT * FROM Warehouse"; var adapter = new SqlDataAdapter(request, connectionString); var warehouse_table = new DataTable(); adapter.Fill(warehouse_table); var dict = new Dictionary <int, string>(); foreach (DataRow dbrow in warehouse_table.Rows) { dict.Add((int)dbrow["id"], dbrow["partOfTheWarehouse"].ToString()); } form.WarehouseData = dict; } form.WarehouseIdSelect = (int)row.Cells["Warehouse_id"].Value; { var request = "SELECT * FROM UnitsForProduct"; var adapter = new SqlDataAdapter(request, connectionString); var units_table = new DataTable(); adapter.Fill(units_table); var dict = new Dictionary <int, string>(); foreach (DataRow dbrow in units_table.Rows) { dict.Add((int)dbrow["id"], dbrow["Units"].ToString()); } form.UnitsData = dict; } form.UnitsIdSelect = (int)row.Cells["Units_id"].Value; var res = form.ShowDialog(); if (res == DialogResult.OK) { var name = form.add_name_textbox.Text; var count = form.add_count_textbox.Text; var temper = form.add_temp_textbox.Text; var price = form.add_price_textbox.Text; var warehouseid = form.WarehouseIdSelect; var unitsid = form.UnitsIdSelect; form.add_date_enter.CustomFormat = "yyyy-MM-dd"; form.add_date_enter.Format = DateTimePickerFormat.Custom; var date_enter = form.add_date_enter.Value; form.add_date_outtime.CustomFormat = "yyyy-MM-dd"; form.add_date_outtime.Format = DateTimePickerFormat.Custom; var date_outtime = form.add_date_outtime.Value; var id = row.Cells["id"].Value.ToString(); var connection = new SqlConnection(connectionString); connection.Open(); var request = @"UPDATE Product SET NameOfItem='" + name + "',Units_id='" + unitsid.ToString() + "',Made='" + date_enter.ToString("yyyy-MM-dd") + "',ValidUntil=" + "'" + date_outtime.ToString("yyyy-MM-dd") + "',Quantity='" + count + "',StorageTemperature='" + temper + "',Warehouse_id='" + warehouseid.ToString() + "',PurchasePrice='" + price + "' WHERE id='" + id + "'"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); connection.Close(); updateWarehouseDGV(); } }