Consume Calculator Service

Welcome to the part-2 of WCF…Run your service and copy the address which is available in WCF Test Client which is shown as:

Now create a new console Application as shown:

Right Click References in Solution and select Add Service Reference which populates a new window with entries as Address where you need to paste the address of your Calculator service which was copied in Very first step then click GO button and give a name to it as shown:
Click on OK..Now client console application have a proxy service in it..just create a object of it then access its operation contracts by supplying required parameter values and get the result..sample of such code is shown as: Just press Clrl+F5 then supply the values..

the final output would be as shown:

Thanks…Enjoy…

Now the same Calculator service we now going to consume in windows Application..

1. Create new windows application using C# language and name as Windows_Calculator.

2. Add service reference by right click on  solution and paste the URL of the service in Address bar as we did in console application above in two images and press discover button.

3. create the service_reference object and access their methods and code as shown in below image:

one thing we need to observe here is that we are not at all writing any logic code here in consuming clients because all logic is written in service and we just pass appropriate input and retrieve the results.The output of the above windows application would be as:

Hope would be helpful for anyone atleast…

Microsoft’s Powerful Service: WCF Walk through

Hi Everyone!!!
Today we are going to build a new WCF Service named WCF_Calculator in part 1 and in later sessions we consume this service in console application, Windows Application.

To create a new WCF Service, Start your visual studio 2010, Click on New Project–>Window gets populated..Select C# language and WCF from left most pane–>Select WCF Service Library and give name to your service(here I gave name as WCF_Calculator) as shown below:
Now Click on OK. The solution looks like as:

IService1.cs and Service1.cs are auto-generated files. As we are building Service from scratch hence we delete IService1.cs and Service1.cs files in order to know the behavior of service very well. Select these two files from the solution then right click of mouse and select Delete.
Now add new item by right click solution then add interface named “ICalculator.cs” then code as shown:

We are very to near to pack up..have little patience please….As we have interface ready with us…
Every interface need to be implemented, so now right click your solution and a new item select class name it as “Calculator.cs”. Code the class as shown below:

Now the very last step to fly is open App.Config file and change the interface name which was IService1 to ICalculator in endpoint tag Contract value and also change service tag attribute name=Calculator which is our class name which is implementing our interface. Here our App.Config should look as:

Now Press F5 and your service is in the air…Microsoft Built in WCF Service Host Tool is available which runs our service shown as:

To the left most pane we find our OperationContracts named Add,Sub,Mul and Div…Click on Add then supply values to arguments which is shown in below image as 234 and 432 and click Invoke Button which displays result as:

similarly click each of the OperationContract and supply values and click Invoke button to retrieve result…
We are done in Creation of the Service…In next part WCF 2 we look at how to consume this Calculator service in Console and Windows Service…Thanks…Enjoy…

Razor View Engine

