New domain for blog www.tech-coder.com

I'm pleased to inform you that I have brought new domain for my blog and that is www.tech-coder.com 

www.tech-coder meant technical coder which you serve technical related information now onword.

Till date technical related information served by my blog (www.satasiyakalpesh.blogspot.com) and now it's redirect to www.tech-coder.com.

Read More

How to add new table in NopCommerce

Hey guys I am back after a long time near about 2 year. And hope my previous blogs help's to anyway to my friends.

So I am going to starting with NopCommerce for how to add new table. This is the common question for newbie of NopCommerce.

Basically here sharing my experience with you guys that will help to other.

Step by step explanation for how to add new table on NopCommerce.

Going to explain based on the NopCommerce source code.  So first open source code on visual studio then follow the below steps (Also refer any existing classes/table).

1. Create the Entity class related to table name (e.g. Enity.cs)
      Path : Solution\Libraries\Nop.Core\Domain\Entity.cs

2. Create a Mapping class which bind class to Database table (e.g. EntityMap.cs)
      Path : Solution\Libraries\Nop.Data\Mapping\EntityMap.cs

3. Create a Model class for MVC (i.e. for Admin or Web) (e.g EntityModel.cs)
      Path : Solution\Presentation\Nop.Web\Models\EntityModel.cs (for Web)
      Path : Solution\Presentation\Nop.Admin\Models\EntityModel.cs (for Admin)

4. Create a validator for model (e.g. EntityValidator.cs)
      Path : Solution\Presentation\Nop.Web\Validators\EntityValidator.cs (for Web)
      Path : Solution\Presentation\Nop.Admin\Validators\EntityValidator.cs (for Admin)

5. Create A Mapping Configuration On AutoMapperStartupTask.cs for Entity and Model
      Path : Solution\Presentation\Nop.Admin\Infrastructure

       Mapping Model to Entity and Entity to Model

        Mapper.CreateMap<MyTest, MyTestModel>()
        .ForMember(dest => dest.Name, mo => mo.Ignore())
        .ForMember(dest => dest.MyTestId, mo => mo.Ignore());
 
        Mapper.CreateMap<MyTestModel, MyTest>()
        .ForMember(dest => dest.Name, mo => mo.Ignore())
        .ForMember(dest => dest.MyTestId, mo => mo.Ignore());

6. Apply Mapping between Model and Entity on MappingExtensions.cs
      Path : Solution\Presentation\Nop.Web\Extensions\(for Web)
      Path : Solution\Presentation\Nop.Admin\Extensions\(for Admin)

7. Create a service class and service interface (e.g EntityService.cs , IEntityService.cs)
     Path : Solution\Libraries\Nop.Services\IEntityService.cs
     Path : Solution\Libraries\Nop.Services\EntityService.cs

8. Final step to create Controller and View for given Model.

Hope you get basic idea how to create/add new table on NopCommerce system.

Read More

