void ReleaseDesignerOutlets() { if (TransactionsTable != null) { TransactionsTable.Dispose(); TransactionsTable = null; } if (DateColumn != null) { DateColumn.Dispose(); DateColumn = null; } if (DescriptionColumn != null) { DescriptionColumn.Dispose(); DescriptionColumn = null; } if (ValueColumn != null) { ValueColumn.Dispose(); ValueColumn = null; } }
public void AddAndUpdateWorks_All() { TransactionsTable eventTable = SetupForEventTests(); Assert.NotNull(eventTable); Add(new TransactionNewLayout(DateTime.Now, "boomer2"), eventTable); Assert.AreEqual(1, eventTable.Count(), "after one add"); TransactionBase foundNote = eventTable.GetExisting(new database.ColumnConstant[2] { TransactionsTable.TYPE, TransactionsTable.DATA1_LAYOUTGUID }, new string[2] { TransactionsTable.T_ADDED.ToString(), "boomer2" }); Assert.NotNull(foundNote); // should still only be 1 beacuse we've just edited the existing foundNote.UpdateValue(TransactionsTable.DATA2.Index, "some data2"); Update(foundNote, eventTable); Assert.AreEqual(1, eventTable.Count()); foundNote.UpdateValue(TransactionsTable.DATA2.Index, "some data3"); Update(new TransactionNewLayout(DateTime.Now, "boomer2"), eventTable); Assert.AreEqual(1, eventTable.Count()); Add(new TransactionNewLayout(DateTime.Now, "boomer2"), eventTable); Assert.AreEqual(2, eventTable.Count()); Add(new TransactionImportLayout(DateTime.Now, "roar", "The Roar Caption"), eventTable); Add(new TransactionImportLayout(DateTime.Now, "roar", "The Roar Caption"), eventTable); Assert.AreEqual(4, eventTable.Count()); Add(new TransactionDeleteLayout(DateTime.Now, "roar"), eventTable); Assert.AreEqual(5, eventTable.Count()); }
protected void FetchDat(object sender, EventArgs e) { List <Transaction> transactions = JsonConvert.DeserializeObject <List <Transaction> >(httpget(int.Parse(databaseOption.SelectedValue), "transactions/" + cardList.SelectedValue)); System.Diagnostics.Trace.TraceInformation(JsonConvert.SerializeObject(transactions)); TransactionsTable.DataSource = transactions; TransactionsTable.DataBind(); }
public void QueryTests() { _TestSingleTon.Instance._SetupForLayoutPanelTests(); TransactionsTable eventTable = SetupForEventTests(); LayoutDetails.Instance.TransactionsList = eventTable; System.Windows.Forms.Form form = new System.Windows.Forms.Form(); form.Show(); LayoutDetails.Instance.GetAppearanceFromStorage = _TestSingleTon.Instance.GetAppearanceFromStorage; YOM2013.DefaultLayouts.CreateASystemLayout(form, null); LayoutDetails.Instance.SystemLayout = new Layout.LayoutPanel(CoreUtilities.Constants.BLANK, true); LayoutDetails.Instance.SystemLayout.LoadLayout(LayoutPanel.SYSTEM_LAYOUT, false, null); form.Controls.Add(LayoutDetails.Instance.SystemLayout); Worklog.JournalPanel Journal = new Worklog.JournalPanel("A", null); Assert.NotNull(eventTable); // Add a Really Old Task (20 days ago) Add(new TransactionWorkLog(DateTime.Now.AddDays(-20), "BOOM", "", 1000, 2000, "Writing"), eventTable); Add(new TransactionWorkLog(DateTime.Now, "BOOM", "", 100, 200, "Writing"), eventTable); string value = Journal.GetWeekStats(DateTime.Now); Assert.True(value.IndexOf("100") > -1, "Found Words"); Assert.True(value.IndexOf("200") > -1, "Found Minutes"); // add a task for another entity Add(new TransactionWorkLog(DateTime.Now, "BOOM2", "", 50, 50, "Writing"), eventTable); value = Journal.GetWeekStats(DateTime.Now); Assert.True(value.IndexOf("150") > -1, "Found Words2"); Assert.True(value.IndexOf("250") > -1, "Found Minutes2"); // now look 'a week ago' should find none value = Journal.GetWeekStats(DateTime.Now.AddDays(-10)); Assert.False(value.IndexOf("100") > -1, "Found Words3"); Assert.False(value.IndexOf("200") > -1, "Found Minutes3"); Assert.False(value.IndexOf("150") > -1, "Found Words3"); Assert.False(value.IndexOf("250") > -1, "Found Minutes3"); // Now Layout Specific Tests value = Journal.GetWorkStats_SpecificLayout(DateTime.Now, "BOOM2"); Assert.True(value.IndexOf("50") > -1, "Found Words2"); Assert.False(value.IndexOf("250") > -1, "Found Minutes2"); value = Journal.GetWorkStats_SpecificLayout(DateTime.Now, "BOOM"); Assert.True(value.IndexOf("100") > -1, "Found WordsBOOMSPECIFIC"); Assert.True(value.IndexOf("200") > -1, "Found MinutesBOOMSPECIFIC"); Assert.False(value.IndexOf("250") > -1, "Found Minutes2"); _w.output(value); // Now do Test 'ALL TIME' bylooking at the value we already grabbed because SpecificLayout also includes a Global Count Assert.True(value.IndexOf("1100") > -1, "Found WordsBOOMSPECIFIC _ALLTIME"); Assert.True(value.IndexOf("2200") > -1, "Found MinutesBOOMSPECIFIC _ALLTIME"); }
public void TryingToAddUniqueIDTwice() { TransactionsTable eventTable = SetupForEventTests(); Assert.NotNull(eventTable); TransactionNewLayout tricky = new TransactionNewLayout(DateTime.Now, "boomer2"); Add(tricky, eventTable); Assert.AreEqual(1, eventTable.Count(), "after one add"); tricky.UpdateValue(TransactionsTable.ID.Index, "1"); Add(tricky, eventTable); }
private TransactionsTable SetupForEventTests() { lg.Instance.OutputToConstoleToo = true; FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase(_TestSingleTon.TESTDATABASE); db.DropTableIfExists("events"); db.Dispose(); TransactionsTable eventTable = new TransactionsTable(MasterOfLayouts.GetDatabaseType(_TestSingleTon.TESTDATABASE)); return(eventTable); }
public void ExistWorks() { TransactionsTable eventTable = SetupForEventTests(); Assert.NotNull(eventTable); Add(new TransactionNewLayout(DateTime.Now, "boomer2"), eventTable); Assert.AreEqual(1, eventTable.Count(), "after one add"); TransactionBase foundNote = eventTable.GetExisting(new database.ColumnConstant[2] { TransactionsTable.TYPE, TransactionsTable.DATA1_LAYOUTGUID }, new string[2] { TransactionsTable.T_ADDED.ToString(), "boomer2" }); Assert.NotNull(foundNote); }
public Order GetOrder(Guid orderID) { SimpleProductRepository productRepository = new SimpleProductRepository(); SimpleCustomerRepository customerRepository = new SimpleCustomerRepository(); Order result = null; var batch = new BatchSql(); batch.Append(OrdersTable.Select().Where("OrderID", orderID)); //items //products for the items var sql = new SqlStatement(connectionStringName); sql.Add("SELECT "); sql.Add(ProductsTable.COLUMN_LIST); sql.Add(OrderItemsTable.COLUMN_LIST); sql.Add("FROM Products INNER JOIN OrderItems ON Products.SKU = OrderItems.SKU"); sql.Add("WHERE SKU IN (SELECT SKU FROM OrderItems WHERE OrderID=@OrderID)"); //transactions batch.Append(TransactionsTable.Select().Where("orderid", orderID)); int shippingAddressID = 0; int billingAddressID = 0; int shippingMethodID = 0; //pull it var cmd = sql.BuildCommand(); using (var rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { if (rdr.Read()) { result = new Order(OrdersTable.ReadOrderStatusID(rdr)) { DateCreated = OrdersTable.ReadCreatedOn(rdr), DateShipped = OrdersTable.ReadDateShipped(rdr), UserName = OrdersTable.ReadUserName(rdr), DiscountAmount = OrdersTable.ReadDiscountAmount(rdr), DiscountReason = OrdersTable.ReadDiscountReason(rdr), EstimatedDelivery = OrdersTable.ReadEstimatedDelivery(rdr), ID = orderID, OrderNumber = OrdersTable.ReadOrderNumber(rdr), ShippingAmount = OrdersTable.ReadShippingAmount(rdr), ShippingService = OrdersTable.ReadShippingService(rdr), TaxAmount = OrdersTable.ReadTaxAmount(rdr), }; billingAddressID = OrdersTable.ReadBillingAddressID(rdr); shippingAddressID = OrdersTable.ReadShippingAddressID(rdr); } //load the items result.Items = new List <OrderLine>(); if (rdr.NextResult()) { while (rdr.Read()) { var product = productRepository.LoadProduct(rdr); var item = new OrderLine(OrderItemsTable.ReadDateAdded(rdr), OrderItemsTable.ReadQuantity(rdr), product); result.Items.Add(item); } } //transactions result.Transactions = new List <Transaction>(); if (rdr.NextResult()) { while (rdr.Read()) { Transaction t = new Transaction( TransactionsTable.ReadTransactionID(rdr), orderID, TransactionsTable.ReadAmount(rdr), TransactionsTable.ReadTransactionDate(rdr), TransactionsTable.ReadAuthorizationCode(rdr), TransactionsTable.ReadNotes(rdr), TransactionsTable.ReadProcessor(rdr)); result.Transactions.Add(t); } } } sql = new SqlStatement(connectionStringName); //addresses batch.Append(AddressesTable.Select().Where("addressid", shippingAddressID)); batch.Append(AddressesTable.Select().Where("addressid", billingAddressID)); //shipping method batch.Append(ShippingMethodsTable.Select().Where("shippingmethodid", shippingMethodID)); cmd = batch.BuildCommand(connectionStringName); using (var rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { //shipping address if (rdr.Read()) { //shipping result.ShippingAddress = customerRepository.LoadAddress(rdr); } //billing address if (rdr.NextResult()) { if (rdr.Read()) { result.BillingAddress = customerRepository.LoadAddress(rdr); } } //shipping method if (rdr.NextResult()) { if (rdr.Read()) { LoadShipping(rdr); } } } return(result); }
public UpdateTransactionCommandhandler(IAccountsContext context) { _table = new TransactionsTable(context); }
public void Update(TransactionBase eventRow, TransactionsTable eventTable) { eventTable.UpdateEvent(eventRow); }
public void Add(TransactionBase eventRow, TransactionsTable eventTable) { eventTable.AddEvent(eventRow); }
public TransferCommandHandler(IAccountsContext context) { _accountsTable = new AccountsTable(context); _transactionsTable = new TransactionsTable(context); }
public StartTransactionCommandHandler(IAccountsContext context) { _table = new TransactionsTable(context); }