.NET MVC Example: My Imp Queries

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

-- =============================================

-- Description:

-- =============================================

ALTER PROCEDURE [dbo].[isp_InsertBatch]

@BatchNumber nvarchar(50),

@NoOfEdv int,

@AssignId int,

@EDVIdList nvarchar(max),

@GuIDList nvarchar(max),

@EDVType int,

@CreatedBy int

SET NOCOUNT ON;

BEGIN

INSERT INTO BatchMaster

( [BatchNumber],[NoOfEdv],[AssignId])

VALUES

( @BatchNumber,@NoOfEdv,@AssignId)

declare @BatchID int

Set @BatchId=Scope_Identity()

--============= Entry in EDVMaster Table--========================

DECLARE @EDVID nvarchar(15), @PosEdv int

DECLARE @GUID nvarchar(50),@PosGuid int

----------------------------------------------------------------

SET @EDVIdList = LTRIM(RTRIM(@EDVIdList))+ ','

SET @PosEdv = CHARINDEX(',', @EDVIdList, 1)

SET @GuIDList=LTRIM(RTRIM(@GuIDList))+ ','

SET @PosGuid = CHARINDEX(',', @GuIDList, 1)

----------------------------------------------------------------

IF REPLACE(@EDVIdList, ',', '') <> ''

BEGIN

WHILE @PosEdv > 0

BEGIN

-------------------------------------

SET @EDVID = LTRIM(RTRIM(LEFT(@EDVIdList, @PosEdv - 1)))

SET @GUID = LTRIM(RTRIM(LEFT(@GuIDList, @PosGuid - 1)))

-------------------------------------

IF @EDVID <> ''

BEGIN

--INSERT INTO EdvBatch VALUES(@EDVID,@BatchId)

INSERT INTO EDVMaster(EdvId,EdvExpiryDate,EdvType,Discount,Commission,

CreatedDate,CreatedBy,GuId,IsUsed,BatchId,UserId,IsPrinted) VALUES(@EDVID,null,@EdvType,null,null,getdate(),@CreatedBy,@GUID,'False',@BatchId,null,null)

--print @EDVID + '==>' + @GUID

END

-----------------------------------

SET @EDVIdList = RIGHT(@EDVIdList, LEN(@EDVIdList) - @PosEdv)

SET @PosEdv = CHARINDEX(',', @EDVIdList, 1)

SET @GuIDList = RIGHT(@GuIDList, LEN(@GuIDList) - @PosGuid)

SET @PosGuid = CHARINDEX(',', @GuIDList, 1)

-----------------------------------

END

---=============================================================================

End

########################################################################################

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

-- =============================================

-- Description: exec rpt_LevelWiseCommission NULL,'03/17/2008','03/17/2009',15

-- =============================================

ALTER PROCEDURE [dbo].[rpt_LevelWiseCommission]

@UserId int,

@FromDate datetime,

@ToDate datetime,

@UserType nvarchar(max)

SET NOCOUNT ON;

BEGIN

select distinct Main.UserId ,Main.UserName,

( select isnull(sum(amount),0) from usercommission where UserId = Main.UserId and UserLevel =1 and Commissiondate between coalesce(@FromDate,Commissiondate) and coalesce(@ToDate+1,Commissiondate)) as CommissionLevel1 ,

( select isnull(sum(amount),0) from usercommission where UserId = Main.UserId and UserLevel =2 and Commissiondate between coalesce(@FromDate,Commissiondate) and coalesce(@ToDate+1,Commissiondate)) as CommissionLevel2 ,

( select isnull(sum(amount),0) from usercommission where UserId = Main.UserId and UserLevel =3 and Commissiondate between coalesce(@FromDate,Commissiondate) and coalesce(@ToDate+1,Commissiondate)) as CommissionLevel3 ,

( select isnull(sum(amount),0) from usercommission where UserId = Main.UserId and UserLevel =4 and Commissiondate between coalesce(@FromDate,Commissiondate) and coalesce(@ToDate+1,Commissiondate)) as CommissionLevel4 ,

( select isnull(sum(amount),0) from usercommission where UserId = Main.UserId and UserLevel =5 and Commissiondate between coalesce(@FromDate,Commissiondate) and coalesce(@ToDate+1,Commissiondate)) as CommissionLevel5 ,

