private void dataGridViewReports_RowEnter(object sender, DataGridViewCellEventArgs e)
{
clsMonthlyReports.find(Convert.ToInt32(dataGridViewReports.Rows[e.RowIndex].Cells["clmReportId"].Value));
//Set the checks for the report email recipeints
setRecipientChecksForReport(e.RowIndex);
//Set the template path
tbTemplatePath.Text = clsMonthlyReports.GetDataValue("ReportPath").ToString();
//Sets visibility of the recipients dataGridView
dataGridViewReicpitents.Visible =
(bool)dataGridViewReports.Rows[e.RowIndex].Cells["clmReportActive"].Value;
}
/// <summary>
/// Checks the Report Path and finds if the reports exist for the current period
/// </summary>
private void findIfReportsExist()
{
for (int i = 1; i < lvReports.Items.Count; i++)
{
if (lvReports.Items[i].Tag != null && lvReports.Items[i].Tag.ToString() != "")
{
//Get Report Path
file = CCFBPrefs.ReportsSavePath;
//Add Underschore
clsMonthlyReports.find(Convert.ToInt32(lvReports.Items[i].Tag));
file += cboReportYear.SelectedItem.ToString() +
getFormatedMonthNumber(cboReportMonth.SelectedIndex + 1).ToString() + "_";
//Add Period
file += clsMonthlyReports.ReportName + ".doc";
//Check if file exists
if (File.Exists(file) == true)
{
lvReports.Items[i].BackColor = Color.LightSteelBlue;
lvReports.Items[i].Checked = false;
}
else
{
lvReports.Items[i].BackColor = Color.Beige;
}
}
}
//For each report Checkbox
foreach (CheckBox cb in pnlReports.Controls.OfType <CheckBox>())
{
//If that checkbox does not = ALL
if (cb.Tag != null && cb.Tag.ToString() != "")
{
//Get Report Path
file = CCFBPrefs.ReportsSavePath;
//Add Underschore
clsMonthlyReports.find(Convert.ToInt32(cb.Tag));
file += cboReportYear.SelectedItem.ToString() +
getFormatedMonthNumber(cboReportMonth.SelectedIndex + 1).ToString() + "_";
//Add Period
file += clsMonthlyReports.ReportName + ".doc";
//Check if file exists
if (File.Exists(file) == true)
{
cb.BackColor = Color.Red;
cb.Checked = false;
}
else
{
cb.BackColor = Color.Cornsilk;
}
}
}
}
