public static BoardStruct getBoard(int id)
{
BoardStruct ans = new BoardStruct();
SQLiteCommand command = new SQLiteCommand();
SQLiteDataReader reader = null;
try
{
List <ColumnStruct> list = ColumnDAL.getByBoard(id);
DAL.OpenConnect();
command = new SQLiteCommand(null, DAL.connection);
command.CommandText = "SELECT * FROM Boards WHERE Bid = " + id;
command.Prepare();
reader = command.ExecuteReader();
//string ans = "";
while (reader.Read())
{
int limit = int.Parse("" + reader["TotalLimit"]);
ans = new BoardStruct(id, "" + reader["Name"], list, limit);
//ans += "id: " + reader["Bid"] + "; limit: " + reader["TotalLimit"] + "; name" + reader["Name"] + "/n";
}
command.Dispose();
reader.Close();
DAL.CloseConnect();
}
catch (SQLiteException e)
{
Logger.Log.Fatal("sql exception when retriving board with id: " + id + "\n error: " + e.Message);
if (reader != null)
{
reader.Close();
}
command.Dispose();
DAL.CloseConnect();
}
return(ans);
}
public static int deleteBoard(int boardId)
{
SQLiteCommand command = new SQLiteCommand();
try
{
ColumnDAL.deleteColumnOfBoard(boardId);
DAL.OpenConnect();
command = new SQLiteCommand(null, DAL.connection);
command.CommandText = "DELETE FROM Boards " + " WHERE (Bid = @boardId) ";
SQLiteParameter BID = new SQLiteParameter("@boardId", boardId);
command.Parameters.Add(BID);
command.Prepare();
int changes = command.ExecuteNonQuery();
command.Dispose();
DAL.CloseConnect();
if (changes == 0)
{
Logger.Log.Error("faild to delete board with id: " + boardId + " since it does not exist");
}
else
{
Logger.Log.Info("deleted board with id: " + boardId);
}
return(changes);
}
catch (SQLiteException e)
{
Logger.Log.Fatal("sql exception from deleting board with id: " + boardId + "/n" + e.Message);
command.Dispose();
DAL.CloseConnect();
return(0);
}
}