( select isnull(sum(amount),0) from usercommission where UserId = Main.UserId and UserLevel =6 and Commissiondate between coalesce(@FromDate,Commissiondate) and coalesce(@ToDate+1,Commissiondate)) as CommissionLevel6

from UserInfo Main

where Main.UserID=Coalesce(@UserId,Main.UserId) and Main.UserType=coalesce(@UserType,Main.UserType)

END

########################################################################################

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

-- =============================================

-- Description: rpt_PerformaneWise '14,15','03-17-2008','03-17-2009'

-- =============================================

ALTER PROCEDURE [dbo].[rpt_PerformanceWise]

@UserType int,

@FromDate Datetime,

@ToDate datetime

SET NOCOUNT ON;

BEGIN

declare @SQL nvarchar(max)

Declare @EdvStatus Table(UserId int,EdvExpiryDate datetime,Status nvarchar(20));

with EdvStatus(UserId,EdvExpiryDate,Status)

AS(

select EM.UserId,EM.EdvExpiryDate,

(case when convert(varchar,CreatedDate,110)<convert(varchar,getdate(),110) and EM.IsUsed='False' then

('Expired')

when convert(varchar,CreatedDate,110)<convert(varchar,getdate(),110) AND EM.IsUsed='True' then

('Used')

when convert(varchar,CreatedDate,110)>=convert(varchar,getdate(),110) AND EM.IsUsed='True' then

('Used')

when convert(varchar,CreatedDate,110)>=convert(varchar,getdate(),110) AND EM.IsUsed='False' then

('Active')

END) as Status

from EdvMaster as EM left outer join

sys_Lookup LU On EM.EdvType=LU.LookUpId

where EM.EdvExpiryDate is not null and EM.CreatedDate between coalesce(@FromDate,EM.CreatedDate) and coalesce(@ToDate+1,EM.CreatedDate)

)

INSERT INTO @EdvStatus (UserId,EdvExpiryDate,Status)(select UserId,EdvExpiryDate,Status from EdvStatus);

select distinct CurES.UserId,U.UserName,U.UserType,LK.LookupValue As UserTypeName,(select count(Status) from @EdvStatus where UserId=CurES.UserId)as SendEDV,

(select count(Status) from @EdvStatus where Status='Used' and UserId=CurES.UserId) as EnrolledEDV,

(select count(Status) from @EdvStatus where Status='Expired' and UserId=CurES.UserId) as ExpiredEDV,

(select count(Status) from @EdvStatus where Status='Active' and UserId=CurES.UserId) as RemainEDV ,

(select sum(Amount) from UserCommission where UserCommission.UserId=CurES.UserId) as Commission

from @EdvStatus CurES LEFT OUTER JOIN

UserInfo U ON U.UserId=CurES.UserId LEFT OUTER JOIN

sys_Lookup LK on LK.LookupId=U.UserType

where U.UserType in (coalesce(@UserType,UserType)) and U.UserType between 14 and 15

order by Commission

END

########################################################################################

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

-- =============================================

-- Description:

-- =============================================

ALTER PROCEDURE [dbo].[ssp_GetNextBatchNumber]

@NewBatchNumber nvarchar(50) OUTPUT

BEGIN

declare @MaxId int

--SELECT @NewBatchNumber=('SC'+ cast(YEAR(GETDATE()) as nvarchar(4)) + cast(MONTH(GETDATE()) as nvarchar(2)) + cast((SELECT isnull(MAX(BatchId),0)+1 FROM BatchMaster) as nvarchar(15)))

SELECT @NewBatchNumber=(select 'SC'+ cast(YEAR(GETDATE()) as nvarchar(4)) +

cast(replicate('0',2-LEN(month(getdate())))+ cast(month(getdate()) as nvarchar(2)) as nvarchar(2)) +

cast((SELECT isnull(MAX(BatchId),0)+1 FROM BatchMaster) as nvarchar(15)) )

End

########################################################################################

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

ALTER PROCEDURE [dbo].[ssp_getRendomAdvertisementEdv]

BEGIN

SET NOCOUNT ON;

Select Top 1

Advertisement.[AdvertisementId], [AdvertisementType], mode2.LookUpValue as advertisementTypeName,

[AdvertiserName],[AdvertiseContent], [StartDate], [EndDate], [Impressions],

[Click], [URL], ClubAdvertisementText, [AdvertisementLocation],

from dbo.Advertisement

