Пример #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string userIdStr = Session["userId"].ToString();
            string roleIdStr = Session["roleId"].ToString();
            if (roleIdStr == "1")
            {
                LoadLookup.LoadProgram(ddlProgram, "xxx", true);
                ddlProgram.SelectedValue = "0";
                LoadLookup.LoadMemberOnProgram(0, ddlMember);
                LoadLookup.LoadResource(ddlResource, "xxx");
            }
            if (roleIdStr == "2")
            {
                string        connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString;
                SqlConnection conn          = new SqlConnection(connectionStr);
                string        sqlStatement;
                sqlStatement = "select" +
                               " right('0' + convert(varchar, lp.l_program_id),2) + '-' + lp.program_name as program" +
                               " from pub_user pu" +
                               " inner join program_leader pl" +
                               " on pu.client_id = pl.client_id" +
                               " inner join l_program lp" +
                               " on pl.l_program_id = lp.l_program_id" +
                               " where pu.pub_user_id = " +
                               userIdStr;

                SqlCommand command = new SqlCommand(sqlStatement, conn);
                conn.Open();
                string program    = "";
                object programObj = (object)command.ExecuteScalar();
                if (programObj != DBNull.Value)
                {
                    program = programObj.ToString();
                }
                conn.Close();
                LoadLookup.LoadProgram(ddlProgram, program, true);

                //ddlProgram.SelectedValue = "0";
                //LoadLookup.LoadMemberOnProgram(0, ddlMember);

                //ddlProgram.Enabled = false;
                int programId = Convert.ToInt32(ddlProgram.SelectedValue);
                LoadLookup.LoadMemberOnProgram(programId, ddlMember);

                //SelectProgram(sender, e);
            }

            HttpCookie _dateCookies = Request.Cookies["dates"];
            if (_dateCookies != null)
            {
                txtStartDate.Text = _dateCookies["startDate"];
                txtEndDate.Text   = _dateCookies["endDate"];
            }
        }
        //string scriptStr = "function ShowConfirmation(){return confirm('hahaha');}";
        //Page.ClientScript.RegisterStartupScript(this.GetType(), "Hello", scriptStr, true);
        //Button1.Attributes.Add("OnClick", "javascript:return ShowConfirmation();");
    }
Пример #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //LoadMember(ddlMember, "xxx");
            //LoadMemberList.LoadMember(ddlMember, "xxx");
            //LoadLookup.LoadMember(ddlMember, "xxx");
            LoadLookup.LoadProgram(ddlProgram, "xxx", true);
            ddlProgram.SelectedValue = "0";
            LoadLookup.LoadMemberOnProgram(0, ddlMember);

            HttpCookie _dateCookies = Request.Cookies["dates"];
            if (_dateCookies != null)
            {
                txtStartDate.Text = _dateCookies["startDate"];
                txtEndDate.Text   = _dateCookies["endDate"];
            }

            string userIdStr = Session["userId"].ToString();
            string roleIdStr = Session["roleId"].ToString();

            Menu myMenu = null;
            myMenu = (Menu)Master.FindControl("Menu1");
            if (myMenu != null)
            {
                if (roleIdStr != "1" && roleIdStr == "2")
                {
                    MenuItem mi = (MenuItem)myMenu.FindItem("Edit Pubs");
                    //mi.v
                }
            }
        }
    }
Пример #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string        connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString;
        SqlConnection conn          = new SqlConnection(connectionStr);
        string        sqlStatement;

        if (!IsPostBack)
        {
            //LoadLookup.LoadMember(ddlMember, "xxx");
            LoadLookup.LoadProgram(ddlProgram, "xxx", true);
            ddlProgram.SelectedValue = "0";
            LoadLookup.LoadMemberOnProgram(0, ddlMember);

            sqlStatement =
                "select l_resource_id, description as resource" +
                " from l_resource order by description";

            SqlDataSource dsResource = new SqlDataSource(connectionStr, sqlStatement);

            chxlResource.DataSource     = dsResource;
            chxlResource.DataTextField  = "resource";
            chxlResource.DataValueField = "l_resource_id";
            chxlResource.DataBind();

            HttpCookie _dateCookies = Request.Cookies["dates"];
            if (_dateCookies != null)
            {
                txtStartDate.Text = _dateCookies["startDate"];
                txtEndDate.Text   = _dateCookies["endDate"];
            }
        }
    }
