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;
}
}
