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