Software categories

Computer software

1. Application Software
2. System software
3. computer programming tool
4. Mobile software & Apps

Application software

https://en.wikipedia.org/wiki/List_of_software_categories

https://en.wikipedia.org/wiki/Enterprise_software

Supply chain management (SCM) is the management of the flow of goods and services.It includes the movement and storage of raw materials, work-in-process inventory, and finished goods from point of origin to point of consumption

Enterprise resource planning (ERP) is business management software—typically a suite of integrated applications—that a company can use to collect, store, manage and interpret data from many business activities, including:

• Product planning, cost
• Manufacturing or service delivery
• Marketing and sales
• Inventory management
• Shipping and payment

Enterprise asset management (EAM) is the optimal lifecycle management of the physical assets of an organization

Customer relationship management (CRM) is an approach to managing a company’s interaction with current and future customers. It often involves using technology to organize, automate, and synchronize sales, marketing, customer service, and technical support.

A content management system (CMS) is a computer application that allows publishing, editing and modifying content, organizing, deleting as well as maintenance from a central interface. Such systems of content management provide procedures to manage workflow in a collaborative environment.

DotNetNuke

Umbraco

Business process management (BPM) is a field in operations management that focuses on improving corporate performance by managing and optimizing a company's business processes

Enterprise resource planning (ERP)
SAP(ERP)-it is ERP system.
supplier relation management(SRM)-procurement & logistics
cloud,
SMS,payment gateway,
e-commerce,
audit of software/
BI reports-Database analysis /power BI /spotfire/ tableau/ qlikview
highcharts

mobile apps

App_Code folder does not work with Web Application Projects.

If your application is a Web Application project rather than a Web Site project, the code files should not be in the App_Code folder (stupid design).

Solution:
1)Build Action of class.cs to be changed from "Content" to "Compile".

2)Create a new folder or something and put class files in there.

increase performance of visual studio 2012

Goto Tools>Options>Environment>Add In Security
You will see a checkbox with “allow add in components to load” .Just uncheck it. Restart the IDE and check the lightning speed of the IDE now

https://www.youtube.com/watch?v=XFdBpNc2oaM

try “Tools”-”Options”-”Enviroments and Updates” and disable “Automatically Check for Updates. 

Tools > Options -- CHECK "Show all options"

• IntelliTrace -- DISABLE
• HTML Designer -- DISABLE

50% startup speedup

Tools > Options

• Environment > Add-in/Macros Security -- UNCHECK "Allow Add-in components to load"

Tools > Extension Manager

• Uninstall all you don't need.

Tools > Options > Environment >

• Uncheck "Automatically adjust visual experience based on client performance"
• then uncheck "Enable rich client visual experience".

Tools > Options > Environment > Startup:

• At startup = "Show empty environment"

Tools > Options > Source Control

• Set to "None"

Tools > Options > Environment >

• Uncheck "Automatically adjust visual experience based on client performance"
• then uncheck "Enable rich client visual experience".

Tools > Options > Environment > Startup:

• At startup = "Show empty environment"

Tools > Options > Source Control

• Set to "None"

The only way I know to improve the performance is to disable Edit & Continue option.. Tools -> Options -> Debugging -> Edit & Continue (uncheck the option)

Review a few magical settings (Most impact)

When an ASP.NET website is loaded for the first time, it pre-compiles all your pages and user controls. Once done, everything runs faster. This is great for production websites, but horrible for your development machine. Why?  When programming, you’re usually only modifying a page or two (or back-end code). You’ll iteratively make a change, compile, launch the website, test, and start over; often dozens of times. A two minute compile/load time (like we had) forces you to lose focus and get distracted. The following setting makes pre-compilation more selective, making the first load time massively faster in development scenarios. On my machine, it cut the first load time from around 74 seconds to 6 seconds.

<compilation ... batch="false"> ...</compilation>

Restart your IDE after these and you should observe a noticeable speed increase.

Asp.net server controls from scratch

we can then build reusable visual components for our web application’s user interface by creating our own controls.We can add this custom .dll in GAC and can share with other control too.We can create a custom control that inherits from another server-side control and then extend that control. We can also share a custom control among projects.

