My I.T. Side

Azure SQL Manager

comfreakph@gmail.com — Mon, 01 Jun 2015 10:10:00 +0000

Azure SQL Manager is a simple management portal for the remote developers to add their own IP address to Azure SQL Server. No need to ask them what is their IP address let them assign it!

How Do You Use It?
1. First create an account for your users or developers using ASP.NET MVC Identity.

2. Create a certificate and upload the certificate in azure subscriptions and also put it to your App_Data folder. There are two files if you create the certificate, .cer and .pfx

Code Please!

in /Infrastructure/AzureSqlManagerRepository.cs

private SubscriptionCloudCredentials getCredentials(string subscriptionId, string path){
     var cert = new X509Certificate2(path, "CERTIFICATE_PASSWORD_HERE", X509KeyStorageFlags.MachineKeySet);
     return new CertificateCloudCredentials(subscriptionId, cert);
}

change the CERTIFICATE_PASSWORD_HERE to your certificate password.

and in ServersController.cs

private string BuildPath(){
    return Server.MapPath("~/App_Data/your_certificate_name.pfx");
}

private static string _subscriptionId = "azure_subscription_id_here";

Assign the path, point it to your certificate and change the value in _subscriptionId to your Azure Subscription ID

Preview

Azure SQL Server List

SQL Server Firewall

Source
Download it in GitHub

How to create components in knockoutjs

comfreakph@gmail.com — Wed, 22 Apr 2015 21:09:00 +0000

Make your UI code into reusable component. using KnockoutJS Components

Below is the complete sample code for create components in knockoutJS

Knockoutjs CRUD

comfreakph@gmail.com — Wed, 08 Apr 2015 00:06:00 +0000

A friend ask me to create a sample CRUD in knockoutjs, so I decided to put it in my blog and share it.

First Step:
Add knockoutJS to your project you can download it to knockoutjs website then start with view model script.

var viewModel = function(){
    var self = this;

};

$(document).ready(function(){
    var model = new viewModel();

    ko.applyBindings(model);
});

Next the letter C in CRUD, Create. Let's add a html view for our create.

<form data-bind="submit:Create">
    <label>Description</label>
    <input type="hidden" data-bind="value:id">
    <input type="text" data-bind="value:description">
    <input type="submit" value="submit">
</form>

for our create knockoutjs script, Add id and description property as observables. Then function for saving the data into array that is observableArray.

self.list = ko.observableArray([]);
self.id = ko.observable("");
self.description = ko.observable("");
self.action = ko.observable("add");

self.Create = function(){
    if(self.action() == "add"){
        var id = (self.list().length) + 1;
        self.list.push({
           ID:id,
           Description: ko.observable(self.description())
        });
    }
};

Next is Read, and let's add static data in observableArray and read function:

self.data = ko.observableArray([
   {"ID":1, "Description":"Tops"},
   {"ID":2, "Description":"Dresses"},
   {"ID":3, "Description":"Tees"},
   {"ID":4, "Description":"Blouses"},
   {"ID":5, "Description":"Shorts"},
   {"ID":6, "Description":"Pants"},
   {"ID":7, "Description":"Denim"},
   {"ID":8, "Description":"Bags"},
   {"ID":9, "Description":"Jackets"},
   {"ID":10, "Description":"Skirts"},
   {"ID":11, "Description":"Accessories"}]
);

self.Read = function(){
   self.list([]);
   self.list(ko.utils.arrayMap(self.data(),function(item){
      return{
         ID:item.ID,
         Description: ko.observable(item.Description)
      }
   }));
};

Let's add <table> html tag to display our data

<table>
    <thead>
    <th>ID</th>
    <th>Description</th>
    <th>Action</th>
    </thead>
    <tbody data-bind="foreach:list">
    <tr>
        <td data-bind="text:ID"></td>
        <td data-bind="text:Description"></td>
        <td>
            <a href="#" data-bind="click:$root.Delete">Delete</a> | 
            <a href="#" data-bind="click:$root.Edit">Edit</a>
         </td>
    </tr>
    </tbody>
</table>

Now we have a data, let's do an U in CRUD as Update:

self.Edit = function(data){
   self.action("edit");

   self.description(data.Description());
   self.id(data.ID);
};

Then the D as Delete

self.Delete = function(data){
   if(confirm("Are you sure you want to delete this data?")){
      self.list.remove(data);
   }
};

Overall this is what it looks like in fiddle

Overall a simple approach for CRUD in KnockoutJS

Happy Coding!