Thursday, 1 October 2015

How to Use Highcharts Chart Rotation JS with ASP.NET MVC 5


Step 1: First Create An Web Api Application with MVC sing Visual Studion 2013/15.

Step 2: Add the Highcharts  reference to the Project.


Step 3:Create columnpricture.s in Model Folder
Step 4: Create the DbContext In Model Folder.                                                                                 
Step 5: Create a MVC Controller using EF and the select Model and DbContext... if you will not the the Model or Context in the dropdown then first build the solution then do again.

Step 6. Run the application and go to http://localhost:XXXX/Test                                                    
where XXXX is your localhost and Test is the controller name in my case.and Create some details like .

Step 7: Now to to Home Controller and Add this Action                                                                       

 public class HomeController : Controller
    {
        columnprictureEntities db = new columnprictureEntities();

        public ActionResult Index()
        {
            ViewBag.Title = "Home Page";

            return View();
        }
        public ActionResult Getdata()
        {
            var d = db.columnprictures.ToList();
            List<columnpricture> bb = db.columnprictures.ToList();
            return Json(d, JsonRequestBehavior.AllowGet);

            //var d = (from b in db.columnprictures select b).ToList();
            //List<columnpricture> bb = (from dd in db.columnprictures select dd).ToList();
            //return Json(d, JsonRequestBehavior.AllowGet);
        }
    }
Step  8: Last step you have to Go to Index and add the View.                                                             

@{  Layout = null;  }
<!DOCTYPE html>

<html>

<head>

    <meta name="viewport" content="width=device-width" />
  
    <script src="~/Scripts/jquery-1.10.2.min.js"></script>
    <script src="~/Scripts/Highcharts-4.0.1/js/highcharts.js"></script>
    <script src="~/Scripts/Highcharts-4.0.1/js/modules/exporting.js"></script>
    <script src="~/Scripts/Highcharts-4.0.1/js/highcharts-3d.js"></script>

    <script type="text/javascript">
        $(function () {
            var values = "";
            var data1 = [];
            months = [];
            var count = [];

            //var a = [29.9, 71.5, 106.4, 129.2, 144]
            $.ajax({
                url: '../Home/Getdata',
                type: 'post',
                dataType: "json",
                success: function (msg) {
                    var values = JSON.stringify(msg)
                    //alert(msg.length)
                    for (var i = 0; i < msg.length; i++) {
                        //alert("123")
                        values += "11" + msg[i].tem + "11"
                        debugger;
                        //var a = values.push(bb[i].tem);
                        data1.push(msg[i].id)
                        months.push(msg[i].months)
                        count.push(msg[i].count)
                    }
                    var chart = new Highcharts.Chart({
                        chart: {
                            renderTo: 'container', type: 'column', margin: 75,
                            options3d: { enabled: true, alpha: 15, beta: 15, depth: 50, viewDistance: 25 }
                        }, title: { text: 'Chart rotation demo' }, xAxis: { categories: months },
                        yAxis: { min: 0, title: { text: 'count' } },
                        subtitle: { text: 'Test options by dragging the sliders below' }, plotOptions: {
                            column: {
                                depth: 25
                            }
                        }, series: [{ data: count }]
                    });

                    $('#R0').on('change', function () {
                        chart.options.chart.options3d.alpha = this.value;
                        showValues(); chart.redraw(false);
                    }); $('#R1').on('change', function () {
                        chart.options.chart.options3d.beta = this.value; showValues(); chart.redraw(false);
                    }); function showValues() {
                        $('#R0-value').html(chart.options.chart.options3d.alpha);
                        $('#R1-value').html(chart.options.chart.options3d.beta);
                    } showValues();
                }
            })
        });  </script>
    <title>Index</title>
</head>
<body>
    <div id="container" style="min-width: 700px; height: 400px"></div>
    <div id="sliders" style="min-width: 310px; max-width: 800px; margin: 0 auto;">
        <table>
            <tr>
                <td>Alpha Angle</td>
                <td>
                    <input id="R0" type="range" min="0" max="45" value="15" />
                    <span id="R0-value" class="value"></span>
                </td>
            </tr>
            <tr>
                <td>Beta Angle</td>
                <td>
                    <input id="R1" type="range" min="0" max="45" value="15" />
                    <span id="R1-value" class="value"></span>
                </td>
            </tr>
        </table>
    </div>
</body>
</html>

Output:)



Sunday, 27 September 2015

Entity Framework: how to solve “FOREIGN KEY constraint may cause cycles or multiple cascade paths”?

Introducing FOREIGN KEY constraint 'FK_dbo.ChildProfile_dbo.SourceType_SourceTypeId' on table 'ChildProfile' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Could not create constraint. See previous errors.



