public ChemistryElement findByTableName(string tableName) { command.CommandText = "Select * from ChemistryElement where tableName = ?tb"; command.Prepare(); command.Parameters.AddWithValue("?tb", tableName); reader = command.ExecuteReader(); reader.Read(); ChemistryElement chemistryElement; try { string str = reader[8].ToString(); char c = str[0]; chemistryElement = new ChemistryElement(int.Parse(reader[0].ToString()), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), int.Parse(reader[4].ToString()), reader[5].ToString(), int.Parse(reader[6].ToString()), double.Parse(reader[7].ToString()), c, reader[9].ToString(), reader[10].ToString(), reader[11].ToString()); //Console.Write(chemistryElement); reader.Close(); } catch (Exception ex) { //reader.Close(); return(null); } return(chemistryElement); }
private void readFromFileAndAddToDB(string nameFile) { StreamReader filereader = new StreamReader(nameFile); string str = filereader.ReadToEnd(); //MessageBox.Show(str+"\n"+ str.Split('^').Length+str.Split('^')[0].Split('|').Length); string[] elements = str.Split('^'); for (int i = 1; i < elements.Length; i++) { chemistryController = new ChemistryElementController(); string[] fields = elements[i].Split('|'); string str1 = ""; for (int i1 = 0; i1 < fields.Length; i1++) { str1 += fields[i1] + "\n"; } MessageBox.Show(str1); ChemistryElement chemistryElement = new ChemistryElement( fields[0], fields[1], fields[2], int.Parse(fields[3]), fields[4], int.Parse(fields[5]), double.Parse(fields[6]), 'o', fields[8], fields[9], fields[10]); chemistryElement.GraphicModel = "/MyImages/Графічні моделі/" + chemistryElement.FullName + ".png"; chemistryController.add(chemistryElement); chemistryController.close(); } filereader.Close(); }
public CheckedElement(MainWindow mainWind, ChemistryElement chemElem) { InitializeComponent(); parent = mainWind; viewController = new ViewController(parent); addImage(chemElem.GraphicModel); addRichTextBox(chemElem); }
private void addRichTextBox(ChemistryElement element) { RichTextBox richBox = new RichTextBox(); Thickness margin = richBox.Margin; richBox.Width = 500; richBox.Height = 500; margin.Left = 170; margin.Top = -420; richBox.FontSize = 24; richBox.Margin = margin; richBox.IsReadOnly = true; stPnel.Children.Add(richBox); richBox.Document.Blocks.Add(new Paragraph(new Run(element.ToString()))); }
private void Button_Clickk(object sender, EventArgs e) { //string buttonText = ((Button)sender).Text; Button b = (Button)sender; //MessageBox.Show("" + b.Content); string cont = (string)b.Content; string[] lines = cont.Split('\n'); string[] tableName = lines[0].Split(' '); //MessageBox.Show(tableName[0].Length+" "+tableName[0]); chemistryController = new ChemistryElementController(); ChemistryElement element = chemistryController.findByTableName(tableName[0]); chemistryController.close(); viewController.checkedChemistryElementPage(element); }
private void addRichTextBox(ChemistryElement element, int index) { RichTextBox richBox = new RichTextBox(); Thickness margin = richBox.Margin; richBox.Width = 160; richBox.Height = 256; richBox.IsReadOnly = true; //margin.Left = -300; //margin.Top = 0; richBox.Margin = margin; //stPnel.Children.Add(richBox); richBox.Document.Blocks.Add(new Paragraph(new Run(element.ToString()))); Grid.SetRow(richBox, index / 4 + 1); Grid.SetColumn(richBox, (index % 4) * 2 + 1); allElements.Children.Add(richBox); }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////MAIN QUERIES//////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public void add(ChemistryElement chElem) { command.CommandText = "INSERT INTO ChemistryElement " + "(FullName,TableName,Description,Groupp,Valence,Period,AtomicWeight,Orbital,GraphicModel,Formula,NaturalName)" + "Values (?ful,?tbl,?dscr,?grp,?vlns,?per,?aw,?orbt,?grphic,?frml,?ntral)"; command.Prepare(); command.Parameters.AddWithValue("?ful", chElem.FullName); command.Parameters.AddWithValue("?tbl", chElem.TableTame); command.Parameters.AddWithValue("?dscr", chElem.Description); command.Parameters.AddWithValue("?grp", chElem.Group); command.Parameters.AddWithValue("?vlns", chElem.Valence); command.Parameters.AddWithValue("?per", chElem.Period); command.Parameters.AddWithValue("?aw", chElem.AtomicWeight); command.Parameters.AddWithValue("?orbt", chElem.Orbital); command.Parameters.AddWithValue("?grphic", chElem.GraphicModel); command.Parameters.AddWithValue("?frml", chElem.Formula); command.Parameters.AddWithValue("?ntral", chElem.NaturalName); command.ExecuteNonQuery(); }
//коли вибиваєм елемент з таблички public void checkedChemistryElementPage(ChemistryElement chemistryElement) { mainWind.MainThis.Children.Clear(); mainWind.MainThis.Children.Add(new CheckedElement(mainWind, chemistryElement)); }
public void add(ChemistryElement chemistryElement) { chemistryService.add(chemistryElement); }
private void button_Click(object sender, RoutedEventArgs e) { switch (comboBox.SelectedIndex) { case 0: { chemistryController = new ChemistryElementController(); ChemistryElement chemistryElement = chemistryController.findByTableName(textBox1.Text); chemistryController.close(); clearScreen(); try { addImage(chemistryElement.GraphicModel, 0); addRichTextBox(chemistryElement, 0); } catch (NullReferenceException ex) { } break; } case 1: try { int group = int.Parse(textBox1.Text); } catch (Exception ex) { MessageBox.Show("Only integer value can be read from this text box!!!"); return; } { clearScreen(); chemistryController = new ChemistryElementController(); List <ChemistryElement> chemistryElements = chemistryController.findAllByGroup(textBox1.Text); for (int i = 0; i < chemistryElements.Count; i++) { addImage(chemistryElements[i].GraphicModel, i); addRichTextBox(chemistryElements[i], i); } chemistryController.close(); } break; case 2: { if (textBox1.Text != "p" && textBox1.Text != "s" && textBox1.Text != "d") { MessageBox.Show("Orbitals can be only like 'p' or 's' or 'd'!!!"); return; } clearScreen(); chemistryController = new ChemistryElementController(); List <ChemistryElement> chemistryElements = chemistryController.findAllByOrbital(textBox1.Text); for (int i = 0; i < chemistryElements.Count; i++) { addImage(chemistryElements[i].GraphicModel, i); addRichTextBox(chemistryElements[i], i); } chemistryController.close(); } break; case 3: { clearScreen(); chemistryController = new ChemistryElementController(); List <ChemistryElement> elements = chemistryController.findAll(); for (int i = 0; i < elements.Count; i++) { string str = "/MyImages/Графічні моделі/Гідроген.png"; addImage(elements[i].GraphicModel, i); addRichTextBox(elements[i], i); } chemistryController.close(); } break; } }
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(); } }