private void button1_Click(object sender, EventArgs e) { Mapping.Metveshinomera metvn = new Mapping.Metveshinomera(); Mapping.Metrezerv metr = new Mapping.Metrezerv(); var linq = from n in dbvn.veshinomera where n.id == hotel.Program.Pole.id select n; foreach (var i in linq) { var linq2 = from n in dbr.rezerv where n.idveshi == i.idveshi select n; foreach (var j in linq2) { if (i.kolichestvo >= Convert.ToInt32(numericUpDown1.Value) && j.kolichestvo > Convert.ToInt32(numericUpDown1.Value)) { metr.Edit(j.id, i.idveshi, j.kolichestvo - Convert.ToInt32(numericUpDown1.Value)); } else { if (i.kolichestvo >= Convert.ToInt32(numericUpDown1.Value) && j.kolichestvo == Convert.ToInt32(numericUpDown1.Value)) { metr.Delete(j.id); } else { MessageBox.Show("Не хватает резервов"); } } } } this.Close(); }
private void button1_Click(object sender, EventArgs e) { try { VisiblePrikreplenie vc = new VisiblePrikreplenie(); Mapping.Metveshinomera d = new Mapping.Metveshinomera(); var linq = from n in dbdopuslugi.veshi where n.nazvanie == comboBox1.Items[comboBox1.SelectedIndex].ToString() select n; var linq2 = from n in db.nomera where n.nomer == comboBox2.Items[comboBox2.SelectedIndex].ToString() select n; foreach (var i in linq) { foreach (var j in linq2) { d.ADD(i.id, j.id, Convert.ToInt32(numericUpDown1.Value)); break; } break; } this.Close(); } catch (ArgumentOutOfRangeException) { MessageBox.Show("Не все поля заполнены"); } catch { MessageBox.Show("Error"); } }
private void button1_Click(object sender, EventArgs e) { try { Mapping.Metveshinomera metclient = new Mapping.Metveshinomera(); metclient.Delete(Program.Pole.id); this.Close(); } catch { MessageBox.Show("Error"); } }
private void button1_Click(object sender, EventArgs e) { try { VisiblePrikreplenie vc = new VisiblePrikreplenie(); Mapping.Metveshinomera d = new Mapping.Metveshinomera(); string[] str = comboBox1.Items[comboBox1.SelectedIndex].ToString().Split(new char[] { ' ' }); string[] str1 = comboBox2.Items[comboBox2.SelectedIndex].ToString().Split(new char[] { ' ' }); d.Edit(Program.Pole.id, Convert.ToInt32(str[0]), Convert.ToInt32(str1[0]), Convert.ToInt32(numericUpDown1.Value)); this.Close(); } catch (ArgumentOutOfRangeException) { MessageBox.Show("Не все поля заполнены"); } catch { MessageBox.Show("Error"); } }