protected void Page_Load(object sender, EventArgs e) { // Set page cache to NO HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache); HttpContext.Current.Response.Cache.SetNoServerCaching(); HttpContext.Current.Response.Cache.SetNoStore(); if (Session["UserID"] == null) { Response.Redirect("Login.aspx"); } if ((Session["UserRole"].ToString().Trim()) != "Manager") { Response.Redirect("Dashboard.aspx"); } //Get Client alias from UserID decimal client_alias = Convert.ToDecimal(Session["UserID"].ToString().Substring(0, 4)); //DataTable dtLogin = new DataTable(); //// Since this is admin specific page, not client alias is required to pass to below method. //dtLogin = VPCRMSBAL.GetProductAssignment(); //grdProductAssignment.DataSource = dtLogin; //grdProductAssignment.DataBind(); // Populate Assigned to dropdown on modal. DataTable dtUserTable = new DataTable(); dtUserTable = VPCRMSBAL.GetUserList(client_alias); if (dtUserTable.Rows.Count > 0) { ddlusername.DataSource = dtUserTable; ddlusername.DataTextField = "clientuserfirstname"; ddlusername.DataValueField = "clientuserid"; ddlusername.DataBind(); ddlusername.Items.Insert(0, new ListItem("Select Assign Person", "0")); ddlusername.SelectedIndex = 0; } // Populate Product Name to dropdown on modal. DataTable dtProdTable = new DataTable(); dtProdTable = VPCRMSBAL.GetProductList(client_alias); if (dtProdTable.Rows.Count > 0) { ddlProductName.DataSource = dtProdTable; ddlProductName.DataValueField = "productname"; ddlProductName.DataValueField = "productname"; ddlProductName.DataBind(); ddlProductName.Items.Insert(0, new ListItem("Select Product", "0")); ddlProductName.SelectedIndex = 0; } DataTable dtTable = new DataTable(); // change alias param of below step .. hardcoded for testing as of now. dtTable = VPCRMSBAL.GetCompanyName(client_alias); if (dtTable.Rows.Count > 0) { lblCompanyName.Text = dtTable.Rows[0]["clientname"].ToString(); lblModalCompanyName.Text = dtTable.Rows[0]["clientname"].ToString(); } else { lblCompanyName.Text = "Default Name"; } }