コード例 #1
0
        public static bool AddUnpostedVoucher(AccountingTransactionTempDto voucherEntryDto)
        {
            try
            {
                var newVoucherNo = AccountingDataProvider.GetLastVoucherNo();

                var entity = new tAccountingTransactionTemp
                {
                    CompanyId = voucherEntryDto.CompanyId,
                    CreditAccount = voucherEntryDto.CreditAccount,
                    DebitAccount = voucherEntryDto.DebitAccount,
                    AccountingYearId = voucherEntryDto.AccountingYearId,
                    VoucherNo = newVoucherNo,
                    Currency = voucherEntryDto.CurrencyCode,
                    LineId = voucherEntryDto.LineId,
                    Total = voucherEntryDto.Total,
                    UserId = voucherEntryDto.UserId,
                    ValueTotal = voucherEntryDto.ValueTotal,
                    VoucherDate = voucherEntryDto.VoucherDate,

                };
                var result = AccountingDataProvider.AddUnpostedVoucher(entity);

                if (result == 1)
                {
                    AccountingDataProvider.DeleteLastVoucherInformation(new tLastVoucherInformation
                                                                            {LastVoucherNo = newVoucherNo});
                    AccountingDataProvider.AddLastVoucherInformation(new tLastVoucherInformation
                                                                         {LastVoucherNo = newVoucherNo + 1});
                    return true;
                }
                return false;
            }
            catch (Exception exception)
            {
                throw new Exception(exception.Message);
            }
        }
コード例 #2
0
        public static int UpdateUnpostedVoucher(tAccountingTransactionTemp transaction)
        {
            int rowsAdded;

            using (IDbConnection connection = DbConnectionHelper.GetConnection())
            {
                var query = SqlQueryHelper.GetUpdateQuery<tAccountingTransactionTemp>();

                rowsAdded = connection.Execute(query, transaction);
            }

            return rowsAdded;
        }
コード例 #3
0
        public static bool UpdateUnpostedVoucher(AccountingTransactionTempDto voucherEntryDto)
        {
            try
            {
                var entity = new tAccountingTransactionTemp
                {
                    CompanyId = voucherEntryDto.CompanyId,
                    CreditAccount = voucherEntryDto.CreditAccount,
                    DebitAccount = voucherEntryDto.DebitAccount,
                    AccountingYearId = voucherEntryDto.AccountingYearId,
                    VoucherNo = voucherEntryDto.VoucherNo,
                    Currency = voucherEntryDto.CurrencyCode,
                    LineId = voucherEntryDto.LineId,
                    Total = voucherEntryDto.Total,
                    UserId = voucherEntryDto.UserId,
                    ValueTotal = voucherEntryDto.ValueTotal,
                    VoucherDate = voucherEntryDto.VoucherDate,

                };

                var result = AccountingDataProvider.UpdateUnpostedVoucher(entity);

                if (result == 1)
                {
                    return true;
                }
                return false;
            }
            catch (Exception exception)
            {
                throw new Exception(exception.Message);
            }
        }