step to create project
1) create project -Asp.net server control -this is used to create dll

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace ServerControl1
{
    [ToolboxData("<{0}:VideoPlayer runat=server></{0}:VideoPlayer>")]
    public class VideoPlayer: WebControl
    {
        private string _Mp4Url;
        public string Mp4Url
        {
            get { return _Mp4Url; }
            set { _Mp4Url = value; }
        }

        private string _OggUrl = null;
        public string OggUrl
        {
            get { return _OggUrl; }
            set { _OggUrl = value; }
        }

        private string _Poster = null;
        public string PosterUrl
        {
            get { return _Poster; }
            set { _Poster = value; }
        }

        private bool _AutoPlay = false;
        public bool AutoPlay
        {
            get { return _AutoPlay; }
            set { _AutoPlay = value; }
        }

        private bool _Controls = true;
        public bool DisplayControlButtons
        {
            get { return _Controls; }
            set { _Controls = value; }
        }

        private bool _Loop = false;
        public bool Loop
        {
            get { return _Loop; }
            set { _Loop = value; }
        }

        protected override void RenderContents(HtmlTextWriter output)
        {
            output.AddAttribute(HtmlTextWriterAttribute.Id, this.ID);
            output.AddAttribute(HtmlTextWriterAttribute.Width, this.Width.ToString());
            output.AddAttribute(HtmlTextWriterAttribute.Height, this.Height.ToString());

            if (DisplayControlButtons == true)
            {
                output.AddAttribute("controls", "controls");
            }

            if (PosterUrl != null)
            {
                output.AddAttribute("poster", PosterUrl);
            }

            if (AutoPlay == true)
            {
                output.AddAttribute("autoplay", "autoplay");
            }

            if (Loop == true)
            {
                output.AddAttribute("loop", "loop");
            }
            output.RenderBeginTag("video");
            if (OggUrl != null)
            {
                output.AddAttribute("src", OggUrl);
                output.AddAttribute("type", "video/ogg");
                output.RenderBeginTag("source");
                output.RenderEndTag();
            }

            if (Mp4Url != null)
            {
                output.AddAttribute("src", Mp4Url);
                output.AddAttribute("type", "video/mp4");
                output.RenderBeginTag("source");
                output.RenderEndTag();
            }
            output.RenderEndTag();
        }

        protected override void Render(HtmlTextWriter writer)
        {
            this.RenderContents(writer);
        }
       
    }
   
}

build it.it will create dll.add this dll in Toolbox and use in other project.

2) Next required any asp.net project to use this dll and show on page.

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<%@ Register Assembly="ServerControl1" Namespace="ServerControl1" TagPrefix="cc1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <cc1:VideoPlayer ID="VideoPlayer1" runat="server" Mp4Url="http://techslides.com/demos/sample-videos/small.mp4" OggUrl="http://techslides.com/demos/sample-videos/small.ogv" Width="400" Height="400"  />
    </div>
    </form>
</body>
</html>

run on Google chrome browser.

Understand horrible database

I never got fresh database.it's my bad luck so I always deal with old database which are created by someone who already left the company.Due to this situation,I have wasted so much time while developing or finding bug.Today I got some tips on Google. Hopefully It will help me in future.

1) Create E-R diagram

2) Examine each table and column make sure the meaning of what it stores.

3) Examine each relationship and make sure how the tables relate to one another
or

1) Understand the project flow from front end code or any document

2) find master table and it's transaction table whose having same column ID name

First I look up for the "Master Table", then, with pen and paper, I start mapping the relations with other tables, after that, if there's some app code to look at I start making some raw sketches on how the data flows.See if the option of a Knowledge Transfer session is available to you, and if so, take full advantage of it.


--Find multiple table by using column name

SELECT * FROM ALL_TAB_COLUMNS 

 WHERE COLUMN_NAME LIKE '%TASK%' 

 AND owner = 'database_name';


--Find Column named like 'blah' in a specific table 

SELECT O.NAME, O.ID, C.NAME, O.XTYPE 

FROM SYSOBJECTS O LEFT JOIN SYSCOLUMNS C ON O.ID=C.ID 

WHERE C.NAME LIKE '%SearchFor%' 

AND O.XTYPE IN ('U','V') 

AND O.Name like '%TableName%' ORDER by O.Name


--Find all Columns in DB with name like 'blah' 

 SELECT O.NAME, O.ID, C.NAME, O.XTYPE 

FROM SYSOBJECTS O LEFT JOIN SYSCOLUMNS C ON O.ID=C.ID 

WHERE C.NAME LIKE '%SearchFor%' 

AND O.XTYPE IN ('U','V') ORDER by O.Name

select a.table_name, column_name,DATA_TYPE,DATA_LENGTH 

from all_tab_columns a,USER_ALL_TABLES u
where a.TABLE_NAME=u.TABLE_NAME
and column_name like ‘empid%’  order by DATA_LENGTH desc;

yes we can do a similar search in all views. Here is your query. 

Hope this helps you.. Let me know.


select a.table_name, column_name,DATA_TYPE,DATA_LENGTH 