Assalamualikum Wr Br…Today we deal with Razor View engine which is more powerful. Let us Define View Engine..View Engine renders the view into the HTML form on to the web browser. Microsoft ASP.NET MVC supports two types of ViewEngine. They are: 1.Razor View Engine and 2. Aspx View Engine.
Lets Deal with Razor first.
1.Razor View Engine is an advanced view engine and introduced with MVC3.
2. This is not a language but it is a markup syntax.
3. Razor View Engine supports System.Web.Razor.
4. In Razor View Engine we use Layouts.
5. In Razor View Engine we use PartialPage.
6. Razor View Engine has .cshtml(C#) and .vbhtml (VB) extension for views, Layout and Partial views.
7. Razor Engine is a little slow compared to Aspx Engine.
8. ‘@’ symbol uses in Razor Engine to write the code. @Html.ActionLink(“Login”, “LoginView”)
9. Razor Engine prevents Cross-Site Scripting Attacks, in other words it encodes the script or HTML tags like <,> before rendering to view.
ASPX View Engine have the following Features:
1. ASPX View Engine is the default view engine for the ASP.NET MVC that is included with ASP.NET MVC from the beginning.
2. ASPX View Engine supports System.Web.Mvc.WebFormViewEngine.
3. In ASPX View Engine we use masterPages.
4. In ASPX View Engine we use WebUserControls.
5. ASPX View Engine has a similar extension as in a simple web application like .aspx for the views, .acsx for UserControls and .master for Master Pages.
6. Aspx Engine is faster compared to Razor Engine.
7. ‘’ use as ending point. You can write the code between them in ASPX Engine.
8. ASPX Engine does not prevent Cross-Site Scripting Attacks, in other words any script saved in the database will be fired while rendering the page.
Lets Stop our Theory Session and Gearup the practice…
Create a New ASP.NET MVC 4 application from the main menu “NEW”->Give the Name of your application here we give “Razor_MVC2”->Select Language as C#->A Window PopUs with certain options->select “Empty”->Click Ok.The entire scenario is depicted as below:


This creates an empty ASP.NET MVC project, now your solution must be looking like as below:

Now right-Click on “Controller” directory and add new item->select a Controller->give a name to controller here it is given as “AejaazController” and under Scaffolding options->Template select-> Empty MVC Controller then click “ADD” Button->This results a creation of a new class by name “AejaazController” which inherits Controller Class and also a default method is also gets created as shown in below image:

The name “Index” and method is by default created by VS IDE. Now right Click on Index method and select “ADD VIEW” which populates new window as shown:

Let the name be as “Index”->View Engine as “Razor(CSHTML)” and Uncheck the “Use a Layout or Master page” because we are not using now either layout or master page hence uncheck it, later we deal with it. There are some other Check boxes like “Create a Strongly Typed View” means that when you check it then this view gets attach with model which you need to select from the combo box which we also cover here a bit later. Check Box named with “Create as partial View” is similar to UserControls which we deal in up comming blogs. Now click “ADD” button which opens a page with name Index.cshtml in VS with markup code inside it. Here is the place where we actual startup with Razor View Engine. It is engine which allows C# code to be clubbed with markup only with little differences. C# code and markup is differentiated with “@{//stmts..}”, let us start our code as below:

Now Press F5 to check output you find error stating that resource is not found Blah blah… But just type the /Aejaaz after the localhost:portnumber as shown:

Please Check the Url….This is because When a client request a resource by the Url that goes to controller first as the default controller is Home which is not created and implemented rather we created Aejaaz as Controller and Index as Action method. For this reason we need to change the url.. These settings can be found shown below:

When I change the value of Controller from “Home” to “Aejaaz” then it results direct display on hit of F5.
Similarly when we have multiple controllers then choose the one who need to be first then code it in the RouteConfig file as depicted above.

Thanks Alot…

Testing Webservice using Visual studio 2010 SoapUI

Assalamualaykum Wr Br…
SoapUI is a powerful tool to interact with webservices,WCF RESTFul and many other services. In our previous post we have implemented Calculator WCF service which we tested using Visual Studio Integrated Tool named WCF TEST Client. Now the same tool yet with high features is SoapUI. The following screen shows how soapUI looks like:

Now click the file from main menu->New Generic Project, the following screen appears:

Specify the Project Name as “Calci” and Initial WSDL/WADL: here paste the base address from the WCF_Calculator service and append “?wsdl” as shown in above image. Then click OK that results a new appearance as shown. Please Note that the WCF service needs to be running.

Now specify the inputs to ADD method of WCF service to SoapUI for processing the result in ? and ? replace ? with values as shown in above figure and the click the play button which process the inputs and displays the result in response window adjacent to it.
Thaks alot…Will update you with lot of stuff in upcoming posts till the have a Good Day….

All is well

My Simple App MVC1

Assalamualikum Here we gonna explore first simple app of MVC(Model View Controller).
MVC stands for Model-View-Controller, a design pattern that’s very popular in the web development space. As an alternative to Web Forms, ASP.NET MVCtakes a different approach when it comes to structuring web applications. This means you won’t be dealing with ASPX pages and controls, postbacks or view state, or complicated event lifecycles. Instead, you’ll be defining controllers, actions, and views. The underlying ASP.NETplatform is
the same, however, so things like HTTPhandlers and HTTPmodules still apply, and you can mix MVCand Web Forms pages in the same application. Both ASP.NETWeb Forms and ASP.NET MVCsit alongside each other on top of the core ASP.NETplatform.
The model—The domain that your software is built around.
The view—The visual representation of a model, given some context. It’s usually the resulting markup that the framework renders to the browser.
The controller—The coordinator that provides the link between the view and the model. The controller is responsible for processing input, acting upon the model, and deciding on what action should be performed, such as rendering a view or redirecting to another page.
Now lets start our new project named “MY MVC1” and select C# language then select ASP.NET MVC project then a window gets populated select Empty project.
2. Observe that we find additional directories in solution as “Controller,Model,View and Content” which represents our ASP.NET MVC solution. Right Click on Controller then select New Controller and Give name as MYMVC1Cotroller…
3. A New class gets created inside Controller directory with a default method named as “Index” whose return type is ACTIONRESULT which is View.
4. Right click your Action Result method and select to create new view then a new window populates which asks to use razor view engine(CSHTML) or asp c#(ASPX) then select ASPX.So your controller should be like as shown below:

now lets work with view and should be like as below:

Now when you execute error is encountered because the controller is need to be set which is shown as in the url..

Thats all for the day…We shall continue it at some other time till then good Bye..

SQL Joins in a simple way…

Hi All,
Today we explore the simply quite simple and interesting concept of SQL joins.
Join is a clause which is used to combine rows from two or more tables based on a common field between/among them.
The most common join is INNER JOIN, before we start up, lets create two tables as shown below:
To clear the screen in SQL ORACLE type: cl scr(press Enter).

Now lets insert some data in these tables as shown below:

Similarly add some data into orders table as shown:

Now I recapitulate again that we have two tables named “ORDERS” and “CUSTOMERS”. I retrieve the data from two tables but use single from clause thats because of joins. I retrieve OrderId from order table aliases as O, CustomerName from Customers table aliases as C and O.Orderdate as shown:

The output which we got was based on the constraint customerid is equal in both tables(CUSTOMERS,ORDERS). When the constraint is satisfied the CUSTOMERS Table fields are populated.
What else would happen if I dont specify Inner in select query which does produces the same output as above shown. We conclude that both INNER JOIN AND JOIN ARE SAME.
If we replace * instead of o.orderid,c.customer and o.orderdate then we get the result set as:
It returns all combination of orders tables rows and customers tables rows based on constraint match.
INNER JOIN: Returns all rows when there is at least one match in BOTH tables.It means in first we got 3 rows as output now we get these 3 rows two times as we joined the two tables.

SQL LEFT JOIN Keyword

The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.Observe the following screen:

One thing to note is that left join returns all rows from left table and returns only matched rows from right table.In some databases LEFT JOIN is called LEFT OUTER JOIN.

The LEFT JOIN keyword returns all the rows from the left table (Customers), even if there are no matches in the right table (Orders).

SQL RIGHT JOIN Keyword

The RIGHT JOIN keyword returns all rows from the right table (table2), with the matching rows in the left table (table1). The result is NULL in the left side when there is no match.

In some databases RIGHT JOIN is called RIGHT OUTER JOIN.

SQL FULL OUTER JOIN Keyword

The FULL OUTER JOIN keyword returns all rows from the left table (table1) and from the right table (table2).
The FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins.

Sample Crystal Report in VS2010

Hi We explore sample crystal report creation in visual studio 2010 using C# asp.net.We start first from database. I create a sample database by name Department and a table named Clg.In this table i have tuples as ID, Dept_name and HOD with 4 records.We display the entire table data as a report.
1. Now create an empty new web-project with name as Sample_crystal.
2. Add a webform named as webform1.aspx and add crystalreport which populates a wizard select Standard report and blank report then click ok.
3. Drag-drop the dataset1.xsd from toolbox and on which drop clg table from server explorer.
4. Drag-drop the crystalreportviewer on to the webform and in page_load event add the code as::
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(“Data Source=.\\sqlexpress;Initial Catalog=departmetn;Integrated Security=True;Pooling=False”);
SqlDataAdapter da=new SqlDataAdapter(“select * from clg”,con);
DataSet ds=new DataSet();
da.Fill(ds,”clg”);
CrystalReport1 o = new CrystalReport1();
o.Load(Server.MapPath(“CrystalReport1.rpt”));
o.SetDataSource(ds.Tables[“clg”]);
CrystalReportViewer1.ReportSource=o;
CrystalReportViewer1.DataBind();
}
5. click the field explorer (just as toolbox,server explorer) @ crystalreport.rpt screen select Database fields–>database expert then select our dataset.
6. Expand the database Fields and drag-drop the columns of table on the crystal report Section 3(Details).
Run the application which yields the exact report from database.

