public GeneralDepositLedgerView() { InitializeComponent(); data = new GeneralLedger(); generalDepositLedger.ItemsSource = data.GetDataLedger(0, 0); DataContext = data; }
private GeneralLedger MapToEntity(GeneralLedgerView inputObject) { Mapper mapper = new Mapper(); GeneralLedger outObject = mapper.Map <GeneralLedger>(inputObject); return(outObject); }
public GeneralDepositView() { InitializeComponent(); GDListObj = new GeneralDepositListView(); memberData.Navigate(GDListObj); DataContext = new GeneralLedger(); }
public void SetForEdit(string m_id) { int id = Convert.ToInt32(m_id); data = new GeneralLedger(); data.GetDataDetails(id); DataContext = data; }
public GeneralDepositListView() { InitializeComponent(); GeneralLedger data = new GeneralLedger(); generalDepositlist.ItemsSource = data.GetDataList(); DataContext = data; }
public TransactionImportContext(GeneralLedger general, IEnumerable<AccountIdentifier> patterns, IImportRepository repository) { _general = general; _repository = repository; _patterns = patterns.ToArray(); Array.ForEach(_patterns, p => p.Account = general[p.Account.Id]); }
public void ActivateGeneralLedger(GeneralLedger generalLedger) { var command = new ActivateGeneralLedgerCommand { GeneralLedger = generalLedger }; processXml.Process(command.ToXml()); }
private string GenerateCustomRefNo(GeneralLedger item) { var referenceNo = new StringBuilder(); referenceNo.Append($"{m_applicationName.ToUpper()}-"); referenceNo.Append(DateTime.Now.ToString("ddMMyy-ss-")); referenceNo.Append((item.Id.Split('-'))[1]); return(referenceNo.ToString()); }
void UpdateGeneralLedger(PurchaseModel purchaseModel, int purchaseId, int APKey) { GeneralLedger generalLedger = new GeneralLedger { SubsidiaryLedgerAccountId = purchaseModel.Vendor.Value, GeneralLedgerReferenceNo = purchaseModel.ReferenceNo, GeneralLedgerInvoiceNo = "", GeneralLedgerDate = purchaseModel.Date, GeneralLedgerType = "PUR", PurchaseId = purchaseId }; _serverContext.GeneralLedgers.Add(generalLedger); _serverContext.SaveChanges(); //var invoiceDetail = customerInvoiceModel.Items.GroupBy(x => x.SalesItem.Value).Select(g => new { Id = g.Key, Value = g.Sum(s => Convert.ToDecimal(s.Amount)) }); foreach (PurchaseItemModel item in purchaseModel.Items) { GeneralLedgerDetail generalLedgerDetail = new GeneralLedgerDetail(); //var temp = _serverContext.Inventories.Where(x => x.Id == item.SalesItem.Value).FirstOrDefault(); //generalLedgerDetail.ChartOfAccountId = Convert.ToInt32(temp.InventoryProductServiceIncomeAccountId); generalLedgerDetail.ChartOfAccountId = item.ChartOfAccountItem.Value; generalLedgerDetail.GeneralLedgerDetailMode = "D"; generalLedgerDetail.GeneralLedgerId = generalLedger.Id; generalLedgerDetail.GeneralLedgerDetailAmount = Convert.ToDecimal(item.Amount); generalLedgerDetail.GeneralLedgerDetailDescription = item.Description; _serverContext.GeneralLedgerDetails.Add(generalLedgerDetail); _serverContext.SaveChanges(); } if (purchaseModel.TotalTaxes > 0) { GeneralLedgerDetail generalLedgerDetail = new GeneralLedgerDetail(); generalLedgerDetail.ChartOfAccountId = SalesTaxKey; generalLedgerDetail.GeneralLedgerDetailMode = "D"; generalLedgerDetail.GeneralLedgerId = generalLedger.Id; generalLedgerDetail.GeneralLedgerDetailAmount = purchaseModel.TotalTaxes; generalLedgerDetail.GeneralLedgerDetailDescription = ""; _serverContext.GeneralLedgerDetails.Add(generalLedgerDetail); _serverContext.SaveChanges(); } var APAmount = purchaseModel.Amount; GeneralLedgerDetail APGeneralLedgerDetail = new GeneralLedgerDetail(); APGeneralLedgerDetail.GeneralLedgerId = generalLedger.Id; APGeneralLedgerDetail.GeneralLedgerDetailDescription = ""; APGeneralLedgerDetail.ChartOfAccountId = purchaseModel.ModeOfPayment == "PY" ? APKey : (int)purchaseModel.ChartOfAccounts.Value; APGeneralLedgerDetail.GeneralLedgerDetailMode = "C"; APGeneralLedgerDetail.GeneralLedgerId = generalLedger.Id; APGeneralLedgerDetail.GeneralLedgerDetailAmount = APAmount; _serverContext.GeneralLedgerDetails.Add(APGeneralLedgerDetail); _serverContext.SaveChanges(); }
public async Task TestAddUpdatDelete() { SupplierLedgerModule SupplierLedgerMod = new SupplierLedgerModule(); Supplier supplier = await SupplierLedgerMod.Supplier.Query().GetEntityById(3); Invoice invoice = await SupplierLedgerMod.Invoice.Query().GetEntityById(2); AccountPayable accountPayable = await SupplierLedgerMod.AccountPayable.Query().GetEntityById(2); GeneralLedger generalLedger = await SupplierLedgerMod.GeneralLedger.Query().GetEntityById(17); AddressBook addressBook = await SupplierLedgerMod.AddressBook.Query().GetEntityById(17); SupplierLedgerView view = new SupplierLedgerView() { SupplierId = supplier.SupplierId, InvoiceId = invoice.InvoiceId, AcctPayId = accountPayable.AccountPayableId, Amount = 300M, Gldate = DateTime.Parse("11/11/2019"), AccountId = generalLedger.AccountId, GeneralLedgerId = generalLedger.GeneralLedgerId, DocNumber = 17, Comment = "back to school", AddressId = addressBook.AddressId, CreatedDate = DateTime.Parse("11/11/2019"), DocType = "PV", DebitAmount = null, CreditAmount = null, FiscalYear = 2019, FiscalPeriod = 11 }; NextNumber nnNextNumber = await SupplierLedgerMod.SupplierLedger.Query().GetNextNumber(); view.SupplierLedgerNumber = nnNextNumber.NextNumberValue; SupplierLedger supplierLedger = await SupplierLedgerMod.SupplierLedger.Query().MapToEntity(view); SupplierLedgerMod.SupplierLedger.AddSupplierLedger(supplierLedger).Apply(); SupplierLedger newSupplierLedger = await SupplierLedgerMod.SupplierLedger.Query().GetEntityByNumber(view.SupplierLedgerNumber); Assert.NotNull(newSupplierLedger); newSupplierLedger.Comment = "back to school update"; SupplierLedgerMod.SupplierLedger.UpdateSupplierLedger(newSupplierLedger).Apply(); SupplierLedgerView updateView = await SupplierLedgerMod.SupplierLedger.Query().GetViewById(newSupplierLedger.SupplierLedgerId); Assert.Same(updateView.Comment, "back to school update"); SupplierLedgerMod.SupplierLedger.DeleteSupplierLedger(newSupplierLedger).Apply(); SupplierLedger lookupSupplierLedger = await SupplierLedgerMod.SupplierLedger.Query().GetEntityById(view.SupplierLedgerId); Assert.Null(lookupSupplierLedger); }
public List <ProjectBudget> GetBudgetLinesByGLCode(GeneralLedger gl, ProjectDonor pd) { using (var context = new SCMSEntities()) { var pbList = context.ProjectBudgets.Where(b => b.GeneralLedger.Id == gl.Id && b.BudgetCategory.ProjectDonorId == pd.Id).ToList(); pbList = SCMS.Utils.BudgetLineSorter.SortBudgetLine(pbList); return(pbList); } }
private void Remove_Click(object sender, RoutedEventArgs e) { RemoveDialogView handle = new RemoveDialogView(); handle.ChangeLabelForMember(); if (handle.ShowDialog() == true) { using (SqlConnection con = new SqlConnection(@Connection.ConnectionString)) { if (handle.FirstInput != handle.SecondInput) { MessageBox.Show("Member ID did not match.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation); return; } Connection conn = new Connection(); conn.OpenConection(); int isLogin = 0; string query = "SELECT * From Stuff "; SqlDataReader reader = conn.DataReader(query); while (reader.Read()) { stuff_name = (string)reader["Stuff_Name"]; stuff_pass = (string)reader["Stuff_Password"]; if (stuff_name.Equals(Login.GlobalStuffName) && stuff_pass.Equals(handle.GetPassword)) { isLogin = 1; break; } } if (isLogin != 1) { MessageBox.Show("Wrong Password.Try again.\n", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation); return; } using (SqlCommand command = new SqlCommand("DELETE FROM MonthlyDepositDetails WHERE MemberId = " + handle.FirstInput, con)) { con.Open(); command.ExecuteNonQuery(); con.Close(); } Id = Convert.ToInt32(handle.FirstInput); dateTime = DateTime.Today; string table = "MonthlyDepositDetails"; string type = "Removed"; string color = "Red"; EntryLog entry = new EntryLog(); entry.Add_Entry(table, type, Id, dateTime, color); conn.CloseConnection(); GeneralLedger data = new GeneralLedger(); //next click } } }
private void generalDepositlist_SelectionChanged(object sender, SelectionChangedEventArgs e) { GeneralLedger classObj = generalDepositlist.SelectedItem as GeneralLedger; int id = classObj.MemberId; GDViewObj = new GeneralDepositView(); GDDetailsObj = new GeneralDepositDetailsView(); GDDetailsObj.SearchWithID(id); this.NavigationService.Navigate(GDDetailsObj); }
public async Task <ActionResult> PsRequestPrepaid(string id) { var context = new SphDataContext(); LoadData <Wallet> lo = await GetWallet(id); if (null == lo.Source) { Response.StatusCode = (int)HttpStatusCode.NotFound; return(Json(new { success = false, status = "ERROR", message = $"Cannot find WalletCode with Id: {id}." }, JsonRequestBehavior.AllowGet)); } var generalLedger = new GeneralLedger(); generalLedger.Id = Guid.NewGuid().ToString(); var wallet = lo.Source; decimal noGstPrice = 0; decimal gstPrice = 0; decimal totalPrice = 0; noGstPrice = Convert.ToDecimal(wallet.TotalValue); gstPrice = noGstPrice * Convert.ToDecimal(0.06); totalPrice = noGstPrice + gstPrice; // required by payment gateway var model = new PaymentSwitchRequestModel(); model.TransactionId = GenerateCustomRefNo(generalLedger); model.TransactionAmount = noGstPrice; model.TransactionGST = gstPrice; model.PurchaseDate = DateTime.Now; model.Description = $"{m_applicationName} purchase topup by {User.Identity.Name} for RM{totalPrice} with Id: ({wallet.WalletCode})"; model.CallbackUrl = $"{m_baseUrl}/ost-payment/ps-response-prepaid"; //insert empty transaction into GL with reference no and type generalLedger.ReferenceNo = model.TransactionId; generalLedger.Type = "Prepaid"; using (var session = context.OpenSession()) { session.Attach(generalLedger); await session.SubmitChanges("Default"); } var rijndaelKey = new RijndaelEnhanced(m_paymentGatewayEncryptionKey); var dataToEncrypt = string.Format("{0}|{1}|{2}|{3}|{4}", model.TransactionId, model.TransactionAmount, model.TransactionGST, model.PurchaseDate.ToString("MM/dd/yyyy hh:mm:ss"), model.Description); if (!string.IsNullOrEmpty(model.CallbackUrl)) { dataToEncrypt += "|" + model.CallbackUrl; } var encryptedData = rijndaelKey.Encrypt(dataToEncrypt); Response.StatusCode = (int)HttpStatusCode.OK; return(Json(new { success = true, status = "OK", id = m_paymentGatewayApplicationId, data = encryptedData, url = $"{m_paymentGatewayBaseUrl}/pay" }, JsonRequestBehavior.AllowGet)); }
public ActionResult GeneralLedger_GetTemplate() { using (FATContainer dataContainer = new FATContainer()) { JsonResult result = new JsonResult(); GeneralLedger glInfo = dataContainer.GeneralLedger.Create(); glInfo.TimeMark = DateTime.Now; result.Data = glInfo; return(result); } }
public ActionResult GeneralLedger_Init() { using (FATContainer dataContainer = new FATContainer()) { GeneralLedger glInfo = dataContainer.GeneralLedger.Create(); glInfo.TchNodeID = Convert.ToInt32(RouteData.Values["id"]); TeachingNode tchNode = dataContainer.TeachingNode.FirstOrDefault(node => node.Row_ID == glInfo.TchNodeID); glInfo.TchRoutineID = tchNode.RoutineID; return(View(glInfo)); } }
private static bool GLCodeExists(GeneralLedger gl, SCMSEntities context) { var mbc = context.MasterBudgetCategories.FirstOrDefault(c => c.Id == gl.MasterBudgetCategoryId); //check if gl code already exists var existingGL = context.GeneralLedgers.FirstOrDefault(g => g.Code.Trim() == gl.Code.Trim() && g.MasterBudgetCategory.CountryProgramme.Id == mbc.CountryProgramme.Id && g.Id != gl.Id); if (existingGL != null) { return(true); } return(false); }
public ActionResult GeneralLedger_Insert(GeneralLedger info) { using (FATContainer dataContainer = new FATContainer()) { dataContainer.GeneralLedger.Add(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = info; return(result); } }
public ActionResult GeneralLedger_Update(GeneralLedger info) { using (FATContainer dataContainer = new FATContainer()) { GeneralLedger existedInfo = dataContainer.GeneralLedger.FirstOrDefault(item => item.Row_ID == info.Row_ID); dataContainer.Entry <GeneralLedger>(existedInfo).CurrentValues.SetValues(info); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = existedInfo; return(result); } }
public ActionResult GeneralLedger_Delete(int glRowID) { using (FATContainer dataContainer = new FATContainer()) { GeneralLedger glInfo = dataContainer.GeneralLedger.FirstOrDefault(item => item.Row_ID == glRowID); dataContainer.GeneralLedger.Remove(glInfo); dataContainer.SaveChanges(); JsonResult result = new JsonResult(); result.Data = glInfo; return(result); } }
/// <summary> /// Ghi bản ghi trong DB báo cáo /// </summary> /// <param name="generalLedger">Bản ghi báo cáo</param> /// <returns>1: Thành công</returns> /// <returns>0: Thất bại</returns> /// Created by nnanh - 06-09-2018 public int AddGeneralLedger(GeneralLedger generalLedger) { try { var result = _dbContext.GeneralLedger.Add(generalLedger); } catch (Exception) { return(0); } _dbContext.SaveChanges(); return(1); }
public void SetUp() { DateTimeServer.SetLocal(new TestDateTimeServer(DateTime.Parse("2012-1-1"))); _income = AccountFactory.Income("Income", initialBalance:100M); _pocketMoney = AccountFactory.Income("Pocket Money", initialBalance: 100M); _automaticPayment = new AutomaticPayment() { Debit = _income, Credit = _pocketMoney, Amount = 10M, Description = "Weekly pocket money" }; _generalLedger = new GeneralLedger(new InMemoryRepository()) { _income, _pocketMoney }; }
public async ValueTask <GeneralLedger> Get(CancellationToken cancellationToken = default) { var optional = await _inner.GetOptional(GeneralLedger.Identifier, cancellationToken); if (optional.HasValue) { return(optional.Value); } var generalLedger = GeneralLedger.Factory(); _inner.Add(generalLedger); return(generalLedger); }
public async Task <IFluentGeneralLedger> CreateGeneralLedgerByInvoiceView(InvoiceView invoiceView) { try { AccountReceivable acctRec = await unitOfWork.accountReceivableRepository.GetEntityByPurchaseOrderId(invoiceView.PurchaseOrderId); if (acctRec != null) { GeneralLedger generalLedgerLookup = await unitOfWork.generalLedgerRepository.FindEntityByDocNumber(acctRec.DocNumber); if (generalLedgerLookup == null) { long addressId = await unitOfWork.addressBookRepository.GetAddressIdByCustomerId(acctRec.CustomerId); //Revenue Account ChartOfAccount chartOfAcct = await unitOfWork.chartOfAccountRepository.GetChartofAccount("1000", "1200", "250", ""); GeneralLedger ledger = new GeneralLedger(); ledger.DocNumber = acctRec.DocNumber ?? 0; ledger.DocType = "OV"; ledger.Amount = acctRec.Amount ?? 0; ledger.LedgerType = "AA"; ledger.Gldate = DateTime.Now.Date; ledger.FiscalPeriod = DateTime.Now.Date.Month; ledger.FiscalYear = DateTime.Now.Date.Year; ledger.AccountId = chartOfAcct.AccountId; ledger.CreatedDate = DateTime.Now.Date; ledger.AddressId = addressId; ledger.Comment = acctRec.Remark; ledger.DebitAmount = 0.0M; ledger.CreditAmount = acctRec.Amount ?? 0; ledger.GeneralLedgerNumber = (await unitOfWork.nextNumberRepository.GetNextNumber(TypeOfGeneralLedger.GeneralLedgerNumber.ToString())).NextNumberValue; AddGeneralLedger(ledger); return(this as IFluentGeneralLedger); } processStatus = CreateProcessStatus.AlreadyExists; return(this as IFluentGeneralLedger); } processStatus = CreateProcessStatus.Failed; return(this as IFluentGeneralLedger); } catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); } }
public ResultType GetGeneralLegerList() { ResultType result = new ResultType(); string sqlQuery = @"select ROW_NUMBER() OVER(ORDER BY gl.Gl_Desc asc) as Sno ,gl.Gl_Code,gl.Gl_Desc,gl.Gl_ShortName,gl.Gl_Category,isnull(gl.Gl_PanNo,'')Gl_PanNo,ISNULL(ag.Ac_GrpCode,'')Ac_GrpCode,ISNULL(ag.Ac_Desc,'')Ac_Desc , isnull(asg.Ac_GrpCode,'')Ac_GrpCode,isnull(asg.Ac_SGrpDesc,'')Ac_SGrpDesc,isnull(a.Agent_Code,'')Agent_Code,isnull(a.Agent_Desc,'')Agent_Desc, isnull(ar.Area_Code,'')Area_Code,isnull(ar.Area_Desc,'')Area_Desc from General_Ledger gl left join Account_Group ag on ag.Ac_GrpCode = gl.Ac_GrpCode left join Account_Sub_Group asg on asg.Ac_SGrpCode = gl.Ac_SGrpCode left join Agent a on a.Agent_Code= gl.Agent_Code left join Area ar on ar.Area_Code= gl.Area_Code "; using (SqlConnection conn = new SqlConnection(GetConnectionString())) { using (SqlCommand cmd = conn.CreateCommand()) { conn.Open(); cmd.CommandTimeout = conn.ConnectionTimeout; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = sqlQuery; SqlDataReader dr = cmd.ExecuteReader(); List <GeneralLedger> lstObjects = new List <GeneralLedger>(); GeneralLedger obj = null; while (dr.Read()) { obj = new GeneralLedger(); obj.Sno = dr["Sno"].ToString(); obj.Gl_Code = dr["Gl_Code"].ToString(); obj.Gl_Desc = dr["Gl_Desc"].ToString(); obj.Gl_ShortName = dr["Gl_ShortName"].ToString(); obj.Gl_Category = dr["Gl_Category"].ToString(); obj.Gl_PanNo = dr["Gl_PanNo"].ToString(); obj.Ac_GrpCode = dr["Ac_GrpCode"].ToString(); obj.Ac_Desc = dr["Ac_Desc"].ToString(); obj.Ac_GrpCode = dr["Ac_GrpCode"].ToString(); obj.Ac_SGrpDesc = dr["Ac_SGrpDesc"].ToString(); obj.Agent_Code = dr["Agent_Code"].ToString(); obj.Agent_Desc = dr["Agent_Desc"].ToString(); obj.Area_Code = dr["Area_Code"].ToString(); obj.Area_Desc = dr["Area_Desc"].ToString(); lstObjects.Add(obj); } result.ListData = lstObjects; } } return(result); }
public IActionResult DeleteGeneralLedger([FromHeader] string generalLedgerId) { try { GeneralLedger generalLedger = _dbContext.GeneralLedger.First(i => i.ObjectID.ToString() == generalLedgerId); _dbContext.GeneralLedger.Remove(generalLedger); _dbContext.SaveChanges(); } catch (Exception ex) { return(Ok("Lỗi khi xóa trong database")); } _dbContext.SaveChanges(); return(Ok(new { Code = 200, Success = true, Data = generalLedgerId })); }
/// <summary> /// Performs the playback of actions in this module. /// </summary> /// <remarks>You should not call this method directly, instead pass the module /// instance to the <see cref="TestModuleRunner.Run(ITestModule)"/> method /// that will in turn invoke this method.</remarks> void ITestModule.Run() { Mouse.DefaultMoveTime = 300; Keyboard.DefaultKeyPressTime = 100; Delay.SpeedFactor = 1.0; GL_ACCOUNT account = new GL_ACCOUNT(); account.acctNumber = "571" + StringFunctions.RandStr("9(1)") + " " + StringFunctions.RandStr("A(9)"); // the db is setup to use 4 digits accounts GeneralLedger._SA_Create(account); GeneralLedger._SA_Close(); this._varAccount = account.acctNumber; }
public void SearchAccountTransactions() { var ledger = new GeneralLedger(_repository); var t1 = new Transaction(TestData.Expenses, TestData.Bank, 10M) { Reference = "A", Description = "Buy some stuff" }; ledger.Post(t1); var t2 = new Transaction(TestData.Bank, TestData.Bank, 10M) { Reference = "B", Description = "Withdraw money" }; ledger.Post(t2); var bankTransactions = ledger.GetTransactions(TestData.Bank.Id); bankTransactions.Should().Equal(new[] { t1, t2 }, (x, y) => x.Id == y.Id); var mortgageTransactions = ledger.GetTransactions(TestData.Expenses.Id); mortgageTransactions.Should().Equal(new[] { t1 }, (x, y) => x.Id == y.Id); }
public static double AccountBalance(Session session, Account _Account) { XPQuery <GeneralLedger> LedgerQuery = session.Query <GeneralLedger>(); GeneralLedger LastLedger = (from c in LedgerQuery where c.AccountId == _Account && c.TransactionId.AccountingPeriodId == AccountingPeriodBO.getCurrentAccountingPeriod(session) orderby c.IssuedDate descending , c.UpdateDate descending select c).FirstOrDefault(); if (LastLedger == null) { return(0); } return(LastLedger.Balance); }
public async Task <Guid> Handle(CreateGeneralLedgerCommand request, CancellationToken cancellationToken) { var entity = new GeneralLedger { GlIdByCustomer = request.GlIdByCustomer, GLNameAr = request.GLNameAr, GlNameEn = request.GlNameEn, CustomerId = request.CustomerId }; _context.GeneralLedgers.Add(entity); await _context.SaveChangesAsync(cancellationToken); return(entity.Id); }
/// <summary> /// Performs the playback of actions in this module. /// </summary> /// <remarks>You should not call this method directly, instead pass the module /// instance to the <see cref="TestModuleRunner.Run(ITestModule)"/> method /// that will in turn invoke this method.</remarks> void ITestModule.Run() { Mouse.DefaultMoveTime = 300; Keyboard.DefaultKeyPressTime = 100; Delay.SpeedFactor = 1.0; Settings._SA_Get_AllPayableSettings(); // Setup a new account GL_ACCOUNT newAccount = new GL_ACCOUNT(); if (this._varAccount == "") { newAccount.acctNumber = "590" + StringFunctions.RandStr("9(1)") + " " + StringFunctions.RandStr("A(9)"); // the db is setup to use 4 digits accounts GeneralLedger._SA_Create(newAccount); GeneralLedger._SA_Close(); } else { newAccount.acctNumber = this._varAccount; } // Post an entry in GJ GENERAL_JOURNAL genJournal = new GENERAL_JOURNAL(); GL_ACCOUNT account2 = new GL_ACCOUNT(); GJ_ROW row = new GJ_ROW(); GJ_ROW row2 = new GJ_ROW(); string amount = Functions.RandCashAmount(); row.Account = newAccount; row.debitAmt = amount; genJournal.GridRows.Add(row); // Using the currency account will need foreign currency setup row2.Account = Variables.globalSettings.PayableSettings.CurrencyAccounts[0].BankAccount; row2.creditAmt = amount; genJournal.GridRows.Add(row2); genJournal.source = StringFunctions.RandStr("A(8)"); // to be continued GeneralJournal._SA_Create(genJournal); GeneralJournal._SA_Close(); }
public GeneralLedger GetNextGeneralLedger(Session session, Guid GeneralLedgerId) { GeneralLedger result = null; try { XPCollection <GeneralLedger> NewerGeneralLedgerList = GetNewerGeneralLedger(session, GeneralLedgerId); NewerGeneralLedgerList.Sorting.Add(new SortProperty("IssuedDate", SortingDirection.Ascending)); NewerGeneralLedgerList.Sorting.Add(new SortProperty("CreateDate", SortingDirection.Ascending)); result = NewerGeneralLedgerList.FirstOrDefault(); } catch (Exception) { return(result); } return(result); }
public GeneralLedgerView(GeneralLedger generalLedger) { this.GeneralLedgerId = generalLedger.GeneralLedgerId; this.DocNumber = generalLedger.DocNumber; this.DocType = generalLedger.DocType; this.Amount = generalLedger.Amount; this.LedgerType = generalLedger.LedgerType; this.GLDate = generalLedger.GLDate; this.AccountId = generalLedger.AccountId; this.CreatedDate = generalLedger.CreatedDate; this.AddressId = generalLedger.AddressId; this.Comment = generalLedger.Comment; this.DebitAmount = generalLedger.DebitAmount; this.CreditAmount = generalLedger.CreditAmount; this.FiscalPeriod = generalLedger.FiscalPeriod ?? 0; this.FiscalYear = generalLedger.FiscalYear ?? 0; this.CheckNumber = generalLedger.CheckNumber; this.PurchaseOrderNumber = generalLedger.PurchaseOrderNumber; this.Units = generalLedger.Units; }
public void SetUpForImport() { DateTimeServer.SetLocal(new TestDateTimeServer(DateTime.Parse("2012-1-1"))); _visa = AccountFactory.Liability("visa"); _electricity = AccountFactory.Expense("electricity"); _groceries = AccountFactory.Expense("groceries"); _general = new GeneralLedger(new InMemoryRepository()) {_visa, _electricity, _groceries }; _repository = new Mock<IImportRepository>(MockBehavior.Strict); var patterns = GetPatterns(); _importContext = new TransactionImportContext(_general, patterns, _repository.Object); _import = new Moq.Mock<IImport>(MockBehavior.Strict); _import.SetupGet(x => x.Name).Returns("Mock Import"); _import.SetupGet(x => x.ImportType).Returns("Mock"); }
public void ImportController() { _bank = AccountFactory.Asset("bank", initialBalance: 100); _groceries = AccountFactory.Asset("groceries"); _wow = AccountFactory.Asset("wow"); _unclassifiedExpense = AccountFactory.Expense("unclassified"); _directoryExplorer = new DirectoryExplorer(_directory); _repository = new Mock<IImportRepository>(); _importDetector = new Mock<IImportDetector>(MockBehavior.Strict); _generalLedger = new GeneralLedger(new InMemoryRepository()) { _bank, _groceries, _wow, _unclassifiedExpense }; var transactionContext = new TransactionImportContext(_generalLedger, GetAccountIdentifers(), _repository.Object); _controller = new ImportController(transactionContext, _directoryExplorer, new ImportDetector(new[] {_importDetector.Object})); }
public void SetUp() { _expenseBudgetAccount = AccountFactory.Expense("Grocery Budget"); _expenseAccount = AccountFactory.Expense("Groceries"); _general = new GeneralLedger(new InMemoryRepository()) { _expenseBudgetAccount, _expenseAccount }; _b = new Budget { BudgetAccount = _expenseBudgetAccount, RealAccount = _expenseAccount, Amount = 100M }; }
public AccountIdentifierController(IAccountIdentifierRepository repository, GeneralLedger generalLedger, IEnumerable<PatternBuilder> patterns) { _repository = repository; _generalLedger = generalLedger; _patterns = patterns; }
public void PostTransaction() { var generalLedger = new GeneralLedger(new InMemoryRepository()); Assert.That(generalLedger.Post(_transaction), Is.True); }
public AccountController(GeneralLedger generalLedger) { _generalLedger = generalLedger; }