from all_tab_columns a,ALL_CATALOG u
where a.TABLE_NAME=u.TABLE_NAME
and column_name like upper(‘latitude%’)
and u.table_type=’VIEW’
and u.owner=’YOUR_OWNER’
order by DATA_LENGTH desc;


Find child Table

SELECT table_name FROM ALL_CONSTRAINTS WHERE constraint_type = 'R' -- "Referential integrity" AND r_constraint_name IN ( SELECT constraint_name FROM ALL_CONSTRAINTS WHERE table_name = '[TableName]' AND constraint_type IN ('U', 'P') -- "Unique" or "Primary key" )


select table_name, constraint_name, status, owner from all_constraints where r_owner = :r_owner and constraint_type = 'R' and r_constraint_name in ( select constraint_name from all_constraints where constraint_type in ('P', 'U') and table_name = :r_table_name and owner = :r_owner ) order by table_name, constraint_name

NIce link for software development

Difference between ASP.NET MVC and ASP.NET Web API

Comparing Asp.Net Web API Routing and Asp.Net MVC Routing

Securing ASP.NET Web API using basic Authentication

What is Web API and why to use it ?

Security in ASP.net MVC by using Anti-Forgery token - CodeProject

SQL

What is Normalization in SQL ? - SQLServerCentral

Aggregate Functions in SQL Server 2008

SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example | 

Journey to SQL Authority with Pinal Dave

SQL Server Transactions and Error Handling - CodeProject

Merge Statement in SQL Server 2008 - CodeProject

A Closer Look Inside RAISERROR - SQLServer 2005 - CodeProject

MVC

ASP.Net MVC Life Cycle

MVC Application Lifecycle - CodeProject

A Beginner's Tutorial for Understanding Filters and Attributes in ASP.NET MVC - CodeProject

Differences and Similiarities Of Html.RenderAction and Html.Action Method

RenderPartial vs RenderAction vs Partial vs Action in MVC Razor

Partial Classes in C# With Real Example - CodeProject

Areas in ASP.NET MVC 4 - CodeProject

What Are Areas in ASP.Net MVC - Part 6

MVC Data Annotations for Model Validation

MVC Areas with example

Asp.net MVC Request Life Cycle

Exception or Error Handling and Logging in MVC4

ASP.NET MVC – What Are the Uses of DataType and DisplayColumn Attributes? - CodeProject

Layouts, RenderBody, RenderSection and RenderPage in ASP.NET MVC

Custom Authentication and Authorization in ASP.NET MVC

Understanding ASP.NET MVC Scaffolding

Understanding HTML Helpers in ASP.NET MVC

Understanding ASP.NET MVC Filters and Attributes

How to pass javascript complex object to ASP.NET Web Api and MVC

What is the difference between each version of MVC 2, 3, 4, 5 and 6? (MVC Interview Questions)

ASP.NET MVC3 Vs MVC4 Vs MVC5 Vs MVC6 - Web Development Tutorial

Exception Handling in MVC - CodeProject

C#.net

Basic Object Oriented Programming (OOP) Concepts

c# - What is Shadowing? - Stack Overflow

Virtual vs Override vs New Keyword in C# - CodeProject

IEnumerable VS IQueryable

Difference between ref and out parameters

Differences between Object, Var and Dynamic type

Jump statements in C#

Difference Between Constant and ReadOnly and Static

Understanding Boxing and Unboxing in C#

A Deep Dive into C# Abstract Class

Understanding Delegates in C#

A Deep Dive into C# Interface

Introduction to Entity Framework

Implementation of Dependency Injection Pattern in C#

Introduction to Ado.net

Understanding LINQ Standard Query Operators

Understanding Single, SingleOrDefault, First and FirstOrDefault

Different ways to write LINQ query

Difference between Select and SelectMany in LINQ

Difference Between Finalize and Dispose Method

.Net Garbage Collection in depth

Enums and Structs in C# - CodeProject

Partial Class, Interface or Struct in C Sharp with example

ViewData vs ViewBag vs TempData vs Session

What are Access Modifiers in C#?

Understanding Relationship Between CTS and CLS

What is IL code, CLR, CTS, CLS & JIT? - CodeProject

what is access modifier in c# - ASP.NET,C#.NET,MVC,JQuery,JavaScript,SQL Server,WCF examples

Constructor in C Sharp

C# Heap(ing) Vs Stack(ing) in .NET: Part I

Structs - The complete C# Tutorial

What are sealed classes and sealed methods

Implementation of Dependency Injection Pattern in C#

Understanding Inversion of Control, Dependency Injection and Service Locator

Access Specifier or Modifier in C# | MY.NET Tutorials

