//CreateHouseholdForTeams private Household CreateHousehold(List <Contact> contacts) { Household result = new Household(); Dictionary <long, long> contactDic = new Dictionary <long, long>(); string hhName = "Client Household"; //Get next householdid long householdId = Convert.ToInt64(_dbWrapper.ExecuteScalar(cmd => { cmd.CommandText = SqlConstants.GET_NEXT_SEQUENCE_HOUSEHOLDID; }, _context.Identity.InstitutionId)); //calcualte the household name from the primary contact details foreach (Contact cp in contacts) { if (cp.RelationShipType == RelationShipType.HEAD) { hhName = cp.FirstName + " " + cp.LastName; //name = hhName.Trim(); break; } } var executeResult = _dbWrapper.Execute(cmd => { cmd.CommandText = SqlConstants.CREATE_HOUSEHOLD; DatabaseWrapperHelper.AddInIntParameter(cmd, "householdId", householdId.ToString()); DatabaseWrapperHelper.AddInStringParameter(cmd, "householdName", hhName); DatabaseWrapperHelper.AddInIntParameter(cmd, "householdTypeId", ((int)HouseholdType.PROSPECT).ToString()); }, _context.Identity.InstitutionId); // insert into web_investor foreach (Contact contact in contacts) { CreateContact(contact, householdId); } result.HouseholdID = householdId.ToString(); result.Name = hhName; result.Type = "PROSPECT"; result.Persons = contacts; return(result); }
public bool IsBackOfficeInstitution() { int configId = Convert.ToInt32(_dbWrapper.ExecuteScalar(cmd => { cmd.CommandText = SqlConstants.GET_INSTITUTION_CONFIG; DatabaseWrapperHelper.AddInIntParameter(cmd, "InstitutionId", _context.Identity.InstitutionId); }, _context.Identity.InstitutionId)); return(configId == Constants.IDS_BACKOFFICE_CONFIG_ID); }