Why income tax return is so complicated in India?

Hi to everyone,
I am a computer professionalize and as far as I think I am well educated. Yester night I see a TV advertisement about its now easy to fill “e-return” in India and i am also thinking to fill the return this year so by inspired by that TV add , when I come to office open the google.in and type the e-filling tax , and it gives me the list link as expected from “ google guru”. I go through the first link which is an official website of our nation to fill the return http://www.incometaxindia.gov.in/home.asp and there is a lot of menus in the left hand side but I didn’t getting any idea on which link should I go. I am very much confused between the fourth and fifth menus which are File return online and Pay taxes online. Really I never thought it will have so much confusion and financial terms. As I working in a private company so this will be the reason else in government offices everyone know how to fill tax return and what they get if govt approve any extra TA DA or any allowance for them. They have so much time to calculate all these things but we don’t have.
Can it is not possible that there is a simple form which have some basic enquiry + pen card number +my bank statements and any other thing required then there is upload option and when I fill the form then email to me and my company and after confirmation from my company my income tax return is successfully submitted. As I go through my idea there can be lot more improvement or amendments can be done but it will be simple for us. Hoping that anybody have same trouble and it will change the pattern ……………………..

Sample app or project for the MVC ?

Looking from a long time to get the opportunity to work in MVC framework and I know the basic what is MVC and how it works? How it differs from the traditional web forms, but not getting any project in my companies and lot of other issues are regularly facing which keep myself busy so the main point is that missing the right time and right opportunity to clean my MVC hands.

In those days I am big fan of http://stackoverflow.com so there I got lot of knowledge today any user similar to me in MVC knowledge asked “What will be the right way to start a project on MVC” and the answer is http://nerddinner.com/ (NerdDinner 2.0 Complete ASP.NET MVC Sample App) and source code is also available on codeplex (Project Hosting for Open Source Software) http://nerddinner.codeplex.com/ so the objective of my blogging share my knowledge to my readers. So this is the answer of sample app or project for the MVC ?

date formats

Date and Time Format Patterns

---

All the patterns:
0	MM/dd/yyyy	07/27/2011
1	dddd, dd MMMM yyyy	Wednesday, 27 July 2011
2	dddd, dd MMMM yyyy HH:mm	Wednesday, 27 July 2011 08:40
3	dddd, dd MMMM yyyy hh:mm tt	Wednesday, 27 July 2011 08:40 AM
4	dddd, dd MMMM yyyy H:mm	Wednesday, 27 July 2011 8:40
5	dddd, dd MMMM yyyy h:mm tt	Wednesday, 27 July 2011 8:40 AM
6	dddd, dd MMMM yyyy HH:mm:ss	Wednesday, 27 July 2011 08:40:28
7	MM/dd/yyyy HH:mm	07/27/2011 08:40
8	MM/dd/yyyy hh:mm tt	07/27/2011 08:40 AM
9	MM/dd/yyyy H:mm	07/27/2011 8:40
10	MM/dd/yyyy h:mm tt	07/27/2011 8:40 AM
11	MM/dd/yyyy HH:mm:ss	07/27/2011 08:40:28
12	MMMM dd	July 27
13	MMMM dd	July 27
14	yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK	2011-07-27T0 8:40:28.2891564-04:00
15	yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK	2011-07-27T08:40:28.2891564-04:00
16	ddd, dd MMM yyyy HH':'mm':'ss 'GMT'	Wed, 27 Jul 2011 08:40:28 GMT
17	ddd, dd MMM yyyy HH':'mm':'ss 'GMT'	Wed, 27 Jul 2011 08:40:28 GMT
18	yyyy'-'MM'-'dd'T'HH':'mm':'ss	2011-07-27T08:40:28< /td>
19	HH:mm	08:40
20	hh:mm tt	08:40 AM
21	H:mm	8:40
22	h:mm tt	8:40 AM
23	HH:mm:ss	08:40:28
24	yyyy'-'MM '-'dd HH':'mm':'ss'Z'	2011-07-27 08:40:28Z
25	dddd, dd MMMM yyyy HH:mm:ss	Wednesday, 27 July 2011 08:40:28
26	yyyy MMMM	2011 July
27	yyyy MMMM	2011 July

The patterns for DateTime.ToString ( 'd' ) :
0	MM/dd/yyyy	07/27/2011

The patterns for DateTime.ToString ( 'D' ) :
0	dddd, dd MMMM yyyy	Wednesday, 27 July 2011

The patterns for DateTime.ToString ( 'f' ) :
0	dddd, dd MMMM yyyy HH:mm	Wednesday, 27 July 2011 08:40
1	dddd, dd MMMM yyyy hh:mm tt	Wednesday, 27 July 2011 08:40 AM
2	dddd, dd MMMM yyyy H:mm	Wednesday, 27 July 2011 8:40
3	dddd, dd MMMM yyyy h:mm tt	Wednesday, 27 July 2011 8:40 AM

The patterns for DateTime.ToString ( 'F' ) :
0	dddd, dd MMMM yyyy HH:mm:ss	Wednesday, 27 July 2011 08:40:28

The patterns for DateTime.ToString ( 'g' ) :
0	MM/dd/yyyy HH:mm	07/27/2011 08:40
1	MM/dd/yyyy hh:mm tt	07/27/2011 08:40 AM
2	MM/dd/yyyy H:mm	07/27/2011 8:40
3	MM/dd/yyyy h:mm tt	07/27/2011 8:40 AM

The patterns for DateTime.ToString ( 'G' ) :
0	MM/dd/yyyy HH:mm:ss	07/27/2011 08:40:28

The patterns for DateTime.ToString ( 'm' ) :
0	MMMM dd	July 27

The patterns for DateTime.ToString ( 'r' ) :
0	ddd, dd MMM yyyy HH':'mm':'ss 'GMT'	Wed, 27 Jul 2011 08:40:28 GMT

The patterns for DateTime.ToString ( 's' ) :
0	yyyy'-'MM'-'dd'T'HH':'mm':'ss	2011-07-27T08:40:28

The patterns for DateTime.ToString ( 'u' ) :
0	yyyy'-'MM'-'dd HH':'mm':'ss'Z'	2011-07-27 08:40:28Z

The patterns for DateTime.ToString ( 'U' ) :
0	dddd, dd MMMM yyyy HH:mm:ss	Wednesday, 27 July 2011 08:40:28

The patterns for DateTime.ToString ( 'y' ) :
0	yyyy MMMM	2011 July

---

download box instead of direct open file in new window.

#region download-file
static public void DownloadFile(string filePath)
{
try
{
filePath = filePath.Replace(" ", "_");
HttpContext.Current.Response.ContentType = "application/octet-stream";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + System.IO.Path.GetFileName(filePath));
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.WriteFile(filePath);
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
throw ex;
}
}
#endregion

How to insert complete dataset values into sql server 2005+ using XML

First we have to convert the ds into xml and pass it to the stored

procedure.
For the sake of simplicity i created here a xml schema @xml-schema and temporary table #TempTable.

DECLARE @ixml int
DECLARE @xml-schema varchar(max)
SET @xml-schema ='





'

--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @ixml OUTPUT, @xml-schema
-- Execute a SELECT statement that uses the OPENXML rowset provider.


SELECT *
Into #TempTable
FROM OPENXML(@ixml, '/ROOT/Trans',1)
WITH
(
 TransId  varchar(10),
 [Add] bit,
 Edit bit,
 [Delete] bit,
 [View] bit,
 Block bit
)

Select * From #TempTable

drop table #TempTable

You can change it as per your requirement . have any query please contact me rahularyansharma@gmail.com