CQRS stands for Command Query Responsibility Segregation
Basic concept of this pattern is to keep separate models to read(Query) and write/update(Command) information. Which lead to Command Query Separation.The main aim of CQRS is to assist in building high performance, scalable systems with large amounts of data.
Usage:
Complex CRUD(Create, Read, Update, Delete) model
chris : http://pietschsoft.com/post/2014/06/15/CQRS-Command-Query-Responsibility-Segregation-Design-Pattern
We only need one html file for this. We can also use three files for this purpose.
1. Angular.js file – this is the main javascript file we need to make page support for Angular js. We can include it in our folder or we can directly take it from CDN.
2. Basic Html file – this file should contain ng-app in any HTML tag. ng-controller,ng-repeat and {{variable}} are code syntaxes.
3. CardController.js file - this file contains controller class and with $scope variable it defines its parameters.
<html ng-app xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<!--<script src="scripts/angular.min.js"></script>-->
<script src="//ajax.googleapis.com/ajax/libs/angularjs/1.2.21/angular.min.js"></script>
<script language="javascript">
//we can also use CardController.js for this
var CardController = function ($scope) {
$scope.cards = [{ Id: 1 }, { Id: 4 }];
};
</script>
</head>
<body ng-controller="CardController">
<div ng-repeat="card in cards" class="CardItem">
Id: {{card.Id}}
</div>
</body>
</html>
Output will be
Id: 1
Id: 4
Hope you wanted to learn more simple beginners lessons on AngularJS covering most parts with examples. W3Cschools.com - http://www.w3schools.com/angular/default.asp
Following code shows way to remove all spaces from selected column values. We generally use RTRIM and LTRIM build in string functions but sometimes it doesn’t remove some spaces due to string contains carriage return life feed and tab like control characters. We can’t see these characters with grid result view but we can see in text result view in MSS Management Studio.
REPLACE(REPLACE(REPLACE(RTRIM(LTRIM(ColumnName)), CHAR(10), ''),CHAR(13), ''),CHAR(9), '')
CHAR(9) - 'Tab'
CHAR(10) - 'Line Feed'
CHAR(13) - 'Carriage Return'
Clean Code: A Handbook of Agile Software Craftsmanship [Robert C. Martin]
I got following error when running Test project with visual studio 2010.
SetUp : System.BadImageFormatException : Could not load file or assembly 'TP, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.
Solution:
When I checked there were difference in Solution platforms of two project.One set to x86 while other project set to AnyCPU.So I changed it from AnyCPU to x86.It works.
public static string HashPassword(string password)
{
var provider = new SHA1CryptoServiceProvider();
var encoding = new UnicodeEncoding();
var hash= provider.ComputeHash(encoding.GetBytes(password));
return Convert.ToBase64String(hash);
}
var pwdstr=HashPassword(password);
var user=(from u in context.Users
where u.UserName.Equals(username) && u.pwd.Equals(pwdstr)
select u);
This is simple way to set and check password stored in database.Hope it will helpful.To store in a database use first method and to compare use second method.Until next post cheers!!!
MSSQL set null when value is not numeric in select query
SELECT CASE ISNUMERIC(column1) WHEN 1 THEN column1 ELSE NULL END FROM table1
SQL Server Error Messages - Msg 8152 - String or binary data would be truncated. The statement has been terminated.
This error message is occurred when I tried to insert data to values from another table.It’s due to one column in the table that im inserting data have lesser length than other table column.(varchar(25) – varchar(max)).It couldn’t found previously because second table column I have used max length but when inserting data it filled with strings that contains more than 25 characters.
I found another command to skip that error and continue but its like a try catch statement without catch part(thanks yasindu bro for nice example).
SET ANSI_WARNINGS OFF
Need to use above command before inserting records.but sometimes it’s not working
Inserting multiple records to a table
This isn’t simple thing but I previously work with MySQL and that is different and we can’t use
INSERT INTO tblName (column1,column2)Previously I have work with Aspose slides and now I’m trying to work with this one.First need to download OpenXml SDK for that used following link.This link also contains Open Xml tools setup that includes help documents etc..
Starting Steps
Errors Occurred :
this error can be solved adding reference to windowsBase in .Net Tab.
Before I start I wish you all a very happy new year 2012.It took long time after my last since I got new job and many changes happened in recent months.
I was learning WPF(Windows Presentation Foundation) and I tried to create RSS Feed reader.I tried to get twitter feeds from my twitter account and I searched in google and I found a code but it needed twitter id for that.I found it can be also replace by username.But this code is also useful.
I open http://api.twitter.com/users/show/rasikalb.json {this is for me common url http://api.twitter.com/users/show/[replace username].json}url and it shows some useful json code that we can get many twitter account details.last line contains twitter id.
We can access our twitter feed from http://twitter.com/statuses/user_timeline/[userId or username].rss it shows as follows.Using this rss file we can read tweets.
Hope to post about SQL, C# useful tips in future.Until next post cheers ..!!!
most of linux OS’s, Firefox is default SW.But I like Google Chrome since it has quick search functionality(we can search from address bar), large web page area,collection of themes & plugins, there are many tools to support web developers and it’s softer than others.But it has some disadvatages too.It crashes than others.need more processing power when we open many tabs.Some microsoft products don’t work with other browsers so we need internet explorer in that stage.Firefox is best browser according to http://internet-browser-review.toptenreviews.com/
And also it has chatting facilities,filtering and many features.If you are a beginner it’s better to start your email with gmail.com .But there are many email providers. ex:yahoo.com,live.com, and newest one phoenix mail that provides facility to connect many email accounts to one.I strictly believe using too many email account isn’t good.It will waste your time.
As I post previously Now I’m reading a book called C# 4 and .NET 4.But the thing is Without examples it’s boring so I decided to do it with this one.I heard this is a very useful book.
Hope I can get some big support for my future developments.
Although I have some knowledge and experience with C# I’m trying to organize my knowledge so I’m starting to read Professional C# 4 and .Net 4
This book was recommended by one of the software Architect.I must thank him for his help in many cases.
| Morning Trip | Afternoon Trip |
| 5.50 Start-kandy | 11.15 start-Colombo |
| with CTB bus there was tea break | with private bus it was late mostly because of traffic at the moment |
Although I have good experience of PHP, MySQL & JavaScript I learn many things from this book such as JavaScript Frameworks.I just read this book and I recommend this book for beginner web developers to read.
ASP.NET Ajax Framework http://asp.net/ajax
Clean Ajax Framework http://sourceforge.net/projects/clean-ajax
Dojo Toolkit http://dojotoolkit.org
jQuery http://jquery.com
MochiKit http://mochikit.com
MooTools http://mootools.net
OpenJS http://openjs.com
Prototype http://prototypejs.org
Rialto http://rialto.improve-technologies.com/wiki
script.aculo.us http://script.aculo.us
393Framework Web address
Spry Framework http://labs.adobe.com/technologies/spry
YUI http://developer.yahoo.com/yui
I wanted to open Form2 from Form1 and close Form1.I try this many times but it fails my code is this.
var F2=new Form2();F2.show();
this.close();I searched lot.but I could find any error of the code but Form1 doesn’t closed.Finally I found the answer.It’s my main program.
Application.Run(new Form1());So I couldn’t close Form1.
But I found anther way to close previous one
var f=new Form2();f.Show();
this.Dispose(false);
It works for me.
For comment source code at visual studio or MSSQL sever management studio can use Ctrl+k,Ctrl+c when press Ctrl+k it waiting for another key stroke then press Ctrl+c
For Uncomment use Ctrl+k,Ctrl+u
Ctrl+k,Ctrl+D for format code but this isn’t work in MSSQL Server Management Studio