Beispiel #1
0
        public async Task <ActionResult> Edit(IFormCollection collection)
        {
            int CustomerId = Convert.ToInt32(collection["CustomerId"]);

            ///Checks for Model State
            if (!ModelState.IsValid)
            {
                RedirectToAction("Index", new { customerId = CustomerId });
            }

            //Validates Model Data, can be achieved through IValidator DataAnnotations or Tag Helpers
            //Validation Messages can be added to assist the user
            ValueObjectsHelper valueObjectsHelper = new ValueObjectsHelper();

            if (valueObjectsHelper.TryGetCurrencySymbol(collection["Currency"], out string symbol) ||
                valueObjectsHelper.TryGetValidDecimal(collection["Amount"]))
            {
                /// Updates Transaction Entity on Db. Can be decoupled and injected to Service
                var updatedTransaction = await _transactionRepository.GetByIdCompositeAsync(Convert.ToInt32(collection["TransactionId"]), collection["accountName"]);

                updatedTransaction.Description  = collection["Description"].ToString();
                updatedTransaction.Amount       = Decimal.Parse(collection["Amount"], System.Globalization.NumberStyles.AllowDecimalPoint, System.Globalization.CultureInfo.InvariantCulture);
                updatedTransaction.CurrencyCode = collection["Currency"];

                await _asyncTransactionRepository.UpdateAsync(updatedTransaction);
            }

            var transactionViewModel = _dataManagerViewService.GetTransactionViewModel(Convert.ToInt32(collection["TransactionId"]));

            return(View("Edit", transactionViewModel));
        }
Beispiel #2
0
        /// <summary>
        ///Retrieves the URL of the submitted temp File and creates IDisposable ExcelPackage in Memory.
        ///Loops Excel Row and Validates row data.
        ///Validated row data through the
        ///
        /// </summary>
        /// <param name="urlPath"></param>
        /// <param name="clientId"></param>
        /// <returns></returns>
        public async Task <IEnumerable <FileUploadSummary> > ValidateAndSaveTransactions(string urlPath, int clientId)
        {
            FileInfo file = new FileInfo(urlPath);
            ValidateCurrencyCodes      _validateCurrencyCodes;
            ValidateTransactionAccount _validateTransactionAccount;
            ValueObjectsHelper         valueObjectsHelper  = new ValueObjectsHelper();
            List <FileUploadSummary>   fileUploadSummaries = new List <FileUploadSummary>();

            var accounts = await _asyncAccountsRepository.GetAccountsByCustomer(clientId);

            try
            {
                List <Transaction> transactionsList = new List <Transaction>();

                //Creates IDisposable Excel Package
                using (ExcelPackage package = new ExcelPackage(file))
                {
                    FileUploadSummary fileUploadSummary = new FileUploadSummary();
                    StringBuilder     sb        = new StringBuilder();
                    ExcelWorksheet    worksheet = package.Workbook.Worksheets[1];
                    int rowCount = worksheet.Dimension.Rows;
                    int ColCount = worksheet.Dimension.Columns;

                    //Calls Header Validator Method For Exchel Header Validation
                    if (!AreExcelColumnsHeadersValid(worksheet.Cells[1, 1].Value ?? "",
                                                     worksheet.Cells[1, 2].Value ?? "",
                                                     worksheet.Cells[1, 3].Value.ToString() ?? "",
                                                     worksheet.Cells[1, 4].Value.ToString() ?? ""))
                    {
                        fileUploadSummaries.Add(GetExceptionSummaryMessage("1", "NO VALID HEADERS"));
                        return(fileUploadSummaries);
                    }

                    for (int row = 2; row <= rowCount; row++)
                    {
                        //Validates if Rows are Not Null or Contain Empty Values
                        Transaction transactions = new Transaction();
                        if (worksheet.Cells[row, 1].Value == null || String.IsNullOrEmpty(worksheet.Cells[row, 1].Value.ToString()))
                        {
                            fileUploadSummaries.Add(GetExceptionSummaryMessage(row.ToString(), "No Value for Account Number"));
                            continue;
                        }

                        if ((worksheet.Cells[row, 2].Value == null || String.IsNullOrEmpty(worksheet.Cells[row, 2].Value.ToString())))
                        {
                            fileUploadSummaries.Add(GetExceptionSummaryMessage(row.ToString(), "No Value for Transaction Description"));
                            continue;
                        }

                        if (worksheet.Cells[row, 3].Value == null || String.IsNullOrEmpty(worksheet.Cells[row, 3].Value.ToString()))
                        {
                            fileUploadSummaries.Add(GetExceptionSummaryMessage(row.ToString(), "No Value on Currency Code Row"));
                            continue;
                        }

                        if (worksheet.Cells[row, 4].Value != null && !String.IsNullOrEmpty(worksheet.Cells[row, 4].Value.ToString()))
                        {
                            ///Validates If Row Decimal Value is Valid Decimal
                            if (!valueObjectsHelper.TryGetValidDecimal(worksheet.Cells[row, 4].Value.ToString()))
                            {
                                fileUploadSummaries.Add(GetExceptionSummaryMessage(row.ToString(), "Not a Valid Decimal Amount for Transactions"));
                                continue;
                            }
                        }
                        else
                        {
                            fileUploadSummaries.Add(GetExceptionSummaryMessage(row.ToString(), "No Value for Transaction Amount"));
                            continue;
                        }

                        transactions.AccountId    = worksheet.Cells[row, 1].Value.ToString();
                        transactions.Description  = worksheet.Cells[row, 2].Value.ToString();
                        transactions.CurrencyCode = worksheet.Cells[row, 3].Value.ToString();
                        transactions.Amount       = Convert.ToDecimal(worksheet.Cells[row, 4].Value.ToString());

                        //Currency and Account Validation
                        _validateCurrencyCodes      = new ValidateCurrencyCodes(transactions);
                        _validateTransactionAccount = new ValidateTransactionAccount(transactions, accounts);

                        //validate Currency Through Currency Validator Class
                        if (!_validateCurrencyCodes.IsValid)
                        {
                            fileUploadSummary.RowNumber = row.ToString();
                            fileUploadSummary.Message   = _validateCurrencyCodes.Message;
                            sb.Append("Line: " + row.ToString() + _validateCurrencyCodes.Message);
                            fileUploadSummaries.Add(GetExceptionSummaryMessage(row.ToString(), _validateCurrencyCodes.Message));

                            continue;
                        }

                        //Validate Transaction Account through Account Validator Class
                        if (!_validateTransactionAccount.IsValid)
                        {
                            fileUploadSummaries.Add(GetExceptionSummaryMessage(row.ToString(), _validateTransactionAccount.Message));
                            continue;
                        }
                        transactionsList.Add(transactions);
                    }
                }

                //Calls EFCore.Bulks Extensions handling bulk Updates.
                _asyncTransactionRepository.UpdateBulkAsync(transactionsList);

                //deletes file
                file.Delete();
            }
            catch (Exception ex)
            {
            }
            return(fileUploadSummaries);
        }