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";
        }
    }