public void add(OrganicElement organicElement) { command.CommandText = "INSERT INTO OrganicElement " + "(Description,FullName,Formula,GraphicModel) VALUES(?descr,?fname,?frml,?graphModel)"; command.Prepare(); command.Parameters.AddWithValue("?descr", organicElement.Description); command.Parameters.AddWithValue("?fname", organicElement.FullName); command.Parameters.AddWithValue("?frml", organicElement.Formula); command.Parameters.AddWithValue("?graphModel", organicElement.GraphicModel); command.ExecuteNonQuery(); }
public OrganicElement findOne(int id) { command.CommandText = "Select * from OrganicElement where id = ?id"; command.Prepare(); command.Parameters.AddWithValue("?id", id); reader = command.ExecuteReader(); reader.Read(); OrganicElement organicElement; try { organicElement = new OrganicElement(int.Parse(reader[0].ToString()), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString()); reader.Close(); } catch (Exception ex) { reader.Close(); return(null); } return(organicElement); }
public void add(OrganicElement element) { organicService.add(element); }
private void Button_Click_1(object sender, RoutedEventArgs e) { if (comboBox.SelectedIndex == 0) { string forChar = tBoxes[7].Text; char[] c = forChar.ToCharArray(); try { chemistryController = new ChemistryElementController(); ChemistryElement element = new ChemistryElement(tBoxes[0].Text, tBoxes[1].Text, tBoxes[2].Text, int.Parse(tBoxes[3].Text), tBoxes[4].Text, int.Parse(tBoxes[5].Text), double.Parse(tBoxes[6].Text), c[0], "/MyImages/Графічні моделі/" + tBoxes[0].Text + ".png", tBoxes[9].Text, tBoxes[10].Text ); chemistryController.add(element); MessageBox.Show("Successfully added " + element); for (int i = 0; i < tBoxes.Length; i++) { tBoxes[i].Text = ""; } } catch (Exception ex) { MessageBox.Show("Failed, something is wrong"); } chemistryController.close(); } else if (comboBox.SelectedIndex == 1) { try { organicController = new OrganicController(); OrganicElement element = new OrganicElement(tBoxes[0].Text, tBoxes[1].Text, tBoxes[2].Text, tBoxes[3].Text); organicController.add(element); MessageBox.Show("Successfully added " + element); for (int i = 0; i < tBoxes.Length; i++) { tBoxes[i].Text = ""; } } catch (Exception ex) { MessageBox.Show("Failed, something is wrong"); } organicController.close(); } else if (comboBox.SelectedIndex == 2) { try { pageController = new PageController(); PageWithTextAndImage element = new PageWithTextAndImage(int.Parse(tBoxes[0].Text), tBoxes[1].Text); pageController.add(element); MessageBox.Show("Successfully added " + element); for (int i = 0; i < tBoxes.Length; i++) { tBoxes[i].Text = ""; } } catch (Exception ex) { MessageBox.Show("Failed, something is wrong"); } pageController.close(); } else if (comboBox.SelectedIndex == 3) { try { imageController = new ImageController(); Picture picture = new Picture(tBoxes[0].Text); imageController.add(picture); MessageBox.Show("Successfully added " + picture); for (int i = 0; i < tBoxes.Length; i++) { tBoxes[i].Text = ""; } } catch (Exception ex) { MessageBox.Show("Failed, something is wrong"); } imageController.close(); } }