How to integrate and customize theme in NopCommerce

Today, I am going to write blog about NopCommerce Theme integration and customization.

This blog is helpful to newbie of NopCommerce and those who have started learning NopCommerce.

First a fall download Solution from NopCommerce website. Once download, open solution on Visual Studio.

Once done, Setup and Installation of NopCommerce on your system. Browse website will be landed on home page of NopCommerce. It looks like nice and pretty layout Theme provided by NopCommerce.

So now time to integrate new Theme and Customize it.
Theme folder path in Solution-->Presentation-->Nop.Web-->Themes. Under themes folder looking "DefaultClean" theme which is provided with solution.

For example I have downloaded "NopShop" theme and copy and paste under the themes folder. Look like image ref.

Once new theme "NopShop" folder populate under Themes folder. Browse website and login to admin section and go to Admin-->Configuration-->Setting-->General and miscellaneous settings-->List theme names.

Here user can select the theme name which theme want to integrate on solution.

Now time to result on front end. Front end design will look change with new selected theme.

Once successfully integrated theme. Now time to customize it 

If you need to change any view html, copy that view file from ~/Views/FOLDER_NAME/VIEW_NAME.cshtml and paste it under ~/Themes/NopShop/FOLDER_NAME/VIEW_NAME.cshtml. For example, if you want to change the html code in ~/Views/Shared/_ProductBox.cshtml, copy that file and paste it under ~/Themes/NopShop/Shared/_ProductBox.cshtml.

If you do not need to change any view html, then modifying ~/Themes/NopShop/Content/styles.css is enough. (Also make sure you update ~/Themes/NopShop/Views/Shared/Head.cshtml to point to your NopShop theme CSS)

NopCommerce always first look for the specif view in your theme (NopShop). if it can't find than it will look into the original view at ~/Views folder file. So it means your theme view override with default views folder view. 

Hope you enjoy it and like it.

Read More

TRY_CONVERT() in Sql Server 2012

Sql Server 2012 many new features to the T-SQL. Some were just added from other languages and platforms to ease the transition to SQL.
Others were added to provide very powerful, new way to solve complex problems

Lets see examples of one of the feature of TRY_CONVERT().

TRY_CONVERT()

Some time CONVERT() and ISNUMERIC() is not always reliable,  So values that return are not convertible to all numeric types.

SELECT CONVERT(INT, column1)  FROM Temp WHERE ISNUMERIC(column1) = 1

 So for above statement sometime that will fail for values like 'abc' which are considered numeric but can not be converted to an integer.

but TRY_CONVERT() will give the result of  value 'abc' return NULL instead of returning an error for the entire query.

Syntax:
TRY_CAST ( expression AS data_type [ ( length ) ] )

expression
    The value to be cast. Any valid expression.

data_type
    The data type into which to cast expression.

length
    Optional integer that specifies the length of the target data type.
    The range of acceptable values is determined by the value of data_type.

Read More

Paging implementing on Store Procedure in Microsoft Sql Server 2012

Microsoft Sql Server 2012 introduces an interesting functionality using OFFSET  and FETCH with existing ORDER By Clause. Using OFFSET and FETCH achieving  paging functionality.

Developer can write SQL query for fetch only a set of rows from the complete result set windows and improving performance when fetching and display number of record from table.

Now time for example how to achieving paging using OFFSET and FETCH feature in Sql Server 2012.

SELECT

    Name,

    City,

    State

FROM    Customer

ORDER BY City

   OFFSET 0 ROWS

        FETCH NEXT 5 ROWS ONLY

Here if you want to write dynamic TSQL query for paging.

Declare @pageNo int =3

Declare @pageSize int =10

--Calculating OFFSET

Declare @offSet int = (@pageNo * @pageSize)  - @pageSize

Now writing above paging query with dynamic parameter.

SELECT

    Name,

    City,

    State

FROM    Customer

ORDER BY City

   OFFSET @offSet ROWS

        FETCH NEXT @pageSize ROWS ONLY

Hope you have enjoy sql server 2012 paging feature!!

Read More

ASP.NET 5 Cool New Feature for Missing NuGet Packages

Sometime we are tedious to fine proper Missing  NuGet Package reference on code level.

After searching NuGet Package from package Manager, require to install manually.

So Asp.Net 5 developer Provide a cool feature to help you add to add the correct NuGet Package to your projects. Which type of referencing are missing.

Whenever you will know that NuGet package are missing for your website or class library. You can just press CTRL + . (Period) to activate a helper in the editor that will offer to add the missing package to your project.

Refer image for more visual help provided editor.

Once press CTRL + . (period) editor will suggest the package which you need to add and show you the changes, that will change on using statements at the top of the code file and your code functionality working proper.

Hope you will enjoy new feature from Microsoft !!

Read More

How to change theme on Visual Studio

Writing this blog for those you have not know about theme selection by our self for Visual Studio IDE.

Recently I have observe that still few people have not much aware of theme options provided by Visual Studio.

Here going to show you. Follow the steps for change the theme.

Go to menu Tools --> Options and select the theme from dropdown.

Hope that help to you!!

Read More

Access Internal class or member on another Assemblies in C#

Sometime we would like to access Internal Class or Member on Unit Test case Assembly.

I just happen same situation in my one of the project. So I have googling and spend some time on it and finding solution.

Writing this blog for them who having facing same situation. so that would be help for them.

C# having call Internal Assembly like in Visual Basic(VB) having call Friend Assembly.

Interal class InternalClass
{
    public void Test()
    {
        Console.WriteLine("Sample Class");
    }
}

If would like to access InternalClass on another assemblies then need to define each assemblies name on AssemblyInfo.cs with following line.

[assembly: InternalsVisibleTo("name of assembly here")]

i.e. If you want access InternalClass on assembly ABC then you will need to mention on AssemblyInfo.cs file for same.

[assembly: InternalsVisibleTo("ABC")]

Hope that is help to you!!

For more detail please click here

Read More

After Updating Windows 10 Sql Server Services Need to Start Manually

Recently I just facing Sql Server issue. Which is Sql Server Management Studio not connect with Sql Server.

So based on issue I had google it and find a solution. Which is about Sql Server Services.

So I need to start Sql Server Services manually after updating Windows 10.

Following are step to start Sql Server Services.

1. Press Window + R key so it will open Run window.
2. Now type "services.msc" and hit enter so it will open Service dialogue.
3. Now find sql server service from the Service list.
4. Once find it, just need to click on left panel of Start link.
5. Wait for few second and it will start it.
6. Now you can try to connect Sql Server Management studio to Sql Server.

Hope you got your solution.

Read More

Covnvert List to String in C#

Sometime developer required convert List to comma separated string.

So here we just quick look of string.Join code magic and get our expected result.

List number = new List();
number.Add(1);
number.Add(4);
number.Add(50);
number.Add(78);

string strNumber = string.Join(",", number.ToArray());

Response.Write(strNumber);

Output: 1,4,50,78

Hope you enjoy it!!

Read More

Microsoft Window 10 Installed

Last night I was getting notification from Microsoft that was Window 10 is ready for upgrade.

So I was excited to upgrade because last 1-2 month we are waiting for Window 10 release and finally that dream come true.

Once I have clicked on OK button so that was started to upgrade and it was just taken few hours to upgraded.

First screen look after the Window 10 installation.

I am looking to more explore of Window 10 features.

Read More

Fluent Validation for .NET

Now a days Validation are require thing for website building and prevent from anonymous attacker.

FuentValidation are recommended by many expert to use on existing and new website development stuff because its easy to used I mean its plug and play feature.

Personally I have experienced FuentValidation with NopCommerce, Web API, MVC and Asp.net applications.

How we get start with FluentValidation? Its very simple like other NuGet packages.

Install FluentValidation using Visual Studio Package Manger.


Install-Package FluentValidation

Please visit following link for more demo and document. so please go through demo and document so you will be get more idea how FluentValidation works.

https://github.com/JeremySkinner/FluentValidation

If you have any question about FluentValidation please write me. I will be very happy to write back to you.

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

JQuery reverse each loop

JQuery Reverse each loop.

$($("ddlid").get().reverse()).each(function() { /* ... */ });

Read More

How to call child page function from parent page using JavaScript.

It's very simple using JavaScript with one line code.

document.getElementById('iFrameId').contentWindow.targetFunction(); 

Hope you enjoy it.

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