protected void CreateXML()
    {
        try
        {
            XmlDocument SettingsXML = new XmlDocument();

            if (File.Exists(Server.MapPath(SettingsXMLPath)))
            {

                SettingsXML.Load(Server.MapPath(SettingsXMLPath));
                XmlNodeList nodeXMLList = SettingsXML.SelectNodes("/UserGroups/Authentication");

                XmlNode node = CreateNode(SettingsXML);
                //Get reference to the book node and append the book node to it
                XmlNode userGroupsNode = SettingsXML.SelectSingleNode("/UserGroups");
                userGroupsNode.AppendChild(node);

            }
            else
            {
                XmlNode declarationNode = SettingsXML.CreateXmlDeclaration("1.0", "utf-8", "");
                SettingsXML.AppendChild(declarationNode);
                XmlNode userGroupsNode = SettingsXML.CreateElement("/UserGroups");
                XmlNode node = CreateNode(SettingsXML);
                userGroupsNode.AppendChild(node);
                SettingsXML.AppendChild(userGroupsNode);
            }

            SettingsXML.Save(Server.MapPath(SettingsXMLPath));
            if (Flag != "True")
            {
                lblMessage.Text = "User Registered Successfully.";
            }
            else
            {
                lblMessage.Text = "UserId already exists.";
            }
           
            txtUserId.Text = "";
            txtPassword.Text = "";
        }
        catch (Exception ex)
        {
            HttpContext.Current.Response.Write(ex.Message);
        }
    }
   
    XmlNode CreateNode(XmlDocument doc)
    {
        XmlNode node = doc.CreateElement("Authentication");
       
        XmlAttribute userIDAttribute = doc.CreateAttribute("UserID");
        userIDAttribute.Value = Guid.NewGuid().ToString();
        node.Attributes.Append(userIDAttribute);

        //Add all the children of the node 
        XmlNode authType = doc.CreateElement("AuthType");
        authType.InnerText = ddlUserType.SelectedValue;
        node.AppendChild(authType);

        XmlNode accessId = doc.CreateElement("AccessId");
        accessId.InnerText = txtUserId.Text;
        node.AppendChild(accessId);

        XmlNode accessKey = doc.CreateElement("AccessKey");
        accessKey.InnerText = txtPassword.Text;
        node.AppendChild(accessKey);

        XmlNode creationDate = doc.CreateElement("CreationDate");
        creationDate.InnerText = DateTime.Now.ToLongDateString();
        node.AppendChild(creationDate);

        return node;
        }

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




CREATE PROCEDURE [dbo].[sp_WorkingDays]
(
    @StartDate    DATETIME,
    @EndDate    DATETIME
)
AS
BEGIN
DECLARE @WeekNumber VARCHAR(50)
--DECLARE @StartDate    DATETIME
--DECLARE @EndDate    DATETIME
DECLARE @StDate        VARCHAR(50)
DECLARE @Yr            VARCHAR(10)
DECLARE    @Month        VARCHAR(10)
DECLARE    @EndMonth        VARCHAR(10)
DECLARE @WDayCount    BIGINT
DECLARE @WDay        BIGINT
DECLARE @NumberOfDays INT
DECLARE @lastDayOfMonth BIGINT
DECLARE @WeekDay    VARCHAR(50)
DECLARE @Counter    BIGINT
DECLARE @Pos        BIGINT
DECLARE @HDayCount    BIGINT

--SET @startdate = '2010-02-20'
--SET @enddate = '2010-03-31'
SET @EndMonth = MONTH(@Enddate)

-- Calculating Working Day Excluding Sunday
SET @NumberOfDays = DATEDIFF(d, @startdate, @enddate) + 1
SET DATEFIRST 7
SET ROWCOUNT @NumberOfDays

DECLARE @numbers TABLE (i INT IDENTITY(0,1), x BIT)
INSERT INTO @numbers SELECT NULL FROM master.dbo.sysobjects a,
master.dbo.sysobjects b, master.dbo.sysobjects c
SET ROWCOUNT 0

