AFAIK

Tips for solution architecture

2026-04-01T21:41:00.001+01:00

1. Understand the requirements : Before designing a solution, make sure you fully understand the problem you are trying to solve. Ask questions to clarify requirements, constraints, and priorities.

2. Consider multiple perspectives: Solution architecture should consider the requirements of stakeholders from different perspectives, including business, technical, and user.

3. Focus on simplicity: Solutions that are too complex can be difficult to maintain and troubleshoot. Keep the solution as simple as possible without sacrificing important functionality.

4. Use approved /proven patterns: Use proven design patterns and principles that have worked well in the past. This can help avoid common pitfalls and ensure the solution is reliable and scalable.

5. Plan for change: Design the solution to accommodate future changes and evolutions in requirements, technology, and business needs. This can help avoid costly rework and ensure the solution remains relevant over time.

6. Communicate effectively: Clearly communicate the solution design to stakeholders and team members in a way that they can understand. Use logical diagrams, document solution options, risks and mitigation plans and other tools to help explain the solution.

7. Evaluate and iterate: Evaluate the solution early and often to ensure it meets requirements and functions as intended. Use feedback to iterate and improve the solution as needed.

8. Stay up-to-date: Keep up-to-date with new technologies and best practices in solution architecture. Attend conferences, read blogs and books, and participate in online communities to stay informed.

9. Collaborate: Work closely with peers such as developers, security, infrastructure, devops, testers, project managers, and other stakeholders throughout the solution design process to ensure a successful outcome. Collaboration can help avoid misunderstandings and ensure everyone is aligned on the solution.

#saynotointerview for recruitment process

2017-04-24T18:11:00.001+01:00

I recently went for a training that consists of employees from multinational corporations. During the brainstorming sessions, one fellow gentleman started speaking about firing his colleague. This guy is actually a senior manager and he interviewed the departed. He was blaming the unfortunate guy told he knows all the job description and he was smart during the interview. So they selected him for the job. But in the job, he never raised to his potential and they sacked him. The senior manager was claiming in the brainstorming session the decision was correct. But lots of people in training disagreed with that. Majority people told the recruitment or interview process in the company flawed to test that lad's knowledge. I strongly believe this might not be a one of the situation in recruitment? How many of you came across similar experience in your professional career?

Do you believe the things we put in the job description are the exact things the potential employees will be doing their job? Or is it the aspirational stuff the organisation or the management indented to do? I am going to make a very controversial statement here. In my career, I never worked for any organisation that described the exact job in their job description. I strongly believe most of you reading this will also not disagreeing with me on this case. That is where I believe we should have to think about our recruitment process. Do we need someone to answer the interview questions based on organisations aspirations? Or do we need the real talents who can make a difference in your work environment?

Some of the companies already do some real time tests or practises in the actual office environment as part of the recruitment process. They will be only selected based on the initial assessment or test, initial interview- some might be after the 1st telephonic interview or technical interview. Do you think in 2-4 hours assessment like this can actually bring out the raw latent skills and capabilities? I can strongly say this will never give you the expected result. One of my head of department and I had this discussion and he told me the trust and behaviour aspects are his main reason for making the final cut on this. The questions remain the same? Is it the best candidate for the job?

All the interview processes that mentioned before are there for long period. Any of you ever thought or read about any alternative approaches to recruiting the right candidate? I believe in this twenty-first century we need to think about unconventional approaches for recruiting the right candidates for driving the organisations and the world forward. So what alternatives can we think about?

The slogan I am putting down is #saynotointerviews. I believe we should give the potential employees to showcase their skills and talents in the real work environment.

Take the potential candidate for 2,3 days of real work environment
Ask them to do a specific task as your normal employees are doing.
Assign them to a partner to track their progress.
Evaluate them over this 2, 3 days how they catching up with the job.
How do they understand the job function?
How are they applying their knowledge in the actual work culture?
Ask them to present their experience to the team.
Review them based on how they performed on last 2 or 3 day
Select the most suitable candidate for your work environment.

I know there are lots of companies around the world trying different approaches in their recruitment processes. But how many organisations on the current setup can think differently about their current recruitment process? Anyone ready to scrap their traditional recruitment process and ready to explore the process described above? I believe this will definitely going to help the organisations to find the best/cream candidate for your setup. These potential employees will also be going to benefits from these kind experiences. I would like to conclude this with a George Bernard Shaw quote, "The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man."

The Company of the future race?

2017-03-27T10:21:00.001+01:00

Introduction

Have you ever heard about Valve? - The company that develops amazing video games- the global leader in video game software Industry. Games like Counter-Strike, Half Live, and Team fortress are some of the best from their archery. For management students and enthusiasts, the importance of Valve is not only about these games but also have an amazing organisational model that traditional companies inching to follow. Let's review what Valve is doing better in the level of management functions. This is my interpretation after doing the case study for my course.

Valve is an example of emergence over hierarchy model, each employee is free to choose and initiate their own projects and disputes are resolved through consensus. Teams are formed by individuals around topics of interest. Each team has leaders chosen by informal agreement and there is neither supremacy nor financial benefit associated with it.

Example someone shows an interest to do a project and everyone will say “You are struck with it now” and the project has kick started. Once the project finishes they go back and work individually on the next thing. There is very less bureaucracy and some activities (e.g. Hiring) can take long-time

Valve's Decision Making

In Valve, decisions are made through the accumulation of input from individuals in teams and output an innovative and valuable verdict, even though the founders exercise formal authority in employee recruitment and management. So Valve’s decision making can be categorised as closer to Collective wisdom than the traditional hierarchy management approach. But the level of authority is too narrow in Valve for example – “Newell (co-founder) delegate a lot of his authority to enable employees to make their own decision on how to organise themselves in team”

How employees are motivated?

As an organisation Valve has driven by both material and personal drivers of motivations. Despite the impression that they have built a motivational environment to work through many of their organisational strategies, they are still using bonuses for high performers (social drivers) and high salaries for their employees. So in management model, they are half way between the traditional and new approach of motivation or can say as a hybrid model between Extrinsic and Intrinsic rewards. Even though bonuses for top performers are through peer reviews and rank based system, are precarious and can lead to encourage bad practises or behaviours and eventually can lead to focussing on the narrowest of activities and actions for the employees.

Valve’s highlights

In Valve, coordination is achieved by emergence over bureaucracy. Individuals are motivated by self-interest. This has allowed the company to be highly responsive to market requirements and opportunities. The emergence created efficiency, responsiveness, expertise and eliminated favouritism in Valve’s teams. As there are no formal bosses in the team decisions are made by individuals with freedom and teams are self-organising and highly empowering, encourage hard work and have room for creativity and responsibility. In Valve there is no set of rules or procedures that an employee must follow other than the project they are collaborating should benefit the company. As emergence is 21st-century approach it can attract Y generation to Valve.

Valves major asset lies in the fine line of borders and has managed to incorporate assertive enhanced financial growth and management model innovation in parallel.

Valve’s spotlight

Valve has no internal department such as resource allocation or quality control which might act as bottle neck and slow moving as many people activities required aligning when it comes to decision making. The enormous stress on self-organising make the system susceptible to enormous glitches and emergence can lead to not enough clarity on where they emphasis effort. Too much freedom to experiment with fewer boundaries can lead to loss of focus after initial interest or a blockage and results in too many overlapping projects. When the company grows lack of authority the decision making can be more slow and difficult without formation proper rules. Finally, to avoid Enron’s situation in Valve, the company will have to mechanise a define structure of some level of accountability and conduct systematise meeting in order to ensure transparency and project are shut down properly or dismissing people's.

How to envisage Valve's growth?

Like all the organisation, when it grows Valve will definitely have to face some challenges in its management model. Valve’s current management model is focussing right on the alternative principles in the management models and is bit far from the traditional approach. The approach of coordination through the emergence rather than the bureaucracy, decision making through collective wisdom over hierarchical and hybrid model in motivation rather than the pure extrinsic rewards are the examples of its right shift. When Valve grows can they survive with this or requires a slight left switch towards the traditional principles by introducing some level hierarchy in its process, or bureaucracy process even when it can slow down and disempowering. There is no right answer or choice to this kind of situations. On book or in theory all this principles will work for some organisation. Consider Google as an example, when Google started they are viewed as organisation they followed the alternative approaches in management and over the years the company grown and it made some slight left switch towards the traditional approach and has great success. May be Valve can learn from Google.

