Important alert: (current site time 7/15/2013 8:58:42 AM EDT)
 

winzip icon

A Cooking Recipe Portal V 2.16

Email
Submitted on: 2/15/2009 12:18:36 PM
By: Dexter Zafra  
Level: Advanced
User Rating: By 17 Users
Compatibility: C#, ASP.NET
Views: 41155
author picture
(About the author)
 
     World Recipe V2.9 is an ASP.NET 2.0 C# N-Tier application and SQL 2005 Database with stored procedure to contain and display recipes in a wide variety of categories, also allow your visitors to post their favorite recipes, rate recipe and add comment. You can edit/delete recipes or comments in a password protected admin recipe manager area. Features: Cooking Blog/Article RichText Editor Recipe of the Day Last Viewed Recipe in the last 4 Hours Configure SMTP server address and Webmaster email Enabled/Disabled Comment Through the Admin Page Send to a Friend Email in HTML Format Cross browser compatibility Search capability Email notifications Advanced Admin Management Extremely extensible RSS Feeds Link ratings Link reviews Live Demo at: http://www.myasp-net.com/
Fixed stored procedure rating bug. CAST((1.0 * a.No_Rating/a.No_Rates) as decimal(2,1)) as Rates
Star rating image is now accurate. Fixed few bugz. This new version of XD World Recipe V 2.8 is 3-tier arhcitecture, and much more secured than the older version with added querystring and input validation. This version use Stored Procedure and Object Oriented Programming for data abstraction and code reuse. You must have basic knowledge of Object Oriented Programming, Stored Procedure, IIS 5/6, SQL 2005 server to configure and attach the database. If you want to learn ASP.NET C# 3-tier application architecture and SQL stored procedure, this one is for you. Source code and installation guide included in the zip file. Fixed bug on Count days. Changed inc_admindbconn.aspx connection string to use the web config conn string. Final Update. Added Article Manager and used data abstraction for code reuse and encapsulate some logic. Added article category manager. Fixed pager last and next button bug. Also implemented field length validation. Implemented bi-directional sorting. Features: 1) Recipe Blog / Article - Rich Text Editor 2) Recipe of the Day 3) Most Viewed recipe in the last 4 hours. 4) Admin page to configure SMTP server address and Webmaster email 5) Enabled/disabled comment through admin page. 6) Send to a friend email in HTML format. 7) Optional photo upload for the recipe 8) New Rating/Voting system 9) New CSS layout interface. 10) Dynamic page title and keywords 11) Optimized for SE 12) Article/Blog Manager - Add, edit and delete article/blog Update: 1) Implement CSS DIGG Style custom numeric paging with bidirectional dynamic sorting 2) Used IDataReater to bind the repeater 3) Implement Row_Number paging 4) Improved the page load performance by disabling viewstate 5) Changed the paging logic 7) Make Pager Link SEO Friendly 8) Display pager like 1,2,3,4,5..11,12 Update: Used Generic LIST to bind a repeater with custom entity object. No ObjectDataSource use. Implement caching. If there is new record or update in the database, the cache will be remove. --------------- Latest Update: Used custom paging SQL Row_Number in Admin Recipe Manager Grid to efficiently page data if the the number of recipe grow large. This will improve loading time, and eliminate loading all the records at one time. --------- Update: 9-12-08 Change image upload logic 1)Implemented a logic to append alphanumeric char if image name already exist. This prevent overwriting an existing image. 2) Implemented a logic to delete the image when the recipe with an image is deleted. Necessary to clean up unused images. 3)Implemented a logic to delete an image when updating/replacing an image. 5) Changed the image view logic to prevent file locking "File is being use by another person/user" 6)Create a class to return the image and path so when you change the image directory you only have to open one file. Noet: Make sure you give write permission the image directory. Otherwise you will get an error. ----------- View Live Demo and Screenshots at http://www.ex-designz.net/softwaredetail.asp?fid=1884

 
winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
  1. You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
  2. You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
  3. You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
  4. You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 5 submission(s) by this author

 


Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Advanced category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)
 

Other User Comments

6/20/2008 1:34:17 AMmkanya

