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.
Hello,
I'm interested to work. this. I understand that you want to generate demo data during runtime.
I'm over 8 years exp in .Net..
Please message me.
Thanks,
Sheik
Hi, I am 12+ years experienced HTML,CSS,Php,MVC, C#,Bootsrap,Telerik control,Crystal report,WCF,JSON,SharePoint,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your work confidently.
I am very much Interested to do your work,Please revert me if you have any concern.
Hello,
I hope you doing very well!
I have gone through the description and would like to provide a quality solution using my 5+ years of professional experience in required skills. (.NET/ASP.NET - MVC, EF, SQL, C#).
Awaiting for your positive response so we can have final talk and start project immediately :)
.Net Developer with extensive experience in the development, systems maintenance training. Net applications, relational database (procedures, views and triggers in SQL Server and Oracle), non-relational databases (Apache Solr and Redis), interpretation of UML, versioning source code in Git, SVN, TFS and Mercurial, MVC and MVP concepts, training and advanced technical support. I have also experience with SCRUM.