JOIN UserInfo ON Advertisement.CreatedBy = UserInfo.UserId

join Sys_Lookup as mode on mode.LookUpId= Advertisement.LookUpModeId

where AdvertisementType = 39 and (Enddate >= getdate() ) and (Impressions - isnull( ImpressionCount,0) > 0 or

Click - isnull(ClickCOunt,0) >0) ORDER BY NEWID()

END

########################################################################################

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

-- =============================================

-- Author:

-- =============================================

ALTER PROCEDURE [dbo].[isp_GenerateParentUserCommission]

@RegisterUserId int,

@EdvId nvarchar(50)

BEGIN

CREATE TABLE #tempCommission(

UserID int,

UserName nvarchar(50),

UserType int,

UserTypeName nvarchar(50),

ParentId int,

Levels int,

Commission decimal(18,2) );

WITH ParentCommissions(UserId, UserName,UserType,UserTypeName,ParentId,Levels,Commission)

(

SELECT UI.UserId, UI.UserName,UI.UserType,lk.LookUpValue as UserTypeName,(select EM.UserId from EdvMaster EM where EM.EdvmasterId=UI.EdvmasterId and UI.EdvMasterId>0)as ParentId,0 as Levels, cast(0 as nvarchar(64)) as Commission

FROM UserInfo UI join

sys_lookup lk On lk.LookUpId=UI.UserType

WHERE UI.UserId = @RegisterUserId

UNION ALL

SELECT U.UserId, U.UserName,U.UserType,lkp.LookUpValue as UserTypeName,(select EM.UserId from EdvMaster EM where EM.EdvmasterId=U.EdvMasterId) as ParentId,UComm.Levels+1 as Levels,

(case when lkp.LookUpValue='PP' then

(Select [Value] from sys_Parameters where [key]='PPCommissionLevel'+rtrim(cast((UComm.Levels+1) as char(5))))

when lkp.LookUpValue='SPP' then

(Select [Value] from sys_Parameters where [key]='SPPCommissionLevel'+rtrim(cast((UComm.Levels+1) as char(5))))

when lkp.LookUpValue='WebUser' then

(select [value] from sys_parameters where [key]= 'NormalCommissionLevel'+rtrim(cast((UComm.Levels+1) as char(5))))

end) as Commission

FROM UserInfo AS U JOIN

sys_lookup lkp On lkp.LookUpId=U.UserType join

ParentCommissions AS UComm ON U.UserId = UComm.ParentId and UComm.Levels < 6 and U.UserId <> @RegisterUserId

)

INSERT INTO #tempCommission (UserID ,UserName,UserType,UserTypeName,ParentId ,Levels ,Commission)

SELECT UserID ,UserName,UserType,UserTypeName,ParentId ,Levels ,Commission

FROM ParentCommissions where levels>0

DECLARE cur_ParentCommissions CURSOR FOR Select UserId,Levels,Commission from #tempCommission

Declare @UserId as int --Parent of requested user

Declare @Level as int --Level of parent

Declare @Commission as decimal(18,2) --% Commission get parent

Declare @Amount as decimal(18,2) --Amount of $ get parent user

Declare @REGFEE as decimal(18,2) --UserRegistration fees assign in it.

Declare @TRANSACTIONTYPE as nvarchar(50)

Declare @TRANSACTIONCATEGORY as nvarchar(50)

Select @REGFEE=UnitPrice from Product where ProductName='ClubFee';

Select @TRANSACTIONTYPE= LookUpId from sys_Lookup where LookupValue='Credit';

Select @TRANSACTIONCATEGORY= LookUpId from sys_Lookup where LookupValue='EDVCommission';

OPEN cur_ParentCommissions;

FETCH NEXT FROM cur_ParentCommissions INTO @UserId,@Level,@Commission ;

WHILE @@FETCH_STATUS = 0

BEGIN

if( @Commission>0 )

begin

set @Amount=((@REGFEE * @Commission)/100)

insert into UserCommission

values( @UserId,@Level ,@EdvId ,@Amount,@Commission,getdate()) ;

insert into TransactionTable

values(@UserId,@TRANSACTIONTYPE,@TRANSACTIONCATEGORY,null,@Amount,Getdate());

end

FETCH NEXT FROM cur_ParentCommissions INTO @UserId,@Level,@Commission ;

END

close cur_ParentCommissions

