/// <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); }