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