So... What others can learn from Valve?

I believe there is no right or wrong answer to this question. It’s all depends on situation and can vary according to the scenarios. I truly believe that all the management models should be evolving over the years and same applicable for Valve. At this moment of time current model is working for Valve doesn’t mean we can take the same principle and apply directly to the big organisations like Microsoft. Some people have opinion managing one person or 10 persons or 100 or 1000’s persons are same, but I don’t agree with that. And it is same for Valve’s model. First, we need to understand the thoughtful steps that Valve did in order to get more management innovation and then how this can be applied to Microsoft or any big companies. Suppose Microsoft try to remove all of their bureaucracy and hierarchy. Can they become more transparent or emergent? I believe it can lead to poorly defined processes, loss of control or even embitterment of the peoples because the scale of Microsoft is bigger and some kind of rules and authority is required to create some kind of efficiency. Another example is Valve uses consensus for dispute resolution, will it work for Microsoft or not? Maybe it works or maybe not and that is because the scenario and maturity of their employees.

My point of view is big companies like Microsoft requires spending time in observing and getting the fundamental of this Valve management model and doing some researching and experimenting through small teams and widely understanding the fundamentals and principles behind these models. Then they have to identify the principles that are closely aligned with their company’s fundamental DNA’s and try to apply to the existing teams.

About the Author

Adarsh Soman is an entrepreneurial-spirited, innovative technologist with 9+ years of leadership-level experience in identifying, qualifying, building harmony for, and implementing enabling technologies and enterprise systems that facilitate business processes and strategic objectives. Powerful blend of technology vision and business acumen results in constant development of powerful business strategies supported by cost-effective development of high-performance software applications. Broad expertise in Software development, full project life cycle management, and process improvement initiatives.

Emergence and Creative Confidence

2017-02-28T15:28:00.002+00:00

I started my career on 1st of September 2008 as a software developer at Manchester. Some people in my personal life might know about it. I like to say, that day as the day I found an aura in my life, transformation from the worst possible situation into a new beginning in a matter of 1 hour. The week before, I got an interview confirmation from that company and I was not at all excited about it because I know it is going to be the final interview in UK if I am unsuccessful. I was in that mental state because I was not successful for past 12 such occurrences and not expecting anything different. This shows I was not a brilliant person but had a strong passion and hardworking nature to achieve success. I passed my masters on Sep 2007 and after that, I decided to work only in software development, and lots of people including my parents told this as a worst possible decision. To be precise, they have no issues in choosing software development, but on my adamant decision only software development. Prior to that, I was doing a part-time job and I had around £2000 in my account and got some credit cards worth £1500. I decided to focus on my area of study because I heard lots of students coming from Asia are doing some part-time jobs and continue in that vicious loop. So I decided I don’t want to be in that group. I started applying for software development jobs and that too in the worst possible period I could be looking for a Job, the starting of the recession period. By august 2008 I already did one swap of technology from Java based jobs to .Net based job after understanding the market. Regarding my financial situation by August 2008, I already spend £1980 from my account and credit card outstanding balance of £1000. Out of this 12 Job interviews, one of them was final survival try, throwing all my adamant decision work only in software development and went for an interview of a cleaning job nearby Sainsbury store. I went for the interview and the Manager shown me the things to clear. To be honest it’s cleaning the toilets in Sainsbury store. He liked my obedience and did the induction (showing how to clean it when remains are left in the toilet). He sent me back from there, saying I will be receiving a confirmation message with start date of the shift. Shift usually start from early morning 5.15 and finish by 8.15AM. By doing those 3 hours of job I can earn my livelihood and can continue my job hunt. The next day I was calm and waiting for the confirmation message, but I received a call from him saying the previous person who supposed to leave the job didn’t leave, so I won't get the Job. That is when I decided to go back to my country and do some Job based on my qualification. Usually, I go for interview alone but on my 13th interview my friend drove me to the office, since I couldn't afford the train ticket . I arrived there 30 minutes late and on the way, I informed the hiring manager we lost the way. The IT director received me from the reception saying all their good developers are always late and gave me the confidence the best possible way. IT director and hiring manager took the Interview. They asked lots of questions and I believe I gave some good, positive responses back (not claiming I answered correctly, but my responses were confident as I don’t have anything to lose by that time). At the end of the interview, they told me they want to discuss and they went outside the interview room. The IT director came back and straight away offered the Job that also well paid for a no-UK experienced person. Actually, I would have accepted the offer even if it was half of what they have offered. To be honest in none of my Jobs I was really worried about the salary. I gave more respect for the responsibilities rather than the monetary benefits. I believe if I do the job best of my ability, the financial securities will always be there. It has been the same way in my career and I believe in future also things will work like that. One more thing I like to highlight is no job I left so far in my career because of money. The day I got the job, I truly realised one thing – “worries can never eradicate crisis from life” and decided I will never worry about anything in Life. Before the interview, I was in the worst possible crisis for a 25 years old (who is away from home and had an educational loan for masters studies) and after one successful Interview the new emergence. I came across lots of crises in my life after that, but I always think about the worst period after my master. It will always give an extra confidence and courage to face everything so far. These kinds of personal experiences only strengthen my skills, now when I am dealing with different set of peoples/teams/organisations. As a leader I am finding solutions for the different sets problems- say Microsoft Azure Licensing issues, or azure platform issues, or tackling CRM performance, or architecting the security for the web applications or looking for SQL performance improvement, or empowering people with the best possible usage of agile practices or finding solutions for internal politics in teams/organisations etc. Whenever I face a constraint or problems in my workplace, I usually emerge to provide a solution. After started learning the new leadership tricks and practises, I would like to know myself as a leader who motivates the people surrounding me and enforcing others to emerge from their shells and contribute towards the personal growth and well-being.

My confidence, my passion to succeed, my ability to dream

2016-10-31T15:22:00.000+00:00

My confidence, my passion to succeed, my ability to dream are the ultimate things that drives my life. Today I am working as a Solutions Architect and an agile practitioner and sometimes I think about my past where I started my career 8 years back. I still remember that day; my friend Antu Mammen drove me to an old building in Wythenshawe, Manchester. He drove me there only because I don't have enough money to get a train ticket. My bank balance was 20 pounds that day. He asked me to put 10 pound worth of petrol.

Before going for that interview I decided, if I am not getting that job I will be leaving UK. But fortunately or unfortunately Mr J Fisher IT director at Calrom Ltd offered me the Job, even though I reached there 20 min late for the interview. After getting the offer letter I walked towards Antu, he was standing in front of McDonald's where we parked the car. He was sad and told me he kept the key inside the car and locked the doors. But I smiled and told him finally I got the job. His expression was how come an idiot like me got the job? In a humour note I carried that burden of emotion for last 6,7 year and eventually shared the same with Antu in 2015, when he told me he got a job as Software Test Analyst.

I worked at Carlom for 2 and half years and tasted the first professional experience of software development from there. But towards end of 2009 I started dreaming of a bigger job with lots of opportunity and responsibility. Calrom days taught me a lot, but decision to move on took to learn and explore new heights and opportunities and finally reached London.

London changed my point of view towards work. It was totally different world and I started exploring new things. I learned that if you have the courage and ready to do hard work the sky is your limit. That's where I started dreaming of becoming a Software Architect. Now I am working as Solutions Architect and I believe the experience I got from all jobs including Exponential-e, Capita and NHS fulfilled my dream to become an Architect. In between I became APMG Certified Agile Practitioner too, that is when I realised that combination of technical knowledge plus project management knowledge is a deadly combination. Nowadays everyone think about agility, becoming digitally transformed, Continuous Improvement etc. In this technological landscape technical and project management skills definitely add a lot flavour to success.

I came across lots of blockers and troubles in my career, but every time when I come out from it, I found an extra dimension to my career. First job I learned .NET programming, second one MVC and WCF, next was for EXT.JS library and rest based service, then KNOCKOUT.JS and WEB API 2.0 then people management and leadership skills, agile practitioner, distributed system architecture, data warehousing, data modelling, and finally CRM. Learning technology or leadership/management is not a big challenge for me nowadays because I am enjoying those challenges every day.

