Welcome to www.SirajGadhia.com

C#.Net AppVB.NET AppASP.Net 2.0Graphic PortfolioResume/Contact

Visit C# Sample Application

Download Application Documents

C# Sample Application

Development tools:

C#
ASP.Net FramwWork 1.1
OOP
N Tiers
Visual Studio 2003
Visual SourceSafe
MS Application Blocks
ADO.Net
SQL Server 2000
Storage Procedure
XML
Firework MX 2004
MS FrontPage 2003
JavaScript
CSS

Screen Shots:

Highlights of Features:

Used an open source JavaScript based RTF control to create RTF contents for news article.

Used an Open source JavaScript based Date Picker control.

Created CSS base global vertical menu/navigation control and integrated with layout design.

New news posting cannot display on web without review by admin.

Interactive and user-friendly Admin UI to review, to change sequence of publication and to manage (add/remove) publication from display.

News publication sequence can change by one click at Admin UI.

N-project / N-Tiers development environment with OOP Architect and RAD concept.

Created and utilized an UC to display news at various place of application with short and large view. This UC is also used inside data grid.

Used storage procedure and data reader for better performance.

UI graphics and menu graphics created with MM Fireworks 2004.

Code Snippets:

-- SQL Storage Procedure for Update News Sequence

ALTER PROCEDURE dbo.UpdateNewsSequence
(
	@NewsID int,
	@Type char(2)
)
AS
declare @curSequence int
declare @newSequence int
declare @NewsIdOfNewSequence int
declare @isUpdate bit 
declare @Count int

SET NOCOUNT ON
DECLARE @Error int
SET @Error = 0
BEGIN TRANSACTION

set @Count = (SELECT     COUNT(*) FROM News)
set @curSequence = (SELECT  Sequence  
             FROM News WHERE (NewsID = @NewsID))
set @isUpdate = 1

if @Type = 'UP' 
begin
Set @newSequence = @curSequence+1
if @curSequence = @Count 
  set @isUpdate = 0
end
if @Type = 'DN' 
begin
Set @newSequence = @curSequence-1
if @curSequence = 1 
  set @isUpdate = 0
end

set @NewsIdOfNewSequence = (SELECT  NewsID  
         FROM News WHERE (Sequence = @newSequence))

if @isUpdate = 1
begin
UPDATE    News
SET      Sequence = @newSequence
WHERE     (NewsID = @NewsID)
UPDATE    News
SET      Sequence = @curSequence
WHERE     (NewsID = @NewsIdOfNewSequence)
end

SET @Error = @@Error
IF( @Error > 0 )
	GOTO ErrorHandler

COMMIT TRANSACTION
RETURN 0

ErrorHandler:
ROLLBACK TRANSACTION
RETURN @Error

-- Storage Procedure for Update All News Sequence

ALTER PROCEDURE UpdateAllNewsSequence
AS
declare @count int
declare @NewsId int

set @Count = 0

declare aCur Cursor for 
 SELECT     NewsID
 FROM         News
 ORDER BY Sequence, isReviewed,isPublished, NewsID
 
open aCur
 
while(0=0) begin
 Fetch Next
 From aCur 
 into @NewsId
 
if (@@Fetch_Status <>0) Break
    Set set @Count = @Count + 1 
    UPDATE    News
        SET       Sequence = @Count
        WHERE     (NewsID = @NewsId) 
end
 
 Close aCur
 Deallocate aCur
 RETURN

-- Storage Procedure for News listing at 
-- Home page and Admin Page

ALTER PROCEDURE dbo.GetAllNews
@isForListing bit = 0
AS
-- For Home page
if @isForListing = 1
begin
SELECT     NewsID, Title, Date, Location, 
           Article, Excerpt, Sequence
FROM       News
where (isPublished = 1) AND (isReviewed=1) 
ORDER BY Sequence DESC, NewsID	
end 
-- For Admin page
if @isForListing = 0
begin

Exec UpdateAllNewsSequence

SELECT     NewsID, Title, Date, Location, 
           Article, Excerpt, Sequence, 
           isPublished, isReviewed
FROM       News
ORDER BY Sequence DESC, NewsID	
end 
RETURN

//C# Code Update News Sequencee at Admin page
protected void gridBtnUpNews(object sender, CommandEventArgs e)
{
(new rajApp.Business.News.NewsManager()).UpdateNewsSequence
    (Convert.ToInt32(e.CommandArgument),"UP");
	this.BindData();	
}

protected void gridBtnDnNews(object sender, CommandEventArgs e)
{
(new rajApp.Business.News.NewsManager()).UpdateNewsSequence
  (Convert.ToInt32(e.CommandArgument),"DN");
	this.BindData();	
}

//UpdateNewsSequence method at rajApp DLL

public void UpdateNewsSequence(int NewsID, string Type)
{
string strSp = "UpdateNewsSequence";
System.Data.SqlClient.SqlConnection cn;
System.Data.SqlClient.SqlCommand cm ;
cn = new System.Data.SqlClient
     .SqlConnection(Database.ConnectionString);
cm = new System.Data.SqlClient.SqlCommand(strSp, cn) ;
cm.CommandType =System.Data.CommandType.StoredProcedure ;
cm.Parameters.Add("@Type", SqlDbType.Char,2);
cm.Parameters["@Type"].Value = Type ;
cm.Parameters.Add("@NewsID",SqlDbType.Int);
cm.Parameters["@NewsID"].Value = NewsID ;
cn.Open();
cm.ExecuteNonQuery();
cn.Close();
}

//C# Code Snippet from home page 	
	
private enum PageMode
{
	NewsList,
	NewsDetail,
}
private PageMode Mode
{
    set
	{
	    this.pnlNewsList.Visible = false;
		this.pnlNewsDetail.Visible = false;
		switch (value)
			{
				case PageMode.NewsList: default:
					this.pnlNewsList.Visible = true;
					break;		
				case PageMode.NewsDetail: 
					this.pnlNewsDetail.Visible = true;
					break;			
				}
			}
		}
private void BindData()
{
	this.grdNews.DataSource = 
	        (new rajApp.Business.News.NewsManager()).GetListingNews();		
	this.grdNews.AllowPaging = true;
	this.grdNews.PageSize = 8;
	this.grdNews.DataBind();
	this.grdNews.PagerStyle.Visible =  
	        (this.grdNews.PageCount > 1);			
}
protected void NewsDisplayUC_More(object sender, News.NewsArgs e)
		{
			this.Mode = PageMode.NewsDetail;
			this.NewsLargeView.News = e.News  ;
		}
private void  grdNews_ItemDataBound(object sender, 
       System.Web.UI.WebControls.DataGridItemEventArgs e)
{
    if ((e.Item.ItemType == ListItemType.Item) 
		|| (e.Item.ItemType == ListItemType.AlternatingItem))
	{
	    Schema.News.News News 
		    = (Schema.News.News) e.Item.DataItem;
		NewsDisplay NewsDisplayUC 
		    = (NewsDisplay)e.Item.FindControl("NewsDisplayUC");
			NewsDisplayUC.LargeView = false;
			NewsDisplayUC.News = News;
	}
}

Welcome to SirajGadhia.com

C# Sample Application

Development tools:

VB.Net Sample Application

Development tools:

.Net 2.0 Sample Application

Development tools:

Download a Sample .Net 2.0 Application

Please enter your email and click submit, you will get a zip file of compleate project very soon by email.

Graphic Portfolio

Note: This web site did not update since July 2002

Samples includes:

Development tools:

Update Resume

Please enter your email and click Email Resume.

Contact: