public TodoTask GetTaskByID(Guid taskID)
{
TodoTask currentTask = new TodoTask();
string query = "SELECT * FROM TodoTask WHERE TaskID = @taskID";
h.AddParametersToCommand(new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@taskID",
Value = taskID
}
});
SqlDataReader reader = h.MyExecuteReader(query);
reader.Read();
currentTask.TaskID = taskID;
currentTask.BoardID = (Guid)reader["BoardID"];
currentTask.Name = reader["Name"].ToString();
currentTask.Urgency = (bool)reader["Urgency"];
currentTask.Importance = (bool)reader["Importance"];
currentTask.IsFinished = (bool)reader["IsFinished"];
currentTask.IsDeleted = (bool)reader["IsDeleted"];
currentTask.CreatedDate = (DateTime)reader["CreatedDate"];
reader.Close();
return(currentTask);
}
public int GetTaskByLastAdded()
{
int ID = 0;
string query = "SELECT Max(ID) FROM Task";
SqlDataReader reader = h.MyExecuteReader(query);
while (reader.Read())
{
ID = (int)reader[0];
}
return(ID);
}
public Board GetBoardByID(Guid boardID)
{
string query = "SELECT * FROM [Board] WHERE BoardID = @boardID";
h.AddParametersToCommand(new List<SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@boardID",
Value = boardID
}
});
Board currentBoard = new Board();
SqlDataReader reader = h.MyExecuteReader(query);
reader.Read();
currentBoard.BoardID = boardID;
currentBoard.Name = reader["Name"].ToString();
currentBoard.CreatedDate = (DateTime)reader["CreatedDate"];
reader.Close();
return currentBoard;
}
public Board GetBoardByID(int boardID)
{
Board currentBoard = new Board();
string query = "Select * from Board where ID=@boardID";
h.AddParametersToCommand(new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@boardID", Value = boardID
}
});
SqlDataReader reader = h.MyExecuteReader(query);
currentBoard.ID = boardID;
while (reader.Read())
{
currentBoard.Name = reader["Name"].ToString();
}
reader.Close();
return(currentBoard);
}
