コード例 #1
0
ファイル: TimeEntry.aspx.cs プロジェクト: agholub/TimeWeasel
    private void Populate()
    {
        if (SelectedUserId.Equals(0)) SelectedUserId = LoggedInUserID;
        PopulateDateRanges(); // Fill "Week of" dropdown listbox
        PopulateDataGrid(); // Fill Existing Timerecord datagrid

        int strUser = SelectedUserId;
        StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();

        DataTable  dtPto = ui.GetPTOAvailable(SelectedUserId);
        if (dtPto.Rows.Count > 0)
        {
            lblPTOAvailable.Text = dtPto.Rows[0][0].ToString();
        }

        DataTable dtProjects = new DataTable();

        dtProjects = ui.GetProjectListX(strUser);

        DataRow dr;
        dr = dtProjects.NewRow();
        dr["PROJECT_ID"] = 0;
        dr["PROJECT_NAME"] = "--SELECT--";
        dtProjects.Rows.InsertAt(dr, 0);
        inputProject1.DataSource = dtProjects;
        inputProject1.DataTextField = "PROJECT_NAME";
        inputProject1.DataValueField = "PROJECT_ID";
        inputProject1.DataBind();
        inputProject2.DataSource = dtProjects;
        inputProject2.DataTextField = "PROJECT_NAME";
        inputProject2.DataValueField = "PROJECT_ID";
        inputProject2.DataBind();
        inputProject3.DataSource = dtProjects;
        inputProject3.DataTextField = "PROJECT_NAME";
        inputProject3.DataValueField = "PROJECT_ID";
        inputProject3.DataBind();
        inputProject4.DataSource = dtProjects;
        inputProject4.DataTextField = "PROJECT_NAME";
        inputProject4.DataValueField = "PROJECT_ID";
        inputProject4.DataBind();
        inputProject5.DataSource = dtProjects;
        inputProject5.DataTextField = "PROJECT_NAME";
        inputProject5.DataValueField = "PROJECT_ID";
        inputProject5.DataBind();

        //// phases
        ////StoneTimeBusiness.TimeEntryFunctions  ui= new StoneTimeBusiness.TimeEntryFunctions();
        //DataTable dtPhases = new DataTable();
        //// insert blank row
        //dtPhases = ui.GetPhaseList(strUser);
        //if (dtPhases == null)
        //{ }
        //else
        //{
        //    dr = dtPhases.NewRow();
        //    dr["PHASE_ID"] = 0;
        //    dr["NAME"] = "--SELECT--";
        //    dtPhases.Rows.InsertAt(dr, 0);
        //    inputMilestone1.DataSource = dtPhases;
        //    inputMilestone1.DataTextField = "NAME";
        //    inputMilestone1.DataValueField = "PHASE_ID";
        //    inputMilestone1.DataBind();
        //    inputMilestone2.DataSource = dtPhases;
        //    inputMilestone2.DataTextField = "NAME";
        //    inputMilestone2.DataValueField = "PHASE_ID";
        //    inputMilestone2.DataBind();
        //    inputMilestone3.DataSource = dtPhases;
        //    inputMilestone3.DataTextField = "NAME";
        //    inputMilestone3.DataValueField = "PHASE_ID";
        //    inputMilestone3.DataBind();
        //    inputMilestone4.DataSource = dtPhases;
        //    inputMilestone4.DataTextField = "NAME";
        //    inputMilestone4.DataValueField = "PHASE_ID";
        //    inputMilestone4.DataBind();
        //    inputMilestone5.DataSource = dtPhases;
        //    inputMilestone5.DataTextField = "NAME";
        //    inputMilestone5.DataValueField = "PHASE_ID";
        //    inputMilestone5.DataBind();
        //}
        //// tasks
        //DataTable dtTasks = new DataTable();
        //// insert blank row
        //dtTasks = ui.GetTaskList(strUser.ToString());
        //if (dtTasks == null)
        //{ }
        //else
        //{
        //    dr = dtTasks.NewRow();
        //    dr["TASK_ID"] = 0;
        //    dr["NAME"] = "--SELECT--";
        //    dtTasks.Rows.InsertAt(dr, 0);
        //    inputTask1.DataSource = dtTasks;
        //    inputTask1.DataTextField = "NAME";
        //    inputTask1.DataValueField = "TASK_ID";
        //    inputTask1.DataBind();
        //    inputTask2.DataSource = dtTasks;
        //    inputTask2.DataTextField = "NAME";
        //    inputTask2.DataValueField = "TASK_ID";
        //    inputTask2.DataBind();
        //    inputTask3.DataSource = dtTasks;
        //    inputTask3.DataTextField = "NAME";
        //    inputTask3.DataValueField = "TASK_ID";
        //    inputTask3.DataBind();
        //    inputTask4.DataSource = dtTasks;
        //    inputTask4.DataTextField = "NAME";
        //    inputTask4.DataValueField = "TASK_ID";
        //    inputTask4.DataBind();
        //    inputTask5.DataSource = dtTasks;
        //    inputTask5.DataTextField = "NAME";
        //    inputTask5.DataValueField = "TASK_ID";
        //    inputTask5.DataBind();
        //}

        PreloadRecentProjects(SelectedUserId.ToString());

        // is the date range being displayed going to be "savable"?
        // if not, disable the save button and time datagrid
        LockData();
    }