Answer

Also you can modify your migration class. In my case in the migration class was:


Make  "cascadeDelete: false" Update-Database works perfectly.


OR
Add this code in context



protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();
    }

Update-Database works perfectly.

No connection string named 'MyEntities' could be found in the application config file.

I am using entity framework and ASP.NET MVC 5 and WEB API 2 to build an application


My solution is split into two projects;
  • A class library that includes my data model (.edmx) file and a few custom interfaces
  • The 'container' MVC project that references the class library above
My problem is that when I attempt to use the 'MyEntites' DbContext I get the the following error


No connection string named 'MyEntities' could be found in the application config file.




Answer:


This happens because the class library (where the .edmx file) is not your startup / main project.
You'll need to copy the connection string to the main project config file.
Incase your startup / main project does not have a config file (like it was in my Console Application case) just add one (Startup project - Add New Item -> Application Configuration File).






Saturday, 26 September 2015

Creating a Flot Chart with jQuery Flot and ASP.NET Web API 2

Step 1 : Create ASP.NET Web API 2 project

Step 2: Create Master_Site and SiteAnalyticsData Models in Model Folder

Master_Site


SiteAnalyticsData
Step 3: Add Context Class in Model Folder

Step 4: Open Package Manager Console Enable MIgration and Add Migration then Update database in 
PM> enable-migrations
PM> add-migration "Initial"
PM> update-database

Step 5 : Go to database and add some dummy data like 

Now our data is ready.

Step 6: Create a Web api Controller and paste the below code

using jQueryFlotChart.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;

namespace jQueryFlotChart.Controllers
{
    public class ChartController : ApiController
    {
        public dynamic Get(int year)
        {
            using (SampleDbContext context = new SampleDbContext())
            {

                var alldata = (from item in context.SiteAnalyticsDatas
                               where item.Date.Year == year && item.SiteID == 1
                               group item by item.Date.Month into grp
                               select new
                               {
                                   Month = grp.Key,
                                   Visitors = grp.Sum(x => x.Visitors),
                                   Visits = grp.Sum(x => x.Visits),
                                   PageViews = grp.Sum(x => x.PageViews)
                               }).ToList();

         var ret = new[]
        {  
            new { label="PageViews", data = alldata.Select(x=>new int[]{ x.Month, x.PageViews })},
            new { label="Visits", data = alldata.Select(x=>new int[]{ x.Month, x.Visits })},
            new { label="Visitors", data = alldata.Select(x=>new int[]{ x.Month, x.Visitors })}
            
        };

         return ret;
            }
        }

    }
}
Step 7 : Go to manage package Manager and search for flot and instal it... or you can directly download from Flot website and keep the required js and css file. 
one css file we have to take from flot website... when you will download the file in that example.css will be there so you can use that.


Step 8: Go to View : Home> Index and write /Paste the following code                              

@{Layout = null;}

<!--[if lte IE 8]><script language="javascript" type="text/javascript" src="~/Scripts/flot/excanvas.min.js"></script><![endif]-->
<script src="~/Scripts/jquery-1.10.2.js"></script>
<script src="~/Scripts/flot/jquery.flot.min.js"></script>

<script type="text/javascript">
    $(function () {
        debugger;
        var dataurl = 'api/Chart/';
        $.ajax({
            url: dataurl,
            method: 'GET',
            data: { year: 2012 },
            dataType: 'json',
            success: function (data) {
                debugger;

                $.plot($("#placeholder"), data, options);
            }
        });
        // setup plot
        var options = {
            legend: {
                show: true,
                margin: 10,
                backgroundOpacity: 0.9
            },
            points: {
                show: true,
                radius: 3
            },
            lines: {
                show: true
            },
            grid: { hoverable: true, clickable: true },
            yaxis: { min: 0, tickFormatter: formatter },
            xaxis: { ticks: [[1, "Jan"], [2, "Feb"], [3, "Mar"], [4, "Apr"], [5, "May"], [6, "Jun"], [7, "Jul"], [8, "Aug"], [9, "Sep"], [10, "Oct"], [11, "Nov"], [12, "Dec"]] }

        };
        function formatter(val, axis) {
            return val.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
        }
       
    });



    var previousPoint = null;
    $("#placeholder").bind("plothover", function (event, pos, item) {
        if (item) {
            if (previousPoint != item.dataIndex) {
                previousPoint = item.dataIndex;

                $("#tooltip").remove();
                var x = item.datapoint[0],
                    y = item.datapoint[1].toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
                showTooltip(item.pageX, item.pageY, item.series.label + ": " + y);

            }
        }
        else {
            $("#tooltip").remove();
            previousPoint = null;
        }
    });


    function showTooltip(x, y, contents) {
        $('<div id="tooltip">' + contents + '</div>').css({
            position: 'absolute',
            display: 'none',
            top: y + 5,
            left: x + 5,
            border: '1px solid #fdd',
            padding: '2px',
            'background-color': '#fee',
            opacity: 0.80
        }).appendTo("body").fadeIn(200);
    }

