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