//  value is number to be added to get the new month
    // ddlStartMonth is the value from where month to be added in dropdown
    private void Bind_CaseStatus(int value, int ddlStartMonth)
    {
        int totalNumberOfMonth = 0;
        int currentMonthId = ddlStartMonth;
        if (txtTSLAcceptedDate.Text.Trim() != string.Empty)
        {
            List<MonthsDTO> listMonth = ESalesUnityContainer.Container.Resolve<IForm27CService>().GetMonthList().ToList();

            string selectedDateMonth = txtTSLAcceptedDate.Text.Substring(txtTSLAcceptedDate.Text.IndexOf("-") + 1, 3);
            string selectedDateYear = txtTSLAcceptedDate.Text.Substring(txtTSLAcceptedDate.Text.LastIndexOf("-") + 1);

            List<MonthsDTO> lst = new List<MonthsDTO>();

            int toLimit = 0;
            totalNumberOfMonth = currentMonthId + value;
            if (totalNumberOfMonth < 12)
            {
                toLimit = totalNumberOfMonth - 1;
            }
            else
            {
                toLimit = 12;
            }

            for (int i = currentMonthId; i <= toLimit; i++)
            {
                foreach (MonthsDTO data in listMonth)
                {
                    if (data.Months_Id == i)
                    {
                        MonthsDTO dt = new MonthsDTO();

                        dt.MonthName = data.MonthName + " " + selectedDateYear;
                        dt.Months_Id = i;
                        lst.Add(dt);
                    }
                }
            }

            if (totalNumberOfMonth > 12)
            {
                int nextYearMonths = totalNumberOfMonth - 12;

                for (int i = 1; i < nextYearMonths; i++)
                {
                    foreach (MonthsDTO data in listMonth)
                    {
                        if (data.Months_Id == i)
                        {
                            MonthsDTO dt = new MonthsDTO();

                            dt.MonthName = data.MonthName + " " + (Convert.ToInt32(selectedDateYear) + 1);
                            dt.Months_Id = i;
                            lst.Add(dt);
                        }
                    }
                }
            }
            else
            {

            }

            ddlMonth.DataTextField = "MonthName";
            ddlMonth.DataValueField = "Months_Id";
            ddlMonth.DataSource = lst;
            ddlMonth.DataBind();
        }
        else
        {
            List<MonthsDTO> listMonth = ESalesUnityContainer.Container.Resolve<IForm27CService>().GetMonthList().ToList();
            ddlMonth.DataTextField = "MonthName";
            ddlMonth.DataValueField = "Months_Id";
            ddlMonth.DataSource = listMonth;
            ddlMonth.DataBind();
        }
    }
    private IList<MonthsDTO> Bind_CaseStatus(int value, int ddlStartMonth)
    {
        List<MonthsDTO> lst = new List<MonthsDTO>();
        int totalNumberOfMonth = 0;
        int currentMonthId = ddlStartMonth;
        if (value > 0)
        {
            List<MonthsDTO> listMonth = ESalesUnityContainer.Container.Resolve<IForm27CService>().GetMonthList().ToList();

            //string selectedDateMonth = txtReceivedDate.Text.Substring(txtReceivedDate.Text.IndexOf("-") + 1, 3);
            //string selectedDateYear = txtReceivedDate.Text.Substring(txtReceivedDate.Text.LastIndexOf("-") + 1);

            int selectedDateYear = DateTime.Now.Year;

            int toLimit = 0;
            totalNumberOfMonth = currentMonthId + value;
            if (totalNumberOfMonth <= 12)
            {
                toLimit = totalNumberOfMonth - 1;
            }
            else
            {
                toLimit = 12;
            }

            for (int i = currentMonthId; i <= toLimit; i++)
            {
                foreach (MonthsDTO data in listMonth)
                {
                    if (data.Months_Id == i)
                    {
                        MonthsDTO dt = new MonthsDTO();

                        dt.MonthName = data.MonthName + " " + selectedDateYear;
                        dt.Months_Id = i;
                        lst.Add(dt);
                    }
                }
            }

            if (totalNumberOfMonth > 12)
            {
                int nextYearMonths = totalNumberOfMonth - 12;

                for (int i = 1; i < nextYearMonths; i++)
                {
                    foreach (MonthsDTO data in listMonth)
                    {
                        if (data.Months_Id == i)
                        {
                            MonthsDTO dt = new MonthsDTO();

                            dt.MonthName = data.MonthName + " " + (Convert.ToInt32(selectedDateYear) + 1);
                            dt.Months_Id = i;
                            lst.Add(dt);
                        }
                    }
                }
            }

            return lst;
        }
        return lst;
    }