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