public void import()
{
string sql = "SELECT * FROM cusfields WHERE cusfields.Index<>'Phone' AND cusfields.Index<>'Address' AND cusfields.Index<>'Source' AND cusfields.Index<>'Modified On' AND cusfields.Index<>'Notes' AND cusfields.Index<>'Region' AND cusfields.Index<>'Created On' AND cusfields.Index<>'Email' AND TaskID IS NULL";
TaskCallback call = archiveCusfields;
DatabaseFunctions.SendToPhp(false, sql, call);
}
public static void LoadAgentDictionary()
{
string sql = "SELECT IDKey, FName FROM agents WHERE Active='1'";
TaskCallback call = populateDictionary;
DatabaseFunctions.SendToPhp(false, sql, call);
}
public async Task <bool> attemptNewLogin(string u, string p, bool s)
{
this.Responded = false;
TaskCallback call = new TaskCallback(response);
string statement = "SELECT IDKey,AgentNum FROM agents WHERE Username='******'AND Password='******';";
DatabaseFunctions.SendToPhp(false, statement, call);
while (!Responded)
{
await Task.Delay(5);
}
bool result;
if (dict.Count > 1)
{
if (s)
{
writeUserDataToFile(u, p);
}
result = true;
}
else
{
result = false;
}
return(result);
}
public void response(string result)
{
string[] input = FormatFunctions.SplitToPairs(result);
dict = FormatFunctions.createValuePairs(input);
Responded = true;
if (dict.Count > 1)
{
ClientData.AgentIDK = int.Parse(dict["IDKey"][0]);
string sql = "SELECT PermissionGranted FROM agentpermissions WHERE AgentID='" + AgentIDK + "'";
TaskCallback call = loadSecurityKeys;
DatabaseFunctions.SendToPhp(false, sql, call);
}
}
public async static Task <string> smartsearch(string term, string table)
{
Responded = false;
TaskCallback call = boolSetter;
string sql = "SELECT smartStatement FROM smartsearch WHERE table='" + table + "' AND term='" + term + "';";
DatabaseFunctions.SendToPhp(false, sql, call);
while (!Responded)
{
await Task.Delay(50);
}
string toReturn = "";
if (dict.Count > 0)
{
foreach (string s in dict["smartStatement"])
{
toReturn += " OR " + s;
}
}
return(toReturn);
}
public async Task <bool> attemptSavedLoginAsync()
{
Responded = false;
loadUserDatafromFile();
TaskCallback call = response;
string statement = "SELECT IDKey,AgentNum FROM agents WHERE Username='******'AND Password='******';";
DatabaseFunctions.SendToPhp(false, statement, call);
while (!Responded)
{
await Task.Delay(50);
}
bool result;
if (dict.Count > 1)
{
result = true;
}
else
{
result = false;
}
return(result);
}
