testing live writer

// A smart class used for generating nice HTML based on the language of your
// choice.
using System.Collections.Generic;
using System.Text.RegularExpressions;

namespace Nocco
{
    class Language
    {
        public string Name;
        public string Symbol;
        public Regex CommentMatcher { get { return new Regex(@"^\s*" + Symbol + @"\s?"); } }
        public Regex CommentFilter { get { return new Regex(@"(^#![/]|^\s*#\{)"); } }
        public IDictionary<string, string> MarkdownMaps;
        public IList<string> Ignores;
    }
}

so heres anbother attempt at a post. this time with larger font.

USE [BurnPlus_dev]
GO
/****** Object:  StoredProcedure [api].[admin_discount_create]    Script Date: 26/04/2013 15:08:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER proc [api].[admin_discount_create]
@p xml,
@r xml output
as
begin try

declare @no int,    
        @type varchar(255),
        @type_id int,
        @created datetime,
        @value int



select @type = @p.value('(Discount/@type)[1]', 'varchar(255)'),
        @no = @p.value('(Discount/@no)[1]', 'int'),
        @value = @p.value('(Discount/@value)[1]', 'int')


-------------------------------------------------------------------------------------------------------
-------------------------input validation--------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
    select @type_id = id from discount_type where name = @type


    if   @type_id is null 
        begin 
        raiserror    (N'unknown doscount type ',
                    16, -- severity.
                    1) -- state
        end


        
    if   @no is null  or @no = 0
        begin 
        raiserror    (N'no number of codes to create',
                    16, -- severity.
                    1) -- state
        end
    
        if   @value is null
        begin 
        raiserror    (N'no discount value',
                    16, -- severity.
                    1) -- state
        end

-------------------------------------------------------------------------------------------------------
-------------------------end input validation----------------------------------------------------------
-------------------------------------------------------------------------------------------------------

    set @created = getutcdate()

    insert discount
    (code, discount_type_id,value, created)
    select distinct top(@no)left(newid(),6), @type_id,@value, @created
    from tally t
    cross join tally t2



select @r = (
    select 0 as "@status", 
    object_name(@@procid) as "@procName",
        (
            select code as "@code",
            @type as "@type",
            value as "@value"
            from discount
            where created = @created
            for xml path ('Discount'), type
        )
    for xml path('Result')
    )

end try

begin catch
    exec dbo.set_error @p, @r output
end catch




select * from setting

Tags: c#, sql

a first post about c#

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur vitae imperdiet sem. Ut euismod quam sed tellus faucibus sodales. Donec dictum vestibulum tristique. Aliquam molestie dui vulputate quam lacinia imperdiet. Sed interdum est eu velit semper egestas. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer metus purus, gravida vulputate tempor eu, posuere molestie lacus. Curabitur feugiat lacinia bibendum. Vivamus tristique tristique magna eget pellentesque. Nulla facilisi.

Nulla at purus tellus. Suspendisse quis fringilla nisi. Vivamus ornare sapien ligula, non gravida est. Ut cursus, turpis non aliquet feugiat, turpis libero elementum tortor, in tempus enim elit ut tellus. Curabitur sem eros, egestas id dignissim a, tempus eget elit. Integer at libero nisl. Curabitur quis sapien vitae ante facilisis accumsan. Ut enim orci, fermentum id vulputate vel, venenatis non quam. Sed eu nulla id purus semper laoreet a vel nisl. Donec tincidunt mollis dui, eget semper arcu fermentum sit amet. Aenean varius porta dolor, id vulputate risus auctor a. Integer ac condimentum nulla. Aliquam ornare, neque ac viverra tincidunt, tortor neque placerat massa, sed elementum neque turpis vel leo. Sed vel risus felis, eu pharetra velit. Sed eget velit elit.

Tags: c#, sql