private void RunMainProcess()
    {
        bool e_flag     = true;
        var  campIdList = new List <int>();

        foreach (ListItem li in chklistCamp.Items)
        {
            if (li.Selected)
            {
                e_flag = false;
                campIdList.Add(Int32.Parse(li.Value));
            }
        }

        if (e_flag)
        {
            lblMsg.Text  = "You must select at least one camp";
            lblMsg2.Text = "You must select at least one camp";
            return;
        }

        DataTable dtAllCamps = PaymentProcessingDAL.GetReport(Int32.Parse(ddlCampYear.SelectedValue), Int32.Parse(ddlFed.SelectedValue), campIdList, isFinal);

        if (dtAllCamps.Rows.Count > 0)
        {
            GenerateExcelReport(dtAllCamps, campIdList);
        }
        else
        {
            lblMsg.Text  = "There are no campers qualified under the selection criteria.";
            lblMsg2.Text = "There are no campers qualified under the selection criteria.";
        }
    }
    private void FillPaymentSummaryData()
    {
        DataTable dt = PaymentProcessingDAL.GetSummary(Int32.Parse(ddlCampYear.SelectedValue), Int32.Parse(ddlFed.SelectedValue));

        lblTotalCampersReady.Text = dt.Rows[0]["Count14"].ToString();
        //lblTotalCampsReady.Text = dt.Rows[0]["Camp14"].ToString();
        lblTotalCampersDone.Text = dt.Rows[0]["Count25"].ToString();
        // lblTotalCampsDone.Text = dt.Rows[0]["Camp25"].ToString();
    }