Currency format with decimal point in asp.net

 protected void Page_Load(object sender, EventArgs e)
    {
        string CurrencySymbols = "xof";
        Response.Write(string.Format("{0:F" + getCurrencyDecimalPlaces(CurrencySymbols.ToUpper()) + "}", 12456.017312) + "
");

       

    }
    public static int getCurrencyDecimalPlaces(string CurrencySymbols)
    {
        Dictionary oCurrencyDictionary = new Dictionary();

        #region Add Decimal
        oCurrencyDictionary.Add("RUB", 2); //Russian Ruble
        oCurrencyDictionary.Add("CHF", 2); //Swiss Franc
        oCurrencyDictionary.Add("GBP", 2); //British Pound
        oCurrencyDictionary.Add("EUR", 2); //Euro
        oCurrencyDictionary.Add("USD", 2); //American Dollar
        oCurrencyDictionary.Add("CAD", 2); //Canadian Dollar
        oCurrencyDictionary.Add("INR", 2); //Indian Rupee
        oCurrencyDictionary.Add("GHS", 2); //Ghana Cedi
        oCurrencyDictionary.Add("NGN", 2); //Nigerian Naira
        oCurrencyDictionary.Add("CNY", 2); //Chinese Yuan
        oCurrencyDictionary.Add("BRL", 2); //Brazilian Real
        oCurrencyDictionary.Add("HKD", 2); //Hong Kong Dollar
        oCurrencyDictionary.Add("AED", 2); //UAE Dirham
        oCurrencyDictionary.Add("JPY", 0); //Japanese Yen
        oCurrencyDictionary.Add("XOF", 0); //CFA Franc (BCEAO)
        oCurrencyDictionary.Add("XAF", 0); //CFA Franc (BEAC)
        oCurrencyDictionary.Add("ARS", 2); //Argentine Peso
        oCurrencyDictionary.Add("MXN", 2); //Mexican Peso
        oCurrencyDictionary.Add("NPR", 2); //Nepalese Rupee
        oCurrencyDictionary.Add("THB", 2); //Thai Baht
        oCurrencyDictionary.Add("TRY", 2); //Turkish Lira
        oCurrencyDictionary.Add("VEB", 2); //bolivar fuerte
        oCurrencyDictionary.Add("VND", 2); //Vietnam Dong
        oCurrencyDictionary.Add("UAH", 2); //Ukraine Hryvnia
        oCurrencyDictionary.Add("SEK", 2); //Swedish Kronor
        oCurrencyDictionary.Add("ZAR", 2); //South African Rand
        oCurrencyDictionary.Add("PKR", 2); //Pakistani Rupee
        oCurrencyDictionary.Add("PAB", 2); //Panama Balboa
        oCurrencyDictionary.Add("NZD", 2); //New Zealand Dollar
        oCurrencyDictionary.Add("MYR", 2); //Malaysian Ringgit
        oCurrencyDictionary.Add("SGD", 2); //Singapore Dollar
        oCurrencyDictionary.Add("BDT", 2); //Bangladeshi Taka
        #endregion

        if (oCurrencyDictionary.ContainsKey(CurrencySymbols))
        {
            return oCurrencyDictionary[CurrencySymbols];
        }
        else
        {
            return 2;
        }
    }

Read More

Convert enum to hashtable for dropdown list binding

We have one enum

enum ContractType

{

    Permanent = 1,

    Contract = 2,

    Internship = 99

}

Below function for convert enum to hashtable

public static Hashtable BindToEnum(Type enumType)

{

    // get the names from the enumeration

    string[] names = Enum.GetNames(enumType);

    // get the values from the enumeration

    Array values = Enum.GetValues(enumType);

    // turn it into a hash table

    Hashtable ht = new Hashtable();

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

        // note the cast to integer here is important

        // otherwise we'll just get the enum string back again

        ht.Add(names[i], (int)values.GetValue(i));

    // return the dictionary to be bound to

    return ht;

}

Now we can direct call above function for convert enum to hashtable and use for dropdown bind.

MyDropDownList.DataSource = BindToEnum(typeof(ContractType));

Hope you will help above code !!

Read More

Search text in stored procedure

Search text in store procedure...

SELECT NameFROM sys.proceduresWHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Employee%'


Happy Coding... !! :)

Read More

In Asp.net, how do I embed images in an email?

static void EmbedImages()
{
//create the mail message
MailMessage mail = new MailMessage();

//set the addresses
mail.From = new MailAddress("me@mycompany.com");
mail.To.Add("you@yourcompany.com");

//set the content
mail.Subject = "This is an email";

//first we create the Plain Text part
AlternateView plainView = AlternateView.CreateAlternateViewFromString("This is my plain text content, viewable by those clients that don't support html", null, "text/plain");

//then we create the Html part
//to embed images, we need to use the prefix 'cid' in the img src value
//the cid value will map to the Content-Id of a Linked resource.
//thus <img src='cid:companylogo'> will map to a LinkedResource with a ContentId of 'companylogo'
AlternateView htmlView = AlternateView.CreateAlternateViewFromString("Here is an embedded image.<img src=cid:companylogo >", null, "text/html");

//create the LinkedResource (embedded image)
LinkedResource logo = new LinkedResource( "c:\\temp\\logo.gif" );
logo.ContentId = "companylogo";

//add the LinkedResource to the appropriate view
htmlView.LinkedResources.Add(logo);

//add the views
mail.AlternateViews.Add(plainView);
mail.AlternateViews.Add(htmlView);


//send the message
SmtpClient smtp = new SmtpClient("127.0.0.1"); //specify the mail server address
smtp.Send(mail);
}

Read More

How Parse XML Using Regular Expressions in Asp.net with C#

Hello Friends,

I got good solution for XML element value find from XML string.
Need to just call this function with parameters XML string, XML element name and default value if value not find into XML string.

 private String ExtractContentFromXml(String xml, String element, String defaultValue)
{
         String RegExpression = String.Format(@"(?<={0}>)[\S\s]*?(?=\<\/{0})", element);
         Match ThisMatch = Regex.Match(xml, RegExpression);
        if (ThisMatch.Success)
                  return ThisMatch.Value;
        else
                 return defaultValue;
}

I hope you will enjoy this solution...

Read More

Insert into statement in sql server

http://www.codeproject.com/KB/database/InsertGeneratorPack.aspx

Read More

How to restore database when database was suspect

