private void saveButton_Click(object sender, RoutedEventArgs e) { try { string temp = orgJedBox.SelectedItem.ToString(); string[] words = temp.Split('('); using (pisModelDataContext cont = new pisModelDataContext()) { var query = from c in cont.narudzbenicas where c.id == Convert.ToInt32(idBox.Text) select c; foreach (var ord in query) { ord.id = Convert.ToInt32(idBox.Text); ord.id_org_jed = Convert.ToInt32(words[0]); ord.datum = Convert.ToDateTime(datumPicker.Text); ord.vrijeme = vrijemeBox.Text; } cont.SubmitChanges(); } stavkeNarudzbenice stavke = new stavkeNarudzbenice(); stavke.idBoxx.Text = idBox.Text.ToString(); iznos.tempNarudzbenicaID = Convert.ToInt32(idBox.Text); stavke.ShowDialog(); this.Close(); } catch (Exception ex) { MessageBox.Show("Dogodila se pogreška!!!\n" + ex.Message.ToString()); } }
private void saveButton_Click(object sender, RoutedEventArgs e) { try { string temp = orgJedBox.SelectedItem.ToString(); string[] words = temp.Split('('); int id; using (pisModelDataContext cont = new pisModelDataContext()) { narudzbenica art = new narudzbenica { datum = Convert.ToDateTime(datumPicker.Text), vrijeme = vrijemeBox.Text, id_org_jed = Convert.ToInt32(words[0]) }; cont.narudzbenicas.InsertOnSubmit(art); cont.SubmitChanges(); var entry = (from ee in cont.narudzbenicas select ee).OrderByDescending(ee => ee.id).FirstOrDefault(); id = entry.id; iznos.tempNarudzbenicaID = id; } updateListBox(); //MessageBox.Show(id.ToString()); stavkeNarudzbenice stavke = new stavkeNarudzbenice(); stavke.idBoxx.Text = id.ToString(); //MessageBox.Show(iznos.tempID.ToString()); stavke.ShowDialog(); } catch (Exception ex) { MessageBox.Show("Dogodila se pogreška!!!\n" + ex.Message.ToString()); } }