private void LoadYears() { if (SelectedCompany == null) { return; } tscYears.Items.Clear(); tscYears.Text = ""; try { var dirInfo = new DirectoryInfo(SelectedCompany.DataDir); var dirs = dirInfo.EnumerateDirectories("*"); foreach (var dir in dirs) { string dirName = dir.Name; if (!dirName.StartsWith("AY", StringComparison.OrdinalIgnoreCase)) { continue; } string fromYear = $"20{dirName.Substring(2, 2)}"; string toYear = $"20{dirName.Substring(5, 2)}"; if (string.IsNullOrEmpty(fromYear) || Convert.ToInt32(fromYear) <= 0) { continue; } if (string.IsNullOrEmpty(toYear) || Convert.ToInt32(toYear) <= 0) { continue; } var year = new AccountingYear { YearDir = dirName, YearName = $"{fromYear}-{toYear}", FromDate = new DateTime(Convert.ToInt32(fromYear), 4, 1), ToDate = new DateTime(Convert.ToInt32(toYear), 3, 31) }; tscYears.Items.Add(year); } } catch { } if (tscYears.Items.Count > 0) { tscYears.SelectedIndex = tscYears.Items.Count - 1; } //lvwList.Items.Clear(); //printListItemBindingSource.DataSource = null; }
private void tscYears_SelectedIndexChanged(object sender, EventArgs e) { SelectedYear = tscYears.SelectedItem as AccountingYear; if (SelectedYear != null) { Text = $"Prints - {SelectedCompany.Name} - {SelectedYear.YearName}"; //string filePath = DataPath + "COMP" + SelectedCompany.Code + "\\" + SelectedYear.YearDir + "\\"; string filePath = Path.Combine(SelectedCompany.DataDir, SelectedYear.YearDir) + "\\"; YearConnectionString = @"Provider=vfpoledb.1;Data Source=" + filePath + ";Extended Properties=dBASE IV;Collating Sequence=machine;"; //lvwList.Items.Clear(); //printListItemBindingSource.DataSource = null; lstMenu.SelectedIndex = -1; dtpDate.MaxDate = DateTime.Today; dtpDate.MinDate = SelectedYear.FromDate; dtpDate.MaxDate = SelectedYear.ToDate; dtpDate.Value = new DateTime(Math.Min(SelectedYear.ToDate.Ticks, DateTime.Today.Ticks)); cboMonth.SelectedIndex = dtpDate.Value.Month >= 4 && dtpDate.Value.Month <= 12 ? dtpDate.Value.Month - 4 : dtpDate.Value.Month + 8; } }