private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Ведите наименование услуги!"); return; } PRICELIST p1 = new PRICELIST(); p1.PNAME = textBox1.Text; p1.IDCLASS = 1; p1.COST = (int)numericUpDown1.Value; PRICELIST p2 = new PRICELIST(); p2.PNAME = textBox1.Text; p2.IDCLASS = 2; p2.COST = (int)numericUpDown2.Value; PRICELIST p3 = new PRICELIST(); p3.PNAME = textBox1.Text; p3.IDCLASS = 3; p3.COST = (int)numericUpDown3.Value; PRICELIST p4 = new PRICELIST(); p4.PNAME = textBox1.Text; p4.IDCLASS = 4; p4.COST = (int)numericUpDown4.Value; PRICELIST p5 = new PRICELIST(); p5.PNAME = textBox1.Text; p5.IDCLASS = 5; p5.COST = (int)numericUpDown5.Value; try { using (CWMEntities cwm = new CWMEntities(EnCon)) { cwm.AddToPRICELIST(p1); cwm.AddToPRICELIST(p2); cwm.AddToPRICELIST(p3); cwm.AddToPRICELIST(p4); cwm.AddToPRICELIST(p5); cwm.SaveChanges(); } } catch (Exception ex) { MessageBox.Show("Ошибка при добавлении услуги!", ex.Message); return; } MessageBox.Show("Услуга успешно добавлена"); Close(); }
public EditPrice(string pn) { InitializeComponent(); using (CWMEntities cwm = new CWMEntities(EnCon)) { var r = from p in cwm.PRICELIST where p.PNAME == pn select p; foreach (PRICELIST pr in r) { if (pr.IDCLASS == 1) { numericUpDown1.Value = pr.COST; pr1 = pr; } if (pr.IDCLASS == 2) { numericUpDown2.Value = pr.COST; pr2 = pr; } if (pr.IDCLASS == 3) { numericUpDown3.Value = pr.COST; pr3 = pr; } if (pr.IDCLASS == 4) { numericUpDown4.Value = pr.COST; pr4 = pr; } if (pr.IDCLASS == 5) { numericUpDown5.Value = pr.COST; pr5 = pr; } } textBox1.Text = pr1.PNAME; } }