deallocate cur_ParentCommissions

--select * from #tempCommission

drop table #tempCommission

END

########################################################################################

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

-- =============================================

-- Author:

-- =============================================

ALTER FUNCTION [dbo].[getRelatedUser](@ParentUserId int, @UserType varchar(10))

RETURNS @UsersList TABLE ( UserId int, UserName nvarchar(50) ,ParentId int,ParentName nvarchar(50) , Levels int)

BEGIN

if(@UserType='All')

BEGIN

DECLARE @Level int

set @Level=0;

DECLARE @curUser TABLE (UserId int,UserName nvarchar(50),ParentId int,ParentName nvarchar(50),Levels int);

-- Walks up the hierarchy

WITH TempUserInfo (UserId,UserName,ParentId,ParentName,Levels) AS

( -- This is the 'Anchor' or starting point of the recursive query

SELECT VU.UserId,VU.UserName,VU.ParentId,VU.ParentName,@Level as Levels

FROM View_User VU

WHERE VU.UserId = (select ParentId from View_User where userId=@ParentUserId)

UNION ALL -- This is the recursive portion of the query

SELECT VU.UserId,VU.UserName,VU.ParentId,VU.ParentName,Levels+1

FROM View_User VU

INNER JOIN TempUserInfo -- Note the reference to CTE table name

ON TempUserInfo.ParentId = VU.UserId

)

INSERT INTO @curUser (UserId,UserName,ParentId,ParentName,Levels) (SELECT UserId,UserName,ParentId,ParentName,Levels FROM TempUserInfo);

--select * from @curUser

update @curUser set Levels=abs(Levels-(select count(Cur.Levels)-1 from @curUser Cur))

--select * from @curUser order by Levels

--/////////////////////////////////////////////////////////////////////////////////////

select @Level=isnull(max(Levels),-1)+1 from @curUser;

-- Walks down the hierarchy

WITH TempUserInfo (UserId,UserName,ParentId,ParentName,Levels) AS

( -- This is the 'Anchor' or starting point of the recursive query

SELECT VU.UserId,VU.UserName,VU.ParentId,Vu.ParentName,@Level as Levels

FROM View_User VU

WHERE VU.UserId =@ParentUserId --(select top 1 UserId from View_User where ParentId=120)

UNION ALL -- This is the recursive portion of the query

SELECT VU.UserId,VU.UserName,VU.ParentId,VU.ParentName,Levels+1

FROM View_User VU

INNER JOIN TempUserInfo -- Note the reference to CTE table name

ON VU.ParentId = TempUserInfo.UserId

)

INSERT INTO @curUser (UserId,UserName,ParentId,ParentName,Levels) (SELECT UserId,UserName,ParentId,ParentName,Levels FROM TempUserInfo)

--select * from @curUser order by Levels

INSERT INTO @UsersList (UserId,UserName,ParentId,ParentName,Levels)(select * from @curUser)

END

--/////////////////////Parent User/////////////////////////////////////////////////

ELSE IF (@UserType='Parent')

BEGIN

DECLARE @curParentUser TABLE (UserId int,UserName nvarchar(50),ParentId int,ParentName nvarchar(50),Levels int);

-- Walks up the hierarchy

WITH TempUserInfo (UserId,UserName,ParentId,ParentName,Lvl) AS

( -- This is the 'Anchor' or starting point of the recursive query

SELECT VU.UserId,VU.UserName,VU.ParentId,VU.ParentName,0 as Lvl

FROM View_User VU

WHERE VU.UserId = @ParentUserId

UNION ALL -- This is the recursive portion of the query

SELECT VU.UserId,VU.UserName,VU.ParentId,VU.ParentName,Lvl+1

FROM View_User VU

INNER JOIN TempUserInfo -- Note the reference to CTE table name

ON TempUserInfo.ParentId = VU.UserId

)

INSERT INTO @curParentUser (UserId,UserName,ParentId,ParentName,Levels) (SELECT UserId,UserName,ParentId,ParentName,Lvl FROM TempUserInfo);

--select * from @curChildUser

update @curParentUser set Levels=abs(Levels-(select count(CurParent.Levels)-1 from @curParentUser CurParent))

--select * from @curParentUser order by Levels

INSERT INTO @UsersList (UserId,UserName,ParentId,ParentName,Levels)(select * from @curParentUser)

END

