예제 #1
0
        protected void fnSearch()
        {
            string strSearchString = "Jeff";

            String strActivityTable = "";
            String strContactTable = "";

            if (strSearchString != "")
            {
                try
                {
                    using (SforceService.SforceService sfs = new SforceService.SforceService())
                    {
                        var login = sfs.login("*****@*****.**", sfsecret);

                        if (login.passwordExpired)
                        {
                            Response.Write("Salesforce password expired!");
                        }
                        else
                        {
                            sfs.Url = login.serverUrl;
                            sfs.SessionHeaderValue = new SforceService.SessionHeader();
                            sfs.SessionHeaderValue.sessionId = login.sessionId;
                            var userinfo = login.userInfo;

                            String soqlQuery = "";
                            SforceService.QueryResult qResult = null;
                            soqlQuery = "SELECT Id, FirstName, LastName, Phone, Email FROM Contact WHERE FirstName='" + strSearchString + "'";

                            qResult = sfs.query(soqlQuery);
                            Boolean done = false;

                            if (qResult.size > 0)
                            {
                                strContactTable = strContactTable + ("<div style=\"position:absolute; left: 400px; top: 190px;\">");
                                strContactTable = strContactTable + ("<table border=1 bgcolor=silver style=\"border-collapse:collapse;\">");
                                //Response.Write("<th>Id</th>");
                                strContactTable = strContactTable + ("<th>First Name</th>");
                                strContactTable = strContactTable + ("<th>Last Name</th>");
                                strContactTable = strContactTable + ("<th>Phone</th>");
                                strContactTable = strContactTable + ("<th>Email</th>");
                                while (!done)
                                {
                                    SforceService.sObject[] records = qResult.records;
                                    for (int i = 0; i < records.Length; ++i)
                                    {

                                        SforceService.Contact con = (SforceService.Contact)records[i];
                                        strContactTable = strContactTable + ("<tr>");

                                        //Response.Write("<td>");
                                        //Response.Write(con.Id);
                                        //Response.Write("</td>");

                                        //#####################################################################

                                        /*if (i == 0)
                                        {

                                            //Looking at this i dont think i need to actually even run this? I should just be able to drop con.ID in the fnActivitySelect below and it should work? I'm going to piggy back off this query though to put customer ID into session state
                                            String strSqlId = fnSqlSelect(con.Id)[0].ToString();
                                            Session["sfID"] = con.Id;
                                            if (strSqlId != "")
                                            {

                                                strActivityTable = strActivityTable + (fnActivitySelect(strSqlId));

                                            }
                                        }*/

                                        //#######################################################
                                        strContactTable = strContactTable + ("<td>");
                                        strContactTable = strContactTable + (con.FirstName);
                                        strContactTable = strContactTable + ("</td>");
                                        strContactTable = strContactTable + ("<td>");
                                        strContactTable = strContactTable + (con.LastName);
                                        strContactTable = strContactTable + ("</td>");
                                        strContactTable = strContactTable + ("<td>");
                                        strContactTable = strContactTable + (con.Phone);
                                        strContactTable = strContactTable + ("</td>");
                                        strContactTable = strContactTable + ("<td>");
                                        strContactTable = strContactTable + (con.Email);
                                        strContactTable = strContactTable + ("</td");
                                        strContactTable = strContactTable + ("</tr>");

                                    }
                                    if (qResult.done)
                                    {
                                        done = true;
                                    }
                                    else
                                    {
                                        //qResult = sfs.queryMore(qResult.queryLocator);
                                    }
                                }
                                strContactTable = strContactTable + ("</table>");
                                strContactTable = strContactTable + ("</div>");

                                Response.Write(strContactTable);
                                Response.Write(strActivityTable);
                                Session["strContactTable"] = strContactTable;
                                Session["strActivityTable"] = strActivityTable;

                            }
                            else
                            {
                                Response.Write("No records found.");
                            }
                            //Response.Write("\nQuery succesfully executed.");

                        }
                    }
                }
                catch
                {
                    Response.Write("Query Finally!");
                }

                /*catch (k)
                {
                    Response.Write("Query Failed!");
                    throw k;
                }*/
            }
            else
            {
                Response.Write("Search Field Empty!");
            }
        }
예제 #2
0
        protected void fnSearchROE(string strSoql)
        {
            if (txtPassword.Text != "")
            {
                try
                {
                    using (SforceService.SforceService sfs = new SforceService.SforceService())
                    {

                        var login = sfs.login("*****@*****.**", txtPassword.Text + "eBZ2NqwgBq5PEZx0YZT1yO64");

                        if (login.passwordExpired)
                        {
                            Response.Write("Salesforce password expired!");
                        }
                        else
                        {
                            sfs.Url = login.serverUrl;

                            sfs.SessionHeaderValue = new SforceService.SessionHeader();
                            sfs.SessionHeaderValue.sessionId = login.sessionId;
                            var userinfo = login.userInfo;

                            SforceService.QueryResult qResult = null;

                            qResult = sfs.query(strSoql);
                            Boolean done = false;

                            if (qResult.size > 0)
                            {

                                Response.Write("<table border=1>");
                                Response.Write("<tr>");
                                Response.Write("<th>Name</th><th>Status</th><th>Owner</th><th>City</th><th>State</th>");
                                Response.Write("</tr>");
                                while (!done)
                                {
                                    SforceService.sObject[] records = qResult.records;
                                    for (int i = 0; i < records.Length; ++i)
                                    {
                                        Response.Write("<tr>");
                                        SforceService.Account Acc = (SforceService.Account)records[i];
                                        Response.Write("<td>");
                                        Response.Write("<b>");
                                        Response.Write(Acc.Name);
                                        Response.Write("</td>");
                                        Response.Write("<td>");
                                        Response.Write("</b>");
                                        Response.Write(Acc.Prospecting_Status__c);
                                        Response.Write("</td>");
                                        Response.Write("<td>");
                                        Response.Write(Acc.Owner.Name);
                                        Response.Write("</td>");
                                        Response.Write("<td>");
                                        Response.Write(Acc.BillingAddress.city);
                                        Response.Write("</td>");
                                        Response.Write("<td>");
                                        Response.Write(Acc.BillingAddress.state);
                                        Response.Write("</td>");
                                        Response.Write("</tr>");
                                    }
                                    if (qResult.done)
                                    {
                                        done = true;
                                    }
                                }
                                Response.Write("</table>");

                            }
                            else
                            {
                                Response.Write("No records found.");
                            }
                        }
                    }
                }
                catch (WebException k)
                {
                    Response.Write(k);
                }
            }
            else
            {
                Response.Write("No Password!");
            }
        }
예제 #3
0
        protected void fnSearchROE()
        {
            string strSearchString = "JeffsAwesomeBusiness";

            try
            {
                using (SforceService.SforceService sfs = new SforceService.SforceService())
                {
                    var login = sfs.login("*****@*****.**", sfsecret + "KihwNiN0uRiuKqCx8W8A0ZDBk");

                    if (login.passwordExpired)
                    {
                        Response.Write("Salesforce password expired!");
                    }
                    else
                    {
                        sfs.Url = login.serverUrl;

                        sfs.SessionHeaderValue = new SforceService.SessionHeader();
                        sfs.SessionHeaderValue.sessionId = login.sessionId;
                        var userinfo = login.userInfo;

                        String soqlQuery = "";
                        SforceService.QueryResult qResult = null;
                        soqlQuery = "SELECT Name, BillingAddress FROM Account WHERE Name='" + strSearchString + "'";

                        qResult = sfs.query(soqlQuery);
                        Boolean done = false;

                        if (qResult.size > 0)
                        {

                            while (!done)
                            {
                                SforceService.sObject[] records = qResult.records;
                                for (int i = 0; i < records.Length; ++i)
                                {

                                    SforceService.Account Acc = (SforceService.Account)records[i];

                                    //Savvis Specific

                                    Response.Write(Acc.Name);
                                    Response.Write("<br>");

                                    //Response.Write(Acc.BillingAddress.street);
                                    //Response.Write("<br>");
                                    Response.Write(Acc.BillingAddress.city);
                                    Response.Write(",");
                                    Response.Write(Acc.BillingAddress.state);
                                    //Response.Write(" ");
                                    //Response.Write(Acc.BillingAddress.postalCode);
                                    //Response.Write(Acc.BillingAddress.country);
                                    Response.Write("<br>");
                                    Response.Write("<br>");

                                }
                                if (qResult.done)
                                {
                                    done = true;
                                }
                                else
                                {
                                    //qResult = sfs.queryMore(qResult.queryLocator);
                                }
                            }

                        }
                        else
                        {
                            Response.Write("No records found.");
                        }
                    }
                }
            }
            catch (WebException k)
            {
                Response.Write(k);
            }
        }
예제 #4
0
        protected void fnSfUpdateLocalDb()
        {
            List<string> lstId = new List<string>();
            List<string> lstFName = new List<string>();
            List<string> lstLName = new List<string>();
            //List<string> lstPhone = new List<string>();
            List<string> lstDbId = new List<string>();

            try
            {
                using (SforceService.SforceService sfs = new SforceService.SforceService())
                {
                    var login = sfs.login("*****@*****.**", sfsecret);

                    if (login.passwordExpired)
                    {
                        Response.Write("Salesforce password expired!");
                    }
                    else
                    {
                        sfs.Url = login.serverUrl;
                        sfs.SessionHeaderValue = new SforceService.SessionHeader();
                        sfs.SessionHeaderValue.sessionId = login.sessionId;
                        var userinfo = login.userInfo;

                        String soqlQuery = "";
                        SforceService.QueryResult qResult = null;
                        soqlQuery = "SELECT Id, FirstName, LastName, Phone, Email FROM Contact";

                        qResult = sfs.query(soqlQuery);
                        Boolean done = false;

                        if (qResult.size > 0)
                        {
                            while (!done)
                            {
                                SforceService.sObject[] records = qResult.records;
                                for (int i = 0; i < records.Length; ++i)
                                {
                                    SforceService.Contact con = (SforceService.Contact)records[i];
                                    lstId.Add(con.Id);
                                    lstFName.Add(con.FirstName);
                                    lstLName.Add(con.LastName);
                                    //lstPhone.Add(con.Phone);
                                }
                                if (qResult.done)
                                {
                                    done = true;
                                }
                                else
                                {
                                    qResult = sfs.queryMore(qResult.queryLocator);
                                }
                            }
                        }
                        else
                        {
                            Response.Write("No records found.");
                        }
                        Response.Write("\nQuery succesfully executed.");
                    }
                }

            }
            catch (WebException k)
            {
                Response.Write("Query Failed!");
                throw k;
            }

            lstDbId = fnSqlSelect("");

            Boolean blnMatch = false;
            for (int i = 0; i < lstId.Count(); i++)
            {
                for (int ii = 0; ii < lstDbId.Count(); ii++)
                {
                    if (lstId[i].ToString() == lstDbId[ii].ToString())
                    {
                        blnMatch = true;
                    }
                }
                if (blnMatch == false)
                {
                    fnSqlInsert(lstId[i].ToString(), lstFName[i].ToString(), lstLName[i].ToString());
                    blnMatch = false;
                }
                else
                {
                    blnMatch = false;
                }
            }
        }