protected void btnDownload_Click(object sender, EventArgs e) { if (viewsListBox.SelectedIndex < 0) { Master.ShowMessage("Select an item from list of data!"); return; } string ext_id = viewsListBox.SelectedValue.ToString(); string sql_code; string FormatID = WebTools.GetExpr("FORMAT_ID", "EXTERNAL_DATA", "EXT_ID=" + ext_id); string DateWise = WebTools.GetExpr("DATE_WISE", "EXTERNAL_DATA", "EXT_ID=" + ext_id); string IsoWise = WebTools.GetExpr("ISO_WISE", "EXTERNAL_DATA", "EXT_ID=" + ext_id); string strFileName = WebTools.GetExpr("EXT_DATA", "EXTERNAL_DATA", "EXT_ID=" + ext_id); string strOrderBy = WebTools.GetExpr("ORDER_BY", "EXTERNAL_DATA", "EXT_ID=" + ext_id); string FilterByID = FilterByList.SelectedValue.ToString(); string FilterValue; if (FilterByList.SelectedValue.ToString() == "2") { FilterValue = txtFilterValue.Text; } else { FilterValue = ddFilterValue.SelectedItem.Text; } // add date to file-name if (FilterByID == "1" && !string.IsNullOrEmpty(FilterValue)) { strFileName += " " + DateTime.Parse(ddFilterValue.SelectedValue.ToString()).ToString("yyyymmdd"); } if (FormatID == "1") { // Text strFileName = strFileName + ".txt"; sql_code = WebTools.GetExpr("EXP_SQL", "VIEW_EXT_DATA_HD", "EXT_ID=" + ext_id); } else { // Excel strFileName = strFileName + ".xlsx"; sql_code = WebTools.GetExpr("EXP_SQL_EXL", "VIEW_EXT_DATA_HD", "EXT_ID=" + ext_id); } if (DateWise == "Y" && FilterByID == "1") { sql_code += " AND EXPORT_DATE='" + FilterValue + "'"; } else if (FilterByID == "2" && IsoWise == "Y") { sql_code += " AND ISO_TITLE1='" + FilterValue + "'"; } else if (FilterByID == "3" && IsoWise == "Y") { sql_code += " AND DWG_TRANS_NO='" + FilterValue + "'"; } if (strOrderBy != "") { sql_code += " " + strOrderBy; } string strFilePath = WebTools.SessionDataPath() + strFileName; if (FormatID == "1") { CreateTextFile(strFilePath, sql_code); } else if (FormatID == "2") { ExcelImport.ExportToExcelNopi(strFilePath, sql_code); } DownloadFile(strFilePath); }