Number to Words in c#

//Below content is copied some other sites
//--------------------------------------------
//First Example
//-------------------------------------------
public static string NumberToWords(int number)
        {
            if (number == 0)
                return "zero";

            if (number < 0)
                return "minus " + NumberToWords(Math.Abs(number));

            string words = "";

            if ((number / 10000000) > 0)
            {
                words += NumberToWords(number / 10000000) + " crore ";
                number %= 10000000;
            }

            if ((number / 100000) > 0)
            {
                words += NumberToWords(number / 100000) + " lakh ";
                number %= 100000;
            }

            if ((number / 1000) > 0)
            {
                words += NumberToWords(number / 1000) + " thousand ";
                number %= 1000;
            }

            if ((number / 100) > 0)
            {
                words += NumberToWords(number / 100) + " hundred ";
                number %= 100;
            }

            if (number > 0)
            {
                if (words != "")
                    words += "and ";

                string[] unitsMap = { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen" };
                string[] tensMap = { "zero", "ten", "twenty", "thirty", "forty", "fifty", "sixty", "seventy", "eighty", "ninety" };

                if (number < 20)
                    words += unitsMap[number];
                else
                {
                    words += tensMap[number / 10];
                    if ((number % 10) > 0)
                        words += "-" + unitsMap[number % 10];
                }
            }

            return words;
        }

 //-------------------------------------------------------------------
 .// Second Example
 //------------------------------------------------------------
private void button1_Click(object sender, EventArgs e)
        {
            textBox2.Text = changeCurrencyToWords(textBox1.Text);
            if (textBox2.Text.Contains("and Crore"))
            {
                textBox2.Text = textBox2.Text.Replace("and Crore", "");
            }
            if(textBox2.Text.Contains("and Lakh"))
            {
                textBox2.Text=textBox2.Text.Replace(" and Lakh", "");
            }
            if (textBox2.Text.Contains("and Thousand"))
            {
                textBox2.Text=textBox2.Text.Replace(" and Thousand", "");
            }
            if (textBox2.Text.Contains("and Hundred"))
            {
                textBox2.Text = textBox2.Text.Replace(" and Hundred", "");
            }
        }
       

        public String changeNumericToWords(double numb)
        {
            String num = numb.ToString();
            return changeToWords(num, false);
        }
        public String changeCurrencyToWords(String numb)
        {
            return changeToWords(numb, true);
        }
        public String changeNumericToWords(String numb)
        {
            return changeToWords(numb, false);
        }
        public String changeCurrencyToWords(double numb)
        {
            return changeToWords(numb.ToString(), true);
        }
        private String changeToWords(String numb, bool isCurrency)
        {
            String val = "", wholeNo = numb, points = "", andStr = "", pointStr = "";
            String endStr = (isCurrency) ? ("Rupees Only") : ("");
            try
            {
                int decimalPlace = numb.IndexOf(".");
                if (decimalPlace > 0)
                {
                    wholeNo = numb.Substring(0, decimalPlace);
                    points = numb.Substring(decimalPlace + 1);
                    if (Convert.ToInt32(points) > 0)
                    {
                        andStr = (isCurrency) ? ("and") : ("point");// just to separate whole numbers from points/cents
                        endStr = (isCurrency) ? ("Paisa " + endStr) : ("");
                        pointStr = translateCents(points);
                    }
                }
                val = String.Format("{0} {1}{2} {3}", translateWholeNumber(wholeNo).Trim(), andStr, pointStr, endStr);
            }
            catch { ;}
            return val;
        }
        private String translateWholeNumber(String number)
        {
            string word = "";
            try
            {
                bool beginsZero = false;//tests for 0XX
                bool isDone = false;//test if already translated
                double dblAmt = (Convert.ToDouble(number));
                //if ((dblAmt > 0) && number.StartsWith("0"))
                if (dblAmt > 0)
                {//test for zero or digit zero in a nuemric
                beginsZero = number.StartsWith("0");
                int numDigits = number.Length;
                int pos = 0;//store digit grouping
                String place = "";//digit grouping name:hundres,thousand,etc...
                switch (numDigits)
                {
                    case 1://ones' range
                    word = ones(number);
                    isDone = true;
                    break;
                    case 2://tens' range
                    word = tens(number);
                    isDone = true;
                    break;
                    case 3://hundreds' range
                    pos = (numDigits % 3) + 1;
                    place = " Hundred ";
                    break;
                    case 4://thousands' range
                    case 5:
                    pos = (numDigits % 4) + 1;
                    place = " Thousand ";
                    break;
                    case 6://lakh' range
                    case 7:
                    pos = (numDigits % 6) + 1;
                    place = " Lakh ";
                    break;
                    case 8://Crore' range
                    case 9:
                    pos = (numDigits % 8) + 1;
                    place = " Crore ";
                    break;
                    case 10://Arab's range
                   
                    //add extra case options for anything above Billion...
                    default:
                    isDone = true;
                    break;
                }
                if (!isDone)
                {
                    //if transalation is not done, continue...(Recursion comes in now!!)
                    word = translateWholeNumber(number.Substring(0, pos)) + place + translateWholeNumber(number.Substring(pos));
                    //check for trailing zeros
                    if (beginsZero)
                        word = " and " + word.Trim();
                }
                //ignore digit grouping names
                if (word.Trim().Equals(place.Trim()))
                    word = "";
                }
            }
            catch { ;}
            return word.Trim();
        }
        private String tens(String digit)
        {
            int digt = Convert.ToInt32(digit);
            String name = null;
            switch (digt)
            {
                case 10:
                name = "Ten";
                break;
                case 11:
                name = "Eleven";
                break;
                case 12:
                name = "Twelve";
                break;
                case 13:
                name = "Thirteen";
                break;
                case 14:
                name = "Fourteen";
                break;
                case 15:
                name = "Fifteen";
                break;
                case 16:
                name = "Sixteen";
                break;
                case 17:
                name = "Seventeen";
                break;
                case 18:
                name = "Eighteen";
                break;
                case 19:
                name = "Nineteen";
                break;
                case 20:
                name = "Twenty";
                break;
                case 30:
                name = "Thirty";
                break;
                case 40:
                name = "Fourty";
                break;
                case 50:
                name = "Fifty";
                break;
                case 60:
                name = "Sixty";
                break;
                case 70:
                name = "Seventy";
                break;
                case 80:
                name = "Eighty";
                break;
                case 90:
                name = "Ninety";
                break;
                default:
                if (digt > 0)
                {
                    name = tens(digit.Substring(0, 1) + "0") + " " + ones(digit.Substring(1));
                }
                break;
            }
            return name;
        }
        private String ones(String digit)
        {
            int digt = Convert.ToInt32(digit);
            String name = "";
            switch (digt)
            {
                case 1:
                name = "One";
                break;
                case 2:
                name = "Two";
                break;
                case 3:
                name = "Three";
                break;
                case 4:
                name = "Four";
                break;
                case 5:
                name = "Five";
                break;
                case 6:
                name = "Six";
                break;
                case 7:
                name = "Seven";
                break;
                case 8:
                name = "Eight";
                break;
                case 9:
                name = "Nine";
                break;
            }
            return name;
        }
        private String translateCents(String cents)
        {
            String cts = "", digit = "", engOne = "";
            for (int i = 0; i < cents.Length; i++)
            {
                digit = cents[i].ToString();
                if (digit.Equals("0"))
                {
                    engOne = "Zero";
                }
                else
                {
                    engOne = ones(digit);
                }
                cts += " " + engOne;
            }
            return cts;
        }

How to Remember the things long time

1) When you remember something that one start to laps after 24 hours. Therefore it needs to be again study same thing in 24 hours. That one continue to remember one week but after one week again start to laps therefore need  to again study in 7 days. After that it remain to 6 month.

2) Should be read fast. Put the finger on the line and look and read a sentence one at a time i.e, don't read slowly and look and read 2-3 words at a time

3) Make the habit to write.

4) Make the bullet points and read once before going to sleep.

Should be ready before start my WSIMS software

1) Internet facility should be there.

2) One operator always ready to work on my software and also if i am taking the responsibility of entry then also one operator of client side always work with me.

3) All files related to data entry should be ready before data entry. Ready means how many files are there, NGO list with file number etc.

4) Database should be provide of APL-BPL and also PDF files of 2007 and 2009.

5) One genuine person should be there who have knowledge about the files and other work.

6) Talk before about in how many days my cheque will be in my hand. Note down- Don't do all the work and then approach for the money. Should be make the milestone and receive the amount accordingly.

7) If you are going to data entry then before taking this work confirm that there should be proper and sufficient space to work.

8) There should be proper response of phone. like if you are busy then cut the phone in middle and response the phone whenever free. But don't delay to answering.

Modify Excel Properties through C#

            Excel._Application app=new Excel.Application();
            Excel.Workbooks Wbs=app.Workbooks;;
            Excel.Workbook Wb= Wbs.Add(1);;
            //Excel.Worksheets Osheets;
            Excel.Worksheet Osheet=(Excel.Worksheet)Wb.ActiveSheet;
           
                Osheet.PageSetup.Orientation = XlPageOrientation.xlLandscape;

                Osheet.PageSetup.LeftMargin = double.Parse("42.05");//left margin(0.58) * 72.5
                Osheet.PageSetup.RightMargin = double.Parse("31.09");//right margin(0.44) * 72.5
                Osheet.PageSetup.TopMargin = double.Parse("42.05");
                Osheet.PageSetup.BottomMargin = double.Parse("31.09");
                Osheet.PageSetup.HeaderMargin = double.Parse("0");
                Osheet.PageSetup.FooterMargin = double.Parse("0");

                Range oRng = Osheet.get_Range(Osheet.Cells[1, 1], Osheet.Cells[1, 10]);
                oRng.Merge(Type.Missing);              
                           
                Osheet.Cells[1, 1] = "Nishant";                                       
                Range oRng = (Range)Osheet.Cells[1, 1]
                oRng.EntireColumn.Font.Name = "Arial";
                oRng.EntireColumn.Font.Size = "11";
                oRng.Font.Bold = true;
                oRng.Font.Underline = true;
                oRng.EntireColumn.WrapText = true;
                oRng.EntireColumn.NumberFormat = "@";
                oRng.EntireColumn.VerticalAlignment = XlVAlign.xlVAlignCenter;
                oRng.HorizontalAlignment = XlHAlign.xlHAlignCenter;

