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();
}
}
