private void button9_Click_1(object sender, EventArgs c) { Uri uri = new Uri(textBox3.Text); string host = uri.Host; using (DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn)) { var eUri = match.Match_table_xpath.Where(e => e.Uri_host == host).FirstOrDefault(); if (eUri == null) { Match_table_xpath nUri = new Match_table_xpath(); nUri.Uri_host = host.ToString(); nUri.Max_table_xpath = textBox4.Text; nUri.Second_table_xpath = textBox6.Text; nUri.Max_table_id_value = textBox7.Text; nUri.Second_table_id_value = textBox8.Text; match.Match_table_xpath.InsertOnSubmit(nUri); } else { eUri.Uri_host = host.ToString(); eUri.Max_table_xpath = textBox4.Text; eUri.Second_table_xpath = textBox6.Text; eUri.Max_table_id_value = textBox7.Text; eUri.Second_table_id_value = textBox8.Text; //match.match_table_xpath.InsertOnSubmit(eUri); } match.SubmitChanges(); } MessageBox.Show("OK"); }
partial void DeleteMatch_table_xpath(Match_table_xpath instance);
partial void InsertMatch_table_xpath(Match_table_xpath instance);
partial void UpdateMatch_table_xpath(Match_table_xpath instance);
private void button9_Click_1(object sender, EventArgs c) { Uri uri = new Uri(textBox3.Text); string host = uri.Host; //using (SoccerScoreCompact match = new SoccerScoreCompact(cnn)) //{ var eUri = Conn.match.Match_table_xpath.Where(e => e.Uri_host == host).FirstOrDefault(); if (eUri == null) { Match_table_xpath nUri = new Match_table_xpath(); nUri.Uri_host = host.ToString(); nUri.Max_table_xpath = textBox4.Text; nUri.Second_table_xpath = textBox6.Text; nUri.Max_table_id_value = textBox7.Text; nUri.Second_table_id_value = textBox8.Text; Conn.match.Match_table_xpath.InsertOnSubmit(nUri); } else { eUri.Uri_host = host.ToString(); eUri.Max_table_xpath = textBox4.Text; eUri.Second_table_xpath = textBox6.Text; eUri.Max_table_id_value = textBox7.Text; eUri.Second_table_id_value = textBox8.Text; //match.Match_table_xpath.InsertOnSubmit(eUri); } Conn.match.SubmitChanges(); //} MessageBox.Show("OK"); }