EXEC sp_resetstatus DataBaseName;
ALTER DATABASE DataBaseName SET EMERGENCY
DBCC checkdb(DataBaseName)
ALTER DATABASE DataBaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (DataBaseName, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DataBaseName SET MULTI_USER

Read More

Parent Child Relationship on self table in sqlserver

CREATE TABLE dbo.Emp
(
EmpID int PRIMARY KEY,
EmpName varchar(30),
MgrID int FOREIGN KEY REFERENCES Emp(EmpID)
)
GO

Insert few record into table

INSERT dbo.Emp SELECT 1, 'President', NULL
INSERT dbo.Emp SELECT 2, 'Vice President', 1
INSERT dbo.Emp SELECT 3, 'CEO', 2
INSERT dbo.Emp SELECT 4, 'CTO', 2
INSERT dbo.Emp SELECT 5, 'Group Project Manager', 4
INSERT dbo.Emp SELECT 6, 'Project Manager 1', 5
INSERT dbo.Emp SELECT 7, 'Project Manager 2', 5
INSERT dbo.Emp SELECT 8, 'Team Leader 1', 6
INSERT dbo.Emp SELECT 9, 'Software Engineer 1', 8
INSERT dbo.Emp SELECT 10, 'Software Engineer 2', 8
INSERT dbo.Emp SELECT 11, 'Test Lead 1', 6
INSERT dbo.Emp SELECT 12, 'Tester 1', 11
INSERT dbo.Emp SELECT 13, 'Tester 2', 11
INSERT dbo.Emp SELECT 14, 'Team Leader 2', 7
INSERT dbo.Emp SELECT 15, 'Software Engineer 3', 14
INSERT dbo.Emp SELECT 16, 'Software Engineer 4', 14
INSERT dbo.Emp SELECT 17, 'Test Lead 2', 7
INSERT dbo.Emp SELECT 18, 'Tester 3', 17
INSERT dbo.Emp SELECT 19, 'Tester 4', 17
INSERT dbo.Emp SELECT 20, 'Tester 5', 17
GO


Create sql function


create FUNCTION [dbo].[ShowHierarchy]
(
@Root bigint
)
RETURNS
@menutable TABLE(EmpName varchar(max),MgrID int,EmpID int)
AS
BEGIN


DECLARE @EmpID int, @EmpName varchar(30),@MgrID int, @rootid bigint


set @rootid =@Root
SELECT @EmpID=EmpID,@EmpName=EmpName,@MgrID=MgrID FROM dbo.Emp WHERE EmpID = @Root

-- SET @EmpName = (SELECT EmpName FROM dbo.Emp WHERE EmpID = @Root)
if(@EmpName is not null)
begin
insert into @menutable select REPLICATE(' ', @@NESTLEVEL * 4) + @EmpName,@MgrID,@EmpID
end

SET @EmpID = (SELECT MIN(EmpID) FROM dbo.Emp WHERE MgrID = @Root)

WHILE @EmpID IS NOT NULL
BEGIN
insert into @menutable select * from dbo.ShowHierarchy(@EmpID)
SET @EmpID = (SELECT MIN(EmpID) FROM dbo.Emp WHERE MgrID = @rootid AND EmpID > @EmpID)
END
return
END


//call this function from where you want
Select * from dbo.ShowHierarchy(0)

Read More

Price Regular expression

^([0-9]*|\d*\.\d{1}?\d*)$

Read More

How to call server side function using JQuery in Asp.net

Click Here for Download Source Code

Below is Default.aspx page code
-------------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Call server side method using Jquery</title>

<!-- Add the jQuery Reference Library-->
<script src="Script/jquery-1.4.min.js" type="text/javascript"></script>
<script type="text/javascript">
$('#btnok').click(function() {

$.ajax({

type: "POST",

url: "Default.aspx/Test1",

data: "{'args1':'Kalpesh','args2':'Patel'}",

contentType: "application/json",

dataType: "json",

success: function(msg) {

// Replace the div's content with the page method's return.

$("#newresult").text(msg.d);

}

});

});

</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<input id="Button1" type="button" value="button" />
<span id="status"></span>
</div>
</form>
</body>
</html>


Code Behide file code (Default.aspx.cs)
-----------------------------------------

using System;

using System.Web.Services;

using System.Web;

public partial class _Default : System.Web.UI.Page

{

public void test()

{

}

[WebMethod(EnableSession = false)]

public static string Test1(string args1, string args2)

{

return "Hello: " + args1 + " " + args2;

}

[WebMethod]

public static string Test2()

{

return "Hello: " + DateTime.Now.Millisecond + " -- Kalpesh Patel";

}

}

Read More

Sometimes Page load event not firing in asp.net

The reason for the page executing doesn't affect the page cycle, the Load event always fires when the page is executed.

So, if the Page_Load doesn't run sometimes, it's because the page is cached and doesn't execute on the server. The page can be cached in the browser, in a router somewhere along the way, or on the server using server side page caching.

If you haven't enabled server side page caching for the page, it's cached in the browser or in the network. You can use cache settings to try to elliminate this:

Response.Cache.SetCacheability(HttpCacheability.NoCache);

This will keep the page from being cached in normal circumstances. (Check also that your browser isn't in offline mode, then it will use anything in the cache regardless of it's cacheability settings.)

Read More

Excel Data Reader - Read Excel files in .NET (Convert Excel data to DataTable using Asp.Net)

Click here to download Excel.dll File FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read);
//1. Reading from a binary Excel file ('97-2003 format; *.xls)
IExcelDataReader excelReader =ExcelReaderFactory.CreateBinaryReader(stream);

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

IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

//... //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();
//5. Data Reader methods
while (excelReader.Read()) { //excelReader.GetInt32(0); }
//6. Free resources (IExcelDataReader is IDisposable) excelReader.Close();
I hope help to you.

Read More

Get Physical Path using Asp.Net

Hello Friend,

I have found to get physical path from different way.

1) On .aspx.cs Page

string path = Server.MapPath("/");

2) On Class File (.CS) Page

String Path = HttpContext.Current.Server.MapPath("/");

3) If you are using Thread and want to get physical path in .CS or .asax file

String Path = HttpContext.AppDomainAppPath.Replace("//","\\");

Read More

India Currency Format in .Rdcl report and Write custom function in .Rdcl Report.

Step 1: First choose Document outline from left panel

Step 2: Right click on Report and select Property

Step 3: Write function in code tab

Step 4: Then select field from report which you want to set currency format.

Step 5: Call custom function from code tab. using =code.FunctionName(parameter)

Step 6: You will get result.

I hope help to you.

Read More

Declare Nested Cursor in Sql Server

declare @id bigint
--Declare outer cursor

declare outer_cursor cursor for

select id from table

--Declare inner cursor as a variable

declare @inner_cursor cursor

open outer_cursor

fetch next from outer_cursor into @id

while(@@FETCH_STATUS=0)

begin

-- Few statements

declare @cartid bigint

declare @qty bigint

set @inner_cursor = cursor for select id,qty from cart where productid=@id

open @new_count
fetch next from @inner_cursor into @cartid, @qty while(@@FETCH_STATUS=0)

begin

--Few Statements

end

end

Read More

India Currency format using Asp.Net

Hello Friends,

I got nice solution.

using System.Globalization;

CultureInfo info = new CultureInfo("hi-IN");
Response.Write(double.Parse("1389000.00").ToString("N2", info));

I hope help to you.

Read More

Use .VB and .CS class file in one website using asp.net

When I was creating my one of the site, I chose to write it in C#. I had a problem with the App_Code folder because I had some code in VB.NET code and some C# code I needed to put in there. I didn't want to rewrite my VB.NET code in the App_Code folder just so I could write the rest of the code for the site in C#.

Luckily, the ASP.NET Team had already thought about just this kind of circumstance. They implemented a way to partition the App_Code folder into sub-folders, one for each set of code files written in the same programming language. Awesome, I didn't have to spend a couple hours converting code from VB.NET to C#!

The below works with ASP.NET 2.0 and later.

Even if you don't use multiple different programming languages for your code files in the App_Code folder, you could use this feature to organize your sets of related code files into sub-folders.

Step 1: Add the following lines to the web.config

<configuration>
<system.web>
<compilation>
<codeSubDirectories>
<add directoryName="VB_Code"/>
<add directoryName="CS_Code"/>
codeSubDirectories>
compilation>
system.web>
configuration>

Step 2: Create a sub-folder in the App_Code folder for each language you want to support.
For Example:
/App_Code/VB_Code
/App_Code/CS_Code

Step 3: Place your VB.NET code in the VB_Code folder and place C# code in the CS_Code folder.

Read More

Display India Currency format using JavaScript

function intToFormat(nStr)
{
nStr += '';
x = nStr.split('.');
x1 = x[0];
x2 = x.length > 1 ? '.' + x[1] : '';
var rgx = /(\d+)(\d{3})/;
var z = 0;
var len = String(x1).length;
var num = parseInt((len/2)-1);

while (rgx.test(x1))
{
if(z > 0)
{
x1 = x1.replace(rgx, '$1' + ',' + '$2');
}
else
{
x1 = x1.replace(rgx, '$1' + ',' + '$2');
rgx = /(\d+)(\d{2})/;
}
z++;
num--;
if(num == 0)
{
break;
}
}
return x1 + x2;
}

Read More