--/////////////////////Child User/////////////////////////////////////////////////

ELSE IF (@UserType='Child')

BEGIN

DECLARE @curChildUser TABLE (UserId int,UserName nvarchar(50),ParentId int,ParentName nvarchar(50),Levels int);

WITH TempUserInfo (UserId,UserName,ParentId,ParentName,Levels) AS

( -- This is the 'Anchor' or starting point of the recursive query

SELECT VU.UserId,VU.UserName,VU.ParentId,VU.ParentName,0 as Levels

FROM View_User VU

WHERE VU.UserId = @ParentUserId

UNION ALL -- This is the recursive portion of the query

SELECT VU.UserId,VU.UserName,VU.ParentId,VU.ParentName,Levels+1

FROM View_User VU

INNER JOIN TempUserInfo -- Note the reference to CTE table name

ON VU.ParentId = TempUserInfo.UserId

)

INSERT INTO @curChildUser (UserId,UserName,ParentId,ParentName,Levels)(SELECT UserId,UserName,ParentId,ParentName,Levels FROM TempUserInfo)

--select * from @curUser

INSERT INTO @UsersList (UserId,UserName,ParentId,ParentName,Levels)(select * from @curChildUser)

END

RETURN

END

########################################################################################

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

-- =============================================

-- exec ssp_GetUserInfoByUserType '16'

-- =============================================

ALTER PROCEDURE [dbo].[ssp_GetUserInfoByUserType]

@UserType nvarchar(100)

BEGIN

declare @SQL nvarchar(max)

set @SQL = 'select

u.UserId,

FirstName,

MiddleName,

LastName,

Gender,

DOB,

ms.LookUpId as MaritalStatus,

ms.LookUpValue as MaritalStatusName,

UserName,

Password,

sq.LookUpId as SecretQuestionId,

sq.LookUpValue as SecretQuestionName,

SecretAnswer,

Address1, Address2, City, StateName, PostalCode, c.CountryId, c.CountryName,

PhoneNumber, MobileNumber, EmailAddress, u.CreatedDate, UpdatedDate,

s.LookUpId as StatusId,

s.LookUpValue as StatusName,

PaypalId, Photo, KickOfDay, NickName, u.UserType,

uType.LookUpValue as UserTypeName, UserDiscountVoucher,

e.EdvMasterId as EdvMaster, e.EdvId, IsOnline,

LastLoginDate from UserInfo as u

left outer join sys_LookUp as ms on ms.LookUpId = u.MaritalStatus

left outer join sys_LookUp as sq on sq.LookUpId = u.SecretQuestionId

left outer join sys_LookUp as s on s.LookUpId = u.StatusId

left outer join Country as c on c.CountryId = u.CountryId

left outer join sys_LookUp as uType on uType.LookUpId = u.UserType

left outer join EdvMaster as e on e.EdvMasterId = u.EdvMasterId

where u.UserType in (' + @UserType +')'

exec sp_executesql @SQL

End

########################################################################################

ALTER PROCEDURE [dbo].[ssp_SearchUser]

@EmailAddress nvarchar(50),

@FirstName nvarchar(50),

@LastName nvarchar(50),

@ContactName nvarchar(50),

@StatusId int,

@RoleId int

BEGIN

declare @sqlstring nvarchar(max)

set @sqlstring= N'

SELECT

Users.UserId,

Users.Email,

Titles.TitleName,

Users.FirstName,

Users.LastName,

Users.ContactName,

Users.LastSynchronise,

Users.CreatedDate,

Users.UpdatedDate,

Status.StatusName,

Roles.RoleName

from Users

INNER JOIN

Titles

ON (Users.TitleId = Titles.TitleId)

INNER JOIN

Status

ON (Users.StatusId = Status.StatusId)

INNER JOIN

Roles

ON (Users.RoleId = Roles.RoleId)'

if(@EmailAddress is not null)

begin

set @sqlstring = @sqlstring + N' And Users.Email Like ''%' + @EmailAddress + '%'''

end

if(@FirstName is not null)

begin

set @sqlstring = @sqlstring + N' And Users.FirstName Like ''%' + @FirstName + '%'''

end

if(@LastName is not null)

begin

set @sqlstring = @sqlstring + N' And Users.LastName Like ''%' + @LastName + '%'''

end

if(@ContactName is not null)

begin

