All My Work Done.

Create Widget in Orchard Module using VS 2010

2010-11-04T03:41:00.000-07:00

Add/Create Widget in Orchard Module

For example name of module is “TestModule” and widget name is “TestWidget”

1. Add class in Modules>> TestModule>> ViewModels>>TestWidgetViewModel.cs

Add this code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

 

namespace TestModule.ViewModels

{

    public class TestWidgetViewModel

    {

        public string var1 { get; set; }

        public int var2 { get; set; }

    }

}

2. Add class in Modules>> TestModule>> Models>>TestWidgetPart.cs

Add this code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using Orchard.ContentManagement;

 

 

namespace TestModule.Models

{

    public class TestWidgetPart : ContentPart

    {

    }

}

3. Add class in Modules>> TestModule>> Drivers>>TestWidgetPartDriver.cs

Add this code

using Orchard.ContentManagement.Drivers;

using TestModule.ViewModels;

using TestModule.Models;

 

namespace TestModule.Drivers

{

   public class TestWidgetPartDriver : ContentPartDriver<TestWidgetPart>

    {

        protected override DriverResult Display(TestWidgetPart part, string displayType, dynamic shapeHelper)

        {

            var model = new TestWidgetViewModel();

            return ContentShape("Parts_TestWidget",

                                () =>

                                {

                                    var shape = shapeHelper.Parts_TestWidget();

                                    shape.ContentPart = part;

                                    shape.ViewModel = model;

                                    return shape;

                                });

        }

    }

}

4. if Migrations.cs file is not available create in TestModule solution and add code as

using System;

using System.Collections.Generic;

using Orchard.ContentManagement.Drivers;

using Orchard.ContentManagement.MetaData;

using Orchard.ContentManagement.MetaData.Builders;

using Orchard.Core.Contents.Extensions;

using Orchard.Data.Migration;

using System.Data;

 

 

namespace TestModule.DataMigrations

{

    public class Migrations : DataMigrationImpl

    {

        public int Create()

        {

            

            ContentDefinitionManager.AlterTypeDefinition("TestWidget",

               cfg => cfg

                   .WithPart("TestWidgetPart")

                   .WithPart("CommonPart")

                   .WithPart("WidgetPart")

                   .WithSetting("Stereotype", "Widget")

               );

 

            return 1;

        }

 

    }

}

5. If Placement.info file is not available create in TestModule solution and add code as

<Placement>

  <Place Parts_TestWidget="Content:1"/>

Placement>

6. In View folder create new folder Parts add file as TestWidget.cshtml add code as

<h1>Test Widgeth1>

7. Rebuild/compile solution and run

8. logon with admin in site

go to dashboard >>Site Configuration>>Features
Enable/Update your TestModule

9. Go to Widgets>>Manage Widgets

Where you TestWidget in available widget list
From where you can add to particular layer and zone you want.

step 8 and 9 can be done in code and its done when module is enable

create setup folder in TestModule
create file Modules>> TestModule>> Setup>>TestWidgetSetupService.cs

and add code as

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using Orchard.ContentManagement;

using Orchard.Widgets.Models;

namespace TestModule.Setup