Пример #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string userIdStr = Session["userId"].ToString();
            string roleIdStr = Session["roleId"].ToString();
            if (roleIdStr == "1")
            {
                LoadLookup.LoadProgram(ddlProgram, "xxx", false);
            }
            if (roleIdStr == "2")
            {
                string        connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString;
                SqlConnection conn          = new SqlConnection(connectionStr);
                string        sqlStatement;
                sqlStatement = "select" +
                               " right('0' + convert(varchar, lp.l_program_id),2) + '-' + lp.program_name as program" +
                               " from pub_user pu" +
                               " inner join program_leader pl" +
                               " on pu.client_id = pl.client_id" +
                               " inner join l_program lp" +
                               " on pl.l_program_id = lp.l_program_id" +
                               " where pu.pub_user_id = " +
                               userIdStr;

                SqlCommand command = new SqlCommand(sqlStatement, conn);
                conn.Open();
                string program    = "";
                object programObj = (object)command.ExecuteScalar();
                if (programObj != DBNull.Value)
                {
                    program = programObj.ToString();
                }
                conn.Close();
                LoadLookup.LoadProgram(ddlProgram, program, false);
                ddlProgram.Enabled = false;
                //int programId = Convert.ToInt32(ddlProgram.SelectedValue);
                //LoadLookup.LoadMemberOnProgram(programId, ddlMember);
            }

            HttpCookie _dateCookies = Request.Cookies["dates"];
            if (_dateCookies != null)
            {
                txtStartDate.Text = _dateCookies["startDate"];
                txtEndDate.Text   = _dateCookies["endDate"];
            }

            Menu myMenu = null;
            myMenu = (Menu)Master.FindControl("Menu1");
            if (myMenu != null)
            {
                if (roleIdStr != "1" && roleIdStr == "2")
                {
                    MenuItem mi = (MenuItem)myMenu.FindItem("Edit Pubs");
                    //mi.v
                }
            }
        }
    }
Пример #5
0
    protected void Page_Load(object sender, System.EventArgs e)
    {
        if (!IsPostBack)
        {
            LoadLookup.LoadMember(ddlMember, "xxx");

            //FillUpGrid();
        }
    }
Пример #6
0
    protected void gvCollectiveNameClient_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            LinkButton lbEditTemp = null;
            lbEditTemp = (LinkButton)e.Row.FindControl("lnkEdit");
            LinkButton lbDeleteTemp = null;
            lbDeleteTemp = (LinkButton)e.Row.FindControl("lnkDelete");

            DataRowView  drv = (DataRowView)e.Row.DataItem;
            string       currCollectiveNameStr = drv["collective_name"].ToString();
            DropDownList ddlCollectiveNameTemp = null;
            ddlCollectiveNameTemp = (DropDownList)e.Row.FindControl("ddlCollectiveName");
            if (ddlCollectiveNameTemp != null)
            {
                LoadLookup.LoadCollectiveName(ddlCollectiveNameTemp, currCollectiveNameStr);
            }
            string       currClientStr = drv["client"].ToString();
            DropDownList ddlMemberTemp = null;
            ddlMemberTemp = (DropDownList)e.Row.FindControl("ddlMember");
            if (ddlMemberTemp != null)
            {
                LoadLookup.LoadMember(ddlMemberTemp, currClientStr, "01/01/2000", "01/01/2015");
            }
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            LinkButton lbAddTemp = null;
            lbAddTemp = (LinkButton)e.Row.FindControl("lnkAdd");
            if (lbAddTemp == null)
            {
                return;
            }
            DropDownList ddlCollectiveNameTemp = null;
            ddlCollectiveNameTemp = (DropDownList)e.Row.FindControl("ddlNewCollectiveName");
            if (ddlCollectiveNameTemp == null)
            {
                return;
            }
            else
            {
                LoadLookup.LoadCollectiveName(ddlCollectiveNameTemp, "xxx");
            }
            DropDownList ddlMemberTemp = null;
            ddlMemberTemp = (DropDownList)e.Row.FindControl("ddlNewMember");
            if (ddlMemberTemp == null)
            {
                return;
            }
            else
            {
                LoadLookup.LoadMember(ddlMemberTemp, "xxx", "01/01/2000", "01/01/2015");
            }
        }
    }
