The Weird and The Wonderful

public int LoadedSampleCount
        {
            get { return (int)GetValue(LoadedSampleCountProperty); }
            set { SetValue(LoadedSampleCountProperty, value); }
        }
        public static readonly DependencyProperty LoadedSampleCountProperty =
            DependencyProperty.Register("LoadedSampleCount", typeof(int), typeof(TreeWindowVM SampleSetLoaderVM), new PropertyMetadata(0));

foreach (Object item in group)
{
// Some code...
int i = 1;
string key = "SomeString_" + i.ToString();
// Some more code...
}

try
{
    account.Save();
}
catch { ; } //Not good!

 
DECLARE @Scrap_Qty int
DECLARE @FilledQty int
SET @Scrap_Qty=10 --Change this to 1 and it still run
SET @FilledQty = 2
 
BEGIN
 
IF @Scrap_Qty  > @FilledQty
 declare @currDate varchar(10)   
 Set @currDate= Convert(VARCHAR(10),GetDate(),103)  
 PRINT @currDate
 
END  
 

DECLARE @Scrap_Qty int
DECLARE @FilledQty int
SET @Scrap_Qty=10 --Change this to 1 and it won't output @Scrap_Qty
SET @FilledQty = 2
 
BEGIN
 
IF @Scrap_Qty  > @FilledQty
	PRINT @Scrap_Qty
 declare @currDate varchar(10)   
 Set @currDate= Convert(VARCHAR(10),GetDate(),103)  
 PRINT @currDate
 
END  

using System;
using CLAP;
 
namespace Clap
{
    class Program
    {
        static void Main(string[] args)
        {
            Parser.Run<Program>(args);
        }
 
        [Verb(Description = "Imports an Impro CSV report file.", Aliases = "import,imp")]
        static void ImportCsv(
            [Required]
            [Description("Full path to the file to import.")] string filePath)
        {
            Console.WriteLine("Will import " + filePath);
        }
    }
}

Unhandled Exception: System.TypeLoadException: Could not load type 'CLAP.Parser' from assembly 'Clap, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'.
   at Clap.Program.Main(String[] args)

private MailMessage BuildMailMessage(...)
{
...
 
mailMessage.BCC.Add("guys@address.com");
 
..
}

private void button1_Click(object sender, EventArgs e)
{
    int lefttop = Convert.ToInt16(_1.Text);
    int centertop = Convert.ToInt16(_2.Text);
    int righttop = Convert.ToInt16(_3.Text);
    int leftcenter = Convert.ToInt16(_4.Text);
    int centercenter = Convert.ToInt16(_5.Text);
    int rightcenter = Convert.ToInt16(_6.Text);
    int leftbottom = Convert.ToInt16(_7.Text);
    int centerbottom = Convert.ToInt16(_8.Text);
    int rightbottom = Convert.ToInt16(_9.Text);
    int row1 = lefttop + centertop + righttop;
    int row2 = leftcenter + centercenter + rightcenter;
    int row3 = leftbottom + centerbottom + rightbottom;
    int col1 = lefttop + leftcenter + leftbottom;
    int col2 = centertop + centercenter + centerbottom;
    int col3 = righttop + rightcenter + rightbottom;
    int dia1 = lefttop + centercenter + rightbottom;
    int dia2 = leftbottom + centercenter + righttop;
    if (row1 == row2)
    {
        if (row2 == row3)
        {
            if (row3 == col1)
            {
                if (col1 == col2)
                {
                    if (col2 == col3)
                    {
                        if (col3 == dia1)
                        {
                            if (dia1 == dia2)
                            {
                                MessageBox.Show("Your magic square is correct!");
                            }
                            else
                            {
                                MessageBox.Show("Wrong! Application will restart!");
                                this.Close();
                                Process restart = new Process();
                                restart.StartInfo.FileName = @"path name here";
                                restart.Start();
                            }
                        }
                        else
                        {
                            MessageBox.Show("Wrong! Application will restart!");
                            this.Close();
                            Process restart = new Process();
                            restart.StartInfo.FileName = @"path name here";
                            restart.Start();
                        }
                    }
                    else
                    {
                        MessageBox.Show("Wrong! Application will restart!");
                        this.Close();
                        Process restart = new Process();
                        restart.StartInfo.FileName = @"path name here";
                        restart.Start();
                    }
                }
                else
                {
                    MessageBox.Show("Wrong! Application will restart!");
                    this.Close();
                    Process restart = new Process();
                    restart.StartInfo.FileName = @"path name here";
                    restart.Start();
                }
            }
            else
            {
                MessageBox.Show("Wrong! Application will restart!");
                this.Close();
                Process restart = new Process();
                restart.StartInfo.FileName = @"path name here";
                restart.Start();
            }
        }
        else
        {
            MessageBox.Show("Wrong! Application will restart!");
            this.Close();
            Process restart = new Process();
            restart.StartInfo.FileName = @"path name here";
            restart.Start();
        }
    }
    else
    {
        MessageBox.Show("Wrong! Application will restart!");
        this.Close();
        Process restart = new Process();
        restart.StartInfo.FileName = @"path name here";
        restart.Start();
    }
}

