protected void btnExport_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"SupplierName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"Price"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"Gift"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"IsOrder"), typeof(string)));
List <OfferUI> coll = OfferController.GetAllOfferByBidIdWithIsOrder(BidId);
foreach (OfferUI offer in coll)
{
int i = 0;
System.Data.DataRow row = dt.NewRow();
row[i++] = offer.SupplierName;
row[i++] = offer.TotalPrice;
row[i++] = offer.Gift;
row[i++] = GlobalStrings.GetYesNo(offer.IsOrder);
dt.Rows.Add(row);
}
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=OffersExport_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension);
Response.Charset = @"UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = ex.FileContentType;
Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble());
Response.Write(ex.ToString());
Response.End();
}
protected void LoadItems()
{
phHasItems.Visible = true;
phHasNoItems.Visible = false;
if (dgOffers.PageSize * dgOffers.CurrentPageIndex > dgOffers.VirtualItemCount)
{
dgOffers.CurrentPageIndex = 0;
hfCurrentPageIndex_dgOffers.Value = dgOffers.CurrentPageIndex.ToString();
}
List <OfferUI> coll = OfferController.GetAllOfferByBidIdWithIsOrder(BidId);
BindList(coll);
}