private void deleteButton_Click(object sender, EventArgs e) { TsEntity db = new TsEntity(); if (devicesDGV.SelectedRows.Count == 0 && accessoriesDGV.SelectedRows.Count == 0) { MessageBox.Show(" Сначала выберите строчку", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var row = devicesDGV.SelectedRows.Count > 0 ? devicesDGV.SelectedRows[0] : accessoriesDGV.SelectedRows[0]; if (devicesDGV.SelectedRows.Count > 0) { var id = Convert.ToInt32(row.Cells["id"].Value.ToString()); db.devices.Remove(db.devices.Where(it => it.id == id).FirstOrDefault()); db.SaveChanges(); } if (accessoriesDGV.SelectedRows.Count > 0) { var id = Convert.ToInt32(row.Cells["id"].Value.ToString()); db.device_accessories.Remove(db.device_accessories.Where(it => it.id == id).FirstOrDefault()); db.SaveChanges(); } this.Refresh_Click(sender, e); }
private void okButton_Click(object sender, EventArgs e) { DateTime guaranteeEnd, entryDate; TsEntity db = new TsEntity(); try { guaranteeEnd = Convert.ToDateTime(guaranteeTextBox.Text); entryDate = Convert.ToDateTime(entryDateTextBox.Text); } catch (Exception exception) { MessageBox.Show("Введите дату в формате дд.мм.гггг", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var name = nameTextBox.Text; var serialNumber = Convert.ToInt32(serialNumberTextBox.Text); var seller = sellerComboBox.Text; var type = typeComboBox.Text; var globalType = globalTypeComboBox.Text; var price = priceTextBox.Text; var placement = placementComboBox.Text; var responsible = responsibleComboBox.Text; var id = 0; //using (SqlConnection connection = new SqlConnection(connectionString)) //{ // var command = new SqlCommand(); // command.CommandType = CommandType.Text; // command.CommandText = string.Format(@"insert into dbo.devices(deviceName, serialNumber, guaranteeEnd, seller, type, entryDate, price, placement, responsible) // values (N'{0}', {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8})", // name, serialNumber, guaranteeEnd, seller, type, entryDate, price, placement, responsible); // connection.Open(); // command.ExecuteNonQuery(); // connection.Close(); //db.SaveChanges(); switch (Text) { case "Добавить устройство": if (type == "ПК" || type == "Ноутбук" || type == "Моноблок" || globalType == "Устройство") { db.devices.Add(new devices() { deviceName = name, serialNumber = serialNumber, guaranteeEnd = guaranteeEnd, seller = seller, type = type, entryDate = entryDate, price = price, placement = placement, responsible = responsible }); db.SaveChanges(); } if (type == "Мышь" || type == "Клавиатура" || type == "Геймпад" || type == "Аудио-система" || globalType == "Комплектующее") { db.device_accessories.Add(new device_accessories() { accessoryName = name, serialNumber = serialNumber, guaranteeEnd = guaranteeEnd, seller = seller, type = type, entryDate = entryDate, price = price, placement = placement, responsible = responsible }); db.SaveChanges(); } break; case "Редактировать устройство": id = Convert.ToInt32(db.devices.Where(it => it.deviceName == name).FirstOrDefault().id); db.UpdateDeviceForSupport(id, name, serialNumber, guaranteeEnd, seller, type, entryDate, price, placement, responsible); break; case "Редактировать комплекктующее к устройству": id = Convert.ToInt32(db.device_accessories.Where(it => it.accessoryName == name) .FirstOrDefault().id); db.UpdateAccessoryForSupport(id, name, serialNumber, guaranteeEnd, seller, type, entryDate, price, placement, responsible); break; default: return; } this.Close(); }