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 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 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); }