// member functions // This version of verifyFlower() will verify that the flower entry // passed as an argument does not exist within the database, rather than // comparing with the contents of a pseudo-database, or a dummy Flower instantiation, // like what was done for Iteration I. public string verifyFlower(string userEnteredEnglish, string userEnteredLatin, string userEnteredBotan, string userEnteredNote, string userEnteredImgPath) { string msgToDisplay; Database_Manager DBMngr = new Database_Manager(); // need to be able to get the flower entry from the database // which matches the id of 'customFlower' // if a change is made to the english name AND that change does not result in it being blank if ((userEnteredEnglish != DBMngr.FetchEnglish(flowerId)) && (userEnteredEnglish != "")) { DBMngr.changeEnglishName(userEnteredEnglish, flowerId); msgToDisplay = "Changes successfully saved!"; } else { msgToDisplay = "Changes unable to be saved: One of the three minimum attributes is missing."; } // same structure for latin name and botanical family if ((userEnteredLatin != DBMngr.FetchLatin(flowerId)) && (userEnteredLatin != "")) { DBMngr.changeLatinName(userEnteredLatin, flowerId); msgToDisplay = "Changes successfully saved!"; } else { msgToDisplay = "Changes unable to be saved: One of the three minimum attributes is missing."; } if ((userEnteredBotan != DBMngr.FetchBotan(flowerId)) && (userEnteredBotan != "")) { DBMngr.changeBotanicalFam(userEnteredBotan, flowerId); msgToDisplay = "Changes successfully saved!"; } else { msgToDisplay = "Changes unable to be saved: One of the three minimum attributes is missing."; } if (userEnteredNote != DBMngr.FetchNote(flowerId) && userEnteredNote != "") { DBMngr.changeNote(userEnteredNote, flowerId); msgToDisplay = "Changes successfully saved!"; } if (userEnteredImgPath != DBMngr.FetchFilePath(flowerId) && userEnteredImgPath != "") { userEnteredImgPath = ChangeFilePath(userEnteredImgPath); DBMngr.changeImgPath(userEnteredImgPath, flowerId); msgToDisplay = "Changes successfully saved!"; } return(msgToDisplay); }
private void FetchNames(int[] id, ref bool res1, ref bool res2, ref bool res3) { //////////////////////////////////////////////////////// string query = "SELECT English, Latin, Botanical FROM Flower WHERE id = " + id[0]; try { Database_Manager db = new Database_Manager(); if (id[0] != 0) { res1 = true; flowers[0].setEnglishName(db.FetchEnglish(id[0])); flowers[0].setLatinName(db.FetchLatin(id[0])); flowers[0].setBotanicalFam(db.FetchBotan(id[0])); if (id[1] != 0) { res2 = true; flowers[1].setEnglishName(db.FetchEnglish(id[1])); flowers[1].setLatinName(db.FetchLatin(id[1])); flowers[1].setBotanicalFam(db.FetchBotan(id[1])); if (id[2] != 0) { res3 = true; flowers[2].setEnglishName(db.FetchEnglish(id[2])); flowers[2].setLatinName(db.FetchLatin(id[2])); flowers[2].setBotanicalFam(db.FetchBotan(id[2])); } } } //TODO //When database is implemented this method will pull name, botanical, and latin for each result //from the database and put it in each flower object } catch (SqlException e) { MessageBox.Show(e.Message); throw; } }
//Query the database using the ID of the entry in question. //Will return the botanical name of the entry //This exists in order to compare English names and Latin names in order to help decide //which one the user might be looking for. private string Fetch_botanical(int id) { string temp; Database_Manager db = new Database_Manager(); try { temp = db.FetchBotan(id); } catch (Exception) { throw; } return(temp); }
private void ChangeToFlowerProfileBtn_Click(object sender, EventArgs e) { Database_Manager DBMngrInstance = new Database_Manager(); new flowerProfile(DBMngrInstance.FetchEnglish(copyOfFlowerId), DBMngrInstance.FetchLatin(copyOfFlowerId), DBMngrInstance.FetchBotan(copyOfFlowerId), DBMngrInstance.FetchNote(copyOfFlowerId), DBMngrInstance.FetchFilePath(copyOfFlowerId), copyOfFlowerId, userAcctType).Show(); this.Hide(); }