C# Hashtable Examples

C# - Hashtable Class

Difference between Generics and Collections with example

C# - Difference between Array and Arraylist in C# with Example - ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL Server,Ajax,SSRS, XML examples

Difference between Deferred execution and Immediate execution

Differences Between Hashtable and Dictionary

How to Use Take/TakeWhile and Skip/SkipWhile in LINQ

C#/.NET interview Question - What are the different types of collections in .NET ... - DotNetFunda.com

Understanding 4 Types of AJAX Frameworks | Elance Blog

design patterns - What is dependency injection? - Stack Overflow

StringBuilder C#

C# - Difference between String and Stringbuilder in C#, Asp.net - ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL Server,Ajax,SSRS, XML examples

Singleton VS. Static Classes

Asynchronous Programming in C# 5.0 Part 1: Understand Async and Await

Parallel Programming in .NET Framework 4: Getting Started | C# Frequently Asked Questions

Async and Await

Constructors and Its Types in C# With Examples

OOPS

Diving into OOP (Day 5): All About C# Access Modifiers (Public/Private/Protected/Internal/Sealed/Constants/Static and Readonly Fields) - CodeProject

Object-Oriented Programming Concepts

ASP.Net

ASP.NET Life Cycle

Secure web hosting

IIS 7: Generate CSRs (Certificate Signing Requests) | SSL Certificates - GoDaddy Help

IIS 7: Install a certificate | SSL Certificates - GoDaddy Help

AngularJS

AngularJS Tutorial | Dot Net Tricks

AngularJS Tutorial

Major s/w implementation

Address Information API Guide

US Street Address API documentation - SmartyStreets

SecureFTP

Secure FTP Upload and Download

Download, Upload files from SFTP Server in C# | Cybarlab

Build a Home FTP Server with FileZilla

File uploaders

HTML5 Image uploader with Jcrop | HTML5 and CSS3 Tutorials at Script Tutorials

jQuery HTML5 Uploader

How to submit additional form data · blueimp/jQuery-File-Upload Wiki · GitHub

Page Closing Confirmation with jQuery Custom Event

parrots/SignatureToImageDotNet · GitHub

Options · blueimp/jQuery-File-Upload Wiki · GitHub

Client side Image Resizing · blueimp/jQuery-File-Upload Wiki · GitHub

jQuery Signature Pad Compression/Decompression algorithm

US English Address List

http://173.236.87.106/PresPro/

MVC Sitemap Provider tutorial 2 – Breadcrumbs « Ed Spencer's Blog

Google API useful

Admin console

Google APIs Console

Blog.CoenGoedegebure.nl: Accessing Google Drive from .NET

An internal error occurred loading p12 certificate

Google Drive SDK — Google Developers

Google APIs Console

Drive API Client Library for .NET - Google APIs Client Library for .NET — Google Developers

OAuth 2.0 for web applications - AdSense Management API — Google Developers

OAuth2 flows - API Documentation

Google Drive SDK — Google Developers

Implementing OAuth 2.0 Authentication - YouTube — Google Developers

Using OAuth 2.0 to Access Google APIs - Google Accounts Authentication and Authorization — Google Developers

code-e: .NET, OAuth2, and the Google Analytics Service account.

OAuth 2 Simplified - Aaron Parecki

Google Apps Platform — Google Developers

Google Drive SDK — Google Developers

asp.net - Google Drive API .Net Issues - Stack Overflow

Google Drive API v2 | Daimto

Google Drive SDK — Google Developers

Google Drive SDK — Google Developers

Google Drive SDK — Google Developers

Google Talk Developer Documentation - Google Talk for Developers — Google Developers

[Solved] How to read mail from Gmail using C#.net - CodeProject

C# - Retrieve Email from Gmail Account, fetch email from gmail , how to access gmail inbox, get mail from inbox of gmail in c#

Google Apps Application APIs - Google Apps Platform — Google Developers

Read Gmail Inbox Message in ASP.NET - CodeProject

5 things you didn't know you could do with the Google Drive API - Google Apps Developer Blog

Retrieve Email and Parse Email in C# - Tutorial

Accessing Google Spreadsheets with C# using Google Data API - Stack Overflow

Gmail functionality send , delete , read , unread , archive in c#.net : The Official Forums for Microsoft ASP.NET

.NET Client Library Developer's Guide - Google Data APIs — Google Developers

https://developers.google.com

SMS sending

Sending SMS using .NET - CodeProject

.NET SMS gateway. Bulk text message API

Wire2Air SMS API Information

Wire2Air Simple HTTP API.doc

Wire2Air billing : What is text credit and how many credits required to deliver one text message? – Wire2Air Customer Service Portal

