/// <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));
}