People sometimes criticises me for moving fast, the answer to them is I don't have time to waste for any of them because I am not actually trying to chase or fulfilling others dreams. I am behind my dream and I am only with others in search, if they can fulfil any of my dreams somehow. Recently one of my CEO friend laughed at me and asked - why are you working for others? You won't have the freedom and you will be forced to fulfil other people's dream. My reply to him was simple. "Some people are fortunate enough to start a business and succeed. In my career I had chosen a different route and now if I wanted also I can't move away from that route easily." So until an offer comes to my way, I have to travel parallel with other peoples dream and I will have to look after my real fire.

Nowadays a new dream started propagating around me. I want to become a CIO or CTO. This dream is only a continuation of what I started doing from my childhood. Most recently the route evolved as Software developer to senior software engineer to technical specialist to solutions architect to CTO. The next destination has started appearing very vaguely in front of me. Last time the distance between dream and reality took 4 to 5 years. Again the new destination can take similar or more amount of time. But I am sure about one thing-there will be definitely new learning and new blockers. Eventually all this will transforms me stronger and good fit for that situation.

Some of you might think is he good enough to do it? I am also giving myself a challenge to show all others wrong. One day I told one of my best colleagues (ex) from Capita- I won't be talking always, but when I talk I will make sure that all others are listening. For me, my confidence, my passion to succeed and my ability to dream are stronger than others.

(my) Management v/s Leadership

2016-04-28T12:32:00.001+01:00

The Wall Street Journal Guide to Management” by Alan Murray describes - Leadership and management must go hand in hand. They are not the same thing. But they are necessarily linked, and complementary. Any effort to separate the two is likely to cause more problems than it solves.

I read the above lines from someone from LinkedIn who actually sent me a personal email regarding one of my crazy blog posts. I didn’t want to reply because I know the basic electronics and the post was more about my fiction than the actual electronics. One day I was casually browsing through his LinkedIn profile and found some interesting articles relating to leadership, management and technical leadership. Since then I was thinking to write about the leadership and management.

I usually take my writing through some famous quotes, in this case also no difference. Recently I have just finished reading the autobiography of the Indian Guru Osho and I like to elucidate my leadership and management style through one of his quotes. ‘Never ask, “Who is my real friend?” Ask, “Am I a real friend to somebody?” That is the right question. Always be concerned with yourself.’

On that note, the first question that came to me was am I a good leader or am I able to manage myself very well? I went back to my childhood and tried to remember when was the first time I showed my leadership and management skills? I am sure this is not the first time, but a striking one from a summer time after my class 6, a local Vayanasala(library) was conducting a cricket tournament. I and couple of local friends approached a team and told them we want to play for them. We took part in the trials and unfortunately they told us we were not good enough to play in the tournament.

After coming home, my thoughts turned to how we could play in that tournament. Next day morning I met my friends and told them we are going to form a cricket team and are going to play. To enter that tournament as a team we need to pay Rs.100 as an entry fee. I asked everyone, if they are willing to share the cost, but the consensus was that we wouldn't be able to collect that much of money, so we thought of several ways to increase our entry fee fund. We also tried one fraudulent thing. Near my home there is a small temple which hasn't got a hundi(collection pot) in front of the road at that time. We took a pot from my house and covered with red velvet and tried to imitate a hundi. One senior member in the village found this and advised “this as cheating the God”! Eventually we found the money from our parents so the team was formed and all my local friends were included in the cricket team.

So our dream had come true and I appointed myself as Captain of the team along with opening batman and bowler after vigilant selection process. As we were the rookies you can predict the outcome of the matches, but six months later we were starting to win the matches.

When I look back, my management skills were valuable in overcoming the hurdles to form the team and finding the money. My leadership skills were used in deciding the strategic decision of the team like opening batting/bowling and who should bowl the next overs or which batsman should bat in each position. I used my management skills to administer the team and my leadership skills innovates how to win the match. Another illustration of my leadership skills was always looking to win matches by rotating the bowlers or shift the batsman and making the correct alterations to the fielding positions. If we lost the match also, I was there to take the full responsibility because I might place a person on one fielding position and he dropped a lollipop. It was a clear example of my natural leadership. After each match while we were walking back, we discussed the mistakes and things that went wrong or what went according to the plan. Now in my IT career after each sprint or project these actions we call it as retrospective.

At the age of 11 or 12, I was able to do this because of the opportunities. Looking back, I also believe that captivating that opportunity was the key factor that ensued in developing the management and leadership skills that I had, along with my passion to play in the tournament, my decision to build the team, persuade others to share the cost, etc. One more thing I really want to emphasis along with this, if you want to chase something, you need to take brave decisions or steps, on the surface it might seem that in opportunities are limited then if you look around you can find the best wine out of the shelf.

Most of you might think what was the motivation behind this article or there are thousands of posts available about the management and leadership or what it stands out from other posts. The answer is unpretentious, at times there are circumstances in life where you could think, if you are good enough to do certain things in life. While looking back to our life itself, we might be able to find the best retort to that kind of puzzle. If not, please try to read about the other people experiences. Here, I tried to share a small incident from my life. If I ever believed I was not able to lead or manage myself very well, I wouldn't have been able to write about this.

The next topic, I am going to write about is my writing skills. Reflecting on my writing skills I hope that have shown some potential, there's room for improvement, but I believe the best is still to come.

Bootstrap Server Side Sorting Cont....

2015-04-15T10:54:00.004+01:00

On my previous post I had already mentioned about how to apply the sort to Bootstrap paginated tables. By making the following changes server side sorting can be achieved along with pagination.

On Filter Model

self.sortBy = ko.observable('Id');//Default sort Column

self.sortAscending = ko.observable(false);

self.iconType = ko.observable('glyphicon glyphicon-chevron-down'); // Icon to appear near Column

No Changes to Adarsh Log Model or Adarsh Log list Model

Knockout.js View Model for Adarsh Log Changes

Add the sortTable method to it

self.sortTable = function (viewModel, e) {

var columClicked = $(e.target).attr("data-column")

var sortAscending = (self.filter().sortAscending() === true) ? false : true;

self.filter().sortAscending(sortAscending);

self.filter().sortBy(columClicked);

datacontext.getAllPost(self.adarshLogListModel, config.adarshLogUrl, model.adarshLogListModel, self.filter).always(function () {

var list = [];

if (self.filter().currentPageIndex() <= 0) {

self.filter().enablePrev(false);

}

self.adarshLogListModel().adarshLogList().forEach(function (item) {

var newRecord = new model.adarshLog();

ko.mapping.fromJS(item, {}, newRecord);

list.push(newRecord);

});

self.adarshLogs(list);

// var newFilter = model.filter;

ko.mapping.fromJS(self.adarshLogListModel().filterModel(), {}, self.filter());

//(newFilter);

self.individualPageList(self.adarshLogListModel().filterModel().individualPageList());

if (self.filter().currentPageIndex() <= 1) {

self.filter().enablePrev(false);

}

if (self.filter().currentPageIndex() >= self.filter().totalPageCount()) {

self.filter().enableNext(false);

}

self.isBusy(false);

self.filter().iconType((sortAscending === false) ? "glyphicon glyphicon-chevron-down" : "glyphicon glyphicon-chevron-up");

});

}

Filter.CS C#Model Changes

Add Following Properties

public string SortBy { get; set; }

public bool SortAscending { get; set; }

No Changes to Get All WebApi Controller Method

GetAll Repository Change

Before applying the pagination, add the sorting

switch (filter.SortBy)

{

case "Id":

if(filter.SortAscending)

adarshLogList = adarshLogList.OrderBy(a => a.Id);

else

adarshLogList = adarshLogList.OrderByDescending(a => a.Id);

break;

case "Name":

if (filter.SortAscending)

adarshLogList = adarshLogList.OrderBy(a => a.Name);

else

adarshLogList = adarshLogList.OrderByDescending(a => a.Name);

break;

}

Changes in View List View

<thead>

</span>

</th>

<th data-column="Name">Name

</span>

</th>

</tr>

</thead>

<tr>

</td>

</tr>

</tbody>

</table>

Bootstrap Server Side Pagination - alternative to data tables

2015-02-17T17:16:00.001+00:00

Background

