コード例 #1
0
        private void FillEvent()
        {
            conn = DBconnection.GetConnection();
            if (conn.State.ToString() == "Closed")
            {
                conn.Open();
            }

            var Today = DateTime.Now.ToString("d-M-yyyy");

            string input   = Today;
            string pattern = "-";

            string[] substrings = Regex.Split(input, pattern);

            var date  = Convert.ToInt32(substrings[0]);
            var month = Convert.ToInt32(substrings[1]);
            var year  = Convert.ToInt32(substrings[2]);

            calender findBday    = new calender();
            var      BanglaValue = findBday.BanglaDate(month, date);
            var      ArabicValue = findBday.ArabicDate(month, date);

            //Arabic date, month, year calculation
            var ArabicMonth = findArabicMonth(ArabicValue);
            var ArabicDigit = findDate(ArabicValue);

            int ArabYr = 0;

            if (ArabicMonth.ToString() == "muh" || ArabicMonth.ToString() == "saf" && month >= 11 || ArabicMonth.ToString() == "raa" && month >= 12)
            {
                ArabYr = 1436;
            }
            else
            {
                ArabYr = 1435;
            }


            //Bangla date, month, year calculation
            var character = findMonth(BanglaValue);
            var digit     = findDate(BanglaValue);
            var IntDigit  = Convert.ToInt32(digit.ToString());

            int yr = 0;

            if (character.ToString() == "মাঘ" || character.ToString() == "ফাল্গুন" || character.ToString() == "চৈত্র" || character.ToString() == "পৌষ" && IntDigit >= 18)
            {
                yr = 1420;
            }
            else
            {
                yr = 1421;
            }

            //Convert date into bangla
            string numOfDate = digit.ToString();

            string[] x = new string[numOfDate.Length];
            string[] y = new string[numOfDate.Length];
            for (int i = 0; i < numOfDate.Length; i++)
            {
                x[i] = numOfDate.Substring(i, 1);
                switch (x[i])
                {
                case "0":
                    y[i] = "০";
                    break;

                case "1":
                    y[i] = "১";
                    break;

                case "2":
                    y[i] = "২";
                    break;

                case "3":
                    y[i] = "৩";
                    break;

                case "4":
                    y[i] = "৪";
                    break;

                case "5":
                    y[i] = "৫";
                    break;

                case "6":
                    y[i] = "৬";
                    break;

                case "7":
                    y[i] = "৭";
                    break;

                case "8":
                    y[i] = "৮";
                    break;

                case "9":
                    y[i] = "৯";
                    break;

                default:
                    break;
                }
            }
            String DateOutput = String.Join("", y);

            //Convert year into bangla
            string numOfYear = yr.ToString();

            string[] m = new string[numOfYear.Length];
            string[] n = new string[numOfYear.Length];
            for (int i = 0; i < numOfYear.Length; i++)
            {
                m[i] = numOfYear.Substring(i, 1);
                switch (m[i])
                {
                case "0":
                    n[i] = "০";
                    break;

                case "1":
                    n[i] = "১";
                    break;

                case "2":
                    n[i] = "২";
                    break;

                case "3":
                    n[i] = "৩";
                    break;

                case "4":
                    n[i] = "৪";
                    break;

                case "5":
                    n[i] = "৫";
                    break;

                case "6":
                    n[i] = "৬";
                    break;

                case "7":
                    n[i] = "৭";
                    break;

                case "8":
                    n[i] = "৮";
                    break;

                case "9":
                    n[i] = "৯";
                    break;

                default:
                    break;
                }
            }
            String YearOutput = String.Join("", n);

            string MonthName = "";

            switch (month)
            {
            case 1:
                MonthName = "January";
                break;

            case 2:
                MonthName = "February";
                break;

            case 3:
                MonthName = "March";
                break;

            case 4:
                MonthName = "April";
                break;

            case 5:
                MonthName = "May";
                break;

            case 6:
                MonthName = "June";
                break;

            case 7:
                MonthName = "July";
                break;

            case 8:
                MonthName = "August";
                break;

            case 9:
                MonthName = "September";
                break;

            case 10:
                MonthName = "October";
                break;

            case 11:
                MonthName = "November";
                break;

            case 12:
                MonthName = "December";
                break;
            }

            BanglaDate.Text  = character.ToString() + " " + DateOutput + ", " + YearOutput;
            EnglishDate.Text = date + " " + MonthName + ", " + year;
            ArabicDate.Text  = ArabicDigit.ToString() + " " + ArabicMonth.ToString() + ", " + ArabYr;

            //Fill event section
            conn = DBconnection.GetConnection();
            if (conn.State.ToString() == "Closed")
            {
                conn.Open();
            }

            SqlCommand    ThisWeekCmd = new SqlCommand("SELECT * FROM [sms].[dbo].[event] WHERE day=" + date + " and month=" + month, conn);
            SqlDataReader twdr        = ThisWeekCmd.ExecuteReader();

            if (twdr.HasRows)
            {
                while (twdr.Read())
                {
                    int    IndexHoliday = twdr.GetOrdinal("holiday");
                    string EventHoliday = twdr.GetString(IndexHoliday);

                    HolidayLblTxt.Text = EventHoliday;
                    //AppointLblTxt.Text = ;
                }
            }
            else
            {
                HolidayLblTxt.Text = "No holiday today!";
                AppointLblTxt.Text = "No appointment today!";
            }
        }
コード例 #2
0
        private void FillEvent()
        {
            conn = DBconnection.GetConnection();
            if (conn.State.ToString() == "Closed")
            {
                conn.Open();
            }

            var Today = DateTime.Now.ToString("d-M-yyyy");

            string input = Today;
            string pattern = "-";

            string[] substrings = Regex.Split(input, pattern);

            var date = Convert.ToInt32(substrings[0]);
            var month = Convert.ToInt32(substrings[1]);
            var year = Convert.ToInt32(substrings[2]);

            calender findBday = new calender();
            var BanglaValue = findBday.BanglaDate(month, date);
            var ArabicValue = findBday.ArabicDate(month, date);

            //Arabic date, month, year calculation
            var ArabicMonth = findArabicMonth(ArabicValue);
            var ArabicDigit = findDate(ArabicValue);

            int ArabYr = 0;
            if (ArabicMonth.ToString() == "muh" || ArabicMonth.ToString() == "saf" && month >= 11 || ArabicMonth.ToString() == "raa" && month >= 12)
            {
                ArabYr = 1436;
            }
            else
            {
                ArabYr = 1435;
            }


            //Bangla date, month, year calculation
            var character = findMonth(BanglaValue);
            var digit = findDate(BanglaValue);
            var IntDigit = Convert.ToInt32(digit.ToString());

            int yr = 0;
            if (character.ToString() == "মাঘ" || character.ToString() == "ফাল্গুন" || character.ToString() == "চৈত্র" || character.ToString() == "পৌষ" && IntDigit >= 18)
            {
                yr = 1420;
            }
            else
            {
                yr = 1421;
            }

            //Convert date into bangla
            string numOfDate = digit.ToString();
            string[] x = new string[numOfDate.Length];
            string[] y = new string[numOfDate.Length];
            for (int i = 0; i < numOfDate.Length; i++)
            {
                x[i] = numOfDate.Substring(i, 1);
                switch (x[i])
                {
                    case "0":
                        y[i] = "০";
                        break;
                    case "1":
                        y[i] = "১";
                        break;
                    case "2":
                        y[i] = "২";
                        break;
                    case "3":
                        y[i] = "৩";
                        break;
                    case "4":
                        y[i] = "৪";
                        break;
                    case "5":
                        y[i] = "৫";
                        break;
                    case "6":
                        y[i] = "৬";
                        break;
                    case "7":
                        y[i] = "৭";
                        break;
                    case "8":
                        y[i] = "৮";
                        break;
                    case "9":
                        y[i] = "৯";
                        break;
                    default:
                        break;
                }
            }
            String DateOutput = String.Join("", y);

            //Convert year into bangla
            string numOfYear = yr.ToString();
            string[] m = new string[numOfYear.Length];
            string[] n = new string[numOfYear.Length];
            for (int i = 0; i < numOfYear.Length; i++)
            {
                m[i] = numOfYear.Substring(i, 1);
                switch (m[i])
                {
                    case "0":
                        n[i] = "০";
                        break;
                    case "1":
                        n[i] = "১";
                        break;
                    case "2":
                        n[i] = "২";
                        break;
                    case "3":
                        n[i] = "৩";
                        break;
                    case "4":
                        n[i] = "৪";
                        break;
                    case "5":
                        n[i] = "৫";
                        break;
                    case "6":
                        n[i] = "৬";
                        break;
                    case "7":
                        n[i] = "৭";
                        break;
                    case "8":
                        n[i] = "৮";
                        break;
                    case "9":
                        n[i] = "৯";
                        break;
                    default:
                        break;
                }
            }
            String YearOutput = String.Join("", n);

            string MonthName = "";
            switch (month)
            {
                case 1:
                    MonthName = "January";
                    break;
                case 2:
                    MonthName = "February";
                    break;
                case 3:
                    MonthName = "March";
                    break;
                case 4:
                    MonthName = "April";
                    break;
                case 5:
                    MonthName = "May";
                    break;
                case 6:
                    MonthName = "June";
                    break;
                case 7:
                    MonthName = "July";
                    break;
                case 8:
                    MonthName = "August";
                    break;
                case 9:
                    MonthName = "September";
                    break;
                case 10:
                    MonthName = "October";
                    break;
                case 11:
                    MonthName = "November";
                    break;
                case 12:
                    MonthName = "December";
                    break;
            }

            BanglaDate.Text = character.ToString() + " " + DateOutput + ", " + YearOutput;
            EnglishDate.Text = date + " " + MonthName + ", " + year;
            ArabicDate.Text = ArabicDigit.ToString() + " " + ArabicMonth.ToString() + ", " + ArabYr;

            //Fill event section
            conn = DBconnection.GetConnection();
            if (conn.State.ToString() == "Closed")
            {
                conn.Open();
            }

            SqlCommand ThisWeekCmd = new SqlCommand("SELECT * FROM [sms].[dbo].[event] WHERE day=" + date + " and month=" + month, conn);
            SqlDataReader twdr = ThisWeekCmd.ExecuteReader();
            if (twdr.HasRows)
            {
                while (twdr.Read())
                {
                    int IndexHoliday = twdr.GetOrdinal("holiday");
                    string EventHoliday = twdr.GetString(IndexHoliday);

                    HolidayLblTxt.Text = EventHoliday;
                    //AppointLblTxt.Text = ;
                }
            }
            else
            {
                HolidayLblTxt.Text = "No holiday today!";
                AppointLblTxt.Text = "No appointment today!";
            }
        }
コード例 #3
0
        private void FindToday()
        {
            var Today = DateTime.Now.ToString("d-M-yyyy");

            string input   = Today;
            string pattern = "-";

            string[] substrings = Regex.Split(input, pattern);

            var date  = Convert.ToInt32(substrings[0]);
            var month = Convert.ToInt32(substrings[1]);
            var year  = Convert.ToInt32(substrings[2]);

            calender findBday    = new calender();
            var      BanglaValue = findBday.BanglaDate(month, date);
            var      ArabicValue = findBday.ArabicDate(month, date);

            //Arabic date, month, year calculation
            var ArabicMonth = findArabicMonth(ArabicValue);
            var ArabicDigit = findDate(ArabicValue);

            int ArabYr = 0;

            if (ArabicMonth.ToString() == "muh" || ArabicMonth.ToString() == "saf" && month >= 11 || ArabicMonth.ToString() == "raa" && month >= 12)
            {
                ArabYr = 1436;
            }
            else
            {
                ArabYr = 1435;
            }


            //Bangla date, month, year calculation
            var character = findMonth(BanglaValue);
            var digit     = findDate(BanglaValue);
            var IntDigit  = Convert.ToInt32(digit.ToString());

            int yr = 0;

            if (character.ToString() == "মাঘ" || character.ToString() == "ফাল্গুন" || character.ToString() == "চৈত্র" || character.ToString() == "পৌষ" && IntDigit >= 18)
            {
                yr = 1420;
            }
            else
            {
                yr = 1421;
            }

            //Convert date into bangla
            string numOfDate = digit.ToString();

            string[] x = new string[numOfDate.Length];
            string[] y = new string[numOfDate.Length];
            for (int i = 0; i < numOfDate.Length; i++)
            {
                x[i] = numOfDate.Substring(i, 1);
                switch (x[i])
                {
                case "0":
                    y[i] = "০";
                    break;

                case "1":
                    y[i] = "১";
                    break;

                case "2":
                    y[i] = "২";
                    break;

                case "3":
                    y[i] = "৩";
                    break;

                case "4":
                    y[i] = "৪";
                    break;

                case "5":
                    y[i] = "৫";
                    break;

                case "6":
                    y[i] = "৬";
                    break;

                case "7":
                    y[i] = "৭";
                    break;

                case "8":
                    y[i] = "৮";
                    break;

                case "9":
                    y[i] = "৯";
                    break;

                default:
                    break;
                }
            }
            String DateOutput = String.Join("", y);

            //Convert year into bangla
            string numOfYear = yr.ToString();

            string[] m = new string[numOfYear.Length];
            string[] n = new string[numOfYear.Length];
            for (int i = 0; i < numOfYear.Length; i++)
            {
                m[i] = numOfYear.Substring(i, 1);
                switch (m[i])
                {
                case "0":
                    n[i] = "০";
                    break;

                case "1":
                    n[i] = "১";
                    break;

                case "2":
                    n[i] = "২";
                    break;

                case "3":
                    n[i] = "৩";
                    break;

                case "4":
                    n[i] = "৪";
                    break;

                case "5":
                    n[i] = "৫";
                    break;

                case "6":
                    n[i] = "৬";
                    break;

                case "7":
                    n[i] = "৭";
                    break;

                case "8":
                    n[i] = "৮";
                    break;

                case "9":
                    n[i] = "৯";
                    break;

                default:
                    break;
                }
            }
            String YearOutput = String.Join("", n);

            BanglaDate.Text = character.ToString() + " " + DateOutput + ", " + YearOutput;
            ArabicDate.Text = ArabicDigit.ToString() + " " + ArabicMonth.ToString() + ", " + ArabYr;

            //Fill this week section
            conn = DBconnection.GetConnection();
            if (conn.State.ToString() == "Closed")
            {
                conn.Open();
            }

            SqlCommand    ThisWeekCmd = new SqlCommand("SELECT Top 7 * FROM [sms].[dbo].[event] WHERE day>=" + date + " and month>=" + month, conn);
            SqlDataReader twdr        = ThisWeekCmd.ExecuteReader();

            if (twdr.HasRows)
            {
                int z = 0;
                while (twdr.Read())
                {
                    int IndexDate    = twdr.GetOrdinal("day");
                    int IndexMonth   = twdr.GetOrdinal("month");
                    int IndexHoliday = twdr.GetOrdinal("holiday");

                    int    TopDate    = twdr.GetInt32(IndexDate);
                    int    TopMonth   = twdr.GetInt32(IndexMonth);
                    string TopHoliday = twdr.GetString(IndexHoliday);

                    string MonthName = "";
                    switch (TopMonth)
                    {
                    case 1:
                        MonthName = "January";
                        break;

                    case 2:
                        MonthName = "February";
                        break;

                    case 3:
                        MonthName = "March";
                        break;

                    case 4:
                        MonthName = "April";
                        break;

                    case 5:
                        MonthName = "May";
                        break;

                    case 6:
                        MonthName = "June";
                        break;

                    case 7:
                        MonthName = "July";
                        break;

                    case 8:
                        MonthName = "August";
                        break;

                    case 9:
                        MonthName = "September";
                        break;

                    case 10:
                        MonthName = "October";
                        break;

                    case 11:
                        MonthName = "November";
                        break;

                    case 12:
                        MonthName = "December";
                        break;
                    }

                    Label TweekU_lbl = new Label();
                    TweekU_lbl.Location = new Point(14, 12 + (z * 22));
                    TweekU_lbl.Name     = "TweekU_lbl_" + z;
                    TweekU_lbl.Text     = MonthName + " " + TopDate;
                    TweekU_lbl.AutoSize = true;
                    thisWeekPanel.Controls.Add(TweekU_lbl);

                    Label TweekL_lbl = new Label();
                    TweekL_lbl.Location = new Point(89, 12 + (z * 22));
                    TweekL_lbl.Name     = "TweekL_lbl_" + z;
                    TweekL_lbl.Text     = " :  " + TopHoliday;
                    TweekL_lbl.AutoSize = true;
                    thisWeekPanel.Controls.Add(TweekL_lbl);
                    z = z + 1;
                }
            }
        }