SELECT @WDayCount = COUNT(d)
    FROM
        (SELECT DATEADD(dd, i, @startdate) d FROM @numbers) dates
        WHERE NOT DATEPART(dw, d) = 1

-- Calculation For Working Days Excluding Sunday
SET @StDate = @StartDate
DECLARE outer_Cursor CURSOR FOR
    SELECT DATEPART(YEAR, d) AS YEAR, DATEPART(MONTH, d) AS MONTH, COUNT(d) AS 'WorkingDay'
    FROM
        (SELECT DATEADD(dd, i, @startdate) d FROM @numbers) dates
        WHERE NOT DATEPART(dw, d) = 1 GROUP BY DATEPART(YEAR, d), DATEPART(MONTH, d)
        ORDER BY 1, 2
OPEN outer_Cursor
FETCH NEXT FROM outer_Cursor INTO @Yr,@Month,@WDay
WHILE @@FETCH_STATUS = 0
BEGIN
    -- Year wise Month Checking
    IF @Yr = YEAR(@EndDate)
    BEGIN
        IF MONTH(@StDate) <= @EndMonth
        BEGIN
            IF @Pos = 1
            BEGIN
                SET @StDate = CONVERT(DATETIME,'01' + '-' + CONVERT(VARCHAR,MONTH(@StDate)) + '-' + CONVERT(VARCHAR,YEAR(@StDate)),103)
            END
        END
        ELSE
        BEGIN
            SET @StDate = @Enddate
        END
    END
    ELSE
    BEGIN
        IF @Pos = 1
        BEGIN
            SET @StDate = CONVERT(DATETIME,'01' + '-' + CONVERT(VARCHAR,MONTH(@StDate)) + '-' + CONVERT(VARCHAR,YEAR(@StDate)),103)
        END
    END
    -- Calculate The Week No
    SELECT @lastDayOfMonth = DAY(DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@StDate)+1,0)))
    IF MONTH(@StDate) = @EndMonth
    BEGIN
        SET @lastDayOfMonth = DAY(@Enddate)
    END
   
    SET @Counter = DAY(@StDate)
    WHILE @Counter <= @lastDayOfMonth
    BEGIN
        -- Code to check weather it is holiday
        SELECT @HDayCount=COUNT(*) FROM HoliDayList WHERE HoliDay = @StDate
        IF @HDayCount > 0
        BEGIN
            -- Calling function to get WeekDay Name
            SET @WeekDay = dbo.GetWeekDayNameOfDate(@StDate)
            IF CONVERT(BIGINT,DAY(@StDate)) <= @lastDayOfMonth
            BEGIN
                IF @WeekDay = 'Saturday'
                BEGIN
                    IF MONTH(@StDate) < 10
                    BEGIN
                        SET @Month = '0' + CONVERT(VARCHAR(2),MONTH(@StDate))
                    END
                    ELSE
                    BEGIN
                        SET @Month = MONTH(@StDate)
                    END
                    -- Calling Function to get Week No
                    SET @WeekNumber = dbo.fn_WeekDays(@Month,@StDate)
                    IF @WeekNumber <> 2 OR @WeekNumber <> 4
                    BEGIN
                        SET @WDayCount = @WDayCount - 1
                    END
                END
                ELSE IF @WeekDay <> 'Sunday'
                BEGIN
                    SET @WDayCount = @WDayCount - 1
                END
                SET @StDate = CONVERT(DATETIME,DATEADD(d,1,@StDate),103)
            END
        END
        ELSE
        BEGIN
            -- Calling function to get WeekDay
            SET @WeekDay = dbo.GetWeekDayNameOfDate(@StDate)
            IF CONVERT(BIGINT,DAY(@StDate)) <= @lastDayOfMonth
            BEGIN
                IF @WeekDay = 'Saturday'
                BEGIN
                    IF MONTH(@StDate) < 10
                    BEGIN
                        SET @Month = '0' + CONVERT(VARCHAR(2),MONTH(@StDate))
                    END
                    ELSE
                    BEGIN
                        SET @Month = MONTH(@StDate)
                    END
                    -- Calling Function to get Week No
                    SET @WeekNumber = dbo.fn_WeekDays(@Month,@StDate)
                    IF @WeekNumber = 2 OR @WeekNumber = 4
                    BEGIN
                        SET @WDayCount = @WDayCount - 1
                    END
                END
                SET @StDate = CONVERT(DATETIME,DATEADD(d,1,@StDate),103)
            END
        END
        SET @Counter = @Counter + 1
    END
    SET @Pos = 1
    SET @WeekNumber = 1
