protected void btnGenerateFile_Click(object sender, EventArgs e)
        {
            DateTime execDate = rdpExtractDate.SelectedDate.Value;

            DataTable orderExtractForRta = boOnlineOrderBackOffice.GetOrderExtractForRta(rdpExtractDate.SelectedDate.Value, advisorVo.advisorId, ddlExtractType.SelectedValue, ddlRnT.SelectedValue, int.Parse(ddlProductAmc.SelectedValue));

            if (orderExtractForRta == null)
            {
                ShowMessage("No data available");
                return;
            }
            if (orderExtractForRta.Rows.Count <= 0)
            {
                ShowMessage("No data available");
                return;
            }

            string downloadFileName = boOnlineOrderBackOffice.GetFileName(ddlExtractType.SelectedValue, ddlProductAmc.SelectedValue, orderExtractForRta.Rows.Count);

            switch (ddlFileFormat.SelectedValue)
            {
            case "dbf":
                string localFilePath = boOnlineOrderBackOffice.CreatDbfFile(orderExtractForRta, ddlRnT.SelectedValue, Server.MapPath("~/ReferenceFiles/RTAExtractSampleFiles/"), string.Empty, false);
                DownloadDbfFile(localFilePath, downloadFileName + ".DBF");
                break;

            case "txt":
                string txtFilePath = downloadFileName;
                DownloadCsvFile(orderExtractForRta, downloadFileName + ".txt", ddlRnT.SelectedValue);
                break;
            }
        }