</script>




<section style="width: 500px; margin: 10px; text-align:center;">
    <div id="placeholder" style="width: 500px; height: 300px;">
    </div>
    <h3 style="font-size:1.4em">Traffic Overview - 2015 </h3>
</section>

Done: RUN the application you will get the o/p.




Sunday, 20 September 2015

How to convert .NET object to JSON string in MVC 5 .

Step 1: First create an empty MVC application
Step 2:Create Employee class in Model folder                                                                                         

Step 3: To converts List<Employee> objects to a JSON string we will use Serialize() method of         JavaScriptSerializer class.  
For that First Create a Empty Home Controller and Paste the Below code.

Step 4 : Create the Index view and write the below code                                                                        
@{

    Layout = null;
}

@ViewBag.Data

Step 5 :Run the application
Done :)

Thursday, 17 September 2015

How to Resolve null values in C Sharp

How to Resolve null values in C #

Say you have a method which accepts a string parameter. The method may need to handle null values in some way. One strategy is to validate the parameter and throw an exception


Another strategy is to provide some default value with an if-else statement:










This can be greatly simplified with the ternary operator:




An even simpler solution is by using the null-coalescing operator ?? :







This statement is equal to the first if-else solution but it’s a lot more elegant and concise.
You can use this technique with any nullable type of course, not just strings. The ?? operator can even be chained:


How to hide the text entered in a .NET console application

You’ve probably encountered console applications that ask for a password. It’s very likely that the password will stay hidden otherwise other people viewing your screen can easily read it.
This short post will present a possible solution on how to achieve a hidden string input in a .NET console application.

The key feature to bear in mind is the overloaded Console.ReadKey method where you can pass in a boolean parameter. A ‘true’ means that the given character typed should be intercepted, i.e. not shown in the console window. We continue reading the characters until it is equal to the new line character ‘\r’ which closes the while loop. We store the password characters in a string builder. Unfortunately the ReadLine method has no equivalent overload which would turn the solution into a one-liner.

Here it comes in code:


You can even hide the blinking cursor with the following code:



Just don’t forget to set the visibility back to true later on.

How to add basic sounds to a .NET console application


How to add basic sounds to a .NET console application:

Today we will look how to add basic sounds to our .Net Console application

Create a Console Application:

The Console object has a Beep method which has a parameterless version:

Console.Beep();










It plays a short beep sound. If you’re not satisfied with it you can go for the overloaded Beep method that accepts a frequency in hertz and a duration in milliseconds.

The lower the frequency value the deeper the sound:

Console.Beep(100, 5000);

That sounds like an organ.

Console.Beep(10000, 5000);

That on the other hand just sounds awful.

Saturday, 12 September 2015

How to publish a project to BitBucket from Visual Studio 2013

Visual Studio 2013 and BitBucket

Today i will show how to publish a project to BitBucket from Visual Studio 2013.
Step 1 :Add solution to Source Control


Step 2: Commit to local Git

Step 3: In the "Changes" area, click "Commits". This takes you to the dialog where you can publish to a Remote Repository.

Step 4: Then go to BitBucket and login and create a repository                                               



Part 5: provide basic information.about your repo and click create                                         

Step 6: Enter the URL to your BitBucket repository (must already exist in BitBucket and must be empty) and click "Publish"

   Step 7: Enter your BitBucket credentials when prompted. After the publish finishes you'll get a results message like this.

Step 8: Use the "Sync" button to update BitBucket with your local commits         
                           

Done Hope it Helps you:)

Wednesday, 2 September 2015

Dependency Injection in ASP.NET MVC 5 or MVC 6 with Structure Map

Dependency Injection in ASP.NET MVC 5 or MVC 6 with Structure Map

You people may be wondering why we need dependency injection. So the answer is DI is a design pattern that basically let you to write a loosely coupled testable code or application.
Three types of dependency injection



There are at least three ways an object can receive a reference to an external module



Constructor injection: the dependencies are provided through a class constructor.
Setter injection: the client exposes a setter method that the injector uses to inject the dependency.
Interface injection: the dependency provides an injector method that will inject the dependency into any client passed to it. Clients must implement an interface that exposes a setter method that accepts the dependency.
But Today we will look Constructor injection.