Пример #7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         HttpCookie _dateCookies = Request.Cookies["dates"];
         if (_dateCookies != null)
         {
             txtStartDate.Text = _dateCookies["startDate"];
             txtEndDate.Text   = _dateCookies["endDate"];
         }
         LoadLookup.LoadMember(ddlMember, "xxx", txtStartDate.Text, txtEndDate.Text);
     }
 }
Пример #8
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         LoadLookup.LoadProgram(ddlProgram, "xxx", false);
         HttpCookie _dateCookies = Request.Cookies["dates"];
         if (_dateCookies != null)
         {
             txtStartDate.Text = _dateCookies["startDate"];
             txtEndDate.Text   = _dateCookies["endDate"];
         }
     }
 }
Пример #9
0
    protected void SelectProgram(object sender, EventArgs e)
    {
        string programIdStr = ddlProgram.SelectedValue.ToString();
        int    programId    = Convert.ToInt32(programIdStr);

        //if (ddlProgram.SelectedIndex != 0 && ddlProgram.SelectedIndex != -1)
        LoadLookup.LoadMemberOnProgram(programId, ddlMember);
        if (ddlProgram.SelectedValue.ToString() != "0")
        {
        }
        else
        {
            //btnReportFocusNon0.Text = "Focus Groups Excluding 0";
        }
    }
Пример #10
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            onePubDiv.Visible = false;
            LoadLookup.LoadProgram(ddlProgram, "xxx", false);
            LoadSharedResource(ddlSharedResource, "xxx");


            HttpCookie _dateCookies = Request.Cookies["dates"];
            if (_dateCookies != null)
            {
                txtStartDate.Text = _dateCookies["startDate"];
                txtEndDate.Text   = _dateCookies["endDate"];
            }
        }
    }
Пример #11
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //LoadLookup.LoadMember(ddlMember, "xxx");
            LoadLookup.LoadProgram(ddlProgram, "xxx", true);
            ddlProgram.SelectedValue = "0";
            LoadLookup.LoadMemberOnProgram(0, ddlMember);

            HttpCookie _dateCookies = Request.Cookies["dates"];
            if (_dateCookies != null)
            {
                txtStartDate.Text = _dateCookies["startDate"];
                txtEndDate.Text   = _dateCookies["endDate"];
            }
        }
    }
Пример #12
0
    protected void grdFocusGroup_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            LinkButton lbEditTemp = null;
            lbEditTemp = (LinkButton)e.Row.FindControl("lnkEdit");
            LinkButton lbDeleteTemp = null;
            lbDeleteTemp = (LinkButton)e.Row.FindControl("lnkDelete");

            DataRowView drv            = (DataRowView)e.Row.DataItem;
            string      currProgramStr = drv["program"].ToString();

            DropDownList ddlProgramTemp = null;
            ddlProgramTemp = (DropDownList)e.Row.FindControl("ddlProgram");
            if (ddlProgramTemp != null)
            {
                LoadLookup.LoadProgram(ddlProgramTemp, currProgramStr, false);
            }
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            LinkButton lbAddTemp = null;
            lbAddTemp = (LinkButton)e.Row.FindControl("lnkAdd");
            if (lbAddTemp == null)
            {
                return;
            }
            TextBox txtGroupNumberTemp = null;
            txtGroupNumberTemp = (TextBox)e.Row.FindControl("txtNewGroupNumber");
            if (txtGroupNumberTemp == null)
            {
                return;
            }
            DropDownList ddlProgramTemp = null;
            ddlProgramTemp = (DropDownList)e.Row.FindControl("ddlNewProgram");
            if (ddlProgramTemp == null)
            {
                return;
            }
            else
            {
                LoadLookup.LoadProgram(ddlProgramTemp, "xxx", false);
            }
        }
    }
