private void Clear_Input() { //Function to clear all text boxes of data txtBoxName.Clear(); txtBoxSciName.Clear(); RAsHrTxt.Clear(); RAsMinTxt.Clear(); RAsSecTxt.Clear(); DecDTxt.Clear(); DecMinTxt.Clear(); DecSecTxt.Clear(); }
private void btnNebulaeSave_Click(object sender, EventArgs e) { //check Right Ascention is correct if (RAsHrTxt_Valid == false || RAsMinTxt_Valid == false || RAsSecTxt_Valid == false) { //reort error in Right ascention if (MessageBox.Show("Right Ascension is not correct. Please validate data.") == DialogResult.OK) { RAsHrTxt.Select(); } return; } //check that Declination is correct if (DecDTxt_Valid == false || DecMinTxt_Valid == false || DecSecTxt_Valid == false) { //report an error in declination if (MessageBox.Show("Declination is not correct. Please validate data.") == DialogResult.OK) { DecDTxt.Select(); } return; } // If all values valid, add to database else { // Open DB connection connect.Open(); //Bind cmd to SQL commands SqlCommand cmd = connect.CreateCommand(); cmd.CommandType = CommandType.Text; //SQL Command to update data if user wishes to edit data in DB if (editRow == true) { //set editRow to false to prevent future save/delete issues editRow = false; cmd.CommandText = "Update NebulaeFavorites Set CommonName = @commonName, ScientificName = @sciName, RAHr = @RAHr, RAMin = @RAMin, RASec = @RASec, DDeg = @DDeg, DMin = @DMin, DSec = @DSec WHERE (NebulaeID = @NebID)"; cmd.Parameters.AddWithValue("@NebID", nebulaID); } //SQL command to be entered into DB with Scientific Name else if (sciName_Valid == true) { cmd.CommandText = "insert into NebulaeFavorites (CommonName, ScientificName, RAHr, RAMin, RASec, DDeg, DMin, DSec) VALUES (@commonName, @sciName, @RAHr, @RAMin, @RASec, @DDeg, @DMin, @DSec)"; } //SQL command to be entered into DB without scientific name else { cmd.CommandText = "insert into NebulaeFavorites (CommonName, RAHr, RAMin, RASec, DDeg, DMin, DSec) VALUES (@commonName, @RAHr, @RAMin, @RASec, @DDeg, @DMin, @DSec)"; } //Bind variables to SQL command names cmd.Parameters.AddWithValue("@commonName", commonName); cmd.Parameters.AddWithValue("@sciName", sciName); cmd.Parameters.AddWithValue("@RAHr", RAHr); cmd.Parameters.AddWithValue("@RAMin", RAMin); cmd.Parameters.AddWithValue("@RASec", RASec); cmd.Parameters.AddWithValue("@DDeg", DDeg); cmd.Parameters.AddWithValue("@DMin", DMin); cmd.Parameters.AddWithValue("@DSec", DSec); cmd.ExecuteNonQuery(); //Close DB connection and reload datagrid connect.Close(); MessageBox.Show("Submitted " + commonName.Trim() + " into database"); //Clear data from Text boxes Clear_Input(); //Reload Table LoadTable(); //Reload combo box on nebulae user control nebulaePanel.LoadComboBox(); //Set nebula ID to null to prevent unwanted editing or deleting nebulaID = null; } }