private void buttonEdit_Click(object sender, EventArgs e)
 {
     if (listViewUchet.SelectedItems.Count == 1)
     {
         UchetProdSet uchet = listViewUchet.SelectedItems[0].Tag as UchetProdSet;
         uchet.IdPosetitel = Convert.ToInt32(comboBoxPos.SelectedItem.ToString().Split('.')[0]);
         uchet.IdProdavec  = Convert.ToInt32(comboBoxProd.SelectedItem.ToString().Split('.')[0]);
         uchet.IdBook      = Convert.ToInt32(comboBoxBook.SelectedItem.ToString().Split('.')[0]);
         Program.CGDb.SaveChanges();
         ShowUchet();
     }
 }
 private void listViewUchet_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (listViewUchet.SelectedItems.Count == 1)
     {
         UchetProdSet uchet = listViewUchet.SelectedItems[0].Tag as UchetProdSet;
         comboBoxPos.SelectedIndex  = comboBoxPos.FindString(uchet.IdPosetitel.ToString());
         comboBoxProd.SelectedIndex = comboBoxProd.FindString(uchet.IdProdavec.ToString());
         comboBoxBook.SelectedIndex = comboBoxBook.FindString(uchet.IdBook.ToString());
     }
     else
     {
         comboBoxPos.SelectedItem  = null;
         comboBoxProd.SelectedItem = null;
         comboBoxBook.SelectedItem = null;
     }
 }
 private void buttonAdd_Click(object sender, EventArgs e)
 {
     if (comboBoxPos.SelectedItem != null && comboBoxProd.SelectedItem != null && comboBoxBook.SelectedItem != null)
     {
         UchetProdSet uchet = new UchetProdSet();
         uchet.IdPosetitel = Convert.ToInt32(comboBoxPos.SelectedItem.ToString().Split('.')[0]);
         uchet.IdProdavec  = Convert.ToInt32(comboBoxProd.SelectedItem.ToString().Split('.')[0]);
         uchet.IdBook      = Convert.ToInt32(comboBoxBook.SelectedItem.ToString().Split('.')[0]);
         Program.CGDb.UchetProdSet.Add(uchet);
         Program.CGDb.SaveChanges();
         ShowUchet();
     }
     else
     {
         MessageBox.Show("Данные не выбраны", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
 private void buttonDel_Click(object sender, EventArgs e)
 {
     try
     {
         if (listViewUchet.SelectedItems.Count == 1)
         {
             UchetProdSet uchet = listViewUchet.SelectedItems[0].Tag as UchetProdSet;
             Program.CGDb.UchetProdSet.Remove(uchet);
             Program.CGDb.SaveChanges();
         }
         comboBoxPos.SelectedItem  = null;
         comboBoxProd.SelectedItem = null;
         comboBoxBook.SelectedItem = null;
     }
     catch
     {
         MessageBox.Show("Невозможно удалить, эта запись используется", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }