protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
dsReportTableAdapters.dtUsersByRequestorTableAdapter dtUsersByRequestorTA = new dsReportTableAdapters.dtUsersByRequestorTableAdapter();
dsReport.dtUsersByRequestorDataTable dtUsersByRequestorDT = new dsReport.dtUsersByRequestorDataTable();
dtUsersByRequestorDT = dtUsersByRequestorTA.GetUsersByRequestor(Convert.ToInt32(ddlRequestor.SelectedValue));
//Status code
for (int i = 0; i < dtUsersByRequestorDT.Rows.Count; i++)
{
if (!(dtUsersByRequestorDT.Rows[i]["UserLevel"] is DBNull))
{
switch (dtUsersByRequestorDT[i].UserLevel)
{
case "A": dtUsersByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break;
case "B": dtUsersByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break;
case "C":
if (!(dtUsersByRequestorDT.Rows[i]["AllowedYear"] is DBNull))
{
if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= dtUsersByRequestorDT[i].AllowedYear)
{
dtUsersByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>";
}
else
{
dtUsersByRequestorDT[i].Status = "<b><font color=\"red\">Expired</font></b>";
}
}
else
{
dtUsersByRequestorDT[i].Status = "<b>Unknown</b>";
}
break;
case "D":
if (!(dtUsersByRequestorDT.Rows[i]["FromDate"] is DBNull) && !(dtUsersByRequestorDT.Rows[i]["ToDate"] is DBNull))
{
if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= dtUsersByRequestorDT[i].FromDate) && (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= dtUsersByRequestorDT[i].ToDate))
{
dtUsersByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>";
}
else
{
dtUsersByRequestorDT[i].Status = "<b><font color=\"red\">Expired</font></b>";
}
}
else
{
dtUsersByRequestorDT[i].Status = "<b>Unknown</b>";
}
break;
default: break;
}
}
}
gvUsers.DataSource = dtUsersByRequestorDT;
gvUsers.DataBind();
lblResult.Text = "Number of users: <b>" + dtUsersByRequestorDT.Rows.Count + "</b>";
lblBreadCrumb.Text = "<a href=\"./\">Home</a> :: <a href=\"ReportByRequestor.aspx\">User Report</a> :: " + ddlRequestor.SelectedItem;
requestorTable.Visible = false;
resultDiv.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
dsReportTableAdapters.dtUsersByRequestorTableAdapter dtUsersByRequestorTA = new dsReportTableAdapters.dtUsersByRequestorTableAdapter();
dsReport.dtUsersByRequestorDataTable dtUsersByRequestorDT = new dsReport.dtUsersByRequestorDataTable();
dtUsersByRequestorDT = dtUsersByRequestorTA.GetUsersByRequestor(Convert.ToInt32(Request.QueryString["id"].ToString()));
for (int i = 0; i < dtUsersByRequestorDT.Rows.Count; i++)
{
if (!(dtUsersByRequestorDT.Rows[i]["UserLevel"] is DBNull))
{
switch (dtUsersByRequestorDT[i].UserLevel)
{
case "A": dtUsersByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break;
case "B": dtUsersByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break;
case "C":
if (!(dtUsersByRequestorDT.Rows[i]["AllowedYear"] is DBNull))
{
if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= dtUsersByRequestorDT[i].AllowedYear)
{
dtUsersByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>";
}
else
{
dtUsersByRequestorDT[i].Status = "<b><font color=\"red\">Expired</font></b>";
}
}
else
{
dtUsersByRequestorDT[i].Status = "<b>Unknown</b>";
}
break;
case "D":
if (!(dtUsersByRequestorDT.Rows[i]["FromDate"] is DBNull) && !(dtUsersByRequestorDT.Rows[i]["ToDate"] is DBNull))
{
if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= dtUsersByRequestorDT[i].FromDate) && (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= dtUsersByRequestorDT[i].ToDate))
{
dtUsersByRequestorDT[i].Status = "<b><font color=\"cyan\">Current</font></b>";
}
else
{
dtUsersByRequestorDT[i].Status = "<b><font color=\"red\">Expired</font></b>";
}
}
else
{
dtUsersByRequestorDT[i].Status = "<b>Unknown</b>";
}
break;
default: break;
}
}
}
gvUsers.DataSource = dtUsersByRequestorDT;
gvUsers.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 + "_user_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);
gvUsers.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("./");
}
}
