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