Thursday, July 13, 2017

The Best deals Online E commerce shopping sites in India

India is growing in terms of online shopping. People are buying more and more online.

Reasons online shopping is growing in India:


  • Main online spenders are youth and youth's expenditure power has grown to a big extent
  • IT sector - IT sector guys are more fashionable and also Indian IT industry has grown a lot which contributes online sales
  • Best prices - Flipkart Amazon Snapdeal Paytm war is going on to grab more and more customers, which is helping customers to shop cheaper

The best online shopping web sites for buying consumer goods in India with ranking:



  1. Amazon: The best shopping website overall because of its service, quality of products, genuineness and over above all trust and pricing
  2. Flipkart : The best shopping website for electronics products like mobiles, A.C, LED etc. Flipkart sale pricing is always the best
  3. Paytm: Paytm has many cons and prons. Paytm used to give good shopping deals but buyer has to assure that deal is being sold by assured seller. I have heard lot many people saying products were not genuine when they bought it from Paytm. So, always choose assured  seller while buying products from Paytm.
  4. Snapdeal: Snapdeal earlier was growing when it is spending its foreign investment, but these Snapdeal is doomed. No investments no deals nothing

Flowers, cakes and gift items shopping websites in India:

  1. Ferns and petals: Fresh Flowers & Perfect Gifts for all Occasion with 3 Hour Delivery & Free Shipping in India. 19,381 Gift Ideas for your Beloved
  2. Phoolwala: Express Rakhi Gifts, phools and gifts shopping
  3. India Cakes: To buy or order cakes online

Travel & holiday booking:

  1. Yatra Booking, Tickets sales and reservation
  2. Yatra: For internation flights,tickets booking, Tickets sales and reservation
  3. Jet airways: For Tickets sales and reservation
  4. ClearTrip:  Booking, Tickets sales and reservation
  5. MakeMyTripTravel & Tourism: Booking, Tickets sales and reservation

Friday, March 24, 2017

interview question in asp.net with html5

Define the canvas area
So to define canvas area you need to use the below HTML code.
This defines the area on which you can draw.

Get access to canvas area To draw on the canvas area we need to first get reference of the context section.

What is the use of column layout in CSS?
CSS column layout helps you to divide your text in to columns. For example consider the below magazine news which is one big text but we need to divide the same in to 3 columns with a border in between. That’s where HTML 5 column layout comes to help.

How many columns we want to divide the text in to ?
To specify number of columns we need to us column-count. “webkit” and “moz-column” are needed for chrome and firefox respectively.


How much gap we want to give between those columns ?
moz-column-gap:40px; /* Firefox */ -webkit-column-gap:40px; /* Safari and Chrome */ column-gap:20px;

Do you want to draw a line between those columns , if yes how much thick ?
-moz-column-rule:4px outset #ff00ff; /* Firefox */ -webkit-column-rule:4px outset #ff00ff; /* Safari and Chrome */ column-rule:6px outset #ff00ff;

Can you explain CSS box model?
CSS box model is a rectangular space around a HTML element which defines border, padding and margin. Border: - This defines the maximum area in which the element will be contained. We can make the border visible, invisible, define height and width etc. Padding: - This defines the spacing between border and element. Margin: - This defines the spacing between border and any neighboring elements.

Can you explain some text effects in CSS 3?
Here the interviewer is expecting you to answer one of two text effects by CSS.Below are two effects which are worth noting.

What is local storage concept in HTML 5?

Many times we would like to store information about the user locally in the computer. For example let’s say user has half-filled a long form and suddenly the internet connection breaks off. So the user would like you to store this information locally and when the internet comes back.He would like to get that information and send it to the server for storage.
Modern browsers have storage called as “Local storage” in which you can store this information.

How can we add and remove data from local storage?

Data is added to local storage using “key” and “value”. Below sample code shows country data “India” added with key value “Key001”.
localStorage.setItem(“Key001”,”India”);  
To retrieve data from local storage we need to use “getItem” providing the key name.
var country = localStorage.getItem(“Key001”); 
You can also store JavaScript object’s in the local storage using the below code.
var country = {};
country.name = “India”;
country.code = “I001”;
localStorage.setItem(“I001”, country);
var country1 = localStorage.getItem(“I001”); 
If you want to store in JSON format you can use “JSON.stringify” function as shown in the below code.
localStorage.setItem(“I001”,JSON.stringify(country));  

What is the lifetime of local storage?

Local storage does not have a life time it will stay until either the user clear it from the browser or you remove it using JavaScript code.

What is the difference between local storage and cookies?

CookiesLocal storage
Client side / Server side.Data accessible both at client side and server side. Cookie data is sent to the server side with every request.Data is accessible only at the local browser side. Server cannot access local storage until deliberately sent to the server via POST or GET.
Size4095 bytes per cookie.5 MB per domain.
ExpirationCookies have expiration attached to it. So after that expiration the cookie and the cookie data get’s deleted.There is no expiration data. Either the end user needs to delete it from the browser or programmatically using JavaScript we need to remove the same.

Local storage data persists forever but session storage is valid until the browser is open, as soon as the browser closes the session variable resets.

What is WebSQL?

WebSQL is a structured relational database at the client browser side. It’s a local RDBMS inside the browser on which you can fire SQL queries.

Is WebSQL a part of HTML 5 specification?

No, many people label it as HTML 5 but it’s not part of HTML 5 specification. The specification is based around SQLite.

So how can we use WebSQL?

The first step we need to do is open the database by using “OpenDatabase” function as shown below. The first argument is the name of the database, the next is the version, then a simple textual title and finally the size of the database.
var db=openDatabase('dbCustomer','1.0','Customer app’, 2 * 1024 * 1024); 
To execute SQL we then need to use “transaction” function and call “executeSql” function to fire SQL.
db.transaction(function (tx) 
{
tx.executeSql('CREATE TABLE IF NOT EXISTS tblCust(id unique, customername)');
tx.executeSql('INSERT INTO tblcust (id, customername) VALUES(1, "shiv")');
tx.executeSql('INSERT INTO tblcust (id, customername) VALUES (2, "raju")');
} 
In case you are firing “select” query you will get data is “results” collection which we can loop and display in the HTML UI.
db.transaction(function (tx) 
{
  tx.executeSql('SELECT * FROM tblcust', [], function (tx, results) {
   for (i = 0; i < len; i++)
{
     msg = "" + results.rows.item(i).log + "
"; document.querySelector('#customer).innerHTML += msg; } }, null); });

The first thing in we need to specify is the “manifest” file. “manifest” file helps you to define how your caching should work. Below is the structure of the manifest file :-

CACHE MANIFEST
# version 1.0
CACHE :
Login.aspx 
  • All manifest file starts with CACHE MANIFEST statement.
  • #( hash tag) helps to provide the version of the cache file.
  • CACHE command specifies which files needs to be cached.
  • The content type of the manifest file should be “text/cache-manifest”.
Below is how cache manifest has been provided using ASP.NET C#.
Response.ContentType = "text/cache-manifest";
Response.Write("CACHE MANIFEST \n");
Response.Write("# 2012-02-21 v1.0.0 \n");
Response.Write("CACHE : \n");
Response.Write("Login.aspx \n");
Response.Flush();
Response.End(); 
One the cache manifest file is created the next thing is to provide the link of the manifest file in the HTML page as shown below.
<html manifest="cache.aspx"> 
When the above file runs first time it gets added in the browser application cache and in case server goes down the page is served from the application cache.