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