Most of the Web developers are familiar with the Datatable.Net for pagination. DataTables can integrate seamlessly with Bootstrap using Bootstrap's table styling options to present a consistent interface with your Bootstrap driven site / app. The main disadvantage with Data table.net is it is applying the pagination at the client side and for the large data set it can take minutes to load the data. Like every other designer I also faced the problem with Data table.net. So what is the best option to replace the client side paging and searching. So I forced to create a custom module to do the pagination and searching. The below sample don’t support the sorting, but got an option to extend the functionality. Please check my Next Post for sorting functionality

The technologies used include, MVC 4.0, HTML5, Bootstarp.css, Knockout. js, Ajax, Web Api 2.0, Linq to SQL and C#.

Knockout.js Model’s

Filter Model

var filter = function () {

var self = this;

self.searchText = ko.observable('');

self.totalCount = ko.observable('0');

self.pageSize = ko.observable('10');

self.currentPageIndex = ko.observable('1');

self.sortBy = ko.observable('');

self.sortAscending = ko.observable(false);

self.countLabel = ko.observable("");

self.enablePrev = ko.observable(true);

self.enableNext = ko.observable(true);

self.totalPageCount = ko.observable('1');

self.individualPageList = ko.observableArray([]);

return self;

}

Adarsh Log Model

var adarshLog = function () {

var self = this;

self.Id = ko.observable('');

self.Name = ko.observable('');

return self;

}

Adarsh Log List Model (Binding both the filter and Adarsh log list)

var adarshLogListModel = function () {

var self = this;

self.adarshLogList = ko.observableArray([]);

self.filterModel = new ko.observable(new filter);

return self;

}

Knockout.js View Model for Adarsh Log

