ASP.NET

Re: Time line for Work Completion for Asp.net C# and SqlServer DB

9-Oct-15 2:25

It sounds rather high to me, but it's an estimate of how long it will take you to do the work, so it depends on how quickly you think you can do it.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

jkirkerx9-Oct-15 9:51

jkirkerx

9-Oct-15 9:51

If you have to write it from scratch, it may take that long for you to do it.
If you already had all the planning done, and you just had to code it, it could be 1/2 the time.

But the 80/20 rule still exists.

You spend 20% of your time writing the code, and 80% fixing things you never thought a user could do, unless of course you already have that experience. Writing and testing RegEx to validate input could consume all your quoted times.

I think a login page should not me more than 4 hours including the database table, cookies, and hashing using PWDTK, or whatever its called. And a logout page more than 2 hours.

Reports are time consuming, they take me about 3 days depending on the complexity, and if it's a HTML or Report Writer report.

When I quote jobs out, I quote the time to write the job 50%, and the time to test the job, make corrections, test validation, speed test, code analysis, user experience, 30%, and then artwork for buttons, icons, 20%. And then I add 20% more hours as a safety cap.

I do quote jobs in units of days, then break it down into hours.

I'll give you some tips that I have learned over the last 12 years.
Don't write the project for Microsoft SQL Server, use Entity Framework instead

I would just write SQL Linq for database functions, and not write out TSQL.

Just start out with BootStrap.css, and create a responsive design. Even if your using webforms and not MVC. With webforms, you can make a DLL for Entity Frameworks, or stick it in App_Code.

Write your HTML for Forms, such as textboxes as

<div class="form-group">
  <label>Enter user name:</label>
  <input class="form-control" />
</div>

and use the bootstrap.css to toggle form errors.

I know I'm going to get negative feedback on my suggestions here, but I should of implemented the practice years ago, and I regret not doing it. That SQL Linq is so slick, it's amazing what you can do with it. And the bootstrap.css allows you to just drop in any theme you want, plus it looks cool.

Re: Time line for Work Completion for Asp.net C# and SqlServer DB

macca2413-Oct-15 0:58

Read Invoice number from pdf file

13-Oct-15 0:58

Thanks for your reply jkirkerk it was very helpful

Praveen Kandari8-Oct-15 22:35

Praveen Kandari

8-Oct-15 22:35

Hi, I want to extract the name of customer, Invoice number, etc from an Invoice that would be a Pdf file.
Please help ASAP.
TIA

Re: Read Invoice number from pdf file

ZurdoDev13-Oct-15 2:24

Re: Read Invoice number from pdf file

13-Oct-15 2:24

Refer to this article on how to extract text from a pdf file, Extract Text from PDF in C# (100% .NET)[^]

There are only 10 types of people in the world, those who understand binary and those who don't.

Praveen Kandari15-Oct-15 1:36

Praveen Kandari

15-Oct-15 1:36

This extract whole document I just want to extract Invoice No.
For e.g If it is like: -
Invoice Number : INVC2563

It should extract only INVC2563.

The string INVC may Vary.

Re: Read Invoice number from pdf file

ZurdoDev15-Oct-15 1:41

Asp.net Rapid Development

15-Oct-15 1:41

Praveen Kandari wrote:
This extract whole document I just want to extract Invoice No.

Yes, extract the text and then parse it to find what you need.

There are only 10 types of people in the world, those who understand binary and those who don't.

macca248-Oct-15 3:38

issue in unifying domain.com with www.domain.com using 301 redirect

8-Oct-15 3:38

Does anyone know of any Rapid Development tool for Asp.net to build a database front-end with reporting in a few days.

Is Visual Studio LightSwitch any good?

9pagod7-Oct-15 5:23

Re: issue in unifying domain.com with www.domain.com using 301 redirect

7-Oct-15 5:23

Hi,

My company website is with ASP.NET 2.0 and one day the marketing guy ask me to unify domain.com to www.domain.com so that if visitors visit domain.com they will be redirected to www.domain.com and the status code must be 301 (301 Moved Permanently). He asks me to verify with http://www.redirect-checker.org/. In this site if we input domain.com and click Analyse button, if we have "Status: 301 Moved Permanently" then it's ok.

I tried with so many methods (using URL_Rewrite muldule with Canonical redirect, setup domain.com and redirect to www.domain.com, add <rewrite> rule to web.config file) and all of the methods work fine. However, I only have "Status: 301 Moved Permanently" for the first times access to the site. A second times when I access I see the site be redirected correctly to www.domain.com but the header is "HTTP/1.1 200 OK" but NOT "Status: 301 Moved Permanently" anymore.

Could you please help me how to always have "Status: 301 Moved Permanently"?

Thank you in advance

Richard Deeming7-Oct-15 5:51

Re: issue in unifying domain.com with www.domain.com using 301 redirect

7-Oct-15 5:51

If you're hitting the correct URL, then 200 is the expected status. You should only get a 301 redirect when you hit the wrong URL.

Try testing the site with Fiddler[^].

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

9pagod7-Oct-15 6:10

