public static bool DeleteUnpostedVoucher(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.DeleteUnpostedVoucher(entity); if (result == 1) { return(true); } return(false); } catch (Exception exception) { throw new Exception(exception.Message); } }
public static AccountingTransactionTempDto GetUnpostedVoucherByNo(int voucherNo) { try { var table = AccountingDataProvider.GetUnpostedVoucherByNo(voucherNo); var model = new AccountingTransactionTempDto { CompanyId = table.CompanyId, CreditAccount = table.CreditAccount, CreditAccountName = AccountingDataProvider.GetAccountByCode(table.CompanyId, table.CreditAccount).AccountName, DebitAccount = table.DebitAccount, DebitAccountName = AccountingDataProvider.GetAccountByCode(table.CompanyId, table.DebitAccount).AccountName, AccountingYearId = table.AccountingYearId, VoucherNo = table.VoucherNo, CurrencyCode = table.Currency, LineId = table.LineId, Total = table.Total, UserId = table.UserId, ValueTotal = table.ValueTotal, VoucherDate = table.VoucherDate }; return(model); } catch (Exception exception) { throw new Exception(exception.Message); } }
private void UpdateFields(AccountingTransactionTempDto template) { cboDebitAccount.SelectedValue = template.DebitAccount; cboCreditAccount.SelectedValue = template.CreditAccount; cboCurrency.SelectedValue = template.CurrencyCode; txtTotal.Text = template.Total.ToString(); txtValueTotal.Text = template.ValueTotal.ToString(); dtpVoucherDate.Text = template.VoucherDate.ToShortDateString(); txtLineId.Text = template.LineId.ToString(); }
public static IEnumerable <AccountingTransactionTempDto> GetAllUnpostedVoucher() { try { var vouchers = AccountingDataProvider.GetAllUnpostedVoucher() as List <tAccountingTransactionTemp>; var voucherViewModel = new List <AccountingTransactionTempDto>(); AccountingTransactionTempDto model; if (vouchers != null) { vouchers.ForEach(delegate(tAccountingTransactionTemp table) { model = new AccountingTransactionTempDto { CompanyId = table.CompanyId, CreditAccount = table.CreditAccount, CreditAccountName = AccountingDataProvider.GetAccountByCode(table.CompanyId, table.CreditAccount).AccountName, DebitAccount = table.DebitAccount, DebitAccountName = AccountingDataProvider.GetAccountByCode(table.CompanyId, table.DebitAccount).AccountName, AccountingYearId = table.AccountingYearId, VoucherNo = table.VoucherNo, CurrencyCode = table.Currency, LineId = table.LineId, Total = table.Total, UserId = table.UserId, ValueTotal = table.ValueTotal, VoucherDate = table.VoucherDate }; voucherViewModel.Add(model); } ); return(voucherViewModel); } } catch (Exception exception) { throw new Exception(exception.Message); } return(null); }