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 addButton_Click(object sender, EventArgs e) { TsEntity db = new TsEntity(); var supportRedactorForm = new SupportRedactorForm(); supportRedactorForm.Text = "Добавить устройство"; var devices = db.devices.ToList(); var accessories = db.device_accessories.ToList(); FillSupportComboBoxes(devices, accessories, supportRedactorForm); supportRedactorForm.Show(); supportRedactorForm.Text = "Добавить устройство"; if (Text == "Администратор отдела МТО") { supportRedactorForm.label5.Visible = false; supportRedactorForm.label6.Visible = false; supportRedactorForm.label7.Visible = false; supportRedactorForm.ipTextBox.Visible = false; supportRedactorForm.networkNameTextBox.Visible = false; supportRedactorForm.subnetMaskTextBox.Visible = false; } supportRedactorForm.FormClosed += (sen, even) => { this.Refresh_Click(sender, e); }; }
public void Refresh_Click(object sender, EventArgs e) { TsEntity db = new TsEntity(); string whereCondition = ""; if (Text == "Администратор отдела МТО") { whereCondition = "Склад МТО"; } else { whereCondition = "Склад тестировщиков"; } var devices = db.devices.Where(it => it.placement.Equals(whereCondition)).ToList(); var accessories = db.device_accessories.Where(it => it.placement.Equals(whereCondition)).ToList(); devicesDGV.DataSource = devices; devicesDGV.Columns["device_accessories"].Visible = false; if (Text == "Администратор отдела МТО") { devicesDGV.Columns["ip"].Visible = false; devicesDGV.Columns["networkName"].Visible = false; devicesDGV.Columns["subnetMask"].Visible = false; } accessoriesDGV.DataSource = accessories; accessoriesDGV.Columns["devices"].Visible = false; collectionDGV.DataSource = db.supportCollection().Where(it => it.placement.Equals(whereCondition)).ToList(); placementComboBox.Items.Clear(); typeComboBox.Items.Clear(); FillTypeAndPlaces(devices, this); }
private void supButton_Click(object sender, EventArgs e) { var form = new UserForm(); //this.supButton.Enabled = false; //this.testButton.Enabled = false; form.ipTextBox.Visible = false; form.subnetMaskTextBox.Visible = false; form.networkNameTextBox.Visible = false; form.label5.Visible = false; form.label6.Visible = false; form.label7.Visible = false; TsEntity db = new TsEntity(); form.Text = "Администратор отдела МТО"; var devices = db.devices.Where(it => it.placement.Equals("Склад МТО")).ToList(); var accessories = db.device_accessories.Where(it => it.placement.Equals("Склад МТО")).ToList(); form.devicesDGV.DataSource = devices; form.devicesDGV.Columns["id"].Visible = false; form.devicesDGV.Columns["device_accessories"].Visible = false; form.devicesDGV.Columns["ip"].Visible = false; form.devicesDGV.Columns["networkName"].Visible = false; form.devicesDGV.Columns["subnetMask"].Visible = false; form.devicesDGV.Columns["deviceName"].HeaderText = "Наименование"; form.devicesDGV.Columns["serialNumber"].HeaderText = "Серийный номер"; form.devicesDGV.Columns["guaranteeEnd"].HeaderText = "Гарантия до"; form.devicesDGV.Columns["seller"].HeaderText = "Продавец"; form.devicesDGV.Columns["type"].HeaderText = "Тип"; form.devicesDGV.Columns["entryDate"].HeaderText = "Дата поступления"; form.devicesDGV.Columns["price"].HeaderText = "Цена"; form.devicesDGV.Columns["placement"].HeaderText = "Размещение"; form.devicesDGV.Columns["responsible"].HeaderText = "Ответственный"; form.accessoriesDGV.DataSource = accessories; form.accessoriesDGV.Columns["devices"].Visible = false; form.accessoriesDGV.Columns["id"].Visible = false; form.accessoriesDGV.Columns["deviceId"].Visible = false; form.accessoriesDGV.Columns["accessoryName"].HeaderText = "Наименование"; form.accessoriesDGV.Columns["serialNumber"].HeaderText = "Серийный номер"; form.accessoriesDGV.Columns["guaranteeEnd"].HeaderText = "Гарантия до"; form.accessoriesDGV.Columns["seller"].HeaderText = "Продавец"; form.accessoriesDGV.Columns["type"].HeaderText = "Тип"; form.accessoriesDGV.Columns["entryDate"].HeaderText = "Дата поступления"; form.accessoriesDGV.Columns["price"].HeaderText = "Цена"; form.accessoriesDGV.Columns["placement"].HeaderText = "Размещение"; form.accessoriesDGV.Columns["responsible"].HeaderText = "Ответственный"; form.collectionDGV.DataSource = db.supportCollection().Where(it => it.placement.Equals("Склад МТО")).ToList(); form.collectionDGV.Columns["deviceName"].HeaderText = "Наименование устройства"; form.collectionDGV.Columns["seller"].HeaderText = "Продавец"; form.collectionDGV.Columns["type"].HeaderText = "Тип"; form.collectionDGV.Columns["price"].HeaderText = "Цена"; form.collectionDGV.Columns["placement"].HeaderText = "Размещение"; form.collectionDGV.Columns["responsible"].HeaderText = "Ответственный"; form.collectionDGV.Columns["accessoryName"].HeaderText = "Наименование аксессуара"; form.collectionDGV.Columns["seller1"].HeaderText = "Продавец"; form.collectionDGV.Columns["type1"].HeaderText = "Тип"; form.collectionDGV.Columns["price1"].HeaderText = "Цена"; form.collectionDGV.Columns["placement1"].HeaderText = "Размещение"; form.collectionDGV.Columns["responsible1"].HeaderText = "Ответственный"; form.FillTypeAndPlaces(devices, form); form.Show(); }
private void editButton_Click(object sender, EventArgs e) { var supportRedactorForm = new SupportRedactorForm(); TsEntity db = new TsEntity(); supportRedactorForm.nameTextBox.Enabled = false; supportRedactorForm.serialNumberTextBox.Enabled = false; supportRedactorForm.entryDateTextBox.Enabled = false; supportRedactorForm.guaranteeTextBox.Enabled = false; supportRedactorForm.sellerComboBox.Enabled = false; supportRedactorForm.typeComboBox.Enabled = false; supportRedactorForm.globalTypeComboBox.Enabled = false; supportRedactorForm.priceTextBox.Enabled = false; if (devicesDGV.SelectedRows.Count == 0 && accessoriesDGV.SelectedRows.Count == 0) { MessageBox.Show(" Сначала выберите строчку", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (devicesDGV.SelectedRows.Count >= 1 && accessoriesDGV.SelectedRows.Count >= 1) { MessageBox.Show(" Выбрано слишком много строк", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (Text == "Администратор отдела МТО") { supportRedactorForm.label5.Visible = false; supportRedactorForm.label6.Visible = false; supportRedactorForm.label7.Visible = false; supportRedactorForm.ipTextBox.Visible = false; supportRedactorForm.networkNameTextBox.Visible = false; supportRedactorForm.subnetMaskTextBox.Visible = false; } var row = devicesDGV.SelectedRows.Count > 0 ? devicesDGV.SelectedRows[0] : accessoriesDGV.SelectedRows[0]; if (devicesDGV.SelectedRows.Count > 0) { var devices = db.devices.ToList(); supportRedactorForm.Text = "Редактировать устройство"; supportRedactorForm.nameTextBox.Text = row.Cells["deviceName"].Value.ToString(); supportRedactorForm.serialNumberTextBox.Text = row.Cells["serialNumber"].Value.ToString(); supportRedactorForm.guaranteeTextBox.Text = row.Cells["guaranteeEnd"].Value.ToString(); supportRedactorForm.sellerComboBox.Text = row.Cells["seller"].Value.ToString(); supportRedactorForm.typeComboBox.Text = row.Cells["type"].Value.ToString(); supportRedactorForm.entryDateTextBox.Text = row.Cells["entryDate"].Value.ToString(); supportRedactorForm.priceTextBox.Text = row.Cells["price"].Value.ToString(); supportRedactorForm.placementComboBox.Text = row.Cells["placement"].Value.ToString(); supportRedactorForm.responsibleComboBox.Text = row.Cells["responsible"].Value.ToString(); supportRedactorForm.globalTypeComboBox.Text = "Устройство"; if (Text == "Администратор отдела тестировки") { supportRedactorForm.networkNameTextBox.Text = row.Cells["networkName"].Value.ToString(); supportRedactorForm.ipTextBox.Text = row.Cells["ip"].Value.ToString(); supportRedactorForm.subnetMaskTextBox.Text = row.Cells["subnetMask"].Value.ToString(); } FillSupportComboBoxes(devices, null, supportRedactorForm); } if (accessoriesDGV.SelectedRows.Count > 0) { var accessories = db.device_accessories.ToList(); supportRedactorForm.Text = "Редактировать комплекктующее к устройству"; supportRedactorForm.nameTextBox.Text = row.Cells["accessoryName"].Value.ToString(); supportRedactorForm.serialNumberTextBox.Text = row.Cells["serialNumber"].Value.ToString(); supportRedactorForm.guaranteeTextBox.Text = row.Cells["guaranteeEnd"].Value.ToString(); supportRedactorForm.sellerComboBox.Text = row.Cells["seller"].Value.ToString(); supportRedactorForm.typeComboBox.Text = row.Cells["type"].Value.ToString(); supportRedactorForm.entryDateTextBox.Text = row.Cells["entryDate"].Value.ToString(); supportRedactorForm.priceTextBox.Text = row.Cells["price"].Value.ToString(); supportRedactorForm.placementComboBox.Text = row.Cells["placement"].Value.ToString(); supportRedactorForm.responsibleComboBox.Text = row.Cells["responsible"].Value.ToString(); supportRedactorForm.label5.Visible = false; supportRedactorForm.label6.Visible = false; supportRedactorForm.label7.Visible = false; supportRedactorForm.ipTextBox.Visible = false; supportRedactorForm.networkNameTextBox.Visible = false; supportRedactorForm.subnetMaskTextBox.Visible = false; supportRedactorForm.globalTypeComboBox.Text = "Комплектующее"; FillSupportComboBoxes(null, accessories, supportRedactorForm); } supportRedactorForm.Show(); supportRedactorForm.FormClosed += (sen, even) => { 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(); }