Пример #13
0
    protected void SelectProgram(object sender, EventArgs e)
    {
        string programIdStr = ddlProgram.SelectedValue.ToString();
        int    programId    = Convert.ToInt32(programIdStr);

        //if (ddlProgram.SelectedIndex != 0 && ddlProgram.SelectedIndex != -1)
        LoadLookup.LoadMemberOnProgram(programId, ddlMember);
        if (ddlProgram.SelectedValue.ToString() != "0")
        {
            int totalFocusGroup = GetTotalFocusGroup(programId);
            btnReportProgramNon0FG.Text = "Focus Groups 1 - " + totalFocusGroup.ToString();
        }
        else
        {
            btnReportProgramNon0FG.Text = "Focus Groups Excluding 0";
        }
        FillMemberSource(programId);
    }
Пример #14
0
    protected void SelectProgram(object sender, EventArgs e)
    {
        int programId = Convert.ToInt32(ddlProgram.SelectedValue);

        LoadLookup.LoadMemberOnProgram(programId, ddlMember);
    }
Пример #15
0
    protected void gvAuthor_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            LinkButton lbEditTemp = null;
            lbEditTemp = (LinkButton)e.Row.FindControl("lnkEdit");
            LinkButton lbDeleteTemp = null;
            lbDeleteTemp = (LinkButton)e.Row.FindControl("lnkDelete");

            DataRowView drv           = (DataRowView)e.Row.DataItem;
            string      currClientStr = drv["client"].ToString();

            DropDownList ddlMemberTemp = null;
            ddlMemberTemp = (DropDownList)e.Row.FindControl("ddlMember");
            if (ddlMemberTemp != null)
            {
                LoadLookup.LoadMember(ddlMemberTemp, currClientStr, "01/01/2000", "01/01/2015");
            }
            TextBox txtLastNameTemp = null;
            txtLastNameTemp = (TextBox)e.Row.FindControl("txtLastName");
            if (txtLastNameTemp == null)
            {
                return;
            }
            else
            {
                txtLastNameTemp.Text = drv["LastName"].ToString();
            }
            TextBox txtForeNameTemp = null;
            txtForeNameTemp = (TextBox)e.Row.FindControl("txtForeName");
            if (txtForeNameTemp == null)
            {
                return;
            }
            else
            {
                txtForeNameTemp.Text = drv["ForeName"].ToString();
            }
            TextBox txtInitialsTemp = null;
            txtInitialsTemp = (TextBox)e.Row.FindControl("txtInitials");
            if (txtInitialsTemp == null)
            {
                return;
            }
            else
            {
                txtInitialsTemp.Text = drv["Initials"].ToString();
            }
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            LinkButton lbAddTemp = null;
            lbAddTemp = (LinkButton)e.Row.FindControl("lnkAdd");
            if (lbAddTemp == null)
            {
                return;
            }
            TextBox txtLastNameTemp = null;
            txtLastNameTemp = (TextBox)e.Row.FindControl("txtNewLastName");
            if (txtLastNameTemp == null)
            {
                return;
            }
            TextBox txtForeNameTemp = null;
            txtForeNameTemp = (TextBox)e.Row.FindControl("txtNewForeName");
            if (txtForeNameTemp == null)
            {
                return;
            }
            TextBox txtInitialsTemp = null;
            txtInitialsTemp = (TextBox)e.Row.FindControl("txtNewInitials");
            if (txtInitialsTemp == null)
            {
                return;
            }
            DropDownList ddlMemberTemp = null;
            ddlMemberTemp = (DropDownList)e.Row.FindControl("ddlNewMember");
            if (ddlMemberTemp == null)
            {
                return;
            }
            else
            {
                LoadLookup.LoadMember(ddlMemberTemp, "xxx", "01/01/2000", "01/01/2015");
            }
        }
    }