protected void gvCompany_RowDataBound(object sender, GridViewRowEventArgs e) { dsUserTableAdapters.licensee4MgrTableAdapter licensee4MgrTA = new dsUserTableAdapters.licensee4MgrTableAdapter(); dsUser.licensee4MgrDataTable licensee4MgrDT = new dsUser.licensee4MgrDataTable(); if (e.Row.RowType == DataControlRowType.DataRow) { licensee4MgrDT = licensee4MgrTA.GetLicenseesByCID(Convert.ToInt32(gvCompany.DataKeys[e.Row.RowIndex]["ID"].ToString())); if (licensee4MgrDT.Rows.Count == 0) { ((HtmlImage)e.Row.FindControl("viewUserID")).Visible = false; } } /* * if (e.Row.RowType == DataControlRowType.DataRow) * { * if (e.Row.RowType == DataControlRowType.DataRow) * { * //e.Row.Cells[3].Text = "<a href=\"CompanyDetail.aspx?id=" + gvUser.DataKeys[e.Row.RowIndex]["ID"].ToString() + "\">" + e.Row.Cells[3].Text + "</a>"; * e.Row.Cells[0].Text = "<input type=\"button\" value=\"View\" onclick=\"window.location='CompanyDetail.aspx?id=" + gvCompany.DataKeys[e.Row.RowIndex]["ID"].ToString() + "'\">"; * e.Row.Cells[1].Text = "<input type=\"button\" value=\" Edit \" onclick=\"window.location='EditCompany.aspx?id=" + gvCompany.DataKeys[e.Row.RowIndex]["ID"].ToString() + "'\">"; * e.Row.Cells[8].Text = "<input type=\"button\" value=\"Delete\" onclick=\"window.location='DeleteCompany.aspx?id=" + gvCompany.DataKeys[e.Row.RowIndex]["ID"].ToString() + "'\">"; * } * } */ }
public List <user> GetUsersByCID(string cid) { string pID = string.Empty; string pFirstName = string.Empty; string pLastName = string.Empty; dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable(); licenseeDT = licenseeTA.GetPrimaryContactByCID(Convert.ToInt32(cid)); if (licenseeDT.Rows.Count > 0) { pID = licenseeDT.Rows[0]["ID"].ToString();; pFirstName = licenseeDT.Rows[0]["FirstName"].ToString(); pLastName = licenseeDT.Rows[0]["LastName"].ToString(); } dsUserTableAdapters.licensee4MgrTableAdapter licensee4MgrTA = new dsUserTableAdapters.licensee4MgrTableAdapter(); dsUser.licensee4MgrDataTable licensee4MgrDT = new dsUser.licensee4MgrDataTable(); licensee4MgrDT = licensee4MgrTA.GetLicenseesByCID(Convert.ToInt32(cid)); for (int i = 0; i < licensee4MgrDT.Rows.Count; i++) { if (!(licensee4MgrDT.Rows[i]["UserLevel"] is DBNull)) { switch (licensee4MgrDT[i].UserLevel) { case "A": licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "B": licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "C": if (!(licensee4MgrDT.Rows[i]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= licensee4MgrDT[i].AllowedYear) { licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { licensee4MgrDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { licensee4MgrDT[i].Status = "<b>Unknown</b>"; } break; case "D": if (!(licensee4MgrDT.Rows[i]["FromDate"] is DBNull) && !(licensee4MgrDT.Rows[i]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= licensee4MgrDT[i].FromDate) && (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= licensee4MgrDT[i].ToDate)) { licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { licensee4MgrDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { licensee4MgrDT[i].Status = "<b>Unknown</b>"; } break; case "X": licensee4MgrDT[i].Status = "<b><font color=\"red\">Suspended</font></b>"; break; default: break; } } } List <user> users = new List <user>(); foreach (DataRow dr in licensee4MgrDT.Rows) { user u = new user(); u.uid = dr["ID"].ToString(); u.firstName = dr["FirstName"].ToString(); u.lastName = dr["LastName"].ToString(); u.email = dr["Email"].ToString(); u.userCategory = dr["UserCategory"].ToString(); u.requestorName = dr["RequestorName"].ToString(); u.status = dr["Status"].ToString(); u.cid = cid; u.primaryContact = Convert.ToBoolean(dr["PrimaryContact"].ToString()); //u.primaryContact = true; //u.requestorName = "Hudson Choi"; //u.status = "Current"; /* * if (dr["RequestorName"] != null) * { * u.requestorName = dr["RequestorName"].ToString(); * } * if (dr["Status"] != null) * { * u.status = dr["Status"].ToString(); * } */ u.pid = pID; u.pFirstName = pFirstName; u.pLastName = pLastName; if (dr["RequestorEmail"] != null) { u.mlbEmail = dr["RequestorEmail"].ToString(); u.mlbName = dr["RequestorName"].ToString(); } else { u.mlbEmail = ""; u.mlbName = ""; } users.Add(u); } return(users); //List<CollectData> //return c; }
protected void Page_Load(object sender, EventArgs e) { tbSearch.Attributes.Add("onClick", "MakeItBlank()"); //Reset the session variables to make it sense Session["licenseeDT"] = null; //dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); //dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable(); dsUserTableAdapters.licensee4MgrTableAdapter licensee4MgrTA = new dsUserTableAdapters.licensee4MgrTableAdapter(); dsUser.licensee4MgrDataTable licensee4MgrDT = new dsUser.licensee4MgrDataTable(); if ((!Page.IsPostBack) || (tbSearch.Text == "Email, Name or Company")) { //licenseeDT = licenseeTA.GetAllUsers(); if (Request.QueryString["key"] != null) { licensee4MgrDT = licensee4MgrTA.GetLicenseeByKeyword(Server.UrlDecode(Request.QueryString["key"].ToString())); } else { licensee4MgrDT = licensee4MgrTA.GetAllUsers(); } } else { //licenseeDT = licenseeTA.GetLicenseeByKeyword(tbSearch.Text); licensee4MgrDT = licensee4MgrTA.GetLicenseeByKeyword(tbSearch.Text); } for (int i = 0; i < licensee4MgrDT.Rows.Count; i++) { if (!(licensee4MgrDT.Rows[i]["UserLevel"] is DBNull)) { switch (licensee4MgrDT[i].UserLevel) { case "A": licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "B": licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "C": if (!(licensee4MgrDT.Rows[i]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= licensee4MgrDT[i].AllowedYear) { licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { licensee4MgrDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { licensee4MgrDT[i].Status = "<b>Unknown</b>"; } break; case "D": if (!(licensee4MgrDT.Rows[i]["FromDate"] is DBNull) && !(licensee4MgrDT.Rows[i]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= licensee4MgrDT[i].FromDate) && (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= licensee4MgrDT[i].ToDate)) { licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { licensee4MgrDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { licensee4MgrDT[i].Status = "<b>Unknown</b>"; } break; case "X": licensee4MgrDT[i].Status = "<b><font color=\"red\">Suspended</font></b>"; break; default: break; } } } gvUser.DataSource = licensee4MgrDT; //gvCompany.DataBind(); gvUser.DataBind(); lblNum.Text = "Total number of users: " + licensee4MgrDT.Rows.Count; }