/// <summary> /// Initializes a new instance of the <see cref="SimplePlaceExecuter"/> class. /// </summary> /// <param name="db">The database.</param> /// <param name="placeName">Name of the place.</param> /// <param name="artistName">Name of the artist.</param> public SimplePlaceExecuter(DataBaseConnector db, string placeName, string artistName) { this.conn = db; bool placePresent = !placeName.Equals(string.Empty); bool artistPresent = !artistName.Equals(string.Empty); this.command = IKnowWhatIWantQuriesBank.GetPlaceQuery(this.conn.Connection, artistPresent, placePresent); if (placePresent) { command.Parameters["@placeName"].Value = "%" + placeName + "%"; } if (artistPresent) { command.Parameters["@artistName"].Value = "%" + artistName + "%"; } }
public bool SetQuery(string songName, string artistName, int fromYear, int toYear) { try { bool songNamePresent = !songName.Equals(string.Empty); bool artistNamePresent = !artistName.Equals(string.Empty); this.command = IKnowWhatIWantQuriesBank.GetArtistQuery(artistNamePresent, songNamePresent, this.conn.Connection); if (songNamePresent) { command.Parameters["@songName"].Value = "%" + songName + "%"; } if (artistNamePresent) { command.Parameters["@artistName"].Value = "%" + artistName + "%"; } command.Parameters["@fromYear"].Value = fromYear; command.Parameters["@toYear"].Value = toYear; return(true); } catch (Exception e) { return(false); } }