public Boolean WriteColumn(NumbColumn col, string boardID, string boardName)
{
String sqlQuery =
"REPLACE INTO Columns (id,name,lim,board_id,board_name) " +
"VALUES (@col_id, @name, @lim, @board_id, @board_name)";
String[] parameters = { "col_id", "name", "lim", "board_id", "board_name" };
String[] args = { col.id, col.name, col.limit.ToString(), boardID, boardName };
return(WriteElement(sqlQuery, parameters, args));
}
private List <NumbTask> getNumbTasksList(NumbColumn col)
{
List <NumbTask> tasks = new List <NumbTask>();
string sql = "SELECT * FROM tasks " + /*Tasks.id,Tasks.title,Tasks.text,Tasks.creation_time,Tasks.due_date " +
* "FROM (Tasks INNER JOIN Columns ON Tasks.column_id=Columns.id) " +*/
"WHERE column_id = @param_col_id ";
SQLiteCommand getTasksComm = new SQLiteCommand(sql, connection);
SQLiteParameter param_col_id = new SQLiteParameter(@"param_col_id", col.id);
getTasksComm.Parameters.Add(param_col_id);
getTasksComm.Connection = connection;
getTasksComm.Prepare();
SQLiteDataReader reader = getTasksComm.ExecuteReader();
while (reader.Read())
{
tasks.Add(new NumbTask((String)reader.GetValue(1), (String)reader.GetValue(2), (String)reader.GetValue(3), (String)reader.GetValue(0), (String)reader.GetValue(4)));
}
return(tasks);
}
