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