Find Jobs
Hire Freelancers

Create a Demo Data Generator

$30-250 USD

已取消
已发布将近 8 年前

$30-250 USD

货到付款
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.
项目 ID: 10408174

关于此项目

6提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
6威客以平均价$134 USD来参与此工作竞价
用户头像
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
$60 USD 在2天之内
4.9 (86条评论)
5.9
5.9
用户头像
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.
$155 USD 在3天之内
3.8 (32条评论)
5.6
5.6
用户头像
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 :)
$128 USD 在3天之内
5.0 (11条评论)
4.0
4.0
用户头像
I have more than 6 Years of experience in SQL and C#. Please go through my profile for more detail. Thanks
$194 USD 在4天之内
5.0 (9条评论)
3.5
3.5
用户头像
.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.
$111 USD 在6天之内
0.0 (0条评论)
0.0
0.0

关于客户

DENMARK的国旗
Aalborg, Denmark
5.0
1
付款方式已验证
会员自3月 21, 2016起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。