Andy Blog

Full-stack developer

Chain of state pattern for auto processing

Introduction State pattern State pattern is a behavioral software design pattern. It implements a state machine in object-oriented design. State pattern can be used to maintain various states in ou...

Posted by Andy Feng on February 14, 2018

Entity Framework working with stored procedure

Preparation database create a Blog table CREATE TABLE Blogs( BlogId int IDENTITY(1,1) PRIMARY KEY, Name nvarchar(50), Url nvarchar(50) ) Populate some data INSERT INTO dbo.Blogs ( Na...

Posted by Andy Feng on February 11, 2018

nopCommerce tutorial - (3) develop a plugin

Introduction There are two approaches to customize nopCommerce to fit our needs. Plugin can be used to extend the functionality of nopCommerce. Theme can be used to define the look and feel of page...

Posted by Andy Feng on February 8, 2018

nopCommerce tutorial (2) increase file upload size

Issue nopCommerce throws exception when uploading a large file for downloadable products. Solution Please modify web.config because nopCommerce uses .NET MVC Please note that the default maxim...

Posted by Andy Feng on February 4, 2018

nopCommerce tutorial (1) - installation and debug

Prepare environment operating system windows 7+, sql server 2008+ control panel > program and features > turn windows feature on/off > IIS > Application Development F...

Posted by Andy Feng on February 3, 2018

ASP.NET WCF Service Tutorial

Download source Introduction WCF(Windows Communication Foundation) is a service layer that allows us to build applications that can communicate using a variety of communication approaches. With it...

Posted by Andy Feng on December 28, 2017

ASP.NET SOAP ASMX Web Services Tutorial

Introduction A web service is a web application which is basically a class consisting of methods that could be used by other applications. Active Server Methods (ASMX) is a solution put forwarded ...

Posted by Andy Feng on December 21, 2017

SQL Server Reporting Services Tutorial 5 - Integrate reports in web page

Prepare report(s)/chart(s) Report1: Report2: Integrate reports - way1: use iframe find the report file at http://localhost/reportserver open a report and get the url like http://hostnam...

Posted by Andy Feng on November 29, 2017

SQL Server Reporting Services Tutorial 4 - Create charts

Create a chart Prepare query select i.title as device, sum(t.quantity_purchased * transaction_price_value) as amount, round(sum(t.quantity_purchased * transaction_price_value) / sum(sum(t.q...

Posted by Andy Feng on November 27, 2017

SQL Server Reporting Services Tutorial 3 - Create more reports

Create a dropdown report Let’s create a dropdown report including date, order_no, amount, quantity. We can drill down the date via year/quarter/month/day and view special orders Prepare sql query...

Posted by Andy Feng on November 22, 2017

FEATURED TAGS
ABOUT ME

Happy coding, happy life