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(); }