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