public static byte[] ExportStock_SymbolPermLongToExcel(stock_SymbolPermLongExtensionCollection stock_SymbolPermLongExtensionCollection, string templatePath)
{
Dictionary<string, object> model = new Dictionary<string, object>();
model["stock_SymbolPermLongExtensionCollection"] = stock_SymbolPermLongExtensionCollection;
return ExportToExcel(model, templatePath);
}
public virtual stock_SymbolPermLongExtensionCollection Export_SymbolPermLongList(DateTime permDate, string market)
{
try
{
Database database = DatabaseFactory.CreateDatabase("DestinationConnection");
DbCommand dbCommand = database.GetStoredProcCommand("spMarketReview");
database.AddInParameter(dbCommand, "@PermDate", DbType.DateTime, permDate);
database.AddInParameter(dbCommand, "@Market", DbType.String, market.ToString());
stock_SymbolPermLongExtensionCollection stock_SymbolPermLongExtensionCollection = new stock_SymbolPermLongExtensionCollection();
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
stock_SymbolPermLongExtension stock_SymbolPermLongExtension = Createstock_SymbolPermLongExtensionFromReader(reader);
stock_SymbolPermLongExtensionCollection.Add(stock_SymbolPermLongExtension);
}
reader.Close();
}
return stock_SymbolPermLongExtensionCollection;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessGetstock_SymbolPermLongListException, ex);
}
}
private void Export_symbolPermLong()
{
stock_SymbolPermLongExtensionCollection stock_SymbolPermLongExtensionCollection = new stock_SymbolPermLongExtensionCollection();
stock_SymbolPermLongExtensionCollection = stock_SymbolPermLongService.Export_SymbolPermLongList(ApplicationHelper.ConvertStringToDate(exportDateInput.Text), exportMarketInput.Value);
byte[] data = Vfs.WebCrawler.Destination.Business.ExportService.ExportStock_SymbolPermLongToExcel(stock_SymbolPermLongExtensionCollection, ApplicationHelper.GetFullPath(ApplicationHelper.ExportSymbolPermLong));
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=\"InfoMartketReview.xls\"");
Response.AddHeader("Content-Length", data.Length.ToString());
Response.OutputStream.Flush();
Response.OutputStream.Write(data, 0, data.Length);
Response.OutputStream.Flush();
}
