private void buttonAdd_Click(object sender, EventArgs e) { WorkersSet workersSet = new WorkersSet(); workersSet.FirstName = boxFirstName.Text; workersSet.MiddleName = boxMiddleName.Text; workersSet.LastName = boxLastName.Text; workersSet.Phone = boxPhone.Text; workersSet.Address = boxAddress.Text; workersSet.Position = boxPosition.Text; Program.wftDb.WorkersSet.Add(workersSet); Program.wftDb.SaveChanges(); ShowWorker(); }
private void buttonEdit_Click(object sender, EventArgs e) { if (listViewClient.SelectedItems.Count == 1) { WorkersSet workersSet = listViewClient.SelectedItems[0].Tag as WorkersSet; workersSet.FirstName = boxFirstName.Text; workersSet.MiddleName = boxMiddleName.Text; workersSet.LastName = boxLastName.Text; workersSet.Phone = boxPhone.Text; workersSet.Address = boxAddress.Text; workersSet.Position = boxPosition.Text; Program.wftDb.SaveChanges(); ShowWorker(); } }
public MainWindow() { InitializeComponent(); CreateMenuPlugins(); //Создаем меню со списком Плагинов try { WorkersSet db = new WorkersSet(); CoWorkerGrid.ItemsSource = db.Co_Workers; //Связываем таблицу с БД } catch (Exception ex) { txtPhrase.Text += "\n" + ex.Message; } }
public Worker Search(string input) { WorkersSet db = new WorkersSet(); var workers = db.Co_Workers.ToList(); Worker worker = new Worker(); foreach (var item in workers) { if (input.ToString() == item.C_Name.ToString()) { worker.ID = item.ID; worker.C_Name = item.C_Name; worker.C_Surname = item.C_Surname; worker.C_email = item.C_email; worker.C_Date_of_Birth = item.C_Date_of_Birth; worker.C_adress = item.C_adress; } } return(worker); }
private void buttonDel_Click(object sender, EventArgs e) { try { if (listViewClient.SelectedItems.Count == 1) { WorkersSet workersSet = listViewClient.SelectedItems[0].Tag as WorkersSet; Program.wftDb.WorkersSet.Remove(workersSet); Program.wftDb.SaveChanges(); ShowProduct(); } Manufacturer.Text = ""; Price.Text = ""; NameProduct.Text = ""; Amount.Text = ""; } catch { MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonDel_Click(object sender, EventArgs e) { try { if (listViewClient.SelectedItems.Count == 1) { WorkersSet workersSet = listViewClient.SelectedItems[0].Tag as WorkersSet; Program.wftDb.WorkersSet.Remove(workersSet); Program.wftDb.SaveChanges(); ShowWorker(); } //очищаем textBoxt-ы boxFirstName.Text = ""; boxMiddleName.Text = ""; boxLastName.Text = ""; boxPhone.Text = ""; boxAddress.Text = ""; boxPosition.Text = ""; } catch { MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }