private static void InsertStatusToSQL(Applicant2 applicant2) { OpenSQLConnection(); try { string sqlCommand = "INSERT INTO [dbo].[communications] " + "([customer_id], [account_id], [loan_id], [type_activity], [date_activity], " + "[activity_category], [activity_description], [date_activity_backup]) " + "VALUES (" + applicant2.LAS_Customer_Id__c + ", null," + applicant2.LAS_Loan_Id__c + ",'2', CURRENT_TIMESTAMP, '12', 'loan_to_SF', null)"; SqlCommand myCommand = new SqlCommand(sqlCommand, myConnection); //myCommand.Connection.Open(); myCommand.ExecuteNonQuery(); LogMessage(sw, applicant2.LAS_Loan_Id__c + " inserted in communication"); } catch (Exception e) { LogErrorMessage(sw, e.ToString()); } }
private static void InsertLoanToSalesforce(EnterpriseWsdl.SoapClient apiClient, Applicant2 applicant2, string applicantId) { EnterpriseWsdl.Loan__c loan2 = new EnterpriseWsdl.Loan__c(); loan2.Applicant__c = applicantId; loan2.LAS_Loan_Id__c = applicant2.LAS_Loan_Id__c; loan2.Bank_Account__c = applicant2.Bank_Account__c.Replace("-", "").Replace(" ", "").Trim(); loan2.Sort_Code__c = applicant2.Sort_Code__c.Replace("-", "").Replace(" ", "").Trim(); if (!String.IsNullOrEmpty(applicant2.Loan_Amount__c)) { loan2.Loan_Amount__c = double.Parse(applicant2.Loan_Amount__c); loan2.Loan_Amount__cSpecified = true; } if (!String.IsNullOrEmpty(applicant2.Loan_Days__c)) { loan2.Loan_Days__c = double.Parse(applicant2.Loan_Days__c); loan2.Loan_Days__cSpecified = true; } if (!String.IsNullOrEmpty(applicant2.Monthly_Net_Income__c)) { loan2.Monthly_Net_Income__c = double.Parse(applicant2.Monthly_Net_Income__c); loan2.Monthly_Net_Income__cSpecified = true; } if (!String.IsNullOrEmpty(applicant2.AppliedOn__c)) { string appliedOn = DateFormat(applicant2.AppliedOn__c); //DateTime dt2 = Convert.ToDateTime(appliedOn); loan2.AppliedOn__c = DateTime.ParseExact(appliedOn, "d/M/yyyy", CultureInfo.InvariantCulture); loan2.AppliedOn__cSpecified = true; } EnterpriseWsdl.sObject[] outreachArray2 = new EnterpriseWsdl.sObject[] { loan2 }; EnterpriseWsdl.SaveResult[] createResult2; EnterpriseWsdl.LimitInfo[] limitInfo2; apiClient.create(header, null, null, null, null, null, null, null, null, null, null, outreachArray2, out limitInfo2, out createResult2); if (createResult2[0].success) { LogLoanInformation(sw, applicant2); } else { LogErrorMessage(sw, "Loan insertion failed due to : " + createResult2[0].errors[0].statusCode); } }
private static void LogLoanInformation(StreamWriter sw, Applicant2 applicant2) { sw.WriteLine("Log time " + String.Format("{0:dd.MM.yyyy hh:mm:ss}", DateTime.Now)); sw.WriteLine("Loan Amount : " + applicant2.Loan_Amount__c + " Loan Days : " + applicant2.Loan_Days__c + " added successfully."); sw.WriteLine(""); }
//private static void InsertApplicantsTosalesForce(EnterpriseWsdl.SoapClient apiClient) private static void InsertApplicantToSalesForce(EnterpriseWsdl.SoapClient apiClient, Applicant2 applicant2) { EnterpriseWsdl.Applicant__c applic2 = new EnterpriseWsdl.Applicant__c(); if (!String.IsNullOrEmpty(applicant2.LAS_Customer_Id__c)) { applic2.LAS_Customer_Id__c = applicant2.LAS_Customer_Id__c; } if (!String.IsNullOrEmpty(applicant2.LAS_User_Name__c)) { applic2.LAS_User_Name__c = applicant2.LAS_User_Name__c; } if (!String.IsNullOrEmpty(applicant2.Title__c)) { applic2.Title__c = applicant2.Title__c; } if (!String.IsNullOrEmpty(applicant2.First_Name__c)) { applic2.First_Name__c = applicant2.First_Name__c.Replace("'", " ").Replace("-", ""); } if (!String.IsNullOrEmpty(applicant2.Middle_Name__c)) { applic2.Middle_Name__c = applicant2.Middle_Name__c.Replace("'", " ").Replace("-", ""); } if (!String.IsNullOrEmpty(applicant2.Last_Name__c)) { applic2.Last_Name__c = applicant2.Last_Name__c.Replace("'", " ").Replace("-", ""); } if (!String.IsNullOrEmpty(applicant2.Email__c)) { applic2.Email__c = applicant2.Email__c; } if (!String.IsNullOrEmpty(applicant2.Mobile__c)) { applic2.Mobile__c = PhoneFormat(applicant2.Mobile__c); } if (!String.IsNullOrEmpty(applicant2.Date_Of_Birth__c)) { string dateofbirth = DateFormat(applicant2.Date_Of_Birth__c); //DateTime dt = DateTime.Parse(dateofbirth); applic2.Date_Of_Birth__c = DateTime.ParseExact(dateofbirth, "d/M/yyyy", CultureInfo.InvariantCulture); applic2.Date_Of_Birth__cSpecified = true; } if (!String.IsNullOrEmpty(applicant2.Residential_Status__c)) { applic2.Residential_Status__c = applicant2.Residential_Status__c; } if (!String.IsNullOrEmpty(applicant2.Marital_Status__c)) { applic2.Marital_Status__c = applicant2.Marital_Status__c; } if (!String.IsNullOrEmpty(applicant2.Postal_Code__c)) { applic2.Postal_Code__c = applicant2.Postal_Code__c; } if (!String.IsNullOrEmpty(applicant2.Mobile__c)) { applic2.Street__c = applicant2.Street__c; } if (!String.IsNullOrEmpty(applicant2.County__c)) { applic2.County__c = applicant2.County__c; } if (!String.IsNullOrEmpty(applicant2.Landline__c)) { applic2.Landline__c = PhoneFormat(applicant2.Landline__c); } if (!String.IsNullOrEmpty(applicant2.Flat_Number__c)) { applic2.Flat_Number__c = applicant2.Flat_Number__c; } if (!String.IsNullOrEmpty(applicant2.Town__c)) { applic2.Town__c = applicant2.Town__c; } if (!String.IsNullOrEmpty(applicant2.Password__c)) { applic2.Password__c = applicant2.Password__c; } EnterpriseWsdl.sObject[] outreachArray = new EnterpriseWsdl.sObject[] { applic2 }; EnterpriseWsdl.SaveResult[] createResult; EnterpriseWsdl.LimitInfo[] limitInfo; apiClient.create(header, null, null, null, null, null, null, null, null, null, null, outreachArray, out limitInfo, out createResult); if (createResult[0].success) { LogApplicantInformation(sw, applicant2); InsertLoanToSalesforce(apiClient, applicant2, createResult[0].id); } else { LogErrorMessage(sw, "Applicant insertion failed due to : " + createResult[0].errors[0].statusCode); } }
private static void LogApplicantInformation(StreamWriter sw, Applicant2 applicant2) { sw.WriteLine("Log time " + String.Format("{0:dd.MM.yyyy hh:mm:ss}", DateTime.Now)); sw.WriteLine("App Id : " + applicant2.LAS_Loan_Id__c + " DOB : " + applicant2.Date_Of_Birth__c + " Email : " + applicant2.Email__c + " Mobile : " + applicant2.Mobile__c + " added successfully."); sw.WriteLine(""); }