Projects

Following Projects Done:

1) Retail/Distribution Management Software (BMS): Kanak Telecom, Jay Mata Di Telecom

2) Water & Sanitation Info Management Software (WSIMS): PHED Patna, Lakhisarai

3) Constituency Info Management Software (CIMS): Uday Narayan Choudhry (Bihar Vidhansabha Chairman)

4) Restaurant Billing Software (RBS): Tikka Express Sheikhpura, Patna

5) Sanitation Scheme Accounting Software (SSAS): PJS Surajagrha, Lakhisarai

Cheap Web Hosting

http://www.anmoul.com

Chanakya Kathan

आचार्य चाणक्य का कथन है कि ‘‘मनुष्य को शेर से एक, बगुले से एक तथा मुर्गे से चार, कौऐ से पांच, कुत्ते से छह और गधे से तीन गुण ग्रहण करना चाहिए।“ “बड़ा हो या छोटा कार्य उसे संपन्न करने के लिये पूरी शक्ति लगाना शेर से सीखना चाहिए।’’ ‘‘बगुले की भांति अपनी इंद्रियों को वश मे कर देश काल अपने बल को जानकर ही अपने सारे कार्य करना चाहिए।“ ‘‘ठीक समय पर जागना, सदैव युद्ध के लिये तैयार रहना, बंधुओं को अपना हिस्सा देना और आक्रामक होकर भोजन करना मुर्गे से सीखना चाहिए।“ ‘‘छिपकर प्रेमालाप करना, ढीठता, नियम समय पर संग्रह करना सदा प्रमादरहित होकर जागरुक रहना तथा किसी पर विश्वास न करना ये पांच गुण कौऐ से सीखना चाहिए ।’’ ‘‘बहुत खाने की शक्ति रखना, न मिलने पर भी संतुष्ट हो जाना, खूब सोना पर तनिक आहट होने पर भी जाग जाना, स्वामीभक्ति और शूरता यह छह गुण कुत्ते से सीखना चाहिए।“ ‘‘बहुत थक जाने पर भी भार उठाना, सर्दी गर्मी से बेपरवाह होन और सदा शांतिपूर्ण जीवन बिताना यह तीन गुण गधे से सीखना चाहिए।“