Beispiel #1
0
        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);
        }
Beispiel #2
0
        public static void LoadAgentDictionary()
        {
            string       sql  = "SELECT IDKey, FName FROM agents WHERE Active='1'";
            TaskCallback call = populateDictionary;

            DatabaseFunctions.SendToPhp(false, sql, call);
        }
Beispiel #3
0
        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);
        }
Beispiel #4
0
 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);
     }
 }
Beispiel #5
0
        public void archiveCusfields(string result)
        {
            List <String> list = new List <String>();

            cusFieldArchive = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result));
            if (cusFieldArchive.Count > 0)
            {
                for (int i = 0; i < cusFieldArchive["Index"].Count; i++)
                {
                    //These lines move Data from Cusfields to Jobfiels, Never needs to be run again!

                    /*string x = "INSERT INTO jobfields (JobID,jobfields.Index,jobfields.Value,AdvValue) VALUES ('" + cusFieldArchive["CusID"][i] + "','" + cusFieldArchive["Index"][i] + "','" + cusFieldArchive["Value"][i] + "','" + cusFieldArchive["AdvValue"][i] + "')";
                     * list.Add(x);
                     * string y = "UPDATE cusfields SET TaskID='999999' WHERE IDKey='"+cusFieldArchive["IDKey"][i]+"'";
                     * list.Add(y);*/
                }
            }
            DatabaseFunctions.SendBatchToPHP(list);
        }
Beispiel #6
0
        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);
        }
Beispiel #7
0
        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);
        }