/// <summary>
/// Creates a new account in the account table
/// </summary>
/// <param name="ado"></param>
/// <param name="account"></param>
/// <param name="ccnUsername"></param>
/// <returns></returns>
internal int Create(ADO ado, Account_DTO_Create account, string ccnUsername)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@CcnUsernameCreator", value = ccnUsername
},
new ADO_inputParams()
{
name = "@CcnUsernameNewAccount", value = account.CcnUsername
},
new ADO_inputParams()
{
name = "@PrvCode", value = account.PrvCode
},
new ADO_inputParams()
{
name = "@CcnNotificationFlag", value = account.CcnNotificationFlag
}
};
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("Security_Account_Create", inputParamList, ref retParam);
//Assign the returned value for checking and output
return(retParam.value);
}
/// <summary>
/// Creates a new account in the account table
/// </summary>
/// <param name="ado"></param>
/// <param name="account"></param>
/// <param name="ccnUsername"></param>
/// <returns></returns>
internal int Create(ADO ado, Account_DTO_Create account, string ccnUsername, bool ccnAdFlag, bool locked = false)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@CcnUsernameCreator", value = ccnUsername
},
new ADO_inputParams()
{
name = "@CcnUsernameNewAccount", value = account.CcnUsername
},
new ADO_inputParams()
{
name = "@PrvCode", value = account.PrvCode
},
new ADO_inputParams()
{
name = "@CcnNotificationFlag", value = account.CcnNotificationFlag
},
new ADO_inputParams()
{
name = "@CcnLockedFlag", value = locked
},
new ADO_inputParams()
{
name = "@CcnADFlag", value = ccnAdFlag
},
new ADO_inputParams()
{
name = "@LngIsoCode", value = account.LngIsoCode
}
};
if (account.CcnDisplayName != null)
{
inputParamList.Add(new ADO_inputParams()
{
name = "@CcnDisplayName", value = account.CcnDisplayName
});
}
if (account.CcnEmail != null)
{
inputParamList.Add(new ADO_inputParams()
{
name = "@CcnEmail", value = account.CcnEmail
});
}
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("Security_Account_Create", inputParamList, ref retParam);
//Assign the returned value for checking and output
return(retParam.value);
}