FETCH NEXT FROM outer_Cursor INTO @Yr,@Month,@WDay
END
CLOSE outer_Cursor
DEALLOCATE outer_Cursor
    SELECT @WDayCount AS TotalWorkingDays, (@WDayCount * 9) AS TotalWorkingHours
END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go



CREATE PROCEDURE [dbo].[sp_OrderId]
AS
BEGIN
DECLARE @Date        VARCHAR(50)
DECLARE @Time        VARCHAR(50)
DECLARE @Num        INT
DECLARE @Pos        INT
DECLARE @NextPos    INT
DECLARE @Name        VARCHAR(50)
DECLARE @TimeFormat    VARCHAR(50)
DECLARE @OrderId    VARCHAR(50)

    SELECT @Date = CONVERT(VARCHAR(50), GETDATE(),112)
    SELECT @Time = Convert(Varchar(50),GETDATE(), 114)

    SET @Num = 0
    SET @Pos = 1
    SET @TimeFormat = ''

    WHILE(@Pos <= LEN(@Time))
    BEGIN
        SELECT @NextPos = CHARINDEX(N':', @Time,  @Pos)
        IF (@NextPos = 0 OR @NextPos IS NULL)
            SELECT @NextPos = LEN(@Time) + 1
        SELECT @Name = RTRIM(LTRIM(SUBSTRING(@Time, @Pos, @NextPos - @Pos)))
        SELECT @Pos = @NextPos+1
       
        IF @TimeFormat = ''
            SET @TimeFormat = @Name
        ELSE
            SET @TimeFormat = @TimeFormat + @Name

        SET @Num = @Num + 1
    END

    SET @OrderId = @Date + @TimeFormat
    SELECT @OrderId = RTRIM(LTRIM(SUBSTRING(@OrderId, 1, len(@OrderId) - 3 )))

SELECT CONVERT(BIGINT, @OrderId) AS OrderId

END

Hey Friends,

here is the code to generate resize image at the time of uploading. Hope It will help.

 public string ResizeBookImage(FileUpload ftpControl, int intWidth, int intHeight, string UploadDirectory, string strTempDirectory)
    {
        string strFileName = "";
        if (ftpControl.HasFile)
        {
            imgResizedName = Guid.NewGuid();
            string ext = Path.GetExtension(ftpControl.FileName);
            strFileName = imgResizedName.ToString();
            string strFName = ftpControl.FileName;
            ftpControl.SaveAs(strTempDirectory + ftpControl.FileName);
            string strFCName = strTempDirectory + strFName;

            System.Drawing.Image image = System.Drawing.Image.FromFile(strFCName);
            int srcWidth = image.Width;
            int srcHeight = image.Height;
            //int thumbHeight = (srcHeight / srcWidth) * thumbWidth;
            Bitmap bmp = new Bitmap(intWidth, intHeight);
            string dest = UploadDirectory + strFileName + ".jpg";
            System.Drawing.Graphics gr = System.Drawing.Graphics.FromImage(bmp);
            gr.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
            gr.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality;
            gr.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;

            System.Drawing.Rectangle rectDestination = new System.Drawing.Rectangle(0, 0, intWidth, intHeight);
            gr.DrawImage(image, rectDestination, 0, 0, srcWidth, srcHeight, GraphicsUnit.Pixel);

            bmp.Save(dest, System.Drawing.Imaging.ImageFormat.Jpeg);

            bmp.Dispose();
            image.Dispose();

            File.Delete(strTempDirectory + strFName);
        }
        return strFileName;
    }

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[sp_SearchString]
(
    @Keywords VARCHAR(MAX),
    @SearchType VARCHAR(100)
)
AS
DECLARE @SearchText VARCHAR(MAX)
DECLARE @Num        INT
DECLARE @Pos        INT
DECLARE @NextPos    INT
DECLARE @TableCount INT
DECLARE @CountSep    INT
DECLARE @Count        INT
DECLARE @BookId        UNIQUEIDENTIFIER
DECLARE @AuthorName VARCHAR(500)
DECLARE @ISBN        VARCHAR(50)
DECLARE @BookName    VARCHAR(500)
DECLARE @PubYear    VARCHAR(20)