I am getting this Error 6 Type 'SqlConnection' is not defined IN THE inc_admindbconn.aspx, what am i doing wrong?
(If this comment was disrespectful, please report it.)

 
6/26/2008 2:26:31 AMDexter Zafra

Open the inc_admindbconn.aspx and locate the DB_Server variable and replace it with this code. DB_Server = System.Configuration.ConfigurationManager.ConnectionStrings("strConn").ConnectionString< BR>
This
way you don't have to change the connection string in the inc_admindbconn.aspx.

(If this comment was disrespectful, please report it.)

 
6/28/2008 2:42:50 AMmkanya

Yes i did that but i am still getting the same error, i am using Visual Studio 2005
(If this comment was disrespectful, please report it.)

 
7/21/2008 10:37:14 AMWalter Senekal

Hi
Are you posting new versions?
If yes please explain what you modified or change the version number
Thanks
Walter
(If this comment was disrespectful, please report it.)

 
7/22/2008 12:56:05 AMDexter Zafra

Latest update.
Article Manager
Added article category manager.
Fixed pager last and next button bug. Implemented field length validation. Implemented bi-directional sorting in recipe and article category.
Fixed stored procedure bug.
(If this comment was disrespectful, please report it.)

 
7/28/2008 1:39:26 AMDexter Zafra

Latest update:
Added article search
Added article bi-directional sort
Factored cs code
Optimized stored procedure query
Use IDataReader to populate repeater
(If this comment was disrespectful, please report it.)

 
8/1/2008 1:51:02 AMDexter Zafra

Updated Admin Recipe Manager stored procedure and added more comments.
Also factored some C# code.
(If this comment was disrespectful, please report it.)

 
8/18/2008 12:30:49 AMDexter Zafra

Update:
1) Implement custom numeric paging with bidirectional sorting
2) Used IDataReater to bind the repeater
3) Implement Row_Number paging
4) Improved the page load performance by disabling viewstate
5) Changed the paging logic
6) SEO Friendly Pager Link
(If this comment was disrespectful, please report it.)

 
8/22/2008 3:01:01 AMDexter Zafra

Update:
Used Generic LIST to bind a repeater with custom entity object. No ObjectDataSource use.
(If this comment was disrespectful, please report it.)

 
8/24/2008 4:05:33 AMDexter Zafra

Update:
Changed paging logic by eliminating find control hide/show panel or label.
(If this comment was disrespectful, please report it.)

 
8/27/2008 11:11:38 AMkibe

nice work
thank for share..
(If this comment was disrespectful, please report it.)

 
8/28/2008 1:30:38 AMDexter Zafra

Update:
Implement caching. The cache will be purge if the database record is updated or added new record.
(If this comment was disrespectful, please report it.)

 
9/1/2008 1:31:05 PMDexter Zafra

Update:
Used custom paging SQL Row_Number in Admin Recipe Manager Grid to efficiently page data if the the number of recipe grow large. This will improve loading time, and eliminate loading all the records at one time.
(If this comment was disrespectful, please report it.)

 
9/3/2008 1:08:30 PMPooh!

Hey Dexter, Great web app!! 5 Globes from me.
But, where is the 'Optional photo upload for recipe' functionality at? I don't see anything anywhere yet that would support that.
(If this comment was disrespectful, please report it.)

 
9/5/2008 2:19:28 AMDexter Zafra

Update:
1) Implement dynamic pagesize option

2) Implement dynamic layout switcher i.e Rows, Grid 2 Columns or Grid 3 Columns

Photo upload will be implemented this weekend along with an empty database to those who want to start from scratch.
(If this comment was disrespectful, please report it.)

 
9/6/2008 5:31:21 PMDexter Zafra

Update:
Implemented Recipe Photo Upload to Image directory and saved filename and extension to database
(If this comment was disrespectful, please report it.)

 
9/8/2008 1:47:10 AMDexter Zafra

Update: 9-7-08
1) Implement admin recipe edit photo and upload new photo.
2) Added recipe photo column in the admin recipe manager to see if the recipe has a photo and also show the image width and height.

-----------
Next update is to be able to delete the image in the directory when the recipe is deleted.
(If this comment was disrespectful, please report it.)

 
9/13/2008 1:44:45 AMDexter Zafra

