Kamalpreet Singh Chauhan kmlprtsng

## json_guide.js
//JSON is supported in IE8+. Otherwise use Json2 or something library

//to convert from json string
JSON.parse(jsonString); //or
jQuery.parseJSON( jsonString );

//JSON to string
JSON.stringify({ attestationId: attestationId, haveReadDoc: haveReadDoc, willComply: willComply }),

## cs_delete_files_in_dir.cs
//Would delete all the files in a directory.
protected void DeleteFiles()
{
      FileInfo[] files = new DirectoryInfo(Server.MapPath(WebConfig.ProfilePhotoPath)).GetFiles(WebConfig.ProfilePhotoPrefix + "*" + User.ID + ".*");
      foreach (FileInfo file in files)
      {
          try
          {
              file.Delete();
          }

## asp_ctrl_ddl.html
<asp:DropDownList runat="server" ID="SomeDropDown" AutoPostBack="true"
				DataTextField="FirstName" DataValueField="Id" AppendDataBoundItems="true">
				<asp:ListItem Text="All" Value="-1" />
</asp:DropDownList>

## js_cancelClick.js
//<a href="#" onClick="return false;">  //Most accepted Solution
//<a href="javascript:void(0)"> ... </a> //Problem: breaks when linking images in IE

//return this from the method.
return false;

//or using jquery
e.stopPropagation(); //stop the event from bubbling
e.preventDefault(); // stop the default functionality

## sql_reset_seed_value.sql
--http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server

SET IDENTITY_INSERT IdentityTable ON

INSERT IdentityTable(TheIdentity, TheValue) VALUES (3, 'First Row')

SET IDENTITY_INSERT IdentityTable OFF

--Note that the next value will be whatever you reseed with + 1, so in this case I set it to 10 so that the next value will be 11.
--This SEED should get updated itself if any Id higher than the seed is used

## scorm_api_map.txt
Changes to API Methods
SCORM1.2                              SCORM2004
LMSInitialize(“”) 	                  Initialize(“”)
LMSFinish(“”) 	                      Terminate(“”)
LMSGetValue(parameter) 	              GetValue(parameter)
LMSSetValue(parameter_1,parameter_2)	SetValue(parameter_1,parameter_2)
LMSCommit(“”) 	                      Commit(“”)
LMSGetLastError() 	                  GetLastError()
LMSGetErrorString(parameter) 	        GetErrorString(parameter)
LMSGetDiagnostic(parameter) 	        GetDiagnostic(parameter)

## sql_column_case_sensitive.sql
-- For SQL Server 2005 and above
ALTER TABLE Foo ALTER COLUMN Bar ntext COLLATE Latin1_General_CS_AS

## linq_keyword_search.cs
if (Keywords.Trim().Length > 0)
  	{
			string[] keywordFilterArr = Keywords.Split(' ');

			query = keywordFilterArr.Where(str => str.Trim().Length > 0)
				.Aggregate(query, (current, str) => current.Where(u => u.FirstName.Contains(str) || u.LastName.Contains(str)));
		}

## asp_checkboxlist_all_selected_items.cs
chkBoxList.Items.Cast<ListItem>()
                              .Where(i => i.Selected)
                              .Select(i => int.Parse(i.Value));

## asp_register_control_page.html
<%@ Register TagPrefix="scott" TagName="footer" Src="Controls/Footer.ascx" %>
	//JSON is supported in IE8+. Otherwise use Json2 or something library

	//to convert from json string
	JSON.parse(jsonString); //or
	jQuery.parseJSON( jsonString );

	//JSON to string
	JSON.stringify({ attestationId: attestationId, haveReadDoc: haveReadDoc, willComply: willComply }),
	//Would delete all the files in a directory.
	protected void DeleteFiles()
	{
	FileInfo[] files = new DirectoryInfo(Server.MapPath(WebConfig.ProfilePhotoPath)).GetFiles(WebConfig.ProfilePhotoPrefix + "" + User.ID + ".");
	foreach (FileInfo file in files)
	{
	try
	{
	file.Delete();
	}
	<asp:DropDownList runat="server" ID="SomeDropDown" AutoPostBack="true"
	DataTextField="FirstName" DataValueField="Id" AppendDataBoundItems="true">
	<asp:ListItem Text="All" Value="-1" />
	</asp:DropDownList>
	//<a href="#" onClick="return false;"> //Most accepted Solution
	//<a href="javascript:void(0)"> ... </a> //Problem: breaks when linking images in IE

	//return this from the method.
	return false;

	//or using jquery
	e.stopPropagation(); //stop the event from bubbling
	e.preventDefault(); // stop the default functionality
	--http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server

	SET IDENTITY_INSERT IdentityTable ON

	INSERT IdentityTable(TheIdentity, TheValue) VALUES (3, 'First Row')

	SET IDENTITY_INSERT IdentityTable OFF

	--Note that the next value will be whatever you reseed with + 1, so in this case I set it to 10 so that the next value will be 11.
	--This SEED should get updated itself if any Id higher than the seed is used
	Changes to API Methods
	SCORM1.2 SCORM2004
	LMSInitialize(“”) Initialize(“”)
	LMSFinish(“”) Terminate(“”)
	LMSGetValue(parameter) GetValue(parameter)
	LMSSetValue(parameter_1,parameter_2) SetValue(parameter_1,parameter_2)
	LMSCommit(“”) Commit(“”)
	LMSGetLastError() GetLastError()
	LMSGetErrorString(parameter) GetErrorString(parameter)
	LMSGetDiagnostic(parameter) GetDiagnostic(parameter)
	-- For SQL Server 2005 and above
	ALTER TABLE Foo ALTER COLUMN Bar ntext COLLATE Latin1_General_CS_AS
	if (Keywords.Trim().Length > 0)
	{
	string[] keywordFilterArr = Keywords.Split(' ');

	query = keywordFilterArr.Where(str => str.Trim().Length > 0)
	.Aggregate(query, (current, str) => current.Where(u => u.FirstName.Contains(str) \|\| u.LastName.Contains(str)));
	}
	chkBoxList.Items.Cast<ListItem>()
	.Where(i => i.Selected)
	.Select(i => int.Parse(i.Value));