BEGIN
IF @SearchType='General'
BEGIN
    IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES
    WHERE TABLE_TYPE='BASE TABLE'
    AND TABLE_NAME='temp')
    SET @TableCount = 1
    ELSE
    BEGIN   
        CREATE TABLE temp (BookID UNIQUEIDENTIFIER,AuthorName VARCHAR(500),
        ISBN VARCHAR(50),BookName VARCHAR(500),PubYear VARCHAR(20))
        SET @TableCount = 0
    END

    SELECT @CountSep = CHARINDEX(N':', @Keywords,1)

    IF @CountSep = 0
        BEGIN
            SELECT BookID FROM (
            SELECT DISTINCT Books.BookID AS BookID, Books.PublisherId, Books.IsDeleted FROM Books INNER JOIN BookPrice ON Books.BookId=BookPrice.BookId
            INNER JOIN BookAuthor ON BookAuthor.BookId=Books.BookId INNER JOIN
            Author ON Author.AuthorId=BookAuthor.AuthorId INNER JOIN Publisher ON Books.PublisherId=Publisher.PublisherId
             WHERE BookPrice.ISBN like'%' + @Keywords + '%' OR
            Books.BookName like'%' + @Keywords + '%'
            OR Books.YearofPublication like'%' + @Keywords + '%'
            OR Author.AuthorName like'%' + @Keywords + '%' AND Publisher.Publisher='XXX' ) AS tmpBook
            INNER JOIN Publisher ON tmpBook.PublisherId=Publisher.PublisherId WHERE Publisher.Publisher='XXX'
            AND tmpBook.IsDeleted = 0
        END
    ELSE
    BEGIN
        SET @Num = 0
        SET @Pos = 1
        WHILE(@Pos <= LEN(@Keywords))
        BEGIN
            SELECT @NextPos = CHARINDEX(N':', @Keywords,  @Pos)
            IF (@NextPos = 0 OR @NextPos IS NULL)
            BEGIN
                SELECT @NextPos = LEN(@Keywords) + 1
            END
            SELECT @SearchText = RTRIM(LTRIM(SUBSTRING(@Keywords, @Pos, @NextPos - @Pos)))

            IF @Pos = 1
            BEGIN
                DECLARE Outer_Cursor CURSOR FOR
       
                    SELECT BookID,AuthorName,ISBN,BookName,PubYear FROM (
                    SELECT DISTINCT Books.BookID AS BookID, Books.PublisherId,
                    Books.IsDeleted, Author.AuthorName AS AuthorName,
                    BookPrice.ISBN AS ISBN,
                    Books.BookName AS BookName, Books.YearofPublication AS PubYear
                    FROM Books INNER JOIN BookPrice ON Books.BookId=BookPrice.BookId
                    INNER JOIN BookAuthor ON BookAuthor.BookId=Books.BookId INNER JOIN
                    Author ON Author.AuthorId=BookAuthor.AuthorId INNER JOIN Publisher ON Books.PublisherId=Publisher.PublisherId
                     WHERE BookPrice.ISBN like'%' + @SearchText + '%' OR
                    Books.BookName like'%' + @SearchText + '%'
                    OR Books.YearofPublication like'%' + @SearchText + '%'
                    OR Author.AuthorName like'%' + @SearchText + '%' AND Publisher.Publisher='XXX' ) AS tmpBook
                    INNER JOIN Publisher ON tmpBook.PublisherId=Publisher.PublisherId WHERE Publisher.Publisher='XXX'
                    AND tmpBook.IsDeleted = 0
               
                OPEN Outer_Cursor
                FETCH NEXT FROM outer_cursor INTO @BookId, @AuthorName, @ISBN, @BookName, @PubYear
                WHILE @@FETCH_STATUS = 0
                    BEGIN
                        INSERT INTO temp (BookId, AuthorName, ISBN, BookName, PubYear)
                        VALUES (@BookId, @AuthorName, @ISBN, @BookName, @PubYear)
                        FETCH NEXT FROM outer_cursor INTO @BookId, @AuthorName, @ISBN, @BookName, @PubYear
                    END
                CLOSE outer_cursor
                DEALLOCATE outer_cursor
            END
            ELSE
            BEGIN
                DELETE FROM temp WHERE BookID NOT IN (
                    SELECT BookID FROM temp
                     WHERE ISBN like'%' + @SearchText + '%' OR
                    BookName like'%' + @SearchText + '%'
                    OR PubYear like'%' + @SearchText + '%'
                    OR AuthorName like'%' + @SearchText + '%'
                )
            END
            SET @Pos = @NextPos+1
        END
        SELECT BookID FROM temp AS tblRecordset
        DROP TABLE temp
    END