element(n) = address + n * size_of_the_element
//If you consider the first element the first, the computation becomes

element(n) = address + (n-1) * size_of_the_element
//Not a huge difference but it adds an unnecessary subtraction for each access.

  private const string SQL = 
    "SELECT " +
    "  ID, " +
    "  NAME, " +
    "  BIRTHDAY " +
    "FROM " +
    "  TABLE " +
    "WHERE " +
    "  NAME LIKE @PARAM";

CREATE PROCEDURE [dbo].[WorkOrder_Search](@Description varchar(250)) 
AS
Begin
	SELECT Order_id,Dept_Code,Graphic_Number,[Description],Quantity,Date_Received as [Recv. Date],Date_Due as [Due Date],
	Date_Delivered as [Delivered Date],proof_sent_date as [Proof Date],print_date as [To Print],
	dbo.func_grOrder_GetAssigned(Order_id) as [Assign To],Status,Note, Master_Cal_ID 
	From grGraphic_Order  
	where [Description] like '%' + @Description + '%'
end

CREATE PROCEDURE [dbo].[WorkOrder_search](@Description varchar(250))
AS
begin
	SET QUOTED_IDENTIFIER  OFF    
	SET ANSI_NULLS  OFF 
	SET NoCount ON
 
	Declare @sql varchar(8000)
	Declare @Orig_1 varchar(1000)
	Declare @Declare varchar(200),
	@From varchar(100),@Into varchar(50),@Groupby varchar(300),
	@Orderby varchar(400),@Select varchar(400),@Select1 varchar(400),@Select2 varchar(300),
	@cursor1 varchar (500),@cursor2 varchar(4000),@create varchar(4000)
 
	set @Orig_1 = ''
 
	Create table #Assignto_temp(Order_id int, Assignto_names varchar(500))
 
	Insert into #Assignto_temp(Order_id )
 
	Select gro.order_id
	From grassignto gro
	Inner join wfpmauser wf
	On gro.user_id = wf.user_id
	group by gro.order_id
 
	declare @order_number int, @Assignto varchar(255), @List_names varchar(255),@order_number_prev int
	declare assignto Cursor
	Local
	Forward_only
	for
 
	Select gro.order_id,Wf.First_name+' '+Wf.Last_name as Assignto
	From grassignto gro
	Inner join wfpmauser wf
	On gro.user_id = wf.user_id
	order by order_id 
 
	open assignto
	Fetch Next from assignto into @order_number, @Assignto
	While @@Fetch_Status=0
	begin
			select @List_names=Assignto_names from #Assignto_temp where order_id=@order_number
	 	
		if @List_names is null 
		begin
			update #Assignto_temp
			set Assignto_names=@Assignto
			where order_id=@order_number
		end
		else
		begin
			update #Assignto_temp
			set Assignto_names=@list_names + ',' + @Assignto
			where order_id=@order_number
		end
		  Fetch Next from assignto into @order_number, @Assignto
	end
	close assignto
	deallocate assignto
 
	Set @Declare ="Declare @Orig_1 varchar(1000),@Originator varchar(100),@order_id int,@Orig varchar(300) set @Orig_1 = '' " 
	Set @Select =  " SELECT distinct gro.* "
	Set @Into = "Into #tmp1 "
	Set @From = "FROM grGraphic_Order Gro left join grOriginator gr on gro.order_id = gr.order_id "
 
	Set @Orderby = "ORDER BY Gro.Graphic_number,Gro.dept_code Desc  "
	Set @Select2 = " SELECT Order_id,Dept_Code ,Graphic_Number,Description,Quantity,Date_Received as [Recv. Date],
	Date_Due as [Due Date],Date_Delivered as [Delivered Date],proof_sent_date as [Proof Date],print_date as [To Print],
	Status,Note, master_cal_id [Master Calendar ID] From #tmp1  ORDER BY dept_code,Graphic_number  "
 
	Set @Create = "Create table #Assignto_temp(Order_id int, Assignto_names varchar(500))
			Insert into #Assignto_temp(Order_id )
			Select gro.order_id
			From grassignto gro
			Inner join wfpmauser wf
			On gro.user_id = wf.user_id
			group by gro.order_id
 

 			declare @order_number int, @Assignto varchar(255), @List_names varchar(255),@order_number_prev int
			declare assignto Cursor
			Local
			Forward_only
			for
		
			Select gro.order_id,Wf.First_name+' '+Wf.Last_name as Assignto
			From grassignto gro
			Inner join wfpmauser wf
			On gro.user_id = wf.user_id
			order by order_id 
		
			open assignto
			Fetch Next from assignto into @order_number, @Assignto
			While @@Fetch_Status=0
			begin
					select @List_names=Assignto_names from #Assignto_temp where order_id=@order_number
			 	
				if @List_names is null 
				begin
			
					update #Assignto_temp
					set Assignto_names=@Assignto
					where order_id=@order_number
			
				end
				else
				begin
					update #Assignto_temp
					set Assignto_names=@list_names + ',' + @Assignto
					where order_id=@order_number
				end
 
				  Fetch Next from assignto into @order_number, @Assignto
 
			end
			close assignto
			deallocate assignto
 
	SELECT #tmp1.Order_id,Dept_Code ,Graphic_Number,Description,Quantity,Date_Received as [Recv. Date],
	Date_Due as [Due Date],Date_Delivered as [Delivered Date],proof_sent_date as [Proof Date],print_date as [To Print],
	isnull(tmp.assignto_names,'Not Assigned') as [Assign To],Status,Note, #tmp1.Master_Cal_ID 
	From #tmp1 LEFT Join #Assignto_temp tmp ON #tmp1.order_id = tmp.order_id ORDER BY Dept_Code,Date_Received Desc"
 
	Select @sql=@Declare + @Select + @Into + @From + ' where Description like ' 
				+ char(39) + '%' + @Description + '%'  + char(39)+ @Orderby  + @create 
	Exec(@sql)
