public T CreateJobForBatchInSalesforce <T>(string salesforceObjectName, string action, string concurrency) { var salesforceBulkJob = Activator.CreateInstance <T>(); try { String connectionString = SalesforceCxn.SalesforceConnectionString(); using (SalesforceConnection connection = new SalesforceConnection(connectionString)) { SalesforceCommand cmd = new SalesforceCommand("CreateJob", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SalesforceParameter("@ObjectName", salesforceObjectName)); //ex. "Account" cmd.Parameters.Add(new SalesforceParameter("@Action", action)); // ex. "Insert" cmd.Parameters.Add(new SalesforceParameter("@ConcurrencyMode", concurrency)); // ex. "Serial" cmd.Parameters.Add(new SalesforceParameter("@ExternalIdColumn", "")); SalesforceDataReader rdr = cmd.ExecuteReader(); salesforceBulkJob = SfdcReflectionUtil.PopulateBaseModelFromReader <T>(rdr); } } catch (Exception ex) { CfsLogging.LogFatal("Error occured Salesforce Data Loader", String.Format(MethodBase.GetCurrentMethod().Name + " method failed in SalesforceContext class") + "\n" + ex); throw; } return(salesforceBulkJob); }
public T GetRecordType <T>(string recordTypeName, string sObjectType) { var recordType = Activator.CreateInstance <T>(); try { String connectionString = SalesforceCxn.SalesforceConnectionString(); string sql = String.Format("SELECT Id, Name,SobjectType FROM RecordType where Name='{0}' and SobjectType = '{1}'", recordTypeName, sObjectType); using (SalesforceConnection connection = new SalesforceConnection(connectionString)) { SalesforceCommand cmd = new SalesforceCommand(sql, connection); SalesforceDataReader rdr = cmd.ExecuteReader(); recordType = SfdcReflectionUtil.PopulateBaseModelFromReader <T>(rdr); } } catch (Exception ex) { CfsLogging.LogFatal("Error occured Salesforce Data Loader", String.Format(MethodBase.GetCurrentMethod().Name + " method failed in SalesforceContext class") + "\n" + ex); throw; } return(recordType); }
public List <T> GetAllLeaseAssignmentsToVirtual <T>(string recordTypeId) { List <T> vLeaseList = new List <T>(); try { String connectionString = SalesforceCxn.SalesforceConnectionString(); using (SalesforceConnection connection = new SalesforceConnection(connectionString)) { SalesforceCommand cmd = new SalesforceCommand("SELECT Lease__c.Name, Lease__c.Id, Account.Name AS AccountName, Account.Id AS AccountId FROM Lease__c, Account WHERE Account.Id = Lease__c.Contract_Customer__c AND (Account.RecordTypeId = " + recordTypeId + ") AND (Lease__c.IsDeleted = 'False')", connection); SalesforceDataReader rdr = cmd.ExecuteReader(); vLeaseList = SfdcReflectionUtil.PopulateListFromReader <T>(rdr); } } catch (Exception ex) { CfsLogging.LogFatal("Error occured Salesforce Data Loader", String.Format(MethodBase.GetCurrentMethod().Name + " method failed in SalesforceContext class") + "\n" + ex); throw; } return(vLeaseList); }
public T GetJobFromSalesforce <T>(string jobId) { var salesforceBulkJob = Activator.CreateInstance <T>(); try { String connectionString = SalesforceCxn.SalesforceConnectionString(); using (SalesforceConnection connection = new SalesforceConnection(connectionString)) { SalesforceCommand cmd = new SalesforceCommand("GetJob", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SalesforceParameter("@jobId", jobId)); SalesforceDataReader rdr = cmd.ExecuteReader(); salesforceBulkJob = SfdcReflectionUtil.PopulateBaseModelFromReader <T>(rdr); } } catch (Exception ex) { CfsLogging.LogFatal("Error occured Salesforce Data Loader", String.Format(MethodBase.GetCurrentMethod().Name + " method failed in SalesforceContext class") + "\n" + ex); throw; } return(salesforceBulkJob); }
public List <T> GetSalesforceRecords <T>(string sql) { List <T> recordList = new List <T>(); try { String connectionString = SalesforceCxn.SalesforceConnectionString(); using (SalesforceConnection connection = new SalesforceConnection(connectionString)) { SalesforceCommand cmd = new SalesforceCommand(sql, connection); SalesforceDataReader rdr = cmd.ExecuteReader(); recordList = SfdcReflectionUtil.PopulateListFromReader <T>(rdr); } } catch (Exception ex) { CfsLogging.LogFatal("Error occured Salesforce Data Loader", String.Format(MethodBase.GetCurrentMethod().Name + " method failed in SalesforceContext class") + "\n" + ex); throw; } return(recordList); }
public TT GetSalesforceBulkBatchResult <TT, T>(string jobId, string batchId) where TT : BaseModelList <T> where T : BaseModel { try { String connectionString = SalesforceCxn.SalesforceConnectionString(); using (SalesforceConnection connection = new SalesforceConnection(connectionString)) { SalesforceCommand cmd = new SalesforceCommand("GetBatchResults", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SalesforceParameter("@JobId", jobId)); cmd.Parameters.Add(new SalesforceParameter("@BatchId", batchId)); SalesforceDataReader rdr = cmd.ExecuteReader(); var salesforceBulkBatchResults = SfdcReflectionUtil.PopulateBaseModelListFromReader <TT, T>(rdr); return(salesforceBulkBatchResults); } } catch (Exception ex) { CfsLogging.LogFatal("Error occured Salesforce Data Loader", String.Format(MethodBase.GetCurrentMethod().Name + " method failed in SalesforceContext class") + "\n" + ex); throw; } }
public TT GetRecordTypesFromSalesforce <TT, T>() where TT : BaseModelList <T> where T : BaseModel { try { String connectionString = SalesforceCxn.SalesforceConnectionString(); string sql = String.Format("SELECT Id, Name,SobjectType FROM RecordType"); using (SalesforceConnection connection = new SalesforceConnection(connectionString)) { SalesforceCommand cmd = new SalesforceCommand(sql, connection); SalesforceDataReader rdr = cmd.ExecuteReader(); var sfRecordTypes = SfdcReflectionUtil.PopulateBaseModelListFromReader <TT, T>(rdr); return(sfRecordTypes); } } catch (Exception ex) { CfsLogging.LogFatal("Error occured Salesforce Data Loader", String.Format(MethodBase.GetCurrentMethod().Name + " method failed in SalesforceContext class") + "\n" + ex); throw; } }
public List <T> GetAccountsFromSalesforce <T>(string recordTypeId) { List <T> accounts = new List <T>(); String connectionString = SalesforceCxn.SalesforceConnectionString(); using (SalesforceConnection connection = new SalesforceConnection(connectionString)) { SalesforceCommand cmd = new SalesforceCommand("SELECT * FROM Account WHERE RecordTypeId = " + recordTypeId, connection); SalesforceDataReader rdr = cmd.ExecuteReader(); accounts = SfdcReflectionUtil.PopulateListFromReader <T>(rdr); } return(accounts); }