protected void Page_Load(object sender, EventArgs e) { dsReportTableAdapters.dtCompaniesByRequestorTableAdapter dtCompaniesByRequestorTA = new dsReportTableAdapters.dtCompaniesByRequestorTableAdapter(); dsReport.dtCompaniesByRequestorDataTable dtCompaniesByRequestorDT = new dsReport.dtCompaniesByRequestorDataTable(); dtCompaniesByRequestorDT = dtCompaniesByRequestorTA.GetCompaniesByRequestor(34); gvCompany.DataSource = dtCompaniesByRequestorDT; gvCompany.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { dsReportTableAdapters.dtCompaniesByRequestorTableAdapter dtCompaniesByRequestorTA = new dsReportTableAdapters.dtCompaniesByRequestorTableAdapter(); dsReport.dtCompaniesByRequestorDataTable dtCompaniesByRequestorDT = new dsReport.dtCompaniesByRequestorDataTable(); dtCompaniesByRequestorDT = dtCompaniesByRequestorTA.GetCompaniesByRequestor(Convert.ToInt32(Request.QueryString["id"].ToString())); //Status Code for (int i = 0; i < dtCompaniesByRequestorDT.Rows.Count; i++) { if (!(dtCompaniesByRequestorDT.Rows[i]["UserLevel"] is DBNull)) { switch (dtCompaniesByRequestorDT[i].UserLevel) { case "A": dtCompaniesByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "B": dtCompaniesByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "C": if (!(dtCompaniesByRequestorDT.Rows[i]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= dtCompaniesByRequestorDT[i].AllowedYear) { dtCompaniesByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { dtCompaniesByRequestorDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { dtCompaniesByRequestorDT[i].Status = "<b>Unknown</b>"; } break; case "D": if (!(dtCompaniesByRequestorDT.Rows[i]["FromDate"] is DBNull) && !(dtCompaniesByRequestorDT.Rows[i]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= dtCompaniesByRequestorDT[i].FromDate) && (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= dtCompaniesByRequestorDT[i].ToDate)) { dtCompaniesByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { dtCompaniesByRequestorDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { dtCompaniesByRequestorDT[i].Status = "<b>Unknown</b>"; } break; default: break; } } } gvCompany.DataSource = dtCompaniesByRequestorDT; gvCompany.DataBind(); dsCompanyTableAdapters.dtRequestorLastNameTableAdapter dtRequestorLastNameTA = new dsCompanyTableAdapters.dtRequestorLastNameTableAdapter(); dsCompany.dtRequestorLastNameDataTable dtRequestorLastNameDT = new dsCompany.dtRequestorLastNameDataTable(); dtRequestorLastNameDT = dtRequestorLastNameTA.GetRequestorLastNameByID(Convert.ToInt32(Request.QueryString["id"].ToString())); Response.Clear(); Response.ClearHeaders(); //For HTTPS Response.Cache.SetCacheability(HttpCacheability.Private); //For HTTPS //Response.AddHeader("content-disposition", "attachment; filename=SpifeAssociates"+Convert.ToDateTime(AssociatesDT.Rows[0]["downloaddate"].ToString()).ToShortDateString()+".xls"); Response.AddHeader("content-disposition", "attachment; filename=" + dtRequestorLastNameDT[0].lastname + "_company_list.xls"); Response.Charset = ""; //Response.Cache.SetCacheability(HttpCacheability.NoCache); // //Response.AddHeader("Content-Type", "application/vnd.ms-excel"); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); gvCompany.RenderControl(htmlWrite); /* * sqlDataAdapter1.Fill(dsDownload1, "users"); * if (!Page.IsPostBack) * { * dgDownload.DataSource = dsDownload1; * dgDownload.DataBind(); * } * dgDownload.RenderControl(htmlWrite); */ Response.Write(stringWrite.ToString()); Response.End(); } else { Response.Redirect("./"); } }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack) { dsReportTableAdapters.dtCompaniesByRequestorTableAdapter dtCompaniesByRequestorTA = new dsReportTableAdapters.dtCompaniesByRequestorTableAdapter(); dsReport.dtCompaniesByRequestorDataTable dtCompaniesByRequestorDT = new dsReport.dtCompaniesByRequestorDataTable(); dtCompaniesByRequestorDT = dtCompaniesByRequestorTA.GetCompaniesByRequestor(Convert.ToInt32(ddlRequestor.SelectedValue)); for (int i = 0; i < dtCompaniesByRequestorDT.Rows.Count; i++) { if (!(dtCompaniesByRequestorDT.Rows[i]["UserLevel"] is DBNull)) { switch (dtCompaniesByRequestorDT[i].UserLevel) { case "A": dtCompaniesByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "B": dtCompaniesByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "C": if (!(dtCompaniesByRequestorDT.Rows[i]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= dtCompaniesByRequestorDT[i].AllowedYear) { dtCompaniesByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { dtCompaniesByRequestorDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { dtCompaniesByRequestorDT[i].Status = "<b>Unknown</b>"; } break; case "D": if (!(dtCompaniesByRequestorDT.Rows[i]["FromDate"] is DBNull) && !(dtCompaniesByRequestorDT.Rows[i]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= dtCompaniesByRequestorDT[i].FromDate) && (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= dtCompaniesByRequestorDT[i].ToDate)) { dtCompaniesByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { dtCompaniesByRequestorDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { dtCompaniesByRequestorDT[i].Status = "<b>Unknown</b>"; } break; default: break; } } } gvCompany.DataSource = dtCompaniesByRequestorDT; gvCompany.DataBind(); lblResult.Text = "Number of companies: <b>" + dtCompaniesByRequestorDT.Rows.Count + "</b>"; lblBreadCrumb.Text = "<a href=\"./\">Home</a> :: <a href=\"CompanyReportByRequestor.aspx\">Company Report</a> :: " + ddlRequestor.SelectedItem; requestorTable.Visible = false; resultDiv.Visible = true; /* * dsReportTableAdapters.dtUsersByRequestorTableAdapter dtUsersByRequestorTA = new dsReportTableAdapters.dtUsersByRequestorTableAdapter(); * * dsReport.dtUsersByRequestorDataTable dtUsersByRequestorDT = new dsReport.dtUsersByRequestorDataTable(); * dtUsersByRequestorDT = dtUsersByRequestorTA.GetUsersByRequestor(Convert.ToInt32(ddlRequestor.SelectedValue)); * gvCompany.DataSource = dtUsersByRequestorDT; * gvCompany.DataBind(); * * lblResult.Text = "Number of users: <b>" + dtUsersByRequestorDT.Rows.Count + "</b>"; * * lblBreadCrumb.Text = "<a href=\"./\">Home</a> :: <a href=\"Report.aspx\">Report</a> :: <a href=\"ReportByRequestor.aspx\">By MLB Contact</a> :: " + ddlRequestor.SelectedItem; * requestorTable.Visible = false; * resultDiv.Visible = true; * */ } }