define(['genericContext', 'commonContext', 'logger', 'config', 'model'], function (datacontext, commonContext, logger, config, model) {

var viewModel = function () {

var self = this;

// Search Tip for Search Text Box

self.searchTip = function () {

$('[data-toggle="popover"]').popover()

}

// Help Text

self.searchTipText = ko.observable("Type search keyword....");

// Initialisation

self.adarshLogs = ko.observableArray([]);

self.adarshLogListModel = ko.observable(new model.adarshLogListModel);

self.filter = ko.observable(new model.filter);

self.individualPageList = ko.observableArray([]);

//Getting the records for intital Load

datacontext.getAllPost(self.adarshLogListModel, config.adarshLogUrl, model.adarshLogListModel, self.filter).always(function () {

var list = [];

self.adarshLogListModel().adarshLogList().forEach(function (item) {

var newRecord = new model.adarshLog();

ko.mapping.fromJS(item, {}, newRecord); //map the json into our oversvable object

list.push(newRecord);

});

self.adarshLogs(list);

// var newFilter = model.filter;

ko.mapping.fromJS(self.adarshLogListModel().filterModel(), {}, self.filter());

//(newFilter);

self.individualPageList(self.adarshLogListModel().filterModel().individualPageList());

if (self.filter().currentPageIndex() <= 1) {

self.filter().enablePrev(false);

}

if (self.filter().currentPageIndex() >= self.filter().totalPageCount()) {

self.filter().enableNext(false);

}

self.isBusy(false);

});

// Search fucntionality

self.searchItems = function (selected) {

self.filter().currentPageIndex(1);

datacontext.getAllPost(self.adarshLogListModel, config.adarshLogUrl, model.adarshLogListModel, self.filter).always(function () {

var list = [];

if (self.filter().currentPageIndex() <= 0) {

self.filter().enablePrev(false);

}

self.adarshLogListModel().adarshLogList().forEach(function (item) {

var newRecord = new model.adarshLog();

ko.mapping.fromJS(item, {}, newRecord); //map the json into our oversvable object

list.push(newRecord);

});

self.adarshLogs(list);

// var newFilter = model.filter;

ko.mapping.fromJS(self.adarshLogListModel().filterModel(), {}, self.filter());

//(newFilter);

self.individualPageList(self.adarshLogListModel().filterModel().individualPageList());

if (self.filter().currentPageIndex() <= 1) {

self.filter().enablePrev(false);

}

if (self.filter().currentPageIndex() >= self.filter().totalPageCount()) {

self.filter().enableNext(false);

}

self.isBusy(false);

});

}

// Previous Page Click

self.previousPage = function () {

if (self.filter().currentPageIndex() > 1) {

var list = [];

self.filter().currentPageIndex(self.filter().currentPageIndex() - 1);

datacontext.getAllPost(self.adarshLogListModel, config.adarshLogUrl, model.adarshLogListModel, self.filter).always(function () {

if (self.filter().currentPageIndex() <= 0) {

self.filter().enablePrev(false);

}

self.adarshLogListModel().userList().forEach(function (item) {

var newRecord = new model.adarshLog();

ko.mapping.fromJS(item, {}, newRecord); //map the json into our oversvable object

list.push(newRecord);

});

self.adarshLogs(list);

// var newFilter = model.filter;

ko.mapping.fromJS(self.adarshLogListModel().filterModel(), {}, self.filter());

//(newFilter);

self.individualPageList(self.adarshLogListModel().filterModel().individualPageList());

if (self.filter().currentPageIndex() <= 1) {

self.filter().enablePrev(false);

}

if (self.filter().currentPageIndex() >= self.filter().totalPageCount()) {

self.filter().enableNext(false);

}

self.isBusy(false);

});

}

else {

self.filter().enablePrev(false);

}

//Next page Click

self.nextPage = function () {

if (self.filter().currentPageIndex() <= self.filter().totalPageCount() - 1) {

var list = [];

self.filter().currentPageIndex(self.filter().currentPageIndex() + 1);

datacontext.getAllPost(self.adarshLogListModel, config.adarshLogUrl, model.adarshLogListModel, self.filter).always(function () {

if (self.filter().currentPageIndex() <= 0) {

self.filter().enablePrev(false);

}

self.adarshLogListModel().adarshLogList().forEach(function (item) {

var newRecord = new model.adarshLog();

ko.mapping.fromJS(item, {}, newRecord); //map the json into our oversvable object

list.push(newRecord);

});

self.adarshLogs(list);

// var newFilter = model.filter;

ko.mapping.fromJS(self.adarshLogListModel().filterModel(), {}, self.filter());

self.individualPageList(self.adarshLogListModel().filterModel().individualPageList());

if (self.filter().currentPageIndex() <= 0) {

self.filter().enablePrev(false);

}

if (self.filter().currentPageIndex() >= self.filter().totalPageCount()) {

self.filter().enableNext(false);

}

self.isBusy(false);

});

}

else {

self.filter().enableNext(false);

}

//Click on Any Specific Page

self.currentPage = function (index) {

self.filter().currentPageIndex(index);

var list = [];

datacontext.getAllPost(self.adarshLogListModel, config.adarshLogUrl, model.adarshLogListModel, self.filter).always(function () {

self.adarshLogListModel().adarshLogList().forEach(function (item) {

var newRecord = new model.adarshLog();

ko.mapping.fromJS(item, {}, newRecord); //map the json into our oversvable object

list.push(newRecord);

});

self.adarshLogs(list);

// var newFilter = model.filter;

ko.mapping.fromJS(self.adarshLogListModel().filterModel(), {}, self.filter());

//(newFilter);

self.individualPageList(self.adarshLogListModel().filterModel().individualPageList());

if (self.filter().currentPageIndex() <= 1) {

self.filter().enablePrev(false);

}

if (self.filter().currentPageIndex() >= self.filter().totalPageCount()) {

self.filter().enableNext(false);

}

self.isBusy(false);

});

}

};

return viewModel;

}

});

Generic Context. Js

define(['services/logger', 'config'],

function (logger, config) {

getAllPost = function (objectObservable, baseUrl, baseModel, filter) {

var list = [];

var options = {

url: baseUrl + 'GetAll',

data: ko.toJSON(filter),

type: "Post",

contentType: "application/json",

dataType: 'json'

};

return $.ajax(options).then(querySuccess);

function querySuccess(data) {

ko.mapping.fromJS(data, {}, objectObservable);

};

var datacontext = {

getAllPost: getAllPost,

};

return datacontext;

});

Filter.cs C# Model

public class Filter

{

public int TotalCount { get; set; }

public int PageSize { get; set; }

public int CurrentPageIndex { get; set; }

public string SortBy { get; set; }

public bool SortAscending { get; set; }

public string SearchText { get; set; }

public string Source { get { return SystemConfig.GetSourceName; } }

public string CountLabel

{

get

{

int progressCountStart = ((CurrentPageIndex - 1) * PageSize) + 1;

int progressCountEnd = (CurrentPageIndex) * PageSize;

if (progressCountEnd > TotalCount)

{

progressCountEnd = TotalCount;

}

return "Showing " + progressCountStart + " to " + progressCountEnd + " of " + TotalCount;

}

public int TotalPageCount

{

get

{

int count = 1;

if (TotalCount > 0 && PageSize > 0)

{

double dec = Math.Ceiling((double)TotalCount / PageSize);

count = Convert.ToInt32(dec);

}

return count;

}

public List IndividualPageList

{

get

{

List result = new List();

int midPoint = 5;

int totalPagesShowing = 10;

if (TotalPageCount <= totalPagesShowing)

{

for (int i = 1; i <= TotalPageCount; i++)

{

result.Add(i);

}

return result;

}

//Total Page showing 10. Midpoint took as 5. So left is 4 pages and right is 5 pages.

int startpoint = CurrentPageIndex - (midPoint - 1);

int endpoint = CurrentPageIndex + midPoint;

if (startpoint < 1)

{

int surplus = midPoint - CurrentPageIndex;

startpoint = 1;

endpoint = endpoint + surplus;

}

if (endpoint > TotalPageCount)

{

int surplus = endpoint - TotalPageCount;

startpoint = startpoint - surplus;

endpoint = endpoint - surplus;

}

for (int i = startpoint; i <= endpoint; i++)

{

result.Add(i);

}

return result;

}

Get All WebApi Controller Method

[HttpPost]

public HttpResponseMessage GetAll(Filter filter)

{

HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);

try

{

var adarshlogList = adarshLogExtended.GetAll(ref filter);

AdarshLogListModel result = new AdarshLogListModel();

result.AdarshLogList = adarshlogList;

result.FilterModel = filter;

response.Content = new ObjectContent(result, GlobalConfiguration.Configuration.Formatters.JsonFormatter);

}

catch (Exception ex)

{

response.StatusCode = HttpStatusCode.BadRequest;

response.ReasonPhrase = ex.Message;

}

return response;

}

GetAll Repository Method

public List GetAll(ref Filter filter)

{

IQueryable adarshLogList = context.AdarshLog;

if (adarshLogList != null)

{

if (filter != null)

{

filter.TotalCount = adarshLogList.Count();

string searchText = filter.SearchText.ToUpper().Trim();

if (!string.IsNullOrWhiteSpace(searchText))

{

filter.TotalCount = (from p in adarshLogList

where ((p.Name != null && p.Name.ToUpper().Trim().Contains(searchText)) || (p.Id!= null && p.Id.ToString.Contains(searchText)))

select p).Count();

adarshLogList = (from p in adarshLogList

where ((p.Name != null && p.Name.ToUpper().Trim().Contains(searchText)) || (p.Id!= null && p.Id.ToString.Contains(searchText)))

orderby p.AddedDate descending

select p).Skip((filter.CurrentPageIndex - 1) * filter.PageSize).Take(filter.PageSize);

return adarshLogList.ToList();

}

else

{

var pagedList = (from p in adarshLogList

orderby p.AddedDate descending

select p).Skip((filter.CurrentPageIndex - 1) * filter.PageSize).Take(filter.PageSize);

return pagedList.ToList();

}

return null;

}

Views

Search.cshtml User Control

Footer.cshtml footer User Control

SQL Server Architecture

2015-01-01T22:19:00.000+00:00

The Main Components of the SQL Architecture are

NETWORK LIBRARY, provide connectivity between the client and the server process.(Client request come to SQLserver via NL)
DATABASE ENGINE, is the server process that sits at the heart if a SQL Server System(RDBMS). Its logically divided as Relational Engine and the Storage Engine.
RELATIONAL ENGINE: RE provides the functionality that control query execution(the request is parsed, optimised and executed)
OLE-DB Request is passed to the storage engine
STORAGE ENGINE- SE pass the IO request to OS.(Storage Engine manages the access and modification of data. Transaction manager, Page Manager, Access methods, Lock manager, File/Device Manager, Buffer, log, sort manager and Utilities)

Sql Server Internals - Named Pipes

2015-01-01T21:50:00.000+00:00

Named pipes enables clients applications to request a reliable and two way connection between the client application and Sql Server, across a network. A named pipe has a name which follows the UNC naming convention : \\Server\pipe\name

The default names pipe for SQL server is :
\\Server\pipe\sql\query

A named instance would have a named pipe of
\\server\pipe\MSSQL$instancename\sql\query

Early versions of SQL Server only provided Named Pipes.

Named Pipes also allows for impersonation of a clients credentials. The feature is used by SQL server when using Linked Servers. The clients logon credentials are passed across to the Linked Server for authentication.

Named Pipes can operate over TCP/IP, NETBEUI or IPX as it indirectly relies on the Common Internet Files Sytems

Single page application (SPA) using ext.js

2014-09-06T00:20:00.002+01:00

what is spa?

Single page application are applications that fit in one page with rich and fluid user experiences like a desktop based applications.

Why is SPA?

All web based elements (html, CSS,javascript) are downloaded from the server on single page load and avoid the continuous page post back. i can explain what this mean. Suppose your web application is made of certain flow and it consists of 5 different pages. Each page need to get data from the user and save before moving to the next page. So when we navigate from one page to other it need to make a round trip to server to store the data in one page and get the data for the next page to display. but in spa we can avoid the continuous post backs. The whole page will not post back any time other than the first load. But it communicate to the server dynamically behind the scene and can achieve the same functionality.

Spa using ext.js

designing a SPA using ext.js is a challenging task if you are unaware about the ext.js framework or similar frameworks.

Ext JS is a javascript library from sencha and based on mvc-s architecture. Mvc-s means model-view-controller - store. If you are familiar with asp.net mvc or scrum we can simply compare ext.js mvc architecture the same way for javascript library. Model similar to the server side models, view consists of html, templates or widgets, controller consists of events and data transfer between the server side and client side. It also includes an additional cool feature called store. store encapsulate the client side cache data Model, say model is data row then store contains data table. Store got an option to auto sync with the data model. based on the need this auto sync option can be switched on/off. while sync'ing a store it will do the necessary dml (insert, update, delete) operations based on data.

Real time communication between the ext js and server side can be achieved by api controller (rest based service). api controller model and ext.js models have two way bindings. So it is easy to pass a model from the client side to the server. It can be configured using the routing configuration.

the client side dynamically communicate with the server side using ext.Ajax (rest api).

Data is retrieving from the server side as json objects. So it is easy to consume the responses from server side.

challenges

Some of the challenges are, how developers interpret the usage of technology, size of the application, time management Etc. If it is not handled properly this challenges can be the difference between the successful and scrapped project.

Prototype in Javascript

2014-07-29T23:35:00.003+01:00

Prototype are link or pointer to other objects. All objects have prototype. Objects are chained together by the prototype chain.

//Constructor
function Office(name, location, domain)
{
this.name=name;
this.location=location;
this.domain=domain;
}

//Prototype

Office.Prototype={
interview: function(){
alert("Hi office location is"+ this.location);
}
};

var myoffice= new Office("expo-e", "london", "telecommunication");

myoffice.interview; // hi office location is london

In the above example

myoffice prototype is shared with Office
Office prototype is shared with object
Object prototype is shared with null

myoffice->Office->Object->null, makes the complete chain of prototype.

when you lookup a property on an object, it will walk up the prototype chain until its found. First my office is checked then the Office is checked, then object and finally it reaches null.

Javascript Closures

2014-07-29T23:21:00.003+01:00

A Javascript closure is when an inner function is inside of an outer function (a function inside a function). The inside function has access to

1. Variables defined in the outer function
2. Argument passed into the outer function

var CreateExample= function(example){
return function(text){
console.log(example +" "+ text);
}
};

var example1= CreateExample("Hi");
var example2= CreateExample("Hello");

example1("test one"); //Hi test one
example2("test two"); //Hello test two.

In most object oriented languages like java/c#, when you reach return all variables declared inside that function get destroyed and memory is freed up.

IN javascript, when creating a closure and return as function, all local variable will remain in memory and accessible.

Can we store wifi and use it later?

2014-07-25T17:04:00.001+01:00

I started using WIFI almost 8 years back (in 2006) when I moved to the UK. Before that, during the engineering degree I studied about WIFI energetically for achieving grades. Nowadays it’s a common friend and every day without her presence, it is awful to envisage. One day my data allowance on the mobile run out and I want to go to an event in central London and want to use the GPS. I had to take map printout and follow the route. I depend a lot on GPS navigation rather than a paper map. So I reached the location half an hour later in the event. Eventually I missed the event and while walking back to the tube station I was thinking about storing the WIFI somehow and using it later, like a battery. People might think why can’t I carry a portable modem and a laptop, but I am thinking about much sophisticated device than that like a battery for the phone.

Did anyone think about a life without batteries now? It is there since most of us on this planet born. In 1749 Benjamin Franklin first used the term "Battery". Ever since it started accruing and become part of everyone, from portable computing devices, mobile phones, electric cars and almost all the devices we are using today. For me the first memory is about a car that run using remote-control (gift for my cousin from his working abroad father).

Is it possible to invent a storage mechanism for WIFI? I don’t know, my connection with electronics is too poorer rather than using the electronic devices. But that day I wished if I have a device or a ‘mechanism’ to store the WIFI and use it later. Like the way mobiles/laptop/ ipad’s are recharging we charge the WIFI device in the evenings and use it throughout the next day. Then we don’t need to worry about the big bills, these corporate mobile providers are sent at the end of the month.

Think about it and share your thought.

Client Certificate Installation on Web application

2014-07-14T16:44:00.000+01:00

Some steps, tips for the installation of client certificate for Webservice and usage.

Microsoft Link

Tech republic Link

Stack overflow

How to do Auditing in web application with Context Info

2014-04-08T15:44:00.001+01:00

Background

Last couple of days I had issues while trying to implement the audit in one of the asp.net application. Especially if tables don’t have the structure to accommodate who modified or when modified fields. So what will do? Is it practical to add all this fields in tables and implement auditing? Yes if you have 5 or 10 tables. What happens if there are 100’s of tables?

I came across this issue. Fortunately some one told about the ContextInfo. Before starting a database connection set the context info with the current user details. And when the operation finishes call a trigger and update the auditing table with contextInfo.

What time context info update?

For all db operation a connection need to open. So conextinfo can be set after the open connection.

create an OpenConnection() method in the base class which all Execute…() methods call, instead of calling cmd.Connection.Open() directly. Then call SetConext method there.

Implementation

1. OpenConnection

internal override void OpenConnection(IDbConnection con)

{

con.Open();

//For Auditing purpose

SetContext(con as SqlConnection);

}

2. SetContext

protected virtual void SetContext(IDbConnection conn)

{

string currentUserName = GetCurrentUserName();

string spName = "sp_set_context";

if (conn != null)

{

if (conn.State != ConnectionState.Open)

conn.Open();

IDbCommand cmd = conn.CreateCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = spName;

IDbDataParameter param = cmd.CreateParameter();

param.ParameterName = "@username";

param.DbType = DbType.String;

param.Size = 255;

param.Value = currentUserName;

cmd.Parameters.Add(param);

cmd.ExecuteNonQuery();

}

3. sp_set_current_context

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE PROCEDURE [dbo].[sp_set_context]

@username nvarchar(256)

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

declare @Ctx varbinary(128)

select @Ctx = convert(varbinary(128), @username)

set context_info @Ctx

END

4.Function

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER FUNCTION [dbo].[f_get_current_user]()
RETURNS uniqueIdentifier
AS
BEGIN

DECLARE @Username nvarchar(256)
DECLARE @UserId uniqueIdentifier
DECLARE @Ctx varbinary(128)
SELECT @Ctx = CONTEXT_INFO()
SELECT @Username = CAST( @Ctx AS nvarchar(256))
IF (@Username is null or @Username = '') select @Username = SYSTEM_USER

SELECT @UserId=UserId from Users where UserName=@Username;

RETURN @UserId
END

5.Trigger

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TRIGGER [dbo].[TR_audit_log] ON [dbo].[TableName] FOR INSERT, DELETE, UPDATE

BEGIN

SET NOCOUNT ON;

IF TRIGGER_NESTLEVEL(OBJECT_ID('TR_audit_log')) > 1 RETURN

DECLARE @user_key uniqueidentifier, @tp INT = 0

IF EXISTS(SELECT 1 FROM deleted) SET @tp = @tp + 1

IF EXISTS(SELECT 1 FROM inserted) SET @tp = @tp + 2

DECLARE @i TABLE (Id int, Name nvarchar(100), audit_data VARCHAR(MAX),

PRIMARY KEY (Id))

DECLARE @d TABLE (Id int, Name nvarchar(100), audit_data VARCHAR(MAX),

PRIMARY KEY (Id))

INSERT INTO @i SELECT Id, Name,

(SELECT Id, Name

FOR XML RAW('audit'))

FROM inserted

INSERT INTO @d SELECT Id, Name,

(SELECT Id, Name

FOR XML RAW('audit'))

FROM deleted

IF @tp = 2

BEGIN

INSERT INTO audit_log ()

END ELSE IF @tp = 1

BEGIN

INSERT INTO audit_log ()

END ELSE

BEGIN

INSERT INTO audit_log (

)

END

SET NOCOUNT OFF;

END

How to get collections on viewmodel on postback in MVC

2013-08-29T00:09:00.002+01:00

In mvc most of the people will face problem how to bind view model list while post request. If a partial control is binding with a list and want to preserve the user input with view model list, most common issue is id/name is same. If the Id/Name are different only MVC engine can bind it with the model.

Please see the below example

Build the view/partial view in the following way. By keeping a row counter means all items will have unique names.

Suppose this partial view is coming inside a View Called MethodName.ASPX and is included inside the

Main Page

using html.beginform()
[httpGet]

{
<%html.dropdownlist(model=>model.Test, new {onclick=Test(<%=model.Id%>);});

<.div id="dvPopulatePartialViewWithList"></.div>

}

Javascript function Test

function Test(id)

{

$.ajax({

type: "Get",

data: "Id=" + Id,

url: '/MyController/GetPartialViewListById',

success: function (result) {

$('#dvPopulatePartialViewWithList').html(result);

}

});

}

Controller Method

public actionresult GetPartialViewListById(int Id)

{

try

{

List list=GetListById(Id);

return renderPartial("MyPartialView",list);

}

catch(Exception ex)

{

throw new exception("error",ex);

}

PartialView MyPartialView

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl>" %>

<%@ Import Namespace="External_ViewModel" %>

<% int rowCounter = 0; //Keep track of unique value for binding to model list

foreach (var model in Model)

{

<%: Html.ValidationSummary(true)%>

<%: Html.Hidden("[" + rowCounter + "].Id", model.Id)%>

<%: Html.Hidden("[" + rowCounter + "].Name", Model.Name)%>

<%= model.nameOfItem%>

[

<%= cav.Item%>

]

<%: Html.TextBox("[" + rowCounter + "].Value", model.Value, new { Style = "width:140px;" })%>

<%: Html.ValidationMessage("[" + rowCounter + "].Value", model.Value)%>

<% ++rowCounter;

} //end foreach Loop

In Controller create the action like this

[httpPost]

public ActionResult MethodName(ViewModel model, List resultList)

{

// when you submit the form resultList will have binded values

}

Entity framework practices

2013-08-28T15:31:00.001+01:00

People who are using entity framework for Dal single dbcontext is going to be a problem in BLL. I use the following structure

I used to get the single dbContext by:- Each single repo class should inherit from base repo class and in base repo class should initialise the dbcontext.

The BaseRepository

public class BaseRepo

{

private readonly bool isNewInstance;

protected OnlineProductLinkEntitiesdbContext;

protected BaseRepository()

{

dbContext = newOnlineProductLinkEntities();

isNewInstance = true;

}

protectedBaseRepository(OnlineProductLinkEntitiesdbContext)

{

isNewInstance = dbContext == null;

if (isNewInstance)

dbContext = newOnlineProductLinkEntities();

this.dbContext = dbContext;

}

protected voidCheckAndTryToOpenConnection()

{

if (dbContext == null)

dbContext = newOnlineProductLinkEntities();

if (dbContext.Connection.State !=ConnectionState.Open)

dbContext.Connection.Open();

}

public void Dispose()

{

if ((!isNewInstance) || (dbContext ==null))

return;

OnlineProductLinkEntities context = (OnlineProductLinkEntities)dbContext;

if (context.Connection.State ==ConnectionState.Open)

{

context.Connection.Close();

}

context.Dispose();

dbContext=null;

}

The single repo class constructor looks like

public Cmo_SiteRepository(){}

public singleRepo (OnlineProductLinkEntitiesdbContext):base(dbContext), Irepository<model, entity>

{ }

A method inside the single repo class will look like this

public int Create(SiteModel model)

{

try

{

CheckAndTryToOpenConnection();

objectTable siteEntity = newobjectTable ();

}

catch (Exception ex)

{

throw new Exception("Exception", ex);

}

How to add a stored procedure in Entity Framework

2013-07-17T10:23:00.004+01:00

Step1- Open the .edmx file
Step2- Right click in .edmx file and select Update Model from Database

Step3- Select Add tab, select Stored Procedures and select the procedure you want to add and click finish as shown in below figure a

Step4- Build the Entity Project to make sure nothing is broke

Step5- Right click on .edmx file and select Model Browser

Step6- Model Browser Popup will appear as below figure. Click on the Strored Procedures in PricingToolModel.Stroe and click the newly added SP (it will appear here)

Step7- The Add Function Import screen will appear

Based on the return we can set up.

If you are returning a multiple column Click on the Get Column Information First, then click the new Complex Type. After that you can see the Return of Collection will select the Complex and a complex type is generated by EF

If its returning scalar you can select which return type like int, string etc...

If its return entitty (means table) please select the correct table from the list..

Click OK, Then your stored procedure added to EF

Step-8 Access the Stroed Procedure Eg- For a complex model
ReturnModel returnModel = new ReturnModel();
using (Entities context = new Entities())
{
var list = context.spGetMyStoredProcedure(Id).ToList();
returnModel= (from b in list
select new ReturnModel () { Id= Convert.ToInt32(b.Id),
Name = b.Name,
Address=b.Address}
).Distinct().ToList();
}

Where do you see yourself in next 5 year period?

2013-07-13T15:06:00.001+01:00

This question is dedicated to every one who is searching for job. What kind of job you applying, you will meet this question some where in the selection journey. There are lots of techniques available to answer this question. Try to create an answer from your own experience or from field. Some examples are

First example

I am definitely interested in making long term commitment to my next position. What you have told me and from the job description, it is exactly what i am looking for and what i am very grateful to do. In terms of future career plan i am confident that if i do my work with excellence, the opportunities will definitely knock my doors. It is always been that way in my career and i am confident i will surely have the similar opportunity here. I will do the job to best of my ability and keep my eye open for the opportunities in the organisation. I am prepared to learn new things and ready to contribute to the overall success of the organisation in a number of ways as it required.

Second example

Actually there is a lot i can accomplish in next 5 years. Obviously i like to really establish myself in my career to learn as much as i can and find a place where i can make positive impact. I had a couple of jobs in the past including my current job. So i understand the value of a good and stable position. I learned a quiet bit from each position- technical skills, how to communicate, how to adapt in a team etc. I being looking for a right opportunity with in an organisation that has a bright future and i know my creative energy and people skills will come in handy. Five years down the road i will put those skills in good use and will learn new ones along the way.

If any body want a customized answer for their job profile please don't hesitate to contact me at

adarshsoman@jobinterviewtrainer.co.uk or adarshsoman@gmail.com

How to Improve Linq Query Performance by using Parallel/ PLinq

2013-04-02T13:09:00.000+01:00

How to Improve Linq Query Performance by using Parallel/ PLinq

I want to highlight the disadvantage first, because if you know the disadvantage you can make a choice if required in your project or not.

Don't use if you have a Single core or dual core CPU's. I found that depending on the complexity of For loop the CPU performance reaches more than 70-80% (Not talking about the simple For loop). So if you want to use the parallelism for complex loop make sure you have more than 2 CPU's

Parallelization sometimes cause a PLinq query to run slower than Linq to object equivalent. Basically it said like queries with few data source elements and fast user delegates are reluctant to speed up much.

Parallel Linq is the parallel implementation of Linq. Parallel Linq implementation on loops provide better performance compared to sequential loop. Parallel Linq also works like Linq queries operate on any in-memory IEnumerale(of T) data source. PLINQ make full use of all processors on the system. The parallelism is achieved by diving the data source into multiple segments and working each segment on different worker threads on multiple processor.

MaxDegreeOfParallelism - Upper limit of number of processors irrespective of number of cores(We can only specify the maximum )limit.. So even if also if we don't use the CPU , no extra task will run in parallel.

Implementation

List testModelList=GetTestModelList();

Parallel.ForEach(testModelList,

new ParallelOptions { MaxDegreeOfParallelism = 5 },

tm=>; {//Do Operations

});

Reference:http://msdn.microsoft.com/en-us/library/dd460688.aspx

Tips To Becoming A Leader At Work

2013-03-26T14:55:00.003+00:00

Recently i read an article from Yun Siang Long At Careerealism

So Thought To Share With My Readers With Some Modification.

1. Take Accountability

Take the accountability for anything that has your iconic belief in it. That means, as long as you participate in the project, you have a hand in the failure of the project.

Learning accountability means not just the good/successful things, but even the bad/failed ones. Always find the best way to admit mistakes - it’s all right to be wrong, but need to identify and sort out. You cannot become a master, if you have not made any mistakes. One of the examples coming to my mind is Dr APJ Abdul Kalams Press Conference after a failed PSLV launch. He took the whole events in his shoulder and briefed the media with out exposing his colleagues.

2. Always trust In Win-Win

Each time a wave falls down they rise again – always think win-win. If we met failure also believe win is around the corner or down the road. If you want to be a leader at work, always believe in your hands as leader to change the world, even though others think you are crazy. Never look around the world. Try to inspire the colleagues or people around with innovation, aspiration and new thoughts and show them how to dream greater heights.

3. Push The Envelope

Try new things. Take some risk. Make yourself uncomfortable. Leaders loves to take risks. They are not afraid of doing what they believe can do. To be a leader at work, you need to take even simple risks like taking on the project no one wants.

4. Do It, Show It

This world is full of people who talk too much and don’t do enough to full full those talkings. If you want to be a leader at work, act upon Something. If you have any ideas that are simmering in your mind, write it down, try to implement.

5. See Opportunities Everywhere

There is no need to create opportunities for yourself to lead. The opportunities to lead are everywhere. You need to be mindful of these opportunities. I have just mentioned one earlier. Are there any opportunities to take on the project no one wants? If you don’t see opportunities everywhere, you are missing the point.

6. Be Open

Be open to criticism, otherwise you are just living off yourself. What does it mean? When you are open to feedback, you are being fed ideas from others that are free. Often times, these ideas come from people smarter than you. They will give you tips on how to improve and how to be better. That’s what a leader needs - constant feedback. You need feedback to be a leader at work, otherwise you are “feed-own” and you will go hungry soon. With no new ideas, a leader dries up.

7. Give, Give, Give

That’s how you open up. Pour out all you got from inside you. Give all you have ideas, thoughts, plans. Feel the vulnerability and learn to like it. When you pour all your ideas out you will need new ones. Where do new ideas come from? From critics who want to tear you down, from well-meaning supporters and from people you least expect. More comes back to you. You have more to input. It enriches you. That’s how you become a leader at work. These are the seven actions to position yourself as a leader at work. You want to be a leader at work? Do not be afraid of taking risks. You have more to gain than lose when you open up.

Orginal Link:

http://www.careerealism.com/tips-becoming-leader-work/?othersrcp=15673&wExp=N

Interviewer category

2012-11-18T01:57:00.000+00:00

I attended a couple of interviews during my 5+ year career and and the experience of my friends circle, especially for getting the first opportunity in the UK and came across various types of interviews. Based on that limited knowledge I can categorize the interviewers into 4 categories

1- Technically well sounded interviewer

2- Interviewer who has taken a list of questions and asking only those questions

3- Interviewer have no idea about technology they are recruiting for but know about the kind of business the company is doing

4- An interviewer who speaks more about the problems they faced with during the ex- colleagues

Category-1 technically well sounded interviewer

I came across 25-30%of technically sounded interviewers. They had clear idea about what they are recruiting for. Manipulating such an interviewer is a big issue. For all interviews basic thing we need to keep is try to be honest for 100% . But in front of a technically sounded person and who know what he is doing try to be 150% honest. If you try to fool him you won't be getting the job.

Category2-interviewer who has taken a list of questions and asking only those questions

I came across 30-40% interviewers this kind. They usually refer some commonly asked online interview questions and make them as interview. Manipulating them is very much easy. Prepare the interview with related technology Q&amp;amp;amp;a. If you don't get time to prepare all at least go through commonly asked interview questions.

If you go through 2,3 interview and you prepare every interview with commonly asked questions, getting a job in 3 interviews is much guaranteed.

Category 3- interviewer have no idea about technology they are recruiting for but knows about the kind of business the company is doing

I came across 20-25% this kind of interviewer during my 5 years career.

People who might become managers or development head with different kind of skill set and very Less knowledge about the technology they are recruiting for.

They will ask very limited technical questions but ask more business problems.

Like if I have to access a web service from third party how you will design the system. Tackling this kind of interviewers is difficult job unless you are very good knowledge about the work you are doing. This kind of people less worried about the technical questions, but might be they will ask one or two technical questions. But getting an offer from this kind of people is very difficult if you are a starter or a graduate job finder.

Category 4- interviewer who speak more about the problems they faced with the ex- colleagues

I came across 10-15 % interviewers of this kind.they won't be satisfied with any kind of answers. But there are good opportunity to get job also from this people. Can tell an example might be they are not satisfied with 14 previous interviews and if you performed bit better than previous 14 this people might offer you the Job. This kind of interviewer will give you very less opportunity to talk. They will only blame about what went wrong when previous employee did the job. They only talk about the problems they faced during last 6-10 months. They don't want to listen to the candidate skills or passion. My advice is if you get an offer from such kind of people stay away from that. Because they will not be happy with you after 6 months of job. They always want more. Like if the system is not working after 5.30 pm this people want you to work and finish the job, but they won't be ready to pay any kind of compensation. If your work is staring at 9 am you need to be office at 9 am.

Like employers have opportunity to select the candidates, candidates are also need to decide which employee they want to work for. Because if you have a real passion for your work some categories of people will make you as a person who hates jobs

I this 4 category if you get in first category or third category you will really get some opportunity to enjoy the work. 2nd category is in tolerable range but stay away from 4th category.

At the mean time if you are an interviewer please identify which group you belong.

How to write secure mvc application using encrypting URL

2012-10-07T23:46:00.000+01:00

There are lots ways available to write the secure Mvc application. In my experience I came across lots of secure application in public facing. I want to tell about some of the mechanism I followed.
1- encrypting the URL Parameters and preserving id's encrypted on the client side
1- I always make sure if I pass Id or any sensitive data into the view always make sure it's encrypted. By doing so make sure if we forced to use HTML.hidden or HTML.hidden for have the encrypted values, in action link if I pass any parameters from the client side (eg:- edit or create or navigating between different actions we can make sure that all the values are encrypted)
During the design of the actions results if it's http get I usually encrypt the sensitive data
[httpget]
Public actionresult display()
{
TestModel testModel=new TestModel();
testModel.id= encrypt(id);
Return View(testModel);
}
[httppost]
Public ActionResult Display(string id)
{
Guid d_id= new Guid(decrypt(id));
// do operation with id
// edit, view, create
String e_id=encrypt(d_id);
Return RedirectToAction{"edit", e_id);
}
By following above encryption mechanism In view if you use the following code
<%:html.hiddenfor(model=>model.id);%>
Or <%:html.hidden("id", Model.id);%>
Also we can make sure that the id won't be visible to the public.
Thanks
Adarsh

A project management experience at the eve of release

2012-09-27T21:34:00.001+01:00

Last 2 months I was not updating my blog because I was busy with some interesting opportunities in my career. Today I am writing this blog on the eve of a project release. Even though I have been involved in a lot of projects for more than 4 years, this is the project that went through all the process estimation, planning, design, implementation, uat and release happened as perfectly as planned. So I thought of sharing my wonderful experience with all my readers. This is the project my organization decided to outsource. But I am showing in my interest to manage this project to our commercial director. Finally lots of management level meeting finally it came to me, but with strict deadlines. On August first week commercial director given green signal for this project and given a business analyst to discuss the business needs. Myself will manage the project in terms of the technical side and the product side business analyst will help to get the requirement. I already worked with this business analyst in my previous projects and we personally have a better mutual understanding each other. Whatever I think, he can understand really well and his thoughts are always can make perfect impact on me. So this bonding already placed the foundation for a big project success. Myself and Ba initially planned an appointment with the project requester and taken the initial requirement. After that meeting I really understood we can deliver this on time even though the project requester got some doubt. I worked lots of big projects in my previous company and I always followed the way my team leads and project managers handled the projects. One of the big project that came to me was a British airways group project and the way my project manager leads the project. In my current organization even though we are saying we are following agile Scrum, but we never kept and progress bar for that. So first change I introduced in this project is the use of the physical progress bar with tickets. Then looking at the board I really can understand the progress of work. Once we got the requirement I divided this to user stories And created bug track items. Once all the stories are put down in the team foundation server, next is dividing the stories into granular level task an updated the progress bar. When my progress bar was filled with tickets some of my team members shown their disinterest in it. They were asking why we need a physical progress board when we had Tfs. My answer was simple every time it's not easy to TFS and understand the progress. I need the progress in my eyes whenever I needed. Now in the eve of the release I can say confidently it helped my project management 100%. Around 15 august me and Ba had a meeting with our managing director. Initially he was forced to send the project for outsourcing. He was bargaining with the deadline. I looked the calendar and my progress board. I have given first of October as release date a two week prior to that will go for uat and sales training. He agreed the date. Now the ball reached my court. 6 week time need to go live and in 4 week time need to go uat and resources for me was limited. This is the first time I am committing a deadline to senior management and the business was looking on this project. I am confident of one thing . My estimations will not go wrong because we clearly got the requirement and I divided the task and I will be able to finish the work in 22 working days. But the main issue was the change of requirement. it can happen at any time because the company is going through a transition period. All the company's premium products are re-branding and lots of new products are introduced by the product team. I took the technical decision which technologies were used. Already we were using mvc2 in other projects. When I did research I found that mvc3 is more stable and can get the built in view engine support. So I preferred mvc3. When the design of the system started I have given importance to usability and performance and uniformity in the process. Color schemes image is used in correlation with the branding that provided by marketing. Coding finished in 13 days time and given a first demo to the project requester and the managing director from last week of August. Initially it was supporting the next generation internet connection. But the request comes for lot of bespoke product that our company is providing as a business solution to our customers and partner like sip connect data center connectivity to partners and data centre connect with multiple end point, carrier connectivity, smart internet service. Smartwire etc. When I deployed for the staging first time I came across lots of issues relating ISO standards. Example like Servers are maintained by NMS Team. Port and firewall by core network team etc. I am so fortunate that time the systems manger he was with my current organization for more than five years came to support me to sort out this issue. Any ways as promised we deployed the system for Uat in last Monday 17 of September. Last 8,9 days lots of testing happened for different areas some form sales guys some from partners some from business analysis some from commercial team some from my team brand testing by marketing etc and fixed a lot of issues. Whenever something is went wrong my colleagues step up and delivered the standard that we expected from a development team. Finally the big D day arrived. 3 days prior to the initial estimation I am releasing the project tomorrow. My team did a wonderful work. We are not claiming the system is 100% perfect. But we can assure from the end user perspective we can remove a lot of pressure and we can take them into a new user experience. There will be new versions coming in the next few months. But as a starting point I am proud everyone associated with this delivered. This small small contribution takes this to a stage where we can tell the user come and experience one of the best solutions for the telecommunication domain. Here in this world success only matters. I pray to the god please convert all our hard work to a big success. If I fail tomorrow nobody care about the past what I delivered, I know that as well. With this I am concluding. Hope all have great times. God bless you.