{

public class TestModuleSetupService : ITestModuleSetupService

{

private readonly IContentManager _contentManager;

public TestModuleSetupService(IContentManager contentManager)

{

_contentManager = contentManager;

}

public void Setup()

{

var homepageLayer = _contentManager.Query<LayerPart>().Where<LayerPartRecord>(lp => lp.Name == "TheHomepage").List().FirstOrDefault();

var beforeContent = _contentManager.Create("TestWidget");

beforeContent.As<WidgetPart>().LayerPart = homepageLayer.As<LayerPart>();

beforeContent.As<WidgetPart>().Title = "";

beforeContent.As<WidgetPart>().Zone = "BeforeMain";

beforeContent.As<WidgetPart>().Position = "1";

_contentManager.Publish(beforeContent);

}

create one more file file Modules>> TestModule>> Setup>>ITestWidgetSetupService.cs

add code as

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using Orchard;

namespace TestModule.Setup

{

public interface ITestModuleSetupService : IDependency

{

void Setup();

}

update migration.cs file as

public class Migration : DataMigrationImpl

{

private readonly ICorporateSiteSetupService _testModuleSetupService;

public Migration(ICorporateSiteSetupService corporateSiteSetupService)

{

_testModuleSetupService = testModuleSetupService;

}

public int Create()

{

        ContentDefinitionManager.AlterTypeDefinition("TestWidget",
               cfg => cfg
                   .WithPart("TestWidgetPart")
                   .WithPart("CommonPart")
                   .WithPart("WidgetPart")
                   .WithSetting("Stereotype", "Widget")
               );

_testModuleSetupService.Setup();

return 1;

}

Integrating jquery slider with jquery cycle

2010-09-08T00:40:00.000-07:00

Adding a new Module Using VS 2010

2010-08-27T04:32:00.000-07:00

Adding a new Module in Orchard

Follow These Steps:

0.1. To begin, enable the Scaffolding feature in Orchard from the "Features" admin panel area.

1. Right-click the Modules node in VS Solution Explorer, and choose “Add > New Project…”

2. In the project creation screen, choose “ASP.NET MVC 2.0 Empty Web Application”

On the path text box, it is default to \src folder. Change it to \src\Orchard.Web\Modules\ folder (Screenshot below). Else Orchard will not recognize the new module.

Finally Type “Tour” for the area name and click [OK].

3. For Orchard to discover this module, you need to add a module.txt file at the project root folder and insert the following content.

name: Tour

antiforgery: enabled

author: The Orchard Team

website: http://Orchard.net

version: 1.0.0

orchardversion: 1.0.0

description: Add Hotel Details.

features:

Tour:

Description: A simple product part.

Category: Travel

4. Check (Not necessary)

Type Ctrl-F5 to build and run in VS.

Scroll down to look for Site Configuration menu and click on Features

If you had done everything right, you will see Tour as a module under the Commerce Travel.

5. Add Orchard.Framework and Orchard.Themes to the project reference

6. To begin with, we need a class to contain the data for the part. Data classes are conventionally added to the "Models" folder of the project. Right-click the Models folder in Visual Studio and choose "Add > Class" from the context menu. With name TourPart.cs

With code:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.ComponentModel.DataAnnotations;

using Orchard.ContentManagement;

using Orchard.ContentManagement.Records;

namespace Tour.Models

{

public class TourRecord : ContentPartRecord

{

public virtual string TourCode { get; set; }

public virtual string Description { get; set; }

}

public class TourPart : ContentPart<TourRecord>

{

[Required]

public string TourCode

{

get { return Record.TourCode; }

set { Record.TourCode = value; }

}

[Required]

public string Description

{

get { return Record.Description; }

set { Record.Description = value; }

}

Now build the Tour project to ensure your Record class compiles successfully.

7. We are going to create a data migration for our Tour module. Why do we need a migration class? The reason is that defining a Record and Part class to store the data doesn't actually impact the database in any way. A data migration is what tells Orchard how to update the database schema when the Tour feature is enabled (the migration runs when the feature is activated). A migration can also upgrade the database schema from prior versions of a module to the schema required by a newer version of a module - this is an advanced topic that won't be covered in this tutorial.

Add DataMigrations folder in root of Tour.

“DataMigrations>>TourDataMigrations.cs”

Add this Code:

using System.Collections.Generic;

using System.Data;

using Orchard.Data.Migration;

using Orchard.ContentManagement.Drivers;

using Orchard.ContentManagement.MetaData;

using Orchard.ContentManagement.MetaData.Builders;

using Orchard.Core.Contents.Extensions;

using Orchard.Indexing;

using Tour.Models;

namespace Tour.DataMigrations

{

public class TourDataMigration : DataMigrationImpl

{

public int Create()

{

// Creating table TourRecord

SchemaBuilder.CreateTable("TourRecord", table => table

.ContentPartRecord()

.Column("TourCode", DbType.String)

.Column("Description", DbType.String)

);

return 1;

}

8. Now let's add the handler for the Tour part. A handler in Orchard is a class that defines the behavior of the part, handling events or manipulating data model prior to rendering the part. The Tour part is very simple, and in this case, our handler class will only specify that an IRepository of TourRecord should be used as the storage for this part.

Create folder Handlers in roote of Tour

Handlers>> TourHandler.cs

Insert code as :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using Orchard.ContentManagement.Handlers;

using Tour.Models;

using Orchard.Data;

namespace Tour.Handlers

{

public class TourHandler : ContentHandler

{

public TourHandler(IRepository<TourRecord> repository)

{

Filters.Add(StorageFilter.For(repository));

}

9. We will also add a driver for our Tour part. A driver in Orchard is a class that defines associations of templates (or views) to display for each context in which the Tour part can render. For example, when displaying a Tour on the front-end, a "Display" method defines the name of the template to use for different display Types (for example, "details" or summary"). Similarly, an "Editor" method of the driver defines the template to use for displaying the editor of the Tour part (for entering values of the TourCode and Description

Fields). We are going to keep this part simple and just use " Tour " as the name of the template to use for both Display

And Editor Contexts (and all displayTypes). Add the TourDriver class as follows.

Create folder Drivers in roote of Tour

Drivers >> TourDriver.cs

Insert code as :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using Tour.Models;

using Orchard.ContentManagement.Drivers;

using Orchard.ContentManagement;

using Orchard.Core.ContentsLocation.Models;

namespace Tour.Drivers

{

public class TourDriver : ContentItemDriver<TourPart>

{

protected override DriverResult Display(TourPart part, string displayType)

{

return ContentPartTemplate(part, "Tour")

.Location(part.GetLocation(displayType));

}

//GET

protected override DriverResult Editor(TourPart part)

{

return ContentPartTemplate(part, "Tour")

.Location(part.GetLocation("Editor"));

}

//POST

protected override DriverResult Editor(TourPart part, IUpdateModel updater)

{

updater.TryUpdateModel(part, Prefix, null, null);

return Editor(part);

}

10. We can add the display and editor views in Visual Studio, using the "Add > View" context menu. First add a "DisplayTemplates" and "EditorTemplates" folder to the "Views" folder in the Tour project, and then right-click the EditorTemplates folder to add the view as follows.

The Add View dialog prompts with a few questions about the view. Name the view "Tour" and select "partial view" and "strongly typed" options, specifying "Tour.Models.TourPart" as the model type to pass to the view. You can also specify "Create" as the default view content, which will give you some sample HTML to customize for the editor view.

Edit the EditorTemplates\Tour.ascx file content so that it appears as follows:

<legend>Fieldslegend>

div>

div>

div>

div>

<p>

fieldset>

11. Repeat the "Add > View" step to create a Tour.ascx file under the "DisplayTemplates" folder, this time choosing "Empty" for the view content.

Now edit the content of the file as follows (this will be used to display the Tour on the front-end:

<br/>

<p>TourCodep>: <b>$b><br />

<p>Descriptionp>:<br/>

12. To activate the Tour part, go to the "Features" section of the Orchard admin panel and enable it.

13. The Create name for the method is the convention for the initial data migration. It contains a single SchemaBuilder.CreateTable method that creates a "TourRecord" table with the TourCode and Description columns in addition to the ones from the basic ContentPartRecord.

Notice how we return 1, which is the version number for our migration.

Let's add another migration step to this to illustrate how you will later alter the existing schema and type metadata as your module evolves. In our case, we'll take this opportunity to add the feature that will enable the part to be attached to any content type. Add the following method to our data migration class:

public int UpdateFrom1() {

  ContentDefinitionManager.AlterPartDefinition("TourPart",

    builder => builder.Attachable());

  return 2;

This new migration is called "UpdateFrom1", which is the convention for upgrading from version 1. Your next migration should be called "UpdateFrom2" and return 3.

14. The defaults positions can be defined programmatically as well.

This can be done from front end Admin> Manage Content Types > Content Parts > Edit

This can be done in a migration:

public int UpdateFrom2() {

  ContentDefinitionManager.AlterPartDefinition("TourPart", builder => builder

    .WithLocation(new Dictionary {

      {"Default", new ContentLocation { Zone = "primary", Position = "9"}},

      {"Editor", new ContentLocation { Zone = "primary", Position = "9"}},

    }));

  return 3;

15. Update Tour go to the "Features" section of the Orchard admin panel and enable it.

16. you may require to remove Global.ascx and Modify the web.config file from Tour Project accordingly :

xml version="1.0"?>

<system.web>

assemblies>

compilation>

namespaces>

pages>

system.web>

<system.web.extensions/>

configuration>

Special Thanks to Patrick’s Bytes and Writing a content part.

get excel data by passing file stream

2010-07-16T04:41:00.000-07:00

//pass file stream and get excel data

//referance link:-http://exceldatareader.codeplex.com/

static void GetAllExcelValues(Stream sourceFileStream)

{

//FileStream sourceFileStream = File.Open(filePath, FileMode.Open, FileAccess.Read);

//1. Reading from a binary Excel file ('97-2003 format; *.xls)

IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(sourceFileStream);

//...

//2. Reading from a OpenXml Excel file (2007 format; *.xlsx)

//IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(sourceFileStream);

//...

////3. DataSet - The result of each spreadsheet will be created in the result.Tables

DataSet result = excelReader.AsDataSet();

//...

//4. DataSet - Create column names from first row

//excelReader.IsFirstRowAsColumnNames = true;

//DataSet result = excelReader.AsDataSet();

var tableCount = 0;

while (tableCount <>

{

var Sheets = result.Tables[tableCount];

int rowCount = 1;

foreach (DataRow Eachrows in Sheets.Rows)

{

foreach (var CellValue in Eachrows.ItemArray)

{

string CharCount = string.Empty;

var data = CellValue != null ? CellValue : string.Empty;

}

rowCount++;

}

tableCount++;

}

excelReader.Close();

}

generate a list of alphabet using csharp

2010-07-16T04:15:00.000-07:00

//generate a list of alphabet using csharp

//this recurcive function will return you

//a string with position of passed int

//say if pass 0 will return A ,1-B,2-C,.....,26-AA,27-AB,....,701-ZZ,702-AAA,703-AAB,...

static string CharacterIncrement(int colCount)

{

int TempCount = 0;

string returnCharCount = string.Empty;

if (colCount <>

{

TempCount = colCount;

char CharCount = Convert.ToChar((Convert.ToInt32('A') + TempCount));

returnCharCount += CharCount;

return returnCharCount;

}

else

{

var rev = 0;

while (colCount >= 26)

{

colCount = colCount - 26;

rev++;

}

returnCharCount += CharacterIncrement(rev-1);

returnCharCount += CharacterIncrement(colCount);

return returnCharCount;

}

//--------this loop call this function---------//

int i = 0;

while (i <>

{

string CharCount = string.Empty;

CharCount = CharacterIncrement(i);

i++;

}

To get Value By Jquery

2010-02-19T02:38:00.000-08:00

// Take value From checked radio

var Value = $('input[name=MyRadioName]radio:checked').val();

// Take value of multiple checked checkbox

// and arrange in , seperated string

var FileCheckList= "";

$.each($('input[name=MyCheck]:checkbox:checked'), function(i, temp) {

if(FileCheckList!="")

FileCheckList +=",";

FileCheckList += $(temp).val();

});

// Get Value of selected from dropdown

var NewValue = $('select[name=MyDropdown] :selected').val();

Create Blank Image With Text On that

2010-02-18T21:01:00.000-08:00

//*****************************************//

// Create Blank Image With Text On that

//*****************************************//

Image imgThumb = new Bitmap(176, 134, PixelFormat.Format24bppRgb);

MemoryStream memeorystreamObj = new MemoryStream();

System.Drawing.Bitmap bitmapObj = new System.Drawing.Bitmap(imgThumb);

Graphics objGraphics = Graphics.FromImage(bitmapObj);

Font objFont1 = new Font("Arial", 10, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Pixel);

Font objFont = new Font("Arial", 15, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Pixel);

objGraphics = Graphics.FromImage(bitmapObj);

// Set Background color

objGraphics.Clear(Color.White);

objGraphics.SmoothingMode = SmoothingMode.AntiAlias;

objGraphics.TextRenderingHint = TextRenderingHint.AntiAlias;

objGraphics.DrawString("Sample Image for", objFont1, new SolidBrush(Color.FromArgb(000, 122, 102)), 0, 25);

objGraphics.DrawString(ThemeName, objFont, new SolidBrush(Color.FromArgb(102, 102, 000)), 0, 40);

objGraphics.Flush();

bitmapObj.Save(memeorystreamObj, ImageFormat.Jpeg);

byte[] imageByteArray = memeorystreamObj.ToArray();

ImageFormat imageFormat = ImageFormat. Jpeg;

string path = "c:\\Folder12\image123.jpg";

FileInfo f2 = new FileInfo(path);

if (!Directory.Exists(f2.Directory.ToString()))

Directory.CreateDirectory(f2.Directory.ToString());

try

{

ImageConverter converter = new ImageConverter();

Image img = null;

Byte[] imageByteArray = null;

img = (Image)converter.ConvertFrom(Imagestream);

MemoryStream stream = new MemoryStream();

img.Save(stream, imageFormat);

img = Image.FromStream(stream);

imageByteArray = (byte[])converter.ConvertTo(img, typeof(byte[]));

img.Dispose();

using (FileStream fs = new FileStream(path, FileMode.Create, FileAccess.ReadWrite))

{

//saving the file as the image

fs.Write(imageByteArray, 0, imageByteArray.Length);

fs.Close();

fs.Dispose();

}

_sucess = true;

}

catch (Exception ex)

{

_sucess = false;

}

Some jquery work

2010-01-18T04:54:00.000-08:00

Javascript function check data exist in array

2009-11-26T05:36:00.000-08:00

function isexist(id, list) {

$.each(list, function(i, temp) {

if (id == temp) {

return true;

}

});

return false;

}

Javascript to sort any list of object

2009-11-24T03:54:00.001-08:00

function myBubbleSort(arrayName, length) {
for (var i = 0; i < (length - 1); i++)
for (var j = i + 1; j < length; j++)
if (arrayName[j].CommentId < arrayName[i].CommentId) {
var dummy = arrayName[i];
arrayName[i] = arrayName[j];
arrayName[j] = dummy;
}
}

Auto Complete In MVC.

2009-05-06T05:39:00.000-07:00

1.Write Code in Aspx Page As Below:-

2.Add JavaScript As Below

function SearchData() //eVERY TIME IT GO TO DATABASE

{

//where Home IS Controller And Search Is Method,SearchValue IS argument

$.getJSON("/Home/Search",

{ SearchValue:document.getElementById("listSearch").value},

function(result)

{

$("#SearchResult").empty();

$.each(result, function(i,temp) {

$("#SearchResult").append("

");

});

}

var NameList;

$(document).ready(function()

{

//where Home IS Controller And Search Is Method,SearchValue IS argument

$.getJSON("/Home/Search",

{ SearchValue:""},

function(result)

{

NameList=result;

$.each(NameList, function(i,temp) {

$("#SearchResult2").append("

");

});

function Search1() //IT DO AT LOCAL

{

$("#SearchResult2").empty();

var listSearch2=document.getElementById("listSearch2");

var txt=new RegExp(listSearch2.value,"i");

$.each(NameList, function(j,temp) {

if(temp.EmployeeName.search(txt)!=-1)

{

$("#SearchResult2").append("

");

}

});

}

3. Code In Controller Will Be like This:-

public JsonResult Search(string SearchValue)

{

string EmpNameList = "";

List<Employee> li = new List<Employee>();

EmployeeDAL empDal = new EmployeeDAL();

li = empDal.SearchEmployee(SearchValue);

return Json(li);

}

Read Data From Excel Sheet In C#.

2009-05-04T03:55:00.000-07:00

public ActionResult ReadExcelData()

{

var sourceFile="C:\\Documents and

Settings\\Administrator\\Desktop\\Taxonomy_Read.xls";

string srcConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="

+sourceFile + @";Extended Properties=""Excel 8.0;HDR=YES;""";

string srcQuery = "Select * from [" + GetExcelSheetNames(

sourceFile)[0] + "]";

OleDbConnection srcConn = new OleDbConnection( srcConnString);

srcConn.Open();

OleDbCommand objCmdSelect =new OleDbCommand( srcQuery, srcConn);

OleDbDataReader readerExcel = objCmdSelect.ExecuteReader(

CommandBehavior.CloseConnection);

while (readerExcel.Read())

{

var i = 0;

while (i <>

{

var data = readerExcel[i].ToString();

i++;

}

readerExcel.Close();

return View("About");

}

static String[] GetExcelSheetNames(string excelFile)

{

OleDbConnection objConn = null;

System.Data.DataTable dt = null;

try

{

// Connection String. Change the excel file to the file you

// will search.

String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +

"Data Source=" + excelFile + ";

Extended Properties=Excel 8.0;";

// Create connection object by using the preceding connection string.

objConn = new OleDbConnection(connString);

// Open connection with the database.

objConn.Open();

// Get the data table containg the schema guid.

dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

if (dt == null)

{

return null;

}

String[] excelSheets = new String[dt.Rows.Count];

int i = 0;

// Add the sheet name to the string array.

foreach (DataRow row in dt.Rows)

{

excelSheets[i] = row["TABLE_NAME"].ToString();

i++;

}

return excelSheets;

}

catch (Exception ex)

{

return null;

}

finally

{

// Clean up.

if (objConn != null)

{

objConn.Close();

objConn.Dispose();

}

if (dt != null)

{

dt.Dispose();

}

//-----OR Can Use Another Method Below But it requires 2 Dll -----//

>> Microsoft.Office.Interop.Excel.dll

>>Office.dll

public ActionResult ReadExcelData()

{

//Request.Files["EditImgFile"];

Microsoft.Office.Interop.Excel.Application ExcelObj = null;

ExcelObj = new Microsoft.Office.Interop.Excel.Application();

if (ExcelObj == null)

{

//MessageBox.Show("ERROR: EXCEL couldn't be started!");

//System.Windows.Forms.Application.Exit();

}

var sourceFile="C:\\Documents and

Settings\\Administrator\\Desktop\\Taxonomy_Read.xls";

Microsoft.Office.Interop.Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open(sourceFile, Type.Missing, Type.Missing, Type.Missing, Type.Missing,

Type.Missing, Type.Missing, Type.Missing, Type.Missing,

Type.Missing, Type.Missing);

Microsoft.Office.Interop.Excel.Sheets sheets = theWorkbook.Worksheets;

Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);

int Ano = 0;

List<string> ParentList = new List<string>();

for(int x = 1; x <= 29; x++)

{

Microsoft.Office.Interop.Excel.Range range = worksheet.get_Range("A"+x.ToString(), "I" + x.ToString());

System.Array myvalues = (System.Array)range.Cells.get_Value(Microsoft.Office.Interop.Excel.XlRangeValueDataType.xlRangeValueDefault);

string[] strArray = ConvertToStringArray(myvalues);

for(int i=0;i<=strArray.Length;i++)

{

if (!string.IsNullOrEmpty(strArray[i])&&i==0)

{

ParentList.Clear();

Ano = 0;

// //insert Main Menu

//var Id = insertTaxonomy(strArray[i],-1);

// //Add return id to ParentList

//ParentList.Add(Id.Tostring());

break;

}

if (!string.IsNullOrEmpty(strArray[i]))

{

////insert sub menu

//var Id = insertTaxonomy(strArray[i],ParentList.ToArray()[Ano-1]);

// //Add return id to ParentList

//ParentList.Insert(Ano, Id.Tostring());

ParentList.RemoveRange(Ano + 1, ParentList.Count-Ano);

Ano = 0;

break;

}

Ano++;

}

theWorkbook.Close(false, hpf.FileName, false);

return View("About");

}

public static string[] ConvertToStringArray(System.Array values)

{

// create a new string array

string[] theArray = new string[values.Length];

// loop through the 2-D System.Array and populate the 1-D String Array

for (int i = 1; i <= values.Length; i++)

{

if (values.GetValue(1, i) == null)

theArray[i - 1] = "";

else

theArray[i - 1] = (string)values.GetValue(1, i).ToString();

}

return theArray;

}

SQL Data Base Connection in C#

2009-05-04T03:06:00.000-07:00

1. Connection with Your Database in Your Code, Data source is IP of data server:-

SqlConnection conn;

conn = new SqlConnection("Data Source=192.168.100.44;

Initial Catalog=DataBaseName;

Persist Security Info=True;

User ID=scoat;

Password=tiger");

conn.Open();

1.1 Connection Using WebConfig, Add this in webconfig:-

<add name="SampleConnectionString"

connectionString="data source=192.168.100.44;

Initial Catalog=DataBaseName;

Persist Security Info=True;

User ID=scoat;

Password=tiger" providerName="System.Data.SqlClient"/>

1.2 Add This In your code:-

SqlConnection conn = New SqlConnection

(ConfigurationManager

.ConnectionStrings["SampleConnectionString"].ConnectionString);

2.Spiecify store procedure Want To Use:-

SqlCommand cmd = new SqlCommand("ProcedureName", conn);

cmd.CommandType = CommandType.StoredProcedure;

3.Pass Parameter To Store Procedure:-

SqlParameter parameterObj = cmd.Parameters.Add("@ProcedureVariable",SqlDbType.Int);

parameterObj.Value = DataToPass;

4. Execut Procedure And Close Connection:-

SqlDataReader thisReader = cmd.ExecuteReader();

thisReader.Close();

conn.Close();

File And Folder Related Operation In C#.

2009-04-28T00:47:00.000-07:00

public ReplaceFile(string NewValue){

// var path = "C:/Documents and Settings/Administrator/My Documents/Visual Studio 2008/Projects/RajanTest1/RajanTest1/Content/ReplaceTest.css";

// var path = ConfigurationManager.AppSettings["HostName"]+"/Content/ReplaceTest.css";

var path = AppDomain.CurrentDomain.BaseDirectory.ToString() + "Content/ReplaceTest.css";

try{

FileStream fs = new FileStream(path, FileMode.Create);

StreamWriter sw = new StreamWriter(fs);

sw.WriteLine(NewValue);

sw.Write(NewValue);

sw.Close();

fs.Close();

//File.Move(path,"C:\\Documents and Settings\\Administrator\\My Documents\\Visual Studio 2008\\Projects\\RajanTest1\\RajanTest1\\Content\\edit_area\\search_replace.js");

}

catch (Exception ee){

string temp = ee.Message;

}

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

static public string[] GetAllFileNames(string baseDir)

{

// Store results in the file results list.

List<string> fileResults = new List<string>();

// Store a stack of our directories.

Stack<string> directoryStack = new Stack<string>();

directoryStack.Push(baseDir);

// While there are directories to process

while (directoryStack.Count > 0)

{

string currentDir = directoryStack.Pop();

// Add all files at this directory.

foreach (string fileName in Directory.GetFiles(currentDir, "*.*"))

{

fileResults.Add(fileName);

}

// Add all directories at this directory.

foreach (string directoryName in Directory.GetDirectories(currentDir))

{

directoryStack.Push(directoryName);

}

return fileResults.ToArray();

}

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

public string FunctionNAme()

{

//Can Get List Of Directory And Also Files

List<string> fname = new List<string>();

// DirectoryInfo di = new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory.ToString() + "Views");

DirectoryInfo di = new DirectoryInfo("c:\\MyFolder");

DirectoryInfo[] dirInfo = di.GetDirectories();

foreach (DirectoryInfo dir in dirInfo)

{

DirectoryInfo di1 = new DirectoryInfo(dir.FullName);

FileInfo[] rgFiles = di1.GetFiles("*.*");//Get All Files Name In Folder

fname.Add(dir.Name); //Add List Of Folder Name

}

//this will Get path of All Files in specified Path/Folder and also Sub-Folder

string[] ara = GetAllFileNames("c:\\MyFolder");

// this is to get/read Content of File

//var path = AppDomain.CurrentDomain.BaseDirectory.ToString() + "Views/Home/About.aspx";

var path="c:\\Myfolder\\Myfile.cs"

try

{

string fileout = string.Empty;

FileStream fs = new FileStream(path, FileMode.Open);

StreamReader sr = new StreamReader(fs);

fileout = sr.ReadToEnd();

sr.Close();

fs.Close();

return fileout;

}

catch (Exception ee)

{

string temp = ee.Message;

}

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

//copy files and folders Recursively from sorce to destination

private void CopyFilesRecursively(DirectoryInfo source, DirectoryInfo target)

{

foreach (DirectoryInfo dir in source.GetDirectories())

CopyFilesRecursively(dir, target.CreateSubdirectory(dir.Name));

foreach (FileInfo file in source.GetFiles())

file.CopyTo(Path.Combine(target.FullName, file.Name)).IsReadOnly = false;

}

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

//Method to delete all files in the folder and subfolders

private void ClearFolder(DirectoryInfo directoryInfo)

{

foreach (FileInfo file in directoryInfo.GetFiles())

{

file.IsReadOnly = false;

file.Delete();

}

foreach (DirectoryInfo subfolder in directoryInfo.GetDirectories())

ClearFolder(subfolder);

}

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

static public string[] GetAllDirNames(string baseDir)

{ //

// Store results in the directory results list.

List<string> fileResults = new List<string>();

// Store a stack of our directories.

Stack<string> directoryStack = new Stack<string>();

directoryStack.Push(baseDir);

// While there are directories to process

while (directoryStack.Count > 0)

{

string currentDir = directoryStack.Pop();

// Add all directories at this directory.

foreach (string directoryName in Directory.GetDirectories(currentDir))

{

directoryStack.Push(directoryName);

fileResults.Add(directoryName);

}

return fileResults.ToArray();

}

Develop And Embed Widget In Site Using MVC.

2009-04-24T00:24:00.000-07:00

1. Create .aspx for particular module/component without master page and without body tag.

For example:-

2. In Controller-

For example:-

HomeController.cs

public ActionResult EmbedWidget()

{

return View("NewWidget");

}

3. This is example code, can have your own code of component that you want to create in your Widget.

4. JavaScript and CSS for this widget must be embedded in same widget page in this case NewWidget.aspx.

5. Once widget is created by above method in any of your site, can use this widget/component in any other site or in same site.

6. Where you want to add this widget in page, just insert "object" tag or "iframe" tag which is comfortable for your page.

For example:-

7. Height and Width of "object" or "iframe" need to set as per your widget/object size.

8. Site that contain widget, in this case microsite.newton.com need to be in running state.

JQuery Help

2009-04-01T05:06:00.000-07:00

jQuery('div.panel') :- All divs with class=“panel”

jQuery('p#intro'):- The paragraph with id=“intro”

jQuery('div#content a:visible'):- All visible links inside the div with id=“content”

jQuery('input[@name=email]'):- All input fields with name=“email”

jQuery('table.orders tr:odd'):- “odd” numbered rows in a table with class “orders”

jQuery('a[@href^="http://"]'):- All external links (links that start with http://)

jQuery('p[a]'):- All paragraphs that contain one or more links

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

jQuery('div#primary').width(300);

Set the width of div id=“primary” to 300 px.

jQuery('p').css('line-height', '1.8em');

Apply a line-height of 1.8em to all paragraphs.

jQuery('li:odd').css({color: 'white', backgroundColor: 'black'});

Apply two CSS rules to every other list item; note that the css() function can take an object instead of two strings.

jQuery('a[@href^="http://"]').addClass('external').attr('target', '_blank');

Add a class of “external” to all external links (those beginning with http://), then add target=“_blank” for good measure. This makes use of chaining, described below.

jQuery('blockquote').each(function(el) { alert(jQuery(this).text()) });

Iterate over every blockquote on the page, and alert its textual content (excluding HTML tags).

jQuery('a').html('Click here!');

Replace all link text on the page with the insidious “Click here!”.

Here are some examples of methods that read values from the first matched element:

var width = jQuery('div').width();

How wide is the first div on the page?

var src = jQuery('img').attr('src');

What’s the src attribute of the first image on the page?

var color = jQuery('h1').css('color');

What colour is the first h1?

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

jQuery('div').not('[@id]')

Returns divs that do not have an id attribute.

jQuery('h2').parent()

Returns all elements that are direct parents of an h2.

jQuery('blockquote').children()

Returns all elements that are children of a blockquote.

jQuery('p').eq(4).next()

Find the fifth paragraph on the page, then find the next element (its direct sibling to the right).

jQuery('input:text:first').parents('form')

Find the form parent of the first input type=“text” field on the page. The optional argument to parents() is another selector.

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

$('form#login')

// hide all the labels inside the form with the 'optional' class

.find('label.optional').hide().end()

// add a red border to any password fields in the form

.find('input:password').css('border', '1px solid red').end()

// add a submit handler to the form

.submit(function(){

return confirm('Are you sure you want to submit?');

});

var div = jQuery('Some text');

You can use chaining to add attributes to the div once it has been created:

var div = jQuery('Some text').addClass('inserted').attr('id', 'foo');

Now append it to the body tag:

div.appendTo(document.body)

Or prepend it to a known location using a selector:

div.prependTo('div#primary')

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

jQuery('p').click(function() { jQuery(this).css('background-color', 'red'); });

Set up paragraphs so that when you click them they turn red.

jQuery('p:first').click()

Send a fake “click” to the first paragraph on the page.

A couple of event related functions deserve a special mention:

jQuery('a').hover(function() {

jQuery(this).css('background-color', 'orange');

}, function() {

jQuery(this).css('background-color', 'white');

});

hover() is a shortcut for setting up two functions that run onmouseover and onmouseout.

jQuery('p').one('click', function() { alert(jQuery(this).html()); });

jQuery(document).bind('stuffHappened', function(event, msg) {

alert('stuff happened: ' + msg);

});

jQuery(document).trigger('stuffHappened', ['Hello!']);

jQuery(document).ready(function() {

alert('The DOM is ready!');

});

Even better, you can shortcut the above by passing your function directly to jQuery():

jQuery(function() {

alert('The DOM is ready!');

});

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

jQuery('div#intro').load('/some/fragment.html');

This performs a GET request against /some/fragment.html and populates div#intro with the returned HTML fragment.

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

jQuery.get('/some/script.php', {'name': 'Simon'}, function(data) {

alert('The server said: ' + data);

}); // GET against /some/script.php?name=Simon

jQuery.post('/some/script.php', {'name': 'Simon'}, function(data) {

alert('The server said: ' + data);

}); // POST to /some/script.php

jQuery.getJSON('/some.json', function(json) {

alert('JSON rocks: ' + json.foo + ' ' + json.bar);

}); // Retrieves and parses /some.json as JSON

jQuery.getScript('/script.js'); // GET and eval() /script.js

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

jQuery.get( url, [data], [callback], [type] )

url String

The URL of the page to load.

data (Optional) Map

Key/value pairs that will be sent to the server.

callback (Optional) Function

A function to be executed whenever the data is loaded successfully.

function (data, textStatus) { // data could be xmlDoc, jsonObj, html, text, etc... this; // the options for this ajax request }

type (Optional) String

Type of data to be returned to callback function: "xml", "html", "script", "json", "jsonp", or "text".

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

$('#external_links a').click(function() {

return confirm('You are going to visit: ' + this.href);

});

$(window).load(function() {

// run this when the whole page has been downloaded

});

Animate your HTML

$('#grow').animate({ height: 500, width: 500 }, "slow", function(){

alert('The element is done growing!');

});

$('#nav').slideDown('slow');