Re: issue in unifying domain.com with www.domain.com using 301 redirect

7-Oct-15 6:10

Thanks Richard!

My goal is to have "301 Moved Permanently" result when I type my company website domain (http://domain.com) into the box in http://www.redirect-checker.org/index.php[^] and click on Analyse. Could you please show me how to obtain this result?

Thanks,

Richard Deeming7-Oct-15 6:14

Re: issue in unifying domain.com with www.domain.com using 301 redirect

7-Oct-15 6:14

Here's the URL Rewrite[^] rule that I've used successfully on several sites now:

XML

<rewrite>
    <rules>
        <rule name="CanonicalHostName">
            <match url="(.*)" />
            <conditions>
                <add input="{HTTP_HOST}" pattern="^www\.domain\.com$" negate="true" />
            </conditions>
            <action 
                type="Redirect" 
                redirectType="Permanent" 
                url="http://www.domain.com/{R:1}" 
            />
        </rule>
    </rules>
</rewrite>

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

9pagod7-Oct-15 6:27

Re: issue in unifying domain.com with www.domain.com using 301 redirect

7-Oct-15 6:27

Thanks Richard!

As I said in my question, I success in redirecting with so many methods and the way you show me was one of my method to redirect the site. The only one thing that makes me in trouble that is after the first times visit, I don't have "301 Moved Permanently" header anymore.

Chinh

Richard Deeming7-Oct-15 8:15

Re: issue in unifying domain.com with www.domain.com using 301 redirect

7-Oct-15 8:15

I've tested one of the sites where I've used that rule in the tester site you linked to, and it produces a 301 redirect followed by a 200 status every time.

If you're ending up on the correct URL when you request the wrong URL, then the redirect is working.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

9pagod7-Oct-15 16:04

Re: issue in unifying domain.com with www.domain.com using 301 redirect

7-Oct-15 16:04

I have made a screenshot video for your easy reference at https://youtu.be/14y3LEL5508[^]. Could you please take a look and point me out how to always have "301 Moved Permanently".

Thanks.

Richard Deeming8-Oct-15 1:51

Re: issue in unifying domain.com with www.domain.com using 301 redirect

8-Oct-15 1:51

Looks like Firefox is caching the redirection. If you look at the headers for second request, you'll see that it's requested http://www.ocb.dev/, not http://ocb.dev/, so the 200 response is expected.

There are various suggestions to disable or clear the cached 301 response in this StackOverflow thread[^].

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

9pagod8-Oct-15 2:31

Access to files from differentes server

8-Oct-15 2:31

Hi Richard,

I have finally fixed the issue with help from a network guy in my company. I don't know what he did but I have "301" to be always presented.

Thank you very much for your help!

Chinh

Wissem ElHami7-Oct-15 1:32

Wissem ElHami

7-Oct-15 1:32

Hello,
I'am develloping an intranet web site, and i deploy the web site in Server A and i'd like to access to files stored in an other Server B.
My question is how can I access the files (pdf) and view them in the navigator.
Thanks

Re: Access to files from differentes server

ZurdoDev13-Oct-15 2:25

Update All records in Gridview

13-Oct-15 2:25

Depends on how you want to view them. Since this is an intranet site you could simply hyperlink to them using UNC paths, "\\server1\files\file1.pdf".

There are only 10 types of people in the world, those who understand binary and those who don't.

macca246-Oct-15 23:09

Re: Update All records in Gridview

6-Oct-15 23:09

I have a number of records displayed in a Gridview. Each record contains a blank field called Code.

I want to have a field on my form, field A, which I can add a number to and there will be a button called updateCode. When I click the button updateCode I want the number in field A to be updated to the field called Code in each record displayed in the GridView.

Anyone know if this can be achieved?

ZurdoDev13-Oct-15 2:27

Creating Reports in VS 2012

13-Oct-15 2:27

macca24 wrote:
Anyone know if this can be achieved?

Quite simple really. In your button click code, pass the textbox value to a stored procedure. In that stored procedure, update all the records. Then refresh the grid.

There are only 10 types of people in the world, those who understand binary and those who don't.

macca246-Oct-15 23:01

Re: Creating Reports in VS 2012

6-Oct-15 23:01

I have a asp.net web application created in VS 2012 and I want to create reports and letters in it.

Anyone know how to create reports and letters in VS 2012?

ZurdoDev13-Oct-15 2:27

Adding 3 fields together and updating a fourth field with the value

13-Oct-15 2:27

You can use the SSRS Report Viewer control and create SSRS Reports. You can also do Crystal Reports. I believe those are probably the 2 most common report engines used with ASP.Net.

There are only 10 types of people in the world, those who understand binary and those who don't.

macca246-Oct-15 22:23

Re: Adding 3 fields together and updating a fourth field with the value

6-Oct-15 22:23

I have four fields, A, B, C, D

Fields A, B, and C will have numerics added to them. I want that when I have added data to all three fields then field D will automatically be updated with the SUM of the 3 fields A, B and C.

Anyone know how to do this?

ZurdoDev13-Oct-15 2:28