public void UntestedTest()
{
InitConnection();
List <GrantedAppsInfo> appsLst = qbApp.GrantedDBs();
IQTable testTab = null;
foreach (var app in appsLst)
{
foreach (var tab in app.GrantedTables)
{
if (tab.Name == "APITestApp: APIUntested")
{
testTab = qbApp.GetTable(tab.Dbid);
break;
}
}
if (testTab != null)
{
break;
}
}
testTab.Query();
IQRecord rec = testTab.Records[0];
var htmlStr = rec["RichText"];
var multiText = rec["MultiLine"];
var mselect = rec["MultiSelect"];
}
public int GetUserIDByUserName(String userName)
{
int uID = -1;
table = application.GetTable(GetTableID("Users"));
table.Query();
IQRecord tempUser = table.Records.Where(x => x[1] == userName).SingleOrDefault();
if (tempUser != null)
{
Int32.TryParse(tempUser[0], out uID);
}
return(uID);
}
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");
}