コード例 #4
0
        private void FindToday()
        {
            var Today = DateTime.Now.ToString("d-M-yyyy");

            string input = Today;
            string pattern = "-";

            string[] substrings = Regex.Split(input, pattern);

            var date = Convert.ToInt32(substrings[0]);
            var month = Convert.ToInt32(substrings[1]);
            var year = Convert.ToInt32(substrings[2]);

            calender findBday = new calender();
            var BanglaValue = findBday.BanglaDate(month, date);
            var ArabicValue = findBday.ArabicDate(month, date);

            //Arabic date, month, year calculation
            var ArabicMonth = findArabicMonth(ArabicValue);
            var ArabicDigit = findDate(ArabicValue);

            int ArabYr = 0;
            if (ArabicMonth.ToString() == "muh" || ArabicMonth.ToString() == "saf" && month >= 11 || ArabicMonth.ToString() == "raa" && month >= 12)
            {
                ArabYr = 1436;
            }
            else
            {
                ArabYr = 1435;
            }


            //Bangla date, month, year calculation
            var character = findMonth(BanglaValue);
            var digit = findDate(BanglaValue);
            var IntDigit = Convert.ToInt32(digit.ToString());

            int yr = 0;
            if (character.ToString() == "মাঘ" || character.ToString() == "ফাল্গুন" || character.ToString() == "চৈত্র" || character.ToString() == "পৌষ" && IntDigit >= 18)
            {
                yr = 1420;
            }
            else
            {
                yr = 1421;
            }

            //Convert date into bangla
            string numOfDate = digit.ToString();
            string[] x = new string[numOfDate.Length];
            string[] y = new string[numOfDate.Length];
            for (int i = 0; i < numOfDate.Length; i++)
            {
                x[i] = numOfDate.Substring(i, 1);
                switch (x[i])
                {
                    case "0":
                        y[i] = "০";
                        break;
                    case "1":
                        y[i] = "১";
                        break;
                    case "2":
                        y[i] = "২";
                        break;
                    case "3":
                        y[i] = "৩";
                        break;
                    case "4":
                        y[i] = "৪";
                        break;
                    case "5":
                        y[i] = "৫";
                        break;
                    case "6":
                        y[i] = "৬";
                        break;
                    case "7":
                        y[i] = "৭";
                        break;
                    case "8":
                        y[i] = "৮";
                        break;
                    case "9":
                        y[i] = "৯";
                        break;
                    default:
                        break;
                }
            }
            String DateOutput = String.Join("", y);

            //Convert year into bangla
            string numOfYear = yr.ToString();
            string[] m = new string[numOfYear.Length];
            string[] n = new string[numOfYear.Length];
            for (int i = 0; i < numOfYear.Length; i++)
            {
                m[i] = numOfYear.Substring(i, 1);
                switch (m[i])
                {
                    case "0":
                        n[i] = "০";
                        break;
                    case "1":
                        n[i] = "১";
                        break;
                    case "2":
                        n[i] = "২";
                        break;
                    case "3":
                        n[i] = "৩";
                        break;
                    case "4":
                        n[i] = "৪";
                        break;
                    case "5":
                        n[i] = "৫";
                        break;
                    case "6":
                        n[i] = "৬";
                        break;
                    case "7":
                        n[i] = "৭";
                        break;
                    case "8":
                        n[i] = "৮";
                        break;
                    case "9":
                        n[i] = "৯";
                        break;
                    default:
                        break;
                }
            }
            String YearOutput = String.Join("", n);

            BanglaDate.Text = character.ToString() + " " + DateOutput + ", " + YearOutput;
            ArabicDate.Text = ArabicDigit.ToString() + " " + ArabicMonth.ToString() + ", " + ArabYr;

            //Fill this week section
            conn = DBconnection.GetConnection();
            if (conn.State.ToString() == "Closed")
            {
                conn.Open();
            }

            SqlCommand ThisWeekCmd = new SqlCommand("SELECT Top 7 * FROM [sms].[dbo].[event] WHERE day>="+date+" and month>="+month, conn);
            SqlDataReader twdr = ThisWeekCmd.ExecuteReader();
            if (twdr.HasRows)
            {
                int z = 0;
                while (twdr.Read())
                {
                    int IndexDate = twdr.GetOrdinal("day");
                    int IndexMonth = twdr.GetOrdinal("month");
                    int IndexHoliday = twdr.GetOrdinal("holiday");

                    int TopDate = twdr.GetInt32(IndexDate);
                    int TopMonth = twdr.GetInt32(IndexMonth);
                    string TopHoliday = twdr.GetString(IndexHoliday);

                    string MonthName = "";
                    switch (TopMonth)
                    {
                        case 1:
                            MonthName = "January";
                            break;
                        case 2:
                            MonthName = "February";
                            break;
                        case 3:
                            MonthName = "March";
                            break;
                        case 4:
                            MonthName = "April";
                            break;
                        case 5:
                            MonthName = "May";
                            break;
                        case 6:
                            MonthName = "June";
                            break;
                        case 7:
                            MonthName = "July";
                            break;
                        case 8:
                            MonthName = "August";
                            break;
                        case 9:
                            MonthName = "September";
                            break;
                        case 10:
                            MonthName = "October";
                            break;
                        case 11:
                            MonthName = "November";
                            break;
                        case 12:
                            MonthName = "December";
                            break;
                    }

                    Label TweekU_lbl = new Label();
                    TweekU_lbl.Location = new Point(14, 12 + (z * 22));
                    TweekU_lbl.Name = "TweekU_lbl_" + z;
                    TweekU_lbl.Text = MonthName + " " + TopDate;
                    TweekU_lbl.AutoSize = true;
                    thisWeekPanel.Controls.Add(TweekU_lbl);

                    Label TweekL_lbl = new Label();
                    TweekL_lbl.Location = new Point(89, 12 + (z * 22));
                    TweekL_lbl.Name = "TweekL_lbl_" + z;
                    TweekL_lbl.Text = " :  " + TopHoliday;
                    TweekL_lbl.AutoSize = true;
                    thisWeekPanel.Controls.Add(TweekL_lbl);
                    z = z + 1;
                }
            }
        }