Update: 9-12-08
Change image upload logic
1)Implemented a logic to append alphanumeric char if image name already exist. This prevent overwriting an existing image.
2) Implemented a logic to delete the image when the recipe with an image is deleted. Necessary to clean up unused images.
3)Implemented a logic to delete an image when updating/replacing an image.
5) Changed the image view logic to prevent file locking "File is being use by another person/user"
6)Create a class to return the image and path so when you change the image directory you only have to open one file.


(If this comment was disrespectful, please report it.)

 
9/14/2008 11:53:56 AMDexter Zafra

Update: 9-13-08
1) Implemented filter with photo in the Admin Manager. This will show only recipe with photo.

2) Implemented filter for last viewed recipes of today, 2 days, 3 days, 1 week, 2 weeks, and 1 month span.
(If this comment was disrespectful, please report it.)

 
9/18/2008 11:07:13 PMDexter Zafra

Update: 9-18-08
1) Refactored and optimized few stored procedures.

2) Update editing recipe page.

3) Fixed missing image bug when updating a recipe with no image.
(If this comment was disrespectful, please report it.)

 
9/20/2008 3:37:14 PMDexter Zafra

Latest Update:

1) Changed paging logic to display the last 2 paging links
i.e. << previous | 1, 2 ... 5,6,7,8,9 ... 22, 23 | last >>
Screenshot of the new pager links: http://www.ex-designz.net/xdcategorypagescreenshot.htm
(If this comment was disrespectful, please report it.)

 
9/26/2008 1:25:42 AMDexter Zafra

Update: 9-25-08
1) Implemented bi-directional sort arrow up and arrow down image.
(If this comment was disrespectful, please report it.)

 
10/1/2008 11:21:17 PMDexter Zafra

Update: 9-30-08
1) Fixed bug in recipe comments post and delete recipe category.
(If this comment was disrespectful, please report it.)

 
11/26/2008 1:09:14 AMReylen Catungal

Hi, I recieved an error message just like below. What will I do?

Line 9: using System.Web.UI.WebControls.WebParts;
Line 10: using System.Web.UI.HtmlControls;
Line 11: using Util;
Line 12:
Line 13: public partial class alphaletter : System.Web.UI.UserControl

Source File: c:\Inetpub\wwwroot\Recipe\Control\alphaletter.ascx.cs Line: 11
(If this comment was disrespectful, please report it.)

 
1/17/2009 8:43:36 PMDexter Zafra

Update: 1/17/09

- Fixed potential XSS vulnerability.
(If this comment was disrespectful, please report it.)

 
1/20/2009 11:46:06 PMDexter Zafra

Update: 1/20-2009

1) Implemented a method to validate querystring value for potential SQL and XSS injection.

2) Updated AddRecipe stored procedure to handle recipe image upload.
(If this comment was disrespectful, please report it.)

 
2/13/2009 3:18:26 PMDexter Zafra

Update 2/12/09

1) Changed to System.Net.Mail
2) Refactored dropdownlistHelper
3) Used Extended custom collection with all sorts of useful stuff.
(If this comment was disrespectful, please report it.)

 
2/14/2009 9:03:21 PMDexter Zafra

Update: 2/14/2009
1) Used Master Page
2) Implement Exception logging and email notification
3) Used System.Net.Mail to send email
4) Refactored code to eliminate code redundancy.

Next update is to create the user login system, profile, cook of the week, and "MyCookBook" system so user can save their favorite recipe.
(If this comment was disrespectful, please report it.)

 
7/20/2009 6:17:25 AMSALEM

THANK U
(If this comment was disrespectful, please report it.)

 
11/16/2009 10:50:53 AMaafreen

can u mail me the dfd and the er diagram of this system. plz on
aafreensingh@yahoo.co.in
(If this comment was disrespectful, please report it.)

 
12/2/2009 10:57:53 PMefren II M. Catedrilla

if you dont mind, could you make a tutorial summarie of A Cooking Recipe Portal V 2.16, i really appreciate it..thank you...
(If this comment was disrespectful, please report it.)

 
12/17/2009 1:51:18 PMAHM Hasil

what is the user name for database recipe?.
(If this comment was disrespectful, please report it.)

 

Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)
 

To post feedback, first please login.