public bool setMaxTasks(int max) { if (max <0 | max> int.MaxValue) { log.Error("the value of max tasks is ilegal"); Console.WriteLine("the value of max tasks is ilegal"); return(false); } this.maxTask = max; log.Info("new max task Was determined"); Console.WriteLine("new max task Was determined"); DatColumn datcolumn = getDatColumnById(this.columnId); datcolumn.setMaxTasks(this.maxTask); ColumnHandler.saveColumns(datColumns); return(true); }
public static List <DatColumn> getColumns() { string connetion_string = null; string database_name = "KanbanDataBase.db"; SQLiteConnection connection; connetion_string = $"Data Source={database_name};Version=3;"; connection = new SQLiteConnection(connetion_string); try { connection.Open(); string sql = "select * from Columns"; SQLiteCommand c = new SQLiteCommand(sql, connection); SQLiteDataReader reader = c.ExecuteReader(); List <DatColumn> output = new List <DatColumn>(); while (reader.Read()) { object max = reader["MaxTask"]; object index = reader["ColumnIndex"]; DatColumn dat = new DatColumn(Convert.ToInt32(index), (string)reader["UserName"], (string)reader["ColumnId"], Convert.ToInt32(max), (string)reader["BoardId"]); output.Add(dat); } connection.Close(); return(output); } catch (Exception) { log.Error("problem with extract from database"); return(null); } }