END
   
ELSE IF @SearchType='ISBN'

    SELECT DISTINCT Books.BookID AS BookID FROM Books INNER JOIN BookPrice ON Books.BookId=BookPrice.BookId
     INNER JOIN Publisher ON Books.PublisherId=Publisher.PublisherId
     WHERE Publisher.Publisher='XXX' AND BookPrice.ISBN like'%' + @Keywords + '%' AND BookPrice.IsDeleted=0

ELSE IF @SearchType='Title'

    SELECT DISTINCT Books.BookID AS BookID FROM Books INNER JOIN BookPrice ON Books.BookId=BookPrice.BookId
     INNER JOIN Publisher ON Books.PublisherId=Publisher.PublisherId
     WHERE Publisher.Publisher='XXX' AND Books.BookName like'%' + @Keywords + '%' AND Books.IsDeleted=0

ELSE IF @SearchType='Author'

    SELECT DISTINCT Books.BookID AS BookID FROM Books INNER JOIN BookPrice ON Books.BookId=BookPrice.BookId
    INNER JOIN BookAuthor ON BookAuthor.BookId=Books.BookId INNER JOIN
    Author ON Author.AuthorId=BookAuthor.AuthorId  INNER JOIN Publisher ON Books.PublisherId = Publisher.PublisherId
     WHERE Publisher.Publisher='XXX' AND Author.AuthorName like'%' + @Keywords + '%' AND BookAuthor.IsDeleted=0

ELSE IF @SearchType='PublicationYear'

    SELECT DISTINCT Books.BookID AS BookID FROM Books INNER JOIN BookPrice ON Books.BookId=BookPrice.BookId
     INNER JOIN Publisher ON Books.PublisherId=Publisher.PublisherId
     WHERE Publisher.Publisher='XXX' AND Books.YearofPublication like'%' + @Keywords + '%' AND Books.IsDeleted=0

ELSE IF @SearchType='Subject'

    SELECT DISTINCT BooksCategory.BookID AS BookID FROM
    BooksCategory INNER JOIN Category ON BooksCategory.CategoryId=Category.CategoryId
    INNER JOIN Books ON BooksCategory.BookId = Books.BookId INNER JOIN Publisher
    ON Books.PublisherId=Publisher.PublisherId
    WHERE Publisher.Publisher='XXX' AND Category.Category like'%' + @Keywords + '%' AND BooksCategory.IsDeleted=0
END