In day to day life of coding or programming our one class generally depend on some other class.
Take a look of my MVC 5 code.







You can see that in index method, it requires to create an instance of "Employee" class to get the full name of a employee. It is very clear that the Index method is tightly coupled with the Employee class.
This is not good when it comes to testing HomeController class. Suppose that you have other methods, with similar types of class dependencies. So, each time when you test the code, you have to pass an actual instance Employee class. This is tedious. You don't have the luxury of passing a fake employee class to easily test your controllers.
So how do we decouple the Employee class from HomeController ? This is our question so



This is where DI comes in handy. You can inject dependencies in several ways. Today i will show you "constructor injection", where you simply inject the dependencies to the constructor of the class. (Ex: in the above example, inject dependencies to the constructor of the HomeController).



So we will look step by step ,How to implement DI using structure map in MVC 5 Application



Step 1 – We have to setup Structure Map



- Lets create a new MVC5 application in Visual Studio 2013/15.
  • Let's use popular "StructreMap" Ioc container to inject dependencies externally. To setup StructreMap, Open a nuget package manager and search for “StructreMap” and install it.
  • You can do the same thing using package manager console powershell.
Step 2 - Create IEmployee interface.



public interface IEmployee
{
string GetFullName();
}



Step 3 - Now Create the actual Employee class/concrete class. This class implements IEmployee interface.



public class Employee: IEmployee
{
public string GetFullName()
{
return "Ravi Kumar Singh";
}
}



Step 4 - Go to the HomeController. Since we use constructor injection, let's create a constructor for the HomeController. It will look similar to this.



public class HomeController : Controller
{
private readonly IEmployee _employee;



// constructor
public HomeController( IEmployee employee)
{
this._employee = employee;
}
//action method
public ActionResult Index()
{
return Content(this.employee.GetFullName());
}
}



Notice that, we are passing the IEmployee interface as the parameter for the constructor. Then we saved the passed parameter into a instant variable of type IEmployee. So what is the benefit of doing this?



Now you can pass any class that implements IEmployee interface to our HomeController. We can create a dummy class which implements IEmployee with dummy data and simply test our HomeController quite easily!



To do this, we need a way to Map our IEmployee interface either with Actual Class or Dummy Class. This is facilitated by our Ioc container "StrutureMap".



Step 5 - Goto ~/DependencyResolution -> IoC.cs file. This file is automatically created once you installed StructureMap. Change it as follows.



public static class IoC {
public static IContainer Initialize() {
ObjectFactory.Initialize(x =>
{
x.For<IEmployee>().Use<Employee>();
});
return ObjectFactory.Container;
}
}



x.For<IEmployee>().Use<FakeEmployee >();
You can easily replace the Actual Employee class with a Dummy Class. That's it.







Done ;)

Tuesday, 2 June 2015

How to use AngularJs in Visual Studio 2013

Step 1 : Our First Step is to install the AngularJS extension for Visual Studio. To do this, I download the angular.intellisense.js file and place it in the 

C:\Program Files (x86)\Microsoft Visual Studio 12.0\JavaScript\References folder on you PC.

Step 2: Next, We have to add AngularJS to our project in Visual Studio using the NuGet package manager (you could also download AngularJS directly from http://www.angularjs.org and place it into your own project alongside your other script files).

First Create Normal empty web application.It will Look Like









Then Right Click on the project and select Package manager












Then search for angular and install in the project , Now you are ready to work with angularjs in visual studio 2013 and it will support intellisense also :)



Friday, 30 January 2015

Shopify API Integration from .NET

To Integrate Shopify first You need Key and Password

So to generate an API key and password, go to http://store.myshopify.com/admin/apps, and click "Create a private API key" at the bottom.It will generate password and key for you.



Then copy and paste this code ....

  public string GetCustomers()
        {
            const string url = "https://store.myshopify.com/admin/customers.json";

            var req = (HttpWebRequest)WebRequest.Create(url);
            req.Method = "GET";
            req.ContentType = "application/json";
            req.Credentials = GetCredential(url);
            req.PreAuthenticate = true;

            using (var resp = (HttpWebResponse)req.GetResponse())
            {
                if (resp.StatusCode != HttpStatusCode.OK)
                {
                    string message = String.Format("Call failed. Received HTTP {0}", resp.StatusCode);
                    throw new ApplicationException(message);
                }

                var sr = new StreamReader(resp.GetResponseStream());
                return sr.ReadToEnd();
            }
        }

        private static CredentialCache GetCredential(string url)
        {
            ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3;
            var credentialCache = new CredentialCache();
            credentialCache.Add(new Uri(url), "Basic", new NetworkCredential("api-key", "password"));
            return credentialCache;
        }




Done;)