Authentication and Authorization in ASP.Net

Hi…Here am going to demonstrate a simple asp.net application which focus on authentication and authorization code of C#.Net. Lets begin our journey…
1. Create a new ASP.Net Empty Project using C# language and name it as “User_Roles”.
2. Create a new ASP Folder by right clicking a solution and name it as “MembersArea”.
3. Add a new aspx page named “Login.aspx” and drag drop Login control from toolbox on to the form,double click on it which auto generates eventhandler and code the .cs file as shown below:

Here I hard Coded the username as “aejaaz” and password as”12345″. If the end user enters these credentials then the method AuthenticateUser returns TRUE or else FALSE which is assigned to member variable “ismember” in conditional statement based on which it redirect to respective page.
4. Open the web.config file of the root and code as shown in image as:

Here we are implementing the authentication to our app by opting mode of authentication as “Forms” and providing DefaultUrl and LoginUrl..

5. Add a web.config file and a new webform named as “member.aspx” to the MembersArea Folder.
6. Code the web.config file as shown below:

In the code we are restricting users who are considered as anonymous which is depicted by “?” in Authorization tag. Simple–The resouces/pages in this “MembersArea” directory are being restricted to anonymous users but allow to other register users.
7. Design the Default.aspx as shown in below image as:

Here “Members Page” is a hyperLink to which set a NavigateUrl property as “~/Members_Area/member.aspx”
8. Set Default.aspx page as StartUp Page and Design the Member.aspx page with a simple message as “Welcome!!! From MembersArea Directory..members.aspx page”…Thats all our journey is end…
Observation: At first the Default.aspx page gets loaded and when you click the “Members Page” link it redirects to Login.aspx page and prompts for Credentials to enter, if you enter correct credentials then it redirects to member.aspx page whose screen shots are shown as:
Step A:

Step B: Click the Members Page hyperlink which need to be redirected to login.aspx page as:

Step C: Enter correct Credentials and submit which redirects to member.aspx page which is intentional.

Just one little thing…Drag-drop a label on to the page and add the following code to page_load event of member.aspx page as shown: