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