private void buttonAdd_Click(object sender, EventArgs e) { if (comboBoxClient.SelectedItem != null && comboBoxSotr.SelectedItem != null) { ConsultSet cons = new ConsultSet(); cons.IdClient = Convert.ToInt32(comboBoxClient.SelectedItem.ToString().Split('.')[0]); cons.IdSotrudnik = Convert.ToInt32(comboBoxSotr.SelectedItem.ToString().Split('.')[0]); if (comboBoxTypeOfCons.SelectedIndex == 0) { cons.TypeConsult = 0; cons.MobileConsult = Convert.ToString(textBoxPredMobile.Text); } else if (comboBoxTypeOfCons.SelectedIndex == 1) { cons.TypeConsult = 1; cons.AcsessConsult = Convert.ToString(textBoxPredAcsess.Text); } else { cons.TypeConsult = 2; cons.OperConsult = Convert.ToString(textBoxPredOper); } Program.SpDb.ConsultSet.Add(cons); Program.SpDb.SaveChanges(); ShowConsultSet(); } else { MessageBox.Show("Данные не выбраны", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void buttonDel_Click(object sender, EventArgs e) { try { if (comboBoxTypeOfCons.SelectedIndex == 0) { if (listViewMobileCons.SelectedItems.Count == 1) { ConsultSet cons = listViewMobileCons.SelectedItems[0].Tag as ConsultSet; Program.SpDb.ConsultSet.Remove(cons); Program.SpDb.SaveChanges(); ShowConsultSet(); } comboBoxSotr.SelectedItem = null; comboBoxClient.SelectedItem = null; textBoxPredMobile.Text = ""; } else if (comboBoxTypeOfCons.SelectedIndex == 1) { if (listViewAcsessCons.SelectedItems.Count == 1) { ConsultSet cons = listViewAcsessCons.SelectedItems[0].Tag as ConsultSet; Program.SpDb.ConsultSet.Remove(cons); Program.SpDb.SaveChanges(); ShowConsultSet(); } comboBoxSotr.SelectedItem = null; comboBoxClient.SelectedItem = null; textBoxPredAcsess.Text = ""; } else { if (listViewOperCons.SelectedItems.Count == 1) { ConsultSet cons = listViewOperCons.SelectedItems[0].Tag as ConsultSet; Program.SpDb.ConsultSet.Remove(cons); Program.SpDb.SaveChanges(); ShowConsultSet(); } comboBoxSotr.SelectedItem = null; comboBoxClient.SelectedItem = null; textBoxPredOper.Text = ""; } } catch { MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void listViewOperCons_SelectedIndexChanged(object sender, EventArgs e) { if (listViewOperCons.SelectedItems.Count == 1) { ConsultSet cons = listViewOperCons.SelectedItems[0].Tag as ConsultSet; comboBoxClient.SelectedIndex = comboBoxClient.FindString(cons.IdClient.ToString()); comboBoxSotr.SelectedIndex = comboBoxClient.FindString(cons.IdSotrudnik.ToString()); textBoxPredOper.Text = cons.OperConsult.ToString(); } else { comboBoxSotr.SelectedItem = null; comboBoxClient.SelectedItem = null; textBoxPredOper.Text = ""; } }
private void button2_Click(object sender, EventArgs e) { if (comboBoxTypeOfCons.SelectedIndex == 0) { if (listViewMobileCons.SelectedItems.Count == 1) { ConsultSet cons = listViewMobileCons.SelectedItems[0].Tag as ConsultSet; cons.IdSotrudnik = Convert.ToInt32(comboBoxSotr.SelectedItem.ToString().Split('.')[0]); cons.IdClient = Convert.ToInt32(comboBoxClient.SelectedItem.ToString().Split('.')[0]); cons.MobileConsult = Convert.ToString(textBoxPredMobile.Text); Program.SpDb.SaveChanges(); ShowConsultSet(); } } if (comboBoxTypeOfCons.SelectedIndex == 1) { if (listViewAcsessCons.SelectedItems.Count == 1) { ConsultSet cons = listViewAcsessCons.SelectedItems[0].Tag as ConsultSet; cons.IdSotrudnik = Convert.ToInt32(comboBoxSotr.SelectedItem.ToString().Split('.')[0]); cons.IdClient = Convert.ToInt32(comboBoxClient.SelectedItem.ToString().Split('.')[0]); cons.AcsessConsult = Convert.ToString(textBoxPredAcsess.Text); Program.SpDb.SaveChanges(); ShowConsultSet(); } } else { if (listViewOperCons.SelectedItems.Count == 1) { ConsultSet cons = listViewOperCons.SelectedItems[0].Tag as ConsultSet; cons.IdSotrudnik = Convert.ToInt32(comboBoxSotr.SelectedItem.ToString().Split('.')[0]); cons.IdClient = Convert.ToInt32(comboBoxClient.SelectedItem.ToString().Split('.')[0]); cons.OperConsult = Convert.ToString(textBoxPredOper.Text); Program.SpDb.SaveChanges(); ShowConsultSet(); } } }