/// <summary>
/// Take the output from a Read and return it as a list of Account_DTO_Update objects
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
internal List <Account_DTO_Update> ReadAccounts(ADO_readerOutput output)
{
if (!output.hasData)
{
return(null);
}
List <Account_DTO_Update> accounts = new List <Security.Account_DTO_Update>();
foreach (var item in output.data)
{
Account_DTO_Update account = new Account_DTO_Update();
account.CcnUsername = ReadString(item.CcnUsername);
account.PrvCode = ReadString(item.PrvCode);
account.CcnNotificationFlag = ReadBool(item.CcnNotificationFlag);
accounts.Add(account);
}
return(accounts);
}
/// <summary>
/// Updates an account in the account table
/// </summary>
/// <param name="ado"></param>
/// <param name="account"></param>
/// <param name="username"></param>
/// <returns></returns>
internal int Update(ADO ado, Account_DTO_Update account, string username)
{
//Get the input parameters for database read
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@CcnUsernameUpdater", value = username
},
new ADO_inputParams()
{
name = "@UpdatedCcnUsername", 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_Update", inputParamList, ref retParam);
//Assign the returned value for checking and output
return(retParam.value);
}
