public bool CreateContact(Contact newCt, long householdId)
{
int investorId = Convert.ToInt32(_dbWrapper.ExecuteScalar(cmd =>
{
cmd.CommandText = SqlConstants.GET_NEXT_SEQUENCE_INVESTORID;
}, _context.Identity.InstitutionId));
var executeResult = _dbWrapper.Execute(cmd =>
{
cmd.CommandText = SqlConstants.CREATE_WEB_USER;
DatabaseWrapperHelper.AddInLongParameter(cmd, "INVESTOR_ID", investorId.ToString());
DatabaseWrapperHelper.AddInLongParameter(cmd, "INSTITUTION_ID", _context.Identity.InstitutionId);
DatabaseWrapperHelper.AddInStringParameter(cmd, "USERNAME", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "PASSWORD", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "PASSWORD_HINT", string.Empty);
DatabaseWrapperHelper.AddInDateTimeParameter(cmd, "CREATE_DATE", DateTime.Now.Date);
DatabaseWrapperHelper.AddInStringParameter(cmd, "STATUS", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "USER_TYPE_ID", "2");
DatabaseWrapperHelper.AddInStringParameter(cmd, "INSTITUTION_ID_LOGIN", string.Empty);
}, _context.Identity.InstitutionId);
executeResult = _dbWrapper.Execute(cmd =>
{
cmd.CommandText = SqlConstants.CREATE_WEB_INVESTOR;
DatabaseWrapperHelper.AddInLongParameter(cmd, "INVESTOR_ID", investorId.ToString());
DatabaseWrapperHelper.AddInStringParameter(cmd, "PREFIX", String.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "SUFFIX", String.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "FIRST_NAME", newCt.FirstName);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MID_INITIAL", newCt.MiddleName);
DatabaseWrapperHelper.AddInStringParameter(cmd, "LAST_NAME", newCt.LastName);
DatabaseWrapperHelper.AddInStringParameter(cmd, "BIRTHDATE", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "SSN_TIN", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MARK_DELETED_YN", "N");
DatabaseWrapperHelper.AddInStringParameter(cmd, "GENDER", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "INVESTOR_NUM", investorId.ToString());
DatabaseWrapperHelper.AddInDateTimeParameter(cmd, "CREATE_DATE", DateTime.Now.Date);
DatabaseWrapperHelper.AddInDateTimeParameter(cmd, "LAST_ACCESS_DATE", DateTime.Now.Date);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MARITAL_STATUS", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "SAME_AS_MAIL_YN", string.Empty);
//Home and Mail correspondence
DatabaseWrapperHelper.AddInStringParameter(cmd, "HOME_PHONE", newCt.HomePhone);
DatabaseWrapperHelper.AddInStringParameter(cmd, "FAX", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, ":EMAIL_ADDR", newCt.PersonalEmail);
DatabaseWrapperHelper.AddInStringParameter(cmd, ":PHONE_MOBILE", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, ":RELATIONSHIP", string.Empty);
//Home and Mail Address
DatabaseWrapperHelper.AddInStringParameter(cmd, "HOME_ADDR1", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "HOME_ADDR2", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "HOME_CITY", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "HOME_STATE", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "HOME_POSTAL_CODE", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "HOME_COUNTRY", string.Empty);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MAIL_ADDR1", newCt.AddressLine1);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MAIL_ADDR2", newCt.AddressLine2);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MAIL_CITY", newCt.City);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MAIL_STATE", newCt.State);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MAIL_POSTAL_CODE", newCt.Zip);
DatabaseWrapperHelper.AddInStringParameter(cmd, "MAIL_COUNTRY", newCt.Country);
}, _context.Identity.InstitutionId);
executeResult = _dbWrapper.Execute(cmd =>
{
cmd.CommandText = SqlConstants.CREATE_HOUSEHOLD_MEMBER;
DatabaseWrapperHelper.AddInLongParameter(cmd, "HOUSEHOLD_ID", householdId.ToString());
DatabaseWrapperHelper.AddInLongParameter(cmd, "INVESTOR_ID", investorId.ToString());
DatabaseWrapperHelper.AddInIntParameter(cmd, "RELATIONSHIP_TYPE_ID", ((int)newCt.RelationShipType).ToString());
DatabaseWrapperHelper.AddInStringParameter(cmd, "DEFAULT_ACCOUNT_ID", string.Empty);
}, _context.Identity.InstitutionId);
newCt.InvestorId = investorId.ToString();
if (executeResult > 0)
{
return(true);
}
return(false);
}
