// Constructors
internal QRecord(IQApplication application, IQTable table, QColumnCollection columns)
{
Application = application;
Table = table;
Columns = columns;
_fields = new List<QField>();
}
// Creates a new table in QuickBase
internal override IQTable CreateInstance(IQApplication application, string tableName, string pNoun)
{
var columnFactory = QColumnFactory.GetInstance();
var recordFactory = QRecordFactory.GetInstance();
return(new QTable(columnFactory, recordFactory, application, tableName, pNoun));
}
public void InitConnection()
{
if (qbApp == null)
{
LoadSettings();
var client = QuickBase.Login(qbSettings["qbUser"], qbSettings["qbPass"], qbSettings["qbSiteURL"]);
qbApp = client.Connect(qbSettings["qbAppDBID"], qbSettings["qbAppToken"]);
}
}
private void CommonConstruction(QColumnFactoryBase columnFactory, QRecordFactoryBase recordFactory, IQApplication application, string tableId)
{
ColumnFactory = columnFactory;
RecordFactory = recordFactory;
Application = application;
TableId = tableId;
Records = new QRecordCollection(Application, this);
Columns = new QColumnCollection(Application, this);
}
private void CommonConstruction(QColumnFactoryBase columnFactory, QRecordFactoryBase recordFactory, IQApplication application, string tableId)
{
ColumnFactory = columnFactory;
RecordFactory = recordFactory;
Application = application;
TableId = tableId;
KeyFID = -1;
Records = new QRecordCollection(Application, this);
Columns = new QColumnCollection(Application, this);
}
internal QTable(QColumnFactoryBase columnFactory, QRecordFactoryBase recordFactory, IQApplication application, string tableName, string pNoun)
{
var createTable = new CreateTable.Builder(application.Client.Ticket, application.Token, application.Client.AccountDomain, application.ApplicationId)
.SetTName(tableName)
.SetPNoun(pNoun)
.Build();
var xml = createTable.Post().CreateNavigator();
var tableId = xml.SelectSingleNode("/qdbapi/newdbid").Value;
TableName = tableName;
RecordNames = pNoun;
CommonConstruction(columnFactory, recordFactory, application, tableId);
}
private int curUserID;//handles the current UserID for the database
public DBhandler()
{
client = QuickBase.Login("*****@*****.**", "Crescendo1", "johnpriem.quickbase.com");
application = client.Connect("bms24ys95", "duzpt2fcvsybbgkrkup4bjurh8b");
table = application.GetTable(GetTableID("Users"));
//setCurUserID();
//GrabPitch(0);
//GrabPitches();
//GetRecording(0,0);
//GrabRecordings(0);
/*Pulls all users and prints their information
* foreach(IQRecord record in table.Records)
* {
* Console.WriteLine(record[0] + "- " + record[1] + ":" + record[2]);
* }*/
//CreateUser("Jack", "Priem");
}
public void AcceptChanges(IQApplication Application, string tbid)
{
if (ColumnSummary || ColumnVirtual || ColumnLookup || choices.All(c => c.inServer))
{
return;
}
List <string> changeList = new List <string>(choices.Count(c => c.inServer == false));
foreach (Choice ch in choices)
{
if (!ch.inServer)
{
changeList.Add(ch.value.ToString());
ch.inServer = true;
}
}
var fac = new FieldAddChoices(Application.Client.Ticket, Application.Token, Application.Client.AccountDomain, tbid, ColumnId, changeList);
var xml = fac.Post();
Http.CheckForException(xml);
}
internal QRecord(IQApplication application, IQTable table, QColumnCollection columns, XPathNavigator recordNode)
: this(application, table, columns)
{
FillRecord(recordNode);
}
internal abstract IQRecord CreateInstance(IQApplication application, IQTable table, QColumnCollection columns);
internal QTable(QColumnFactoryBase columnFactory, QRecordFactoryBase recordFactory, IQApplication application, string tableName, string pNoun)
{
var createTable = new CreateTable.Builder(application.Client.Ticket, application.Token, application.Client.AccountDomain, application.ApplicationId)
.SetTName(tableName)
.SetPNoun(pNoun)
.Build();
var xml = createTable.Post().CreateNavigator();
var tableId = xml.SelectSingleNode("/qdbapi/newdbid").Value;
TableName = tableName;
RecordNames = pNoun;
CommonConstruction(columnFactory, recordFactory, application, tableId);
}
internal abstract IQTable CreateInstance(IQApplication application, string tableId);
internal abstract IQTable CreateInstance(IQApplication application, string tableName, string pNoun);
// Constructors
internal QTable(QColumnFactoryBase columnFactory, QRecordFactoryBase recordFactory, IQApplication application, string tableId)
{
CommonConstruction(columnFactory, recordFactory, application, tableId);
Load();
}
internal abstract IQRecord CreateInstance(IQApplication application, IQTable table, QColumnCollection columns, XPathNavigator recordNode);
internal override IQRecord CreateInstance(IQApplication application, IQTable table, QColumnCollection columns)
{
return new QRecord(application, table, columns);
}
public QRecordCollection(IQApplication application, IQTable table)
{
Application = application;
Table = table;
}
internal QRecord(IQApplication application, IQTable table, QColumnCollection columns, XElement recordNode)
: this(application, table, columns)
{
FillRecord(recordNode);
}
internal QRecord(IQApplication application, IQTable table, QColumnCollection columns, XPathNavigator recordNode)
: this(application, table, columns)
{
FillRecord(recordNode);
}
// Constructors
internal QTable(QColumnFactoryBase columnFactory, QRecordFactoryBase recordFactory, IQApplication application, string tableId)
{
if (columnFactory == null)
{
columnFactory = QColumnFactory.GetInstance();
recordFactory = QRecordFactory.GetInstance();
CommonConstruction(columnFactory, recordFactory, application, tableId);
IsLoaded = false;
}
else
{
CommonConstruction(columnFactory, recordFactory, application, tableId);
Load();
}
}
internal override IQRecord CreateInstance(IQApplication application, IQTable table, QColumnCollection columns, XPathNavigator recordNode)
{
return new QRecord(application, table, columns, recordNode);
}
internal abstract IQRecord CreateInstance(IQApplication application, IQTable table, QColumnCollection columns, XPathNavigator recordNode);
internal override IQRecord CreateInstance(IQApplication application, IQTable table, QColumnCollection columns, XPathNavigator recordNode)
{
return(new QRecord(application, table, columns, recordNode));
}
internal abstract IQRecord CreateInstance(IQApplication application, IQTable table, QColumnCollection columns);
internal QTable(QColumnFactoryBase columnFactory, QRecordFactoryBase recordFactory, IQApplication application, string tableName, string pNoun)
{
var createTable = new CreateTable.Builder(application.Client.Ticket, application.Token, application.Client.AccountDomain, application.ApplicationId)
.SetTName(tableName)
.SetPNoun(pNoun)
.Build();
var xml = createTable.Post();
var tableId = xml.Element("newdbid").Value;
TableName = tableName;
RecordNames = pNoun;
CommonConstruction(columnFactory, recordFactory, application, tableId);
RefreshColumns(); //grab basic columns that QB automatically makes
IsLoaded = true;
}
internal override IQRecord CreateInstance(IQApplication application, IQTable table, QColumnCollection columns)
{
return(new QRecord(application, table, columns));
}
internal override IQTable CreateInstanceLazy(IQApplication application, string tableId)
{
return(new QTable(null, null, application, tableId));
}
public void InitConnection()
{
var client = QuickBase.Login(Settings.Default.qbUser, Settings.Default.qbPass, Settings.Default.qbSiteURL);
qbApp = client.Connect(Settings.Default.qbAppDBID, Settings.Default.qbAppToken);
}
public QColumnCollection(IQApplication application, IQTable table)
{
Application = application;
Table = table;
}
internal abstract IQTable CreateInstance(IQApplication application, string tableId);
internal abstract IQTable CreateInstance(IQApplication application, string tableName, string pNoun);
// Doesn't create a table in QuickBase
internal override IQTable CreateInstance(IQApplication application, string tableId)
{
var columnFactory = QColumnFactory.GetInstance();
var recordFactory = QRecordFactory.GetInstance();
return new QTable(columnFactory, recordFactory, application, tableId);
}
// Constructors
internal QTable(QColumnFactoryBase columnFactory, QRecordFactoryBase recordFactory, IQApplication application, string tableId)
{
CommonConstruction(columnFactory, recordFactory, application, tableId);
Load();
}
public void Disconnect(IQApplication application)
{
application.Disconnect();
}
public void Disconnect(IQApplication application)
{
application.Disconnect();
}
