public void Test_DueDate_GetDueDate()
{
//Arrange
Task testTask = new Task("Mow the lawn", 1, "2017-03-02");
testTask.Save();
string expected = ("2017-03-02");
//Act
string foundDueDate = testTask.GetDueDate();
//Assert
Assert.Equal(expected, foundDueDate);
}
public override bool Equals(System.Object otherTask)
{
if (!(otherTask is Task))
{
return(false);
}
else
{
Task newTask = (Task)otherTask;
bool dueDateEquality = (this.GetDueDate() == newTask.GetDueDate());
bool descriptionEquality = (this.GetDescription() == newTask.GetDescription());
bool categoryEquality = (this.GetCategoryId() == newTask.GetCategoryId());
return(descriptionEquality && dueDateEquality && categoryEquality);
}
}
public override bool Equals(System.Object otherTask)
{
if (!(otherTask is Task))
{
return(false);
}
else
{
Task newTask = (Task)otherTask;
bool idEquality = this.GetId() == newTask.GetId();
bool descriptionEquality = this.GetDescription() == newTask.GetDescription();
bool dueDateEquality = this.GetDueDate() == newTask.GetDueDate();
bool doneEquality = this.GetDone() == newTask.GetDone();
return(idEquality && descriptionEquality && dueDateEquality);
}
}
public override bool Equals(Object otherTask)
{
if (!(otherTask is Task))
{
return(false);
}
else
{
Task newTask = (Task)otherTask;
bool idEquality = (this.GetId() == newTask.GetId());
bool descriptionEquality = (this.GetDescription() == newTask.GetDescription());
bool completedEquality = (this.GetCompleted() == newTask.GetCompleted());
bool dueDateEquality = (this.GetDueDate() == newTask.GetDueDate());
return(idEquality && descriptionEquality && completedEquality && dueDateEquality);
}
}
public void Test_DueDate_SavesInRightFormat()
{
//Arrange
string testDate = "2017-02-17";
string taskDate;
Task testTask = new Task("Mow the lawn", "2017-02-17");
testTask.Save();
//Act
Task foundTask = Task.Find(testTask.GetId());
taskDate = foundTask.GetDueDate();
//Assert
Assert.Equal(testDate, taskDate);
}
public static Task Find(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM tasks WHERE id = @TaskId;", conn);
SqlParameter taskIdParameter = new SqlParameter();
taskIdParameter.ParameterName = "@TaskId";
taskIdParameter.Value = id.ToString();
cmd.Parameters.Add(taskIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
int foundTaskId = 0;
string foundTaskDescription = null;
string foundDueDate = null;
int foundTaskCategoryId = 0;
while (rdr.Read())
{
foundTaskId = rdr.GetInt32(0);
foundTaskDescription = rdr.GetString(1);
foundDueDate = rdr.GetString(2);
foundTaskCategoryId = rdr.GetInt32(3);
}
Task foundTask = new Task(foundTaskDescription, foundDueDate, foundTaskCategoryId, foundTaskId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
Console.WriteLine(foundTask.GetDueDate());
return(foundTask);
}
