protected void Button1_Click(object sender, EventArgs e) { try { DataTable resultsData = new DataTable(); AspxCommonInfo aspxCommonObj = new AspxCommonInfo(); aspxCommonObj.StoreID = GetStoreID; aspxCommonObj.PortalID = GetPortalID; aspxCommonObj.CultureName = GetCurrentCultureName; StoreSettingConfig ssc = new StoreSettingConfig(); string CurrencyCode = ssc.GetStoreSettingsByKey(StoreSetting.MainCurrency, GetStoreID, GetPortalID, CultureName); string CurrencySymbol = StoreSetting.GetSymbolFromCurrencyCode(CurrencyCode, GetStoreID, GetPortalID); List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@CurrencySymbol", CurrencySymbol)); parameter.Add(new KeyValuePair<string, object>("@GiftCardType", _csvGiftCardHiddenCsv.Value)); string filename = "MyReport_GiftCardItems" + "_" + DateTime.Now.ToString("M_dd_yyyy_H_M_s") + ".xls"; string filePath = HttpContext.Current.Server.MapPath(ResolveUrl(this.AppRelativeTemplateSourceDirectory)) + filename; ExportLargeData excelLdata = new ExportLargeData(); excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_GetGiftCardReportsForExport]", parameter, resultsData); } catch (Exception ex) { ProcessException(ex); } }
protected void Button1_Click(object sender, EventArgs e) { try { DataTable resultsData = new DataTable(); AspxCommonInfo aspxCommonObj = new AspxCommonInfo(); aspxCommonObj.StoreID = GetStoreID; aspxCommonObj.PortalID = GetPortalID; aspxCommonObj.CultureName = GetCurrentCultureName; List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); string filename = "MyReport_OrderedItems" + "_" + DateTime.Now.ToString("M_dd_yyyy_H_M_s") + ".xls"; string filePath = HttpContext.Current.Server.MapPath(ResolveUrl(this.AppRelativeTemplateSourceDirectory)) + filename; ExportLargeData excelLdata = new ExportLargeData(); excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_GetItemsOrderedForExport]", parameter, resultsData); } catch (Exception ex) { ProcessException(ex); } }