Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 Tags
Subject: RE: Pricing Question
Thread ID: 395436 Message ID: 395439 # Views: 55 # Ratings: 0
Version: Not Applicable Category: Web Applications
Date: Tuesday, January 14, 2014 11:01:40 PM         
   


> Hi Pete,
>
> If MS "SQL Server" setup effort is the main concern, I think using the MS "Entity Framework", version 4.1 and beyond, with a "Code First" design approach could be an option, because that way the typical, frequent DB server administration tasks is almost all done by your own code, i.e. a simple access attempt would make the EF part create or update the custom DB structure including "seed" values if necessary.
> http://msdn.microsoft.com/en-us/data/jj193542.aspx
>
> As for MS "SQL Express v LocalDB v SQL Compact Edition" in that context:
> http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx
>
>
>
> hth
> -Stefan
>
>
> > Hi Foxitians,
> >
> > This is mainly for any C# + SQL Server developers out there using ASP.net.
> >
> > My question although general in nature is one that I would like to bounce off
> > some of you.
> >
> > Basic requirements and task...
> > - Install SQL Server 2012 on new server customer purchased and is on site now.
> > - Inventory table consisting of 8-10 fields with admin login web form to allow access into
> > changing, adding or deleting inventory items from anywhere with Internet access. No permissions
> > required just an admin login ID and password.
> > - Customer registration form for all credit card sales consisting of 12-14 fields.
> > Customer registration to be added into SQL Server in a Customer table in SQL Server if payment successful.
> > - eCommerce shopping card to allow purchases, calculate sales taxes and accept payment
> > via most major credit cards. Credit card processing company already decided upon and I already have
> > processing code for this credit card processing company.
> > - Payment process upon verification and completion will then add the registration records
> > into the SQL Server Client table.
> > - Next create a sales order record in another SQL Server table and add in the various
> > sales order detail records that were purchases in a child sales order details table in SQL Server.
> > - Other things like user definable shipping companies and rates, tax codes to reflect
> > province for where the purchaser resides, so need a sales tax lookup table.
> > - Wants all email entries validated for only valid email addresses.
> > - Invoice generated in PDF file format and copy sent to purchaser via email with invoice
> > attachment.
> > - Email sent back to my client the seller in summary form only.
> > - Customer wants some reports, but does not know what at this point in time.
> >
> > OK, I estimated this entire job, plus SQL Server installation at 44 hours?
> > This is not including any reports that would be completed later on a quote basis and
> > of course involve additional billing.
> >
> > Does my 44 hours sound in the ball park, including the full SQL Server installation?
> > ps ... SQL Server installation will be done remotely via TeamViewer thus no travel time.
> >
> > Pete "the IceMan", from the Great White North of Canada.
> > www.marathongriffincomputers.com


Hi,

No SQL Server is not the main concern. After dozens of SQL Server installations and
setup with minor changes to allow remote in IP + port access the SQL Server installation
is a walk in the park.
Customer going with his own SQL Server on site as he needed a server anyways and is
putting all business file and documents on a centralized server. Also upgrading his
Simply Accounting software to enterprise version so all centralized on this same server.

My question revolves around a truly customized checkout and credit card payment web program where
fields in SQL Server have to say match up with clients Simply Accounting inventory structure
and customer of course wants professional looking check out box matching existing website colors and
of course adding in customer's own logos and banner tops, etc.

Then of course all the extras like taking and creating an invoice and converting into PDF format
and the smtp email senders, etc.
Involved as well Sales Order and Sales OrderDetails table on SQL Server and included in the credit
card check out system is a web interface allowing the viewing of all sales order by, date, date range
and by customer. This would all be C# web forms involved in this.

My question is pointed to total time to code that I ball parked and quoted at 44 hours. I am curious
what other developers would roughly ball park for such as web check out system?
Your best guess is only what I am after here?


Pete "the IceMan", from the Great White North of Canada.
www.marathongriffincomputers.com

ENTIRE THREAD

Pricing Question Posted by Pete Sass @ 1/14/2014 9:08:11 PM
RE: Pricing Question Posted by Stefan Wuebbe @ 1/14/2014 9:39:12 PM
RE: Pricing Question Posted by Pete Sass @ 1/14/2014 11:01:40 PM
RE: Pricing Question Posted by Mike Gagnon @ 1/15/2014 2:15:16 AM
RE: Pricing Question Posted by Pete Sass @ 1/15/2014 3:06:09 AM
RE: Pricing Question Posted by David Mustakim @ 1/15/2014 3:07:52 AM
RE: Pricing Question Posted by Stefan Wuebbe @ 1/15/2014 12:05:36 PM
RE: Pricing Question Posted by Tom Saddul @ 1/15/2014 6:49:34 AM
RE: Pricing Question Posted by Pete Sass @ 1/15/2014 2:09:27 PM
RE: Pricing Question Posted by David Mustakim @ 1/15/2014 2:37:12 PM
RE: Pricing Question Posted by Pete Sass @ 1/15/2014 9:37:13 PM