protected void ExportButtonShortlisted_Click(object sender, EventArgs e) { if (GridViewShortlisted.Rows.Count == 0) { LabelShortlistExport.Visible = true; LabelShortlistExport.Text = "No data to export!"; } else { Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", string.Format("attachment;filename={0}", "Shortlisted.xls")); Response.ContentType = "application/ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridViewShortlisted.AllowPaging = false; GridViewShortlisted.HeaderRow.Style.Add("background-color", "#ffffff"); for (int i = 0; i < GridViewShortlisted.HeaderRow.Cells.Count; i++) { GridViewShortlisted.HeaderRow.Cells[i].Style.Add("background-color", "#df5015"); } GridViewShortlisted.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["role"] == null) { Response.Redirect("loginStaff.aspx"); } else { if (!IsPostBack) { TripDAO TripDAO = new TripDAO(); List <Trip> TripList = new List <Trip>(); int tripId = Convert.ToInt32(Request.QueryString["tripId"]); TripList = TripDAO.GetShortlisted(tripId); GridViewShortlisted.DataSource = TripList; GridViewShortlisted.DataBind(); TripList = TripDAO.GetRegisteredList(tripId); GridViewRegistered.DataSource = TripList; GridViewRegistered.DataBind(); TripList = TripDAO.GetRegisteredList(tripId); GridViewRegisteredExport.DataSource = TripList; GridViewRegisteredExport.DataBind(); TripList = TripDAO.GetWaitingList(tripId); GridViewWaitingList.DataSource = TripList; GridViewWaitingList.DataBind(); TripList = TripDAO.GetWaitingList(tripId); GridViewWaitingListExport.DataSource = TripList; GridViewWaitingListExport.DataBind(); TripList = TripDAO.GetNorminated(tripId); GridViewNorminated.DataSource = TripList; GridViewNorminated.DataBind(); TripList = TripDAO.GetNorminated(tripId); GridViewNorminatedExport.DataSource = TripList; GridViewNorminatedExport.DataBind(); TripList = TripDAO.GetRegisteredList(tripId); GridViewRegisteredIncharge.DataSource = TripList; GridViewRegisteredIncharge.DataBind(); TripList = TripDAO.GetNorminated(tripId); GridViewNorminatedIncharge.DataSource = TripList; GridViewNorminatedIncharge.DataBind(); TripList = TripDAO.GetWaitingList(tripId); GridViewWaitingListIncharge.DataSource = TripList; GridViewWaitingListIncharge.DataBind(); FeedbackForm cusObj = new FeedbackForm(); FeedbackFormDAO cusDao = new FeedbackFormDAO(); cusObj = cusDao.GetSpecificTrip(tripId); if (cusObj != null) { TripTitleLabel.Text = cusObj.TripTitle; CountryLabel.Text = cusObj.Country; LabelTripId.Text = (cusObj.TripId).ToString(); } } } LabelShortlistExport.Visible = false; LabelWaitingExport.Visible = false; LabelShortlistExport.Visible = false; LabelRegisterExport.Visible = false; }