Thursday, July 28, 2011

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 ?

Wednesday, July 27, 2011

date formats

Date and Time Format Patterns






All

the

patterns:
0MM/dd/yyyy07/27/2011
1

dddd, dd MMMM yyyy
Wednesday, 27 July 2011
2dddd, dd

MMMM yyyy HH:mm
Wednesday, 27 July 2011 08:40
3dddd, dd

MMMM yyyy hh:mm tt
Wednesday, 27 July 2011 08:40

AM
4dddd, dd MMMM yyyy H:mmWednesday, 27 July 2011

8:40
5dddd, dd MMMM yyyy h:mm ttWednesday, 27 July 2011

8:40 AM
6dddd, dd MMMM yyyy HH:mm:ssWednesday, 27 July

2011 08:40:28
7MM/dd/yyyy HH:mm07/27/2011

08:40
8MM/dd/yyyy hh:mm tt07/27/2011 08:40

AM
9MM/dd/yyyy H:mm07/27/2011

8:40
10MM/dd/yyyy h:mm tt07/27/2011 8:40

AM
11MM/dd/yyyy HH:mm:ss07/27/2011

08:40:28
12MMMM ddJuly 27
13MMMM

dd
July

27
14yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK2011-07-27T0

8:40:28.2891564-04:00
15yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK2011-07-27T08:40:28.2891564-04:00
16ddd, dd MMM yyyy

HH':'mm':'ss 'GMT'
Wed, 27 Jul 2011 08:40:28 GMT
17ddd,

dd MMM yyyy HH':'mm':'ss 'GMT'
Wed, 27 Jul 2011 08:40:28

GMT
18yyyy'-'MM'-'dd'T'HH':'mm':'ss2011-07-27T08:40:28< /td>
19HH:mm08:40
20hh:mm

tt
08:40

AM
21H:mm8:40
22h:mm

tt
8:40

AM
23HH:mm:ss08:40:28
24yyyy'-'MM

'-'dd HH':'mm':'ss'Z'
2011-07-27 08:40:28Z
25dddd, dd

MMMM yyyy HH:mm:ss
Wednesday, 27 July 2011

08:40:28
26yyyy MMMM2011

July
27yyyy MMMM2011 July

The patterns for

DateTime.ToString ( 'd' )

:
0MM/dd/yyyy07/27/2011

The patterns for

DateTime.ToString ( 'D' ) :
0dddd, dd MMMM

yyyy
Wednesday, 27 July 2011

The patterns for

DateTime.ToString ( 'f' ) :
0dddd, dd MMMM yyyy

HH:mm
Wednesday, 27 July 2011 08:40
1dddd, dd MMMM yyyy

hh:mm tt
Wednesday, 27 July 2011 08:40 AM
2dddd, dd MMMM

yyyy H:mm
Wednesday, 27 July 2011 8:40
3dddd, dd MMMM

yyyy h:mm tt
Wednesday, 27 July 2011 8:40 AM

The patterns for

DateTime.ToString ( 'F' ) :
0dddd, dd MMMM yyyy

HH:mm:ss
Wednesday, 27 July 2011 08:40:28

The patterns for

DateTime.ToString ( 'g' ) :
0MM/dd/yyyy HH:mm07/27/2011

08:40
1MM/dd/yyyy hh:mm tt07/27/2011 08:40

AM
2MM/dd/yyyy H:mm07/27/2011

8:40
3MM/dd/yyyy h:mm tt07/27/2011 8:40

AM

The patterns for DateTime.ToString ( 'G' )

:
0MM/dd/yyyy HH:mm:ss07/27/2011

08:40:28

The patterns for DateTime.ToString ( 'm' )

:
0MMMM ddJuly 27

The patterns for

DateTime.ToString ( 'r' ) :
0ddd, dd MMM yyyy HH':'mm':'ss

'GMT'
Wed, 27 Jul 2011 08:40:28 GMT

The patterns for

DateTime.ToString ( 's' )

:
0yyyy'-'MM'-'dd'T'HH':'mm':'ss2011-07-27T08:40:28

The patterns for DateTime.ToString ( 'u' )

:
0yyyy'-'MM'-'dd HH':'mm':'ss'Z'2011-07-27

08:40:28Z

The patterns for DateTime.ToString ( 'U' )

:
0dddd, dd MMMM yyyy HH:mm:ssWednesday, 27 July 2011

08:40:28

The patterns for DateTime.ToString ( 'y' )

:
0yyyy MMMM2011 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

Friday, July 8, 2011

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

.net core

 Sure, here are 50 .NET Core architect interview questions along with answers: 1. **What is .NET Core, and how does it differ from the tradi...