static void InsertPersonContactInfoAndMailAddress(Model.Person candidateRecord, int personId, int candidateId)
{
//Insert the Person's email:
if (!string.IsNullOrEmpty(candidateRecord.Email))
{
var personEmail = _db.InsertPersonContactInformation(personId, 2, candidateRecord.Email, null, true, 0).ToList();
}
//Insert Candidate Information
//Returns the PersonContactInformation.Id
var personContactInformationId = -1;
var mailingAddressId = -1;
//0:
personContactInformationId = InsertContactInformation(personId, candidateRecord.handle0text, candidateRecord.handle0type);
//1:
personContactInformationId = InsertContactInformation(personId, candidateRecord.handle1text, candidateRecord.handle1type);
//2:
personContactInformationId = InsertContactInformation(personId, candidateRecord.handle2text, candidateRecord.handle2type);
//3:
personContactInformationId = InsertContactInformation(personId, candidateRecord.handle3text, candidateRecord.handle3type);
//Insert Mailing Address & PersonMailAddress
//Inserts into the MailAddress table and the PersonMailAddress table
if (!string.IsNullOrEmpty(candidateRecord.Address) && !string.IsNullOrEmpty(candidateRecord.City) && !string.IsNullOrEmpty(candidateRecord.State) && !string.IsNullOrEmpty(candidateRecord.Zip))
{
//Returns the PersonMailAddress.Id
var personMailAddressResult = _db.InsertPersonMailingAddress(personId, candidateRecord.Address, candidateRecord.City, candidateRecord.State, candidateRecord.Zip, 0).ToList();
mailingAddressId = Convert.ToInt32(personMailAddressResult[0]);
}
//Insert Candidate Notes
//Inserts into the CandidateNote table
if (!string.IsNullOrEmpty(candidateRecord.Notes))
{
//Returns the CustomerNote.Id
var customerNoteResult = _db.InsertCandidateNote(candidateId, candidateRecord.Notes, candidateRecord.Created, 0).ToList();
}
}
public static void InsertCandidate(Model.Person candidateRecord, int personId)
{
//Get the source type for the candidate:
var sourceTypeIdForCandidate = ImportHelperMethods.GetSourceTypeId(candidateRecord.Source);
//Get the candidate type id:
var candidateStatusTypeId = GetCandidateStatusTypeId(candidateRecord.IdStatus);
Candidate candidateData = new Candidate();
if (!string.IsNullOrEmpty(candidateRecord.xdata))
{
candidateData = LookupValue.ParseXML(candidateRecord.xdata, candidateData);
}
//Get the org id:
var orgId = ImportHelperMethods.GetIdOrganization(candidateRecord.IdOrganization);
var candidateId = -1;
//Insert as a Candidate
//Returns the Candidate record
var candidateResult = _db.InsertCandidate(personId, candidateStatusTypeId, null, null, null, sourceTypeIdForCandidate, candidateData.MaxTravelTypeId, null, null, candidateData.CurrentSalary, candidateData.DesiredSalary, candidateData.CurrentRate, candidateData.DesiredRate, null, candidateData.IsOpenToRelocation, 0, candidateRecord.Created, orgId).ToList();
foreach (var item in candidateResult)
{
candidateId = item.Id;
}
//Insert the Candidate's Mailing Address and Contact Information and Notes:
InsertPersonContactInfoAndMailAddress(candidateRecord, personId, candidateId);
Debug.WriteLine("\n" + "Person imported: " + personId + " " + candidateRecord.FirstName + " " + candidateRecord.LastName + " Customer Id: " + candidateId);
}