public Column(string name, int limit)
{
if (limit <= 0 && limit != Constants.InfiniteLimit)
{
// Console.WriteLine("invalid limit");
return;
}
this.Id = ColumnDAL.getMaxID() + 1;
this.name = name;
this.Limit = limit;
tasksList = new List <int>();
}
/// <summary>
/// Inserting new column to database
/// </summary>
/// <param name="column">column to insert</param>
/// <returns>the id of the new column</returns>
public override long Insert(DalObject dalObject)
{
ColumnDAL column = (ColumnDAL)dalObject;
long output = -1;
using (var connection = new SQLiteConnection(_connectionString))
{
SQLiteCommand command = new SQLiteCommand(null, connection);
SQLiteDataReader dataReader = null;
try
{
connection.Open();
command.CommandText = $"INSERT INTO {columnsTable} ({ColumnDAL.columnNameCol} ,{ColumnDAL.columnOrdinalCol} ,{ColumnDAL.LimitCol},{ColumnDAL.boardIdCol}) " +
$"VALUES (@NameVal,@OrdinalVal,@LimitVal,@boardIdVal); SELECT {DalController.seqCol} FROM {DalController.SqlSeq} WHERE {DalController.seqName}='{columnsTable}';";
SQLiteParameter NameParam = new SQLiteParameter(@"NameVal", column.ColumnName);
SQLiteParameter OrdinalParam = new SQLiteParameter(@"OrdinalVal", column.ColumnOrdinal);
SQLiteParameter LimitParam = new SQLiteParameter(@"LimitVal", column.Limit);
SQLiteParameter boardIDParam = new SQLiteParameter(@"boardIdVal", column.BoardId);
command.Parameters.Add(NameParam);
command.Parameters.Add(OrdinalParam);
command.Parameters.Add(LimitParam);
command.Parameters.Add(boardIDParam);
dataReader = command.ExecuteReader();
if (dataReader.Read())
{
output = (long)dataReader.GetValue(0);
}
}
catch (Exception e)
{
log.Error($"Failed to add column{column.ColumnName}", e);
}
finally
{
if (dataReader != null)
{
dataReader.Close();
}
command.Dispose();
connection.Close();
}
return(output);
}
}
public Func <int, int, bool> GetSave()
{
return((location, bid) => { ColumnDAL.saveColumn(this.toStruct(), location, bid); return true; });
}
public static void Delete(int Cid)
{
ColumnDAL.deleteColumn(Cid);
}
public void UpdateLocation(int newLoc)
{
ColumnDAL.UpdateLocation(this.Id, newLoc);
}
/// <summary>
/// Converts reader to column DAL
/// </summary>
/// <param name="reader"></param>
/// <returns>ColumnDAL</returns>
protected override DalObject ConvertReaderToObject(SQLiteDataReader reader)
{
ColumnDAL column = new ColumnDAL((long)reader.GetValue(0), reader.GetString(1), (long)reader.GetValue(2), (long)reader.GetValue(3), (long)reader.GetValue(4));
return(column);
}
//删除栏目
public bool delete(string id)
{
ColumnDAL dal = new ColumnDAL();
return(dal.Delete(id));
}