end

'Finished Never Implemented

    
    BYTE recv[64];

    DWORD   verb;
    ...
    verb = (upper[curr->recv[0]] << 24) + (upper[curr->recv[1]] << 16) + (upper[curr->recv[2]] << 8) + 0x20;
 
    switch (verb)
    {
    case 'CMD ':
       ...
       break;
 
    case 'MON ':
       ...
       break;
 
    case 'END ':
       ...
       break;
 
    case 'EXT ':
       ...
       break;
 
    default:
        ...
        break;
    }

if (result != Common.ErrorMsg.ErrorNone)
{
    this.Dispatcher.BeginInvoke((ThreadStart)delegate()
    {
    });
    return;
}

Primary Data Store (PDS)...
Dump Table Of PDS (DTP)...
Complex View of DTP (CVD)...
Dump Table of CVD (DTC)...
Complex View of DTC

   
DECLARE file_Cursor CURSOR FOR SELECT Length
                                 FROM Files f
                                INNER JOIN User p
                                   ON p.UserId    = f.UserId
                                INNER JOIN Playlist pm
                                   ON pm.ListId = p.DefaultListId
                                WHERE p.UserId  = @userId
                                  AND pm.FileNumber <> -1
 
-- get total length
 OPEN file_Cursor 
FETCH NEXT FROM file_Cursor INTO @length
       
   WHILE @@FETCH_STATUS = 0
   BEGIN                                           
        SET @fileLength = @fileLength + @length   
                            
        FETCH NEXT FROM file_Cursor INTO @length
   END
             
CLOSE file_Cursor 
DEALLOCATE file_Cursor 

@echo off
for /L %%I in (1,1,100) do call :FizzBuzz %%I
goto :EOF
:FizzBuzz
set I=%1
set /a T3=I %% 3
set /a T5=I %% 5
set /a T35=T3 + T5
if not %T35%==0 goto FizzBuzz5
echo FizzBuzz
goto :EOF
:FizzBuzz5
if not %T5%==0 goto FizzBuzz3
echo Buzz
goto :EOF
:FizzBuzz3
if not %T3%==0 goto FizzBuzzEcho
echo Fizz
goto :EOF
:FizzBuzzEcho
echo %I%
goto :EOF

cmd.Parameters.Add("@SomeID", SqlDbType.Int)
cmd.Parameters("@SomeID").Value = Session("SomeID").ToString()

// some code here

if (condition_a)
{
    if (condition_b)
    {
        // do something here
        if (AlertBox("Something wrong here. You wanna continue?"))
        {
            CheckAvailability();
        }
    }
    else if (condition_c)
    {
        // do something else here
        if (AlertBox("Some other thing wrong here. You wanna continue?"))
        {
            CheckAvailability();
        }
    }
    else
    {
        CheckAvailability();
    }
 
    CheckAvailability();
}
else
{
    CheckAvailability();
}
 
// more code here