//// private void TagNameTextBox_LostFocus(object sender, EventArgs e) // { // connection = new DatabaseConnector("localhost", "root", "Keepdfaith7!", "instrumentinformation"); // connection.connect(); // int itemcount = connection.ReturnMachineColumnCount(TagNameTextBox.Text); // //String query = "select count(" + tableName + ") from " + database; // if (itemcount == 0) // { // done.Cursor = Cursors.Hand; // done.Click += Done_Click; // } // else // { // MessageBox.Show("This machine already exists"); // } // } private void Done_Click(object sender, EventArgs e) { //MessageBox.Show(MachineNameTextbox.Text + "--" + (SelectUnitComboBox.SelectedIndex + 1) + (SelectVoltageRating.SelectedIndex + 1)); string UniqueIdHash = MainForm.GetHashedPassword(MachineNameTextbox.Text + (SelectUnitComboBox.SelectedIndex + 1) + TagNameTextBox.Text); if (MachineNameTextbox.Text.Length <= 5 || MachineBriefDescription.Text.Length <= 5 || TagNameTextBox.Text.Length <= 5) { MessageBox.Show("There is an invalid text somewhere"); } else { connection.update("update machine_details set unique_id='" + UniqueIdHash + "',machine_name='" + MachineNameTextbox.Text + "',tag_name='" + TagNameTextBox.Text + "',description='" + MachineBriefDescription.Text + "',unit='" + (SelectUnitComboBox.SelectedIndex + 1) + "',voltage_rating='" + (SelectVoltageRating.SelectedIndex + 1) + "' where unique_id='" + machineUniqueId + "'"); MessageBox.Show("Machine Added!"); connection.disconnect(); } //connection.insert() }
public void doneHandler(object sender, EventArgs e) { if (result == DialogResult.OK) { //insert into database connection = new DatabaseConnector("localhost", "root", "Keepdfaith7!", "instrumentinformation"); string UniqueIdHash = c.GetHashedPassword(tb.Text + tb2.Text); //MessageBox.Show(UniqueIdHash); connection.connect(); int tableSize = connection.ReturnTableSize("departments"); connection.insert("INSERT INTO departments (unique_id,department_name,index_number,brief_description) VALUES('" + UniqueIdHash + "', '" + tb.Text + "','" + (tableSize + 1) + "', '" + briefDescription.Text + "')"); connection.insertImage(tb2.Text, UniqueIdHash); MessageBox.Show("New Department Added!"); deptName = tb.Text; deptImage = tb2.Text; //c.addDepartment(deptName, deptImage); c.emptyDepartmentsFlow(); c.GetDeparmentsFromDatabase(); f.Dispose(); connection.disconnect(); } //deptName = tb.Text; //deptImage = tb2.Text; //c.addDepartment(deptName, deptImage); //f.Dispose(); //to upload the data int the departments database table //connection = new DatabaseConnector("localhost", "root", "Keepdfaith7!", "instrumentinformation"); // connection.connect(); // if (result==DialogResult.OK) // { // MySqlCommand cmd = new MySqlCommand("insert into departments(id,url,image) values(@id, @url," + "@photo" + ")", conn); // MemoryStream ms = new MemoryStream(); // //tb2.Text = op.FileName; has been assigned in the showChooser method so I don't know if it is necessary // } }
private void Done_Click(object sender, EventArgs e) { MessageBox.Show(MachineNameTextbox.Text + "--" + (SelectUnitComboBox.SelectedIndex + 1) + (SelectVoltageRating.SelectedIndex + 1)); string UniqueIdHash = MainForm.GetHashedPassword(MachineNameTextbox.Text + (SelectUnitComboBox.SelectedIndex + 1) + TagNameTextBox.Text); if (MachineNameTextbox.Text.Length <= 5 || MachineBriefDescription.Text.Length <= 5 || TagNameTextBox.Text.Length <= 5) { MessageBox.Show("There is an invalid text somewhere"); } else { connection = new DatabaseConnector("localhost", "root", "Keepdfaith7!", "instrumentinformation"); connection.connect(); connection.insert("INSERT INTO machine_details (unique_id,machine_name,description,unit,voltage_rating,department,tag_name) VALUES('" + UniqueIdHash + "', '" + MachineNameTextbox.Text + "','" + MachineBriefDescription.Text + "', '" + (SelectUnitComboBox.SelectedIndex + 1) + "', '" + (SelectVoltageRating.SelectedIndex + 1) + "', '" + currentDepartmentIndex + "','" + TagNameTextBox.Text + "')"); MessageBox.Show("Machine Added!"); connection.disconnect(); } //connection.insert() }