Email verification

Quick Start — Real Time Email Verification API 1.0.9 documentation

C# — Real Time Email Verification API 1.0.9 documentation

Email Verification API Demos - emailverifyapi.com

Email Verification API

News API

RestApi - feedzilla-api - Feedzilla RESTful API method documentation - Documentation for Feedzilla News API - Google Project Hosting

File listing

Dynatable.js - jQuery plugin for HTML5+JSON interactive tables and more

National Rate Calculator

Estimator

Advantage Title - Title Rate Calculator

Stewart Title Insurance Company - Rate Calculator for the State of New York

Hacking

ASP.NET MVC security and hacking: Defense-in-depth - Muaz Khan

SQL Injection Attacks by Example

The Web Application Security Consortium / Information Leakage

How to Handle Cross-Site Scripting in ASP.NET MVC Application?

What is Cross-site Scripting and How Can You Fix it?

What is the AntiForgeryToken and why do I need it? - ASP.NET MVC 101 series

Cross-site request forgery - Wikipedia, the free encyclopedia

c# - ValidateAntiForgeryToken purpose, explanation and example - Stack Overflow

SQL Server Performance Preventing Parameter Tampering in ASP.NET MVC

Securing Your ASP.NET MVC Apps

Hack proof your asp.net applications from Session Hijacking - CodeProject

Download Dynamic IP Restrictions for IIS 7 - RC (x64) from Official Microsoft Download Center

Javascript Obfuscate and Encoder

Utility

ColorPicker.com - Quick Online Color Picker Tool

Regular Expression Cheat Sheet (.NET Framework)

RegExr

GIF Categories - Giphy

Free Online YouTube Downloader: Download YouTube Videos, Facebook and many others!

Convert JPG to PDF for free - JPG to PDF online converter

Icon Archive - Search 502,564 free icons, desktop icons, download icons, social icons, xp icons, vista icons

Poor SQL - Instant Free and Open-Source T-SQL Formatting

IP Lookup - IP Locator, IP Location, IP Address Lookup, IP Finder, Reverse DNS, Nameservers

Hex-to-RGB Color Converter

Removal of pdf pages online

Online Image to Icon Converter

.NET Regex Tester - Regex Storm

CSS3 Generator

Catch online videos with Catchvideo.net and convert them to MP3 from Youtube, Dailymotion, Vimeo videos for free

Striket̶h̶r̶o̶u̶g̶h̶ text for Facebook & Twitter

TinEye Reverse Image Search

The easiest way to learn electronics and Arduino programming | 123D Circuits by Autodesk

Iconmaker

loading.io - Your SVG + GIF Ajax Loading Icons

33,200 Free Icons - The Largest Icon Pack Ever

Programming Tips

Username Availability Check in ASP.NET Web Forms with jQuery Validation Plugin | TechBrij

ASP.NET MVC3 Dynamically added form fields model binding

Culture Names [C#]

Building Modern Web Apps with ASP.NET - A new day of free ASP.NET Training for 2014 - Scott Hanselman

Scott Hanselman - Coder, Blogger, Teacher, Speaker, Author

Google reCAPTCHA in ASP.NET MVC

SimpliQ - Flat & Responsive Bootstrap Admin Template

javascript - jQuery DatePicker - Enable Specific Day - Code Not Working - Stack Overflow

Bootply snippet - Bootstrap Bootstrap 3 Template

Conditional Serialization with Json.NET | Geeky Tidbits

Embed image in Email - ASP.NET , C# - CodeProject

Conditional ASP.NET MVC Validation using Data Annotation Attributes - CodeProject

Debugging & Testing Tool

There are multiple tools available for debugging & testing the application.Some of them are listed below with description...

Basic and simple tools

SoupUI-Use for testing web service 

Internet browser Tool
Google Chrome tool
Firebug and Web Developer
Fiddler -Used to check network performance

These tools are useful to do following things
Debugging JavaScript-

1. Compilation Error:We can find syntax error
2. Viewing Scripts
3. Searching scripts
4. Breakpoint & debugging the code
5. change the value at runtime by watches & values
6. console window-Debugging the particular error at runtime and write a some code
7. Profiling Scripts-Check the performance of javascript or any other code.

• Developer Tool in Browser 
• https://jsfiddle.net/
• The console.log() Method
• http://jsbin.com/?html,js
• Firebug

Debugging CSS

1. The CSS View
2. Discovering Styles & modifying style at runtime
3. Adding rules
4. Copy the change code and update it in source code

Network Debugging

1. Viewing result
2. Status code
3. Browser cache
4. Debugging API call
5. Performance check