/// <summary> /// Override of ToString. Mainly used for testing purposes /// </summary> /// <returns>Returns a string representation of the properties of the object and the associated Chore object</returns> public override string ToString() { //Formats the string with variables from this and base class var sum = string.Format("Chore: {0} \nDescription: {1} \nPoints: {2} \nAssignment: {3} " + "\nDue time: {4} \nDays: ", Name, Description, Points, Assignment, DueTime.ToString("T")); //Adds each day to the list foreach (string day in Days) { sum += "\n" + day; } return(sum); }
/// <summary> /// Updates the DB with the information in the Reocurring Chore targeted by the method /// </summary> public void Update() { //Creates queries that updates the concrete_chore and chore entries with this chore's ID string query = string.Format("UPDATE Reoccurring_chore SET " + "due_time='{0}' WHERE chore_id={1}", DueTime.ToString("T"), ID); string query2 = string.Format("UPDATE chore SET " + "child_id={0}, name='{1}', description='{2}', points={3} WHERE chore_id={4}", Assignment, Name, Description, Points, ID); string query3 = string.Format("DELETE FROM days WHERE reo_id=" + "(SELECT reo_id FROM Reoccurring_chore WHERE chore_id={0})", ID); string query4; //Executes the 3 first queries SqlCommand command = new SqlCommand(query, Functions.DatabaseFunctions.DatabaseConnection); Functions.DatabaseFunctions.DatabaseConnection.Open(); command.ExecuteNonQuery(); command = new SqlCommand(query2, Functions.DatabaseFunctions.DatabaseConnection); command.ExecuteNonQuery(); command = new SqlCommand(query3, Functions.DatabaseFunctions.DatabaseConnection); command.ExecuteNonQuery(); //Creates and executes an insert query for each day in the list foreach (string day in Days) { //Creates the query string query4 = string.Format("INSERT INTO [days] (reo_id, day) VALUES " + "((SELECT reo_id FROM Reoccurring_chore WHERE chore_id={0}), '{1}')", ID, day); //Executes the query command = new SqlCommand(query4, Functions.DatabaseFunctions.DatabaseConnection); command.ExecuteNonQuery(); } //Closes connection to DB Functions.DatabaseFunctions.DatabaseConnection.Close(); }
public override string ToString() { return(DueTime.ToString("dd/MM/yyyy") + " - " + Amount.ToString("F2", CultureInfo.InvariantCulture)); }