set @sqlstring = @sqlstring + N' And Users.ContactName Like ''%' + @ContactName + '%'''

end

if(@StatusId <> 0)

begin

set @sqlstring = @sqlstring + N' And Users.StatusId=' + cast(@StatusId as varchar(10))

end

if(@RoleId <> 0 )

begin

set @sqlstring = @sqlstring + N' And Users.RoleId=' + cast(@RoleId as varchar(10))

end

set @sqlstring = @sqlstring + ' AND Users.StatusId<>6 '

set @sqlstring = @sqlstring + ' ORDER BY Users.FirstName'

execute sp_executesql @sqlstring

END

<asp:Button ID="btnHiddenMessage" runat="server" Style="display: none" />

<ajaxtoolkit:ModalPopupExtender ID="messageDialog" runat="server" BehaviorID="popupMessageDialog"

TargetControlID="btnHiddenMessage" PopupControlID="pnlPopupMessage" BackgroundCssClass="modalBackground"

OkControlID="btnOkMessage" OnOkScript="DoRedirect();" />

<asp:Panel ID="pnlPopupMessage" runat="server" CssClass="modalpopup" Style="display: none;

width: 350px;">

<asp:Label ID="messageTitle" runat="server" SkinID="blank" CssClass="msg" Text=" " />

<asp:LinkButton ID="LinkButton2" runat="server" CssClass="close" OnClientClick="$find('popupMessageDialog').hide(); return false;" />

div>

<asp:Label ID="lblmessageBody" runat="server" SkinID="blank" CssClass="msgText" Text=" " />

div>

<asp:Button ID="btnOkMessage" runat="server" Text="OK" Width="40px" OnClientClick="$find('popupMessageDialog').hide(); return false;" />

div>

asp:Panel>

////////////////////////////////////////////CSS For MODEL PoPup/////////////////////////////////////////////////////////////

.modalBackground

{

background-color: black;

filter: alpha(opacity=50);

opacity: 0.5;

}

.modalpopup

{

font-family: arial,helvetica,clean,sans-serif;

font-size: small;

padding: 2px 3px;

display: block;

position: absolute;

}

.messageContainer

{

width: 350px;

}

.messageContainer1

{

width: 460px;

border: solid 1px #808080;

border-width: 1px 0px;

}

.messageHeader

{

background: url(images/sprite.png) repeat-x 0px -200px;

color: #000;

border-color: #808080 #808080 #ccc;

border-style: solid;

border-width: 0px 1px 1px;

padding: 3px 10px;

}

.messageHeader .msg

{

font-weight:bold;

}

.messageBody

{

background-color: #f2f2f2;

border-color: #808080;

border-style: solid;

border-width: 0px 1px;

padding-top: 10px;

padding-left: 10px;

padding-bottom: 30px;

color: Black;

}

.messageBody .msgText

{

background: url(images/sprite.png) no-repeat 0px -1150px;

float: left;

padding-left: 22px;

color: Black;

}

.messageBodyInformation

{

background-color: #f2f2f2;

border-color: #808080;

border-style: solid;

border-width: 0px 1px;

padding-top: 10px;

padding-left: 10px;

padding-bottom: 30px;

}

.messageBodyInformation .msgText

{

background: url(images/information.png) no-repeat 0px 0px;

float: left;

padding-left: 30px;

padding-top: 3px;

height: 60px;

color: Black;

}

.messageBodyError

{

background-color: #f2f2f2;

border-color: #808080;

border-style: solid;

border-width: 0px 1px;

padding-top: 10px;

padding-left: 10px;

padding-right: 10px;

padding-bottom: 30px;

}

.messageBodyError .msgText

{

background: url(images/error.png) no-repeat 0px 0px;

float: left;

padding-left: 30px;

padding-right: 10px;

padding-top: 3px;

padding-bottom: 30px;

height: 60px;

color: Black;

}

.messageFooter

{

background-color: #f2f2f2;

border-color: #808080;

border-style: none solid;

border-width: 0px 1px;

text-align: right;

padding-bottom: 8px;

padding-right: 8px;

}

.close

{

right: 7px;

background: url(images/sprite.png) no-repeat 0px -300px;

width: 25px;

cursor: pointer;

position: absolute;

top: 7px;

height: 15px;

}

.NET MVC Example

.

Thursday, August 20, 2009

My Imp Queries

No comments:

.

.