Demo Data Generator

We already made a demodatahandler for generating data, but this need an update. The code can be found under [login to view URL] There are 20 persons registered as test-persons, and we create and maintain 2 subscription plans. new DemoDataPlanHolder(new PlanHolder(){Amount=175, Created=[login to view URL](-16), Currency="DKK", Interval=1, IntervalRefDate=[login to view URL](-16), Intervaltype=[login to view URL], Name="Måneds abb. DKK"}, new int[]{0,1,3,4,5,7,8,9,10,12,13,14,15,16,17,18,19}), new DemoDataPlanHolder(new PlanHolder(){Amount=23.5M, Created=[login to view URL](-16), Currency="EUR", Interval=1, IntervalRefDate=[login to view URL](-16), Intervaltype=[login to view URL], Name="Monthly sub. EUR"}, new int[]{2,6,11}) These 2 subscription plans is 1 plan with DKK (Danish Krone) as Currency, with an amount of 175 pr. month. Interval = 1 means every month, IntervalRefDate starts 16 months in the past. Intervaltype means all invoices are sent at the same date. The int[] arrays indicates which persons from the list are involved in this plan. The second plan is just an Euro subscription plan, amount is 23,5Euro, and just 3 persons er involved. A little background: We create data that simulates a flow over time. Meaning that we start with just one subscriber, and then over the period of the 16 months, more people are joining - and we end with 16 and 3 subscribers for the 2 plans. The database should end up with the following data: - 2 records in Plan (should already exists - this is handled in the function checkPlan - 2 * 16 records in PlanPayment (one for each month). Look at checkPlanPayment function. - 16 + 3 records in UserPlan. One for each user and the same in Accounts. - xx records in Transaction or TransactionLog. If we had all 21 users assigned for all 16 months, we would end up with 21 * 16 records in Transaction or TransactionLog tables. (TransactionLog is for the processed transactions - when they are paid or cancelled). The update to the demo data handler is we have to start by deleting all records related to the plans first, and then create new records. Customer and Plan records will not be changed! Use builtin database functions. var db = [login to view URL](); <- Will get a db connection [login to view URL]("DELETE FROM XX WHERE ID=?", new object[]{idvalue}); <- will execute and replace ? with the values.