public async Task <IEnumerable <Record> > GetRecords(string objectType) { Client = new SoapClient(); CallOptions callOptions = new CallOptions(); LoginScopeHeader loginScopeHeader = new LoginScopeHeader() { organizationId = SConfig.OrganizationId, portalId = SConfig.PortalId }; LocaleOptions lOptions = new LocaleOptions(); //callOptions.client = ""; var packageVersionsHeader = new List <PackageVersion>(); List <Record> Records = new List <Record>(); var lr = loginToSalesForce(); if (lr.Result) { //var sObjectArray = Client.describeSObjectsAsync(sessionHeader, callOptions, packageVersionsHeader.ToArray(), lOptions, new string[] { objectType }); var sObjectArray = Client.describeSObjectsAsync(sessionHeader, null, null, null, new string[] { objectType }); foreach (var item in sObjectArray.Result.result) { Record rec = new Record(); for (var i = 0; i < item.fields.Count(); i++) { rec.Name = item.fields[i].name; Records.Add(rec); } } } return(Records); }
public async Task <bool> loginToSalesForce() { CallOptions callOptions = new CallOptions(); LoginScopeHeader loginScopeHeader = new LoginScopeHeader() { organizationId = SConfig.OrganizationId, portalId = SConfig.PortalId }; //callOptions.client = ""; LoginClient = new SoapClient(); //loginResponse res = await LoginClient.loginAsync(loginScopeHeader, callOptions, SConfig.UserName, SConfig.Password); try { loginResponse res = await LoginClient.loginAsync(null, null, SConfig.UserName, SConfig.Password); var sessionId = res.result.sessionId; if (!string.IsNullOrEmpty(sessionId)) { Client.Endpoint.Address = new System.ServiceModel.EndpointAddress(res.result.serverUrl); sessionHeader = new SessionHeader() { sessionId = sessionId }; return(true); } else { return(false); } } catch (Exception e) { var mes = e; return(false); } }
//[Route("IntegerateSfCustomeList")] public ClsCustomerServiceLineResponse IntegerateSfCustServiceLine(ClsCusServiceLineIntegRequest ObjRequest) { ClsCustomerServiceLineResponse ObjResponse = new ClsCustomerServiceLineResponse(); List <ClsListofCustServiceLine> LstRes = new List <ClsListofCustServiceLine>(); try { //ObjRequest.LoginUserName = "******"; //ObjRequest.LoginPassword = "******" + "6ohQKoPPG99OP0u8SalTFy8E"; SoapClient ss = new SoapClient(); LoginResult lr = new LoginResult(); LoginScopeHeader LH = new LoginScopeHeader(); if (sessionId == null | sessionId == "") { // Login Call lr = ss.login(null, ObjRequest.LoginUserName, ObjRequest.LoginPassword); if (lr.passwordExpired) { ObjResponse.StatusID = 300; ObjResponse.StatusDescription = "Password Expired"; return(ObjResponse); } sessionId = lr.sessionId.ToString().Trim(); serverUrl = lr.serverUrl.ToString().Trim(); } // Store SessionId in SessionHeader; We will need while making query() call SessionHeader sHeader = new SessionHeader(); sHeader.sessionId = sessionId; // Variable to store query results QueryResult qr = new QueryResult(); SoapClient ss1 = new SoapClient(); ss1.ChannelFactory.Endpoint.Address = new System.ServiceModel.EndpointAddress(serverUrl); ss1.query(sHeader, null, null, null, @"SELECT Id ,Name ,enrtcr__Remaining__c ,enrtcr__Item_Overclaim__c ,enrtcr__Support_Contract__c ,enrtcr__Support_Contract__r.Name ,enrtcr__Support_Contract__r.enrtcr__End_Date__c ,enrtcr__Support_Contract__r.enrtcr__Status__c ,enrtcr__Support_Contract__r.enrtcr__Funding_Type__c ,enrtcr__Support_Contract__r.enrtcr__Funding_Management__c ,enrtcr__Support_Contract__r.enrtcr__Client__c ,enrtcr__Category_Item__r.enrtcr__Support_Category_Amount__c ,enrtcr__Category_Item__r.enrtcr__Delivered__c ,enrtcr__Site__c ,enrtcr__Site__r.Name ,enrtcr__Site__r.enrtcr__Site_GL_Code__c ,enrtcr__Service__c ,enrtcr__Service__r.Name ,enrtcr__Site_Service_Program__c ,enrtcr__Rate__c ,enrtcr__Rate__r.Name ,enrtcr__Rate__r.enrtcr__Amount_Ex_GST__c ,enrtcr__Rate__r.enrtcr__Quantity_Type__c ,enrtcr__Rate__r.enrtcr__Allow_Rate_Negotiation__c FROM enrtcr__Support_Contract_Item__c WHERE ( (enrtcr__Service__c = 'a0h5P0000004KmMQAU' AND enrtcr__Rate__r.enrtcr__Quantity_Type__c = 'Annual') OR (enrtcr__Service__c = 'a0h5P0000005n8GQAQ' AND enrtcr__Rate__r.enrtcr__Quantity_Type__c = 'Each') OR (enrtcr__Service__c = 'a0h5P0000004L35QAE' AND enrtcr__Rate__r.enrtcr__Quantity_Type__c = 'Hour') ) ", out qr); sObject[] records = qr.records; if (records != null) { if (records.Length > 0) { for (var i = 0; i <= records.Length - 1; i++) { ClsListofCustServiceLine Res = new ClsListofCustServiceLine(); Res.Id = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).Id; Res.Name = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).Name; Res.enrtcr__remaining__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Remaining__c; Res.enrtcr__Item_Overclaim__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Item_Overclaim__c; Res.enrtcr__Support_Contract__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__c; Res.enrtcr__Support_Contract__r_Name = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.Name; Res.enrtcr__Support_Contract__r_enrtcr__End_Date__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__End_Date__c; Res.enrtcr__Support_Contract__r_enrtcr__Status__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Status__c; Res.enrtcr__Support_Contract__r_enrtcr__Funding_Type__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Funding_Type__c; Res.enrtcr__Support_Contract__r_enrtcr__Funding_Management__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Funding_Management__c; Res.enrtcr__Support_Contract__r_enrtcr__Client__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Client__c; Res.enrtcr__Category_Item__r_enrtcr__Support_Category_Amount__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Category_Item__r.enrtcr__Support_Category_Amount__c; Res.enrtcr__Category_Item__r_enrtcr__Delivered__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Category_Item__r.enrtcr__Delivered__c; Res.enrtcr__Site__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Site__c; Res.enrtcr__Site__r_Name = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Site__r.Name; Res.enrtcr__Site__r_enrtcr__Site_GL_Code__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Site__r.enrtcr__Site_GL_Code__c; Res.enrtcr__Service__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Service__c; Res.enrtcr__Service__r_Name = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Service__r.Name; Res.enrtcr__Site_Service_Program__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Site_Service_Program__c; Res.enrtcr__Rate__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__c; Res.enrtcr__Rate__r_Name = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__r.Name; Res.enrtcr__Rate__r_enrtcr__Amount_Ex_GST__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__r.enrtcr__Amount_Ex_GST__c; Res.enrtcr__Rate__r_enrtcr__Quantity_Type__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__r.enrtcr__Quantity_Type__c; Res.enrtcr__Rate__r_enrtcr__Allow_Rate_Negotiation__c = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__r.enrtcr__Allow_Rate_Negotiation__c; LstRes.Add(Res); } ObjResponse.StatusID = 200; ObjResponse.StatusDescription = "Success"; ObjResponse.ObjLstCutomers = LstRes; } else { ObjResponse.StatusID = 202; ObjResponse.StatusDescription = "Query executed successfully with no records returned"; } } else { ObjResponse.StatusID = 201; ObjResponse.StatusDescription = "Query executed successfully with null result"; } return(ObjResponse); } catch (Exception ex) { ObjResponse.StatusID = 500; ObjResponse.StatusDescription = ex.Message.ToString(); return(ObjResponse); } }
public bool InsertDataintoSFDC(string userName, string password) { bool Result = false; var bllist = GetBillingInformation(); List <Customer> lstCus = new List <Customer>(); bool result = false; SoapClient ss = new SoapClient(); LoginResult lr = new LoginResult(); LoginScopeHeader LH = new LoginScopeHeader(); if (sessionId == null | sessionId == "") { lr = ss.login(null, userName, password); if (!lr.passwordExpired) { sessionId = lr.sessionId.ToString().Trim(); serverUrl = lr.serverUrl.ToString().Trim(); // Store SessionId in SessionHeader; We will need while making query() call SessionHeader sHeader = new SessionHeader(); sHeader.sessionId = sessionId; serverUrl = "https://abilitycentre--NEWACUAT.my.salesforce.com/services/Soap/c/51.0/00D5P0000008nfN"; // Variable to store query results QueryResult qr = new QueryResult(); SoapClient ss1 = new SoapClient(); //ss1.ChannelFactory.Endpoint.Address = new System.ServiceModel.EndpointAddress("https://abilitycentre--NEWACUAT.my.salesforce.com/services/data/v51.0/composite/tree/enrtcr__Support_Delivered__c/"); ss1.ChannelFactory.Endpoint.Address = new System.ServiceModel.EndpointAddress(serverUrl); //foreach (var res in bllist) //{ enrtcr__Support_Delivered__c esdc = new enrtcr__Support_Delivered__c(); esdc.Batch_Created__c = true; esdc.enrtcr__Client__c = "0035P000003ws2OQAQ"; esdc.enrtcr__Date__c = Convert.ToDateTime("2021-03-30"); esdc.enrtcr__Quantity__c = 10; esdc.enrtcr__Support_Contract_Item__c = "a0n5P000000kHNgQAM"; esdc.enrtcr__Support_Contract__c = "a0o5P000000Bc9vQAC"; esdc.enrtcr__Site__c = "a0l5P000000046nQAA"; esdc.enrtcr__Support_CategoryId__c = "a0c5P000000Co8EQAS"; esdc.enrtcr__Site_Service_Program__c = "a0j5P000000dLBpQAM"; esdc.enrtcr__Rate__c = "a0b5P0000014SHkQAM"; esdc.enrtcr__Worker__c = "0057F000005AtbWQAS"; esdc.enrtcr__Client_Rep_Accepted__c = true; esdc.enrtcr__Use_Negotiated_Rate__c = true; esdc.enrtcr__Negotiated_Rate_Ex_GST__c = 0.85; esdc.enrtcr__Negotiated_Rate_GST__c = 0.00; LimitInfo[] limt; SaveResult[] createResults; try { ss.create(sHeader, null, null, null, null, null, null, null, null, null, null, null, new sObject[] { esdc }, out limt, out createResults); // CreateRecord(new HttpClient(), "New Record", "enrtcr__Support_Delivered__c", esdc); // Result = true; var results = createResults[0].success; } catch (Exception ex) { var exp = ex.ToString(); Result = false; } // } // } } return(Result); }
public bool IntegerateSfCustServiceLine(string userName, string password) { logger.Info("Scheduled Customer Service Line job triggered"); DBAction dba = new DBAction(_integrationAppSettings); string filterstring = dba.GetSalesforceInformation().Replace("\n", ""); bool result = false; List <CustomerServiceLine> ltsCusline = new List <CustomerServiceLine>(); SoapClient ss = new SoapClient(); LoginResult lr = new LoginResult(); LoginScopeHeader LH = new LoginScopeHeader(); if (sessionId == null | sessionId == "") { lr = ss.login(null, userName, password); if (!lr.passwordExpired) { sessionId = lr.sessionId.ToString().Trim(); serverUrl = lr.serverUrl.ToString().Trim(); } } // Store SessionId in SessionHeader; We will need while making query() call SessionHeader sHeader = new SessionHeader(); sHeader.sessionId = sessionId; // Variable to store query results QueryResult qr = new QueryResult(); SoapClient ss1 = new SoapClient(); ss1.ChannelFactory.Endpoint.Address = new System.ServiceModel.EndpointAddress(serverUrl); var lastintegratedDate = dba.GetLastintegratedDateandTime("Last_CustomerLineIntegrate"); // if (lastintegratedDate == null) ss1.query(sHeader, null, null, null, @"SELECT Id ,Name ,enrtcr__Remaining__c ,enrtcr__Item_Overclaim__c ,enrtcr__Support_Contract__c ,enrtcr__Support_Contract__r.Name ,enrtcr__Support_Contract__r.enrtcr__End_Date__c ,enrtcr__Support_Contract__r.enrtcr__Status__c ,enrtcr__Support_Contract__r.enrtcr__Funding_Type__c ,enrtcr__Support_Contract__r.enrtcr__Funding_Management__c ,enrtcr__Support_Contract__r.enrtcr__Client__c ,enrtcr__Category_Item__r.enrtcr__Support_Category_Amount__c ,enrtcr__Category_Item__r.enrtcr__Delivered__c ,enrtcr__Site__c ,enrtcr__Site__r.Name ,enrtcr__Site__r.enrtcr__Site_GL_Code__c ,enrtcr__Service__c ,enrtcr__Service__r.Name ,enrtcr__Site_Service_Program__c ,enrtcr__Rate__c ,enrtcr__Rate__r.Name ,enrtcr__Rate__r.enrtcr__Amount_Ex_GST__c ,enrtcr__Rate__r.enrtcr__Quantity_Type__c ,enrtcr__Rate__r.enrtcr__Allow_Rate_Negotiation__c FROM enrtcr__Support_Contract_Item__c WHERE(" + filterstring + ") AND enrtcr__Support_Contract__r.enrtcr__Status__c = 'Current' ", out qr); //else //{ // var UTCTime = Convert.ToDateTime(lastintegratedDate).ToString("yyyy-MM-dd") + "T" + Convert.ToDateTime(lastintegratedDate).ToString("HH:mm:ss") + "Z"; // ss1.query(sHeader, null, null, null, @"SELECT Id // ,Name // ,enrtcr__Remaining__c // ,enrtcr__Item_Overclaim__c // ,enrtcr__Support_Contract__c // ,enrtcr__Support_Contract__r.Name // ,enrtcr__Support_Contract__r.enrtcr__End_Date__c // ,enrtcr__Support_Contract__r.enrtcr__Status__c // ,enrtcr__Support_Contract__r.enrtcr__Funding_Type__c // ,enrtcr__Support_Contract__r.enrtcr__Funding_Management__c // ,enrtcr__Support_Contract__r.enrtcr__Client__c // ,enrtcr__Category_Item__r.enrtcr__Support_Category_Amount__c // ,enrtcr__Category_Item__r.enrtcr__Delivered__c // ,enrtcr__Site__c // ,enrtcr__Site__r.Name // ,enrtcr__Site__r.enrtcr__Site_GL_Code__c // ,enrtcr__Service__c // ,enrtcr__Service__r.Name // ,enrtcr__Site_Service_Program__c // ,enrtcr__Rate__c // ,enrtcr__Rate__r.Name // ,enrtcr__Rate__r.enrtcr__Amount_Ex_GST__c // ,enrtcr__Rate__r.enrtcr__Quantity_Type__c // ,enrtcr__Rate__r.enrtcr__Allow_Rate_Negotiation__c,LastModifiedDate // FROM enrtcr__Support_Contract_Item__c // WHERE(" + filterstring + ") AND enrtcr__Support_Contract__r.enrtcr__Status__c = 'Current' and LastModifiedDate > YESTERDAY", out qr); //} sObject[] records = qr.records; if (records != null) { if (records.Length > 0) { for (var i = 0; i <= records.Length - 1; i++) { CustomerServiceLine csl = new CustomerServiceLine(); var customerId = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Client__c; csl.ServiceAgreementCustomerId = dba.GetCustomerId(customerId); csl.ServiceAgreementId = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__c;; csl.ServiceAgreementName = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.Name; csl.ServiceAgreementEndDate = Convert.ToDateTime(((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__End_Date__c); if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Status__c == "Current") { csl.ServiceAgreementStatus = (int)CustomerStatus.Current; } if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Status__c == "Expired") { csl.ServiceAgreementStatus = (int)CustomerStatus.Expired; } if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Status__c == "Rollover") { csl.ServiceAgreementStatus = (int)CustomerStatus.Rollover; } if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Status__c == "Cancelled") { csl.ServiceAgreementStatus = (int)CustomerStatus.Cancelled; } if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Status__c == "Quote Submitted") { csl.ServiceAgreementStatus = (int)CustomerStatus.QuoteSubmitted; } if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Status__c == "Client Declined") { csl.ServiceAgreementStatus = (int)CustomerStatus.ClientDeclined; } csl.ServiceAgreementFundingManagement = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Funding_Management__c; csl.ServiceAgreementFundingType = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Support_Contract__r.enrtcr__Funding_Type__c; csl.ServiceAgreementItemId = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).Id; csl.ServiceAgreementItemName = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).Name; csl.SupportCategoryAmount = (float)((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Category_Item__r.enrtcr__Support_Category_Amount__c; csl.SupportCategoryDelivered = (float?)((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Category_Item__r.enrtcr__Delivered__c; csl.FundsRemaining = (float?)((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Remaining__c; if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Item_Overclaim__c == "Allow") { csl.ItemOverclaim = (int)ItemOverClaim.Allow; } if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Item_Overclaim__c == "Warn") { csl.ItemOverclaim = (int)ItemOverClaim.Warn; } if (((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Item_Overclaim__c == "Prevent") { csl.ItemOverclaim = (int)ItemOverClaim.Prevent; } csl.SiteId = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Site__c; csl.SiteName = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Site__r.Name; // csl.SiteGlCode = ""; csl.SiteServiceProgramId = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Site_Service_Program__c; csl.ServiceId = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Service__c; csl.ServiceName = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Service__r.Name; csl.RateId = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__c; csl.RateName = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__r.Name; csl.RateAmount = (float?)((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__r.enrtcr__Amount_Ex_GST__c; csl.RateType = ((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__r.enrtcr__Quantity_Type__c; csl.AllowRateNegotiation = Convert.ToBoolean(((SfServiceRef.enrtcr__Support_Contract_Item__c)qr.records[i]).enrtcr__Rate__r.enrtcr__Allow_Rate_Negotiation__c == null ? false : true); csl.Default = false; ltsCusline.Add(csl); } //Insert record to Database dba.IntegrateCustomerLineinfointoDB(ltsCusline); } result = true; } return(result); }
public bool IntegerateSfCustomeList(string userName, string password) { logger.Info("Scheduled Customer List job triggered"); List <Customer> lstCus = new List <Customer>(); bool result = false; SoapClient ss = new SoapClient(); LoginResult lr = new LoginResult(); LoginScopeHeader LH = new LoginScopeHeader(); DBAction dba = new DBAction(_integrationAppSettings); var lastintegratedDate = dba.GetLastintegratedDateandTime("Last_CustomerIntegrate"); if (sessionId == null | sessionId == "") { lr = ss.login(null, userName, password); if (!lr.passwordExpired) { sessionId = lr.sessionId.ToString().Trim(); serverUrl = lr.serverUrl.ToString().Trim(); // Store SessionId in SessionHeader; We will need while making query() call SessionHeader sHeader = new SessionHeader(); sHeader.sessionId = sessionId; // Variable to store query results QueryResult qr = new QueryResult(); SoapClient ss1 = new SoapClient(); ss1.ChannelFactory.Endpoint.Address = new System.ServiceModel.EndpointAddress(serverUrl); // if (lastintegratedDate == null) ss1.query(sHeader, null, null, null, @"SELECT Id,Name,OtherStreet,OtherCity,OtherState,OtherPostalCode,RecordType.Name,Enrite_Care_Auto_Number__c,enrtcr__Status__c,LastModifiedDate FROM Contact WHERE RecordType.Name = 'Client' AND (enrtcr__Status__c='Current' OR enrtcr__Status__c='Deceased' OR enrtcr__Status__c='Inactive')", out qr); //else //{ // var UTCDate = Convert.ToDateTime(lastintegratedDate); // var UTCTime = UTCDate.ToString("yyyy-MM-dd") + "T" + UTCDate.ToString("HH:mm:ss") + "Z"; // ss1.query(sHeader, null, null, null, @"SELECT Id,Name,OtherStreet,OtherCity,OtherState,OtherPostalCode,RecordType.Name,Enrite_Care_Auto_Number__c,enrtcr__Status__c,LastModifiedDate FROM Contact WHERE RecordType.Name = 'Client' // AND (enrtcr__Status__c='Current' OR enrtcr__Status__c='Deceased' OR enrtcr__Status__c='Inactive') and LastModifiedDate >YESTERDAY", out qr); //} sObject[] records = qr.records; if (records != null) { if (records.Length > 0) { for (var i = 0; i <= records.Length - 1; i++) { Customer cs = new Customer(); cs.CustomerId = ((SfServiceRef.Contact)qr.records[i]).Id; cs.Name = ((SfServiceRef.Contact)qr.records[i]).Name; cs.Street = ((SfServiceRef.Contact)qr.records[i]).OtherStreet; cs.City = ((SfServiceRef.Contact)qr.records[i]).OtherCity; cs.State = ((SfServiceRef.Contact)qr.records[i]).OtherState; cs.PostalCode = ((SfServiceRef.Contact)qr.records[i]).OtherPostalCode; cs.LumaryId = ((SfServiceRef.Contact)qr.records[i]).Enrite_Care_Auto_Number__c; if (((SfServiceRef.Contact)qr.records[i]).enrtcr__Status__c != null) { cs.Active = false; if (((SfServiceRef.Contact)qr.records[i]).enrtcr__Status__c == "Current") { cs.Status = 1; } if (((SfServiceRef.Contact)qr.records[i]).enrtcr__Status__c == "Deceased") { cs.Status = 2; } if (((SfServiceRef.Contact)qr.records[i]).enrtcr__Status__c == "Inactive") { cs.Status = 3; } } cs.Active = true; cs.OnHold = false; lstCus.Add(cs); } } dba.IntegrateCustomerInfotoDB(lstCus); } } result = true; } return(result); }
//[Route("IntegerateSfCustomeList")] public ClsCustomerListResponse IntegerateSfCustomeList(ClsCusIntegRequest ObjRequest) { ClsCustomerListResponse ObjResponse = new ClsCustomerListResponse(); List <ClsListofCustomers> LstRes = new List <ClsListofCustomers>(); try { //ObjRequest.LoginUserName = "******"; //ObjRequest.LoginPassword = "******" + "6ohQKoPPG99OP0u8SalTFy8E"; SoapClient ss = new SoapClient(); LoginResult lr = new LoginResult(); LoginScopeHeader LH = new LoginScopeHeader(); if (sessionId == null | sessionId == "") { // Login Call lr = ss.login(null, ObjRequest.LoginUserName, ObjRequest.LoginPassword); if (lr.passwordExpired) { ObjResponse.StatusID = 300; ObjResponse.StatusDescription = "Password Expired"; // ObjResponse.Response = null; return(ObjResponse); } sessionId = lr.sessionId.ToString().Trim(); serverUrl = lr.serverUrl.ToString().Trim(); } // Store SessionId in SessionHeader; We will need while making query() call SessionHeader sHeader = new SessionHeader(); sHeader.sessionId = sessionId; // Variable to store query results QueryResult qr = new QueryResult(); SoapClient ss1 = new SoapClient(); ss1.ChannelFactory.Endpoint.Address = new System.ServiceModel.EndpointAddress(serverUrl); ss1.query(sHeader, null, null, null, @"SELECT Id,Name,OtherStreet,OtherCity,OtherState,OtherPostalCode,RecordType.Name FROM Contact WHERE RecordType.Name = 'Client' AND (enrtcr__Status__c='Current' OR enrtcr__Status__c='Deceased' OR enrtcr__Status__c='Inactive')", out qr); sObject[] records = qr.records; if (records != null) { if (records.Length > 0) { for (var i = 0; i <= records.Length - 1; i++) { ClsListofCustomers Res = new ClsListofCustomers(); Res.Id = ((SfServiceRef.Contact)qr.records[i]).Id; Res.Name = ((SfServiceRef.Contact)qr.records[i]).Name; Res.OtherStreet = ((SfServiceRef.Contact)qr.records[i]).OtherStreet; Res.OtherCity = ((SfServiceRef.Contact)qr.records[i]).OtherCity; Res.OtherStreet = ((SfServiceRef.Contact)qr.records[i]).OtherState; Res.OtherPostalCode = ((SfServiceRef.Contact)qr.records[i]).OtherPostalCode; Res.RecordTypeName = ((SfServiceRef.Contact)qr.records[i]).RecordType.Name; LstRes.Add(Res); } ObjResponse.StatusID = 200; ObjResponse.StatusDescription = "Success"; ObjResponse.ObjLstCutomers = LstRes; } else { ObjResponse.StatusID = 202; ObjResponse.StatusDescription = "Unable to find client"; } } else { ObjResponse.StatusID = 201; ObjResponse.StatusDescription = "User not found"; } //string JS = JsonConvert.SerializeObject(records); //Interaction.MsgBox("Success"); // ObjResponse.Response = records; return(ObjResponse); } catch (Exception ex) { ObjResponse.StatusID = 500; ObjResponse.StatusDescription = ex.Message.ToString(); //ObjResponse.Response = null; return(ObjResponse); } }