private void PopulateClientAddress() { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetClientAddress(SelectedClientID.ToString()); // populate the address data if( dt.Rows.Count > 0 ) { txtAddress1.Text = dt.Rows[0]["address1"].ToString(); txtAddress2.Text = dt.Rows[0]["address2"].ToString(); txtCity.Text = dt.Rows[0]["CITY"].ToString(); txtZip.Text = dt.Rows[0]["zip"].ToString(); // set the state drop down list ddlClientState.SelectedValue = dt.Rows[0]["state_id"].ToString(); } else { txtAddress1.Text = ""; txtAddress2.Text = ""; txtCity.Text = ""; txtZip.Text = ""; // set the state drop down list ddlClientState.SelectedValue = "1"; } }
private void PopulateUserList() { DataTable dt = new DataTable(); StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); dt = ui.GetUserList(LoggedInUserID.ToString()); gvUsers.DataSource = dt; gvUsers.DataBind(); }
private void PopulateStates() { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetStates(); ddlClientState.DataTextField = "ABBREVIATION"; ddlClientState.DataValueField = "STATE_ID"; ddlClientState.DataSource = dt; ddlClientState.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetClientList(); gvClients.DataSource = dt; gvClients.DataBind(); } }
private void PopulateRoles() { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetRoles(); // populate the role dropdown list. inputRole.DataTextField = "Name"; inputRole.DataValueField = "USER_TYPE_ID"; inputRole.DataSource = dt; inputRole.DataBind(); }
private void GetPTOGroupTypes() { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetPTOGroupTypes(); // populate the EmployeeType dropdown list. inputPTOGroup.DataTextField = "PTO_GROUP_NAME"; inputPTOGroup.DataValueField = "PTO_GROUP_ID"; inputPTOGroup.DataSource = dt; inputPTOGroup.DataBind(); }
private void PopulateClient() { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); if (SelectedClientID > 0) { DataTable dt = ui.GetClientData(SelectedClientID.ToString()); txtCompanyName.Text = dt.Rows[0]["COMPANY_NAME"].ToString(); txtWebsite.Text = dt.Rows[0]["company_website"].ToString(); InputClientComment.Text = dt.Rows[0]["comment"].ToString(); PopulateClientAddress(); } }
private void PopulateUserData(string userId) { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetUserData(userId); MembershipUser user = Membership.GetUser(dt.Rows[0]["UserName"].ToString()); if (Roles.IsUserInRole(user.UserName, "ADMIN")) chkAdmin.Checked = true; else chkAdmin.Checked = false; if (Roles.IsUserInRole(user.UserName, "PM")) chkProjectManager.Checked = true; else chkProjectManager.Checked = false; if (user.IsLockedOut) { chkLocked.Visible = true; chkLocked.Checked = true; }else{ chkLocked.Visible = false; chkLocked.Checked = false; } PopulateUserTitleList(); PopulateEmployeeStatus(); PopulateUserTypeList(); GetPTOGroupTypes(); PopulateRoles(); //PopulateEmployeeTypeList(); inputFirstName.Text = ""; inputMiddleName.Text = ""; inputLastName.Text = ""; //inputName.Text = dt.Rows[0]["User_Type_ID][ inputUserName.Text = ""; inputPW.Text = ""; inputConfirmPW.Text = ""; if (!userId.Equals("0")) { if(dt.Rows[0]["Email"] != null) inputUserEmail.Text = dt.Rows[0]["Email"].ToString(); //inputFirstName.Text = dt.Rows[0]["First"].ToString() inputFirstName.Text = dt.Rows[0]["First"].ToString(); if (dt.Rows[0]["Middle"] != null) { inputMiddleName.Text = dt.Rows[0]["Middle"].ToString(); } inputLastName.Text = dt.Rows[0]["Last"].ToString(); //inputName.Text = dt.Rows[0]["User_Type_ID"].ToString() inputUserName.Text = dt.Rows[0]["UserName"].ToString(); inputPW.Text = dt.Rows[0]["Password"].ToString(); inputConfirmPW.Text = dt.Rows[0]["Password"].ToString(); inputRole.DataValueField = "USER_TYPE_ID"; inputRole.SelectedValue = dt.Rows[0]["USER_TYPE_ID"].ToString(); inputPTOGroup.DataValueField = "PTO_GROUP_ID"; inputPTOGroup.SelectedValue = dt.Rows[0]["PTO_GROUP_ID"].ToString(); ddlEmpStatus.SelectedValue = dt.Rows[0]["STATUS"].ToString(); if (dt.Rows[0]["TITLE_ID"] != null) { ddlTitle.SelectedValue = dt.Rows[0]["TITLE_ID"].ToString(); } else { ddlTitle.SelectedIndex = 0; } txtTermDate.Text = dt.Rows[0]["TERMINATION_DATE"].ToString(); txtStartDate.Text = Convert.ToDateTime( dt.Rows[0]["START_DATE"].ToString()).ToShortDateString(); if (dt.Rows[0]["EMPLOYEE_TYPE_ID"] == null) { } else { inputEmployeeType.DataValueField = "EMPLOYEE_TYPE_ID"; inputEmployeeType.SelectedValue = dt.Rows[0]["EMPLOYEE_TYPE_ID"].ToString(); } } else { inputFirstName.Text = ""; inputMiddleName.Text = ""; inputLastName.Text = ""; //inputName.Text = "" inputUserName.Text = ""; inputPW.Text = ""; inputConfirmPW.Text = ""; } }
private Boolean Save(DataTable dt, Boolean replace) { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); ui.SaveTime(dt, Convert.ToInt16(ddlUserList.SelectedValue), replace); return true; }
public int GetUserId(string username) { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetUserInfo(username); DataRow dr = dt.Rows[0]; int userid = Convert.ToInt16(dr["USER_ID"].ToString()); return userid; }
private DataTable GetTimeEntryData() { DataTable dt = new DataTable(); StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); dt = ui.GetTimeEntryData(MasterDate, base.SelectedUserId); return dt; }
protected void Page_Load(object sender, EventArgs e) { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); //Response.Write(ui.GetUserInfo( User.Identity.Name.ToString())); if (!IsPostBack) { PopulateUserList(); // fill User List Populate(); } }
private void GetPhasesAndTasks(int ProjectIndex) { int intProject = 0; StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = new DataTable(); switch (ProjectIndex) { case 1: intProject = Convert.ToInt16(inputProject1.SelectedValue); if (intProject < 1) return; inputBillable1.Checked = Opposite(ui.IsGlobalProject(intProject)); dt = ui.GetPhaseListX(SelectedUserId, intProject); if (dt != null) { inputMilestone1.DataSource = dt; inputMilestone1.DataTextField = "NAME"; inputMilestone1.DataValueField = "PHASE_ID"; inputMilestone1.DataBind(); } dt = ui.GetTaskList(SelectedUserId.ToString(), intProject); if (dt != null) { inputTask1.DataSource = dt; inputTask1.DataTextField = "NAME"; inputTask1.DataValueField = "TASK_ID"; inputTask1.DataBind(); } break; case 2: intProject = Convert.ToInt16(inputProject2.SelectedValue); if (intProject < 1) return; inputBillable2.Checked = Opposite(ui.IsGlobalProject(intProject)); dt = ui.GetPhaseListX(SelectedUserId, intProject); if (dt != null) { inputMilestone2.DataSource = dt; inputMilestone2.DataTextField = "NAME"; inputMilestone2.DataValueField = "PHASE_ID"; inputMilestone2.DataBind(); } dt = ui.GetTaskList(SelectedUserId.ToString(), intProject); if (dt != null) { inputTask2.DataSource = dt; inputTask2.DataTextField = "NAME"; inputTask2.DataValueField = "TASK_ID"; inputTask2.DataBind(); } break; case 3: intProject = Convert.ToInt16(inputProject3.SelectedValue); if (intProject < 1) return; inputBillable3.Checked = Opposite(ui.IsGlobalProject(intProject)); dt = ui.GetPhaseListX(SelectedUserId, intProject); if (dt != null) { inputMilestone3.DataSource = dt; inputMilestone3.DataTextField = "NAME"; inputMilestone3.DataValueField = "PHASE_ID"; inputMilestone3.DataBind(); } dt = ui.GetTaskList(SelectedUserId.ToString(), intProject); if (dt != null) { inputTask3.DataSource = dt; inputTask3.DataTextField = "NAME"; inputTask3.DataValueField = "TASK_ID"; inputTask3.DataBind(); } break; case 4: intProject = Convert.ToInt16(inputProject4.SelectedValue); if (intProject < 1) return; inputBillable4.Checked = Opposite(ui.IsGlobalProject(intProject)); dt = ui.GetPhaseListX(SelectedUserId, intProject); if (dt != null) { inputMilestone4.DataSource = dt; inputMilestone4.DataTextField = "NAME"; inputMilestone4.DataValueField = "PHASE_ID"; inputMilestone4.DataBind(); } dt = ui.GetTaskList(SelectedUserId.ToString(), intProject); if (dt != null) { inputTask4.DataSource = dt; inputTask4.DataTextField = "NAME"; inputTask4.DataValueField = "TASK_ID"; inputTask4.DataBind(); } break; case 5: intProject = Convert.ToInt16(inputProject5.SelectedValue); if (intProject < 1) return; inputBillable5.Checked = Opposite(ui.IsGlobalProject(intProject)); dt = ui.GetPhaseListX(SelectedUserId, intProject); if (dt != null) { inputMilestone5.DataSource = dt; inputMilestone5.DataTextField = "NAME"; inputMilestone5.DataValueField = "PHASE_ID"; inputMilestone5.DataBind(); } dt = ui.GetTaskList(SelectedUserId.ToString(), intProject); if (dt != null) { inputTask5.DataSource = dt; inputTask5.DataTextField = "NAME"; inputTask5.DataValueField = "TASK_ID"; inputTask5.DataBind(); } break; } }
protected void gvTime_Updating(Object sender, GridViewUpdateEventArgs e) { int projectId = 0; int taskId = 0; int phaseId = 0; int billable = 0; if (e.Keys["Billable"].ToString().Equals("True")) { billable = 1; } taskId = Convert.ToInt16(e.Keys["Task"].ToString()); projectId = Convert.ToInt16(e.Keys["Project"].ToString()); phaseId = Convert.ToInt16(e.Keys["Milestone"].ToString()); GridView gv = (GridView)sender; HiddenField omon = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidMon"); HiddenField omonDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidMonDesc"); HiddenField otue = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidTue"); HiddenField otueDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidTueDesc"); HiddenField owed = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidWed"); HiddenField owedDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidWedDesc"); HiddenField othr = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidThr"); HiddenField othrDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidThrDesc"); HiddenField ofri = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidFri"); HiddenField ofriDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidFriDesc"); HiddenField osat = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidSat"); HiddenField osatDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidSatDesc"); HiddenField osun = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidSun"); HiddenField osunDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidSunDesc"); TextBox mon = (TextBox)gv.Rows[e.RowIndex].FindControl("Monday"); TextBox monDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editMonDescription"); TextBox tue = (TextBox)gv.Rows[e.RowIndex].FindControl("Tuesday"); TextBox tueDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editTuesDescription"); TextBox wed = (TextBox)gv.Rows[e.RowIndex].FindControl("Wednesday"); TextBox wedDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editWedDescription"); TextBox thr = (TextBox)gv.Rows[e.RowIndex].FindControl("Thursday"); TextBox thrDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editThursDescription"); TextBox fri = (TextBox)gv.Rows[e.RowIndex].FindControl("Friday"); TextBox friDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editFriDescription"); TextBox sat = (TextBox)gv.Rows[e.RowIndex].FindControl("Saturday"); TextBox satDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editSatDescription"); TextBox sun = (TextBox)gv.Rows[e.RowIndex].FindControl("Sunday"); TextBox sunDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editSunDescription"); StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); //ui.DeleteUserTime(projectId, taskId, phaseId, Convert.ToBoolean(billable), SelectedUserId); DataTable dt = GetTimeTableSchema(); // if the hours change or the hours are greater than zero and the description changes then update. if ((!GetNumericValue(mon.Text).Equals(GetNumericValue(omon.Value))) || (GetNumericValue(mon.Text)>0 && !monDesc.Text.Equals(omonDesc.Value))) { DataRow dr = dt.NewRow(); dr["ID"] = 0; dr["Date"] = MasterDate; dr["Project"] = projectId; dr["Milestone"] = phaseId; dr["Task"] = taskId; dr["Person"] = ddlUserList.SelectedValue; dr["Duration"] = mon.Text; dr["Billable"] = billable; dr["Description"] = monDesc.Text; dt.Rows.Add(dr); } if ((!GetNumericValue(tue.Text).Equals(GetNumericValue(otue.Value))) || (GetNumericValue(tue.Text)>0 && !tueDesc.Text.Equals(otueDesc.Value))) { DataRow dr = dt.NewRow(); dr["ID"] = 0; dr["Date"] = MasterDate.AddDays(1); dr["Project"] = projectId; dr["Milestone"] = phaseId; dr["Task"] = taskId; dr["Person"] = ddlUserList.SelectedValue; dr["Duration"] = tue.Text; dr["Billable"] = billable; dr["Description"] = tueDesc.Text; dt.Rows.Add(dr); } if ((!GetNumericValue(wed.Text).Equals(GetNumericValue(owed.Value))) || (GetNumericValue(wed.Text) > 0 && !wedDesc.Text.Equals(owedDesc.Value))) { DataRow dr = dt.NewRow(); dr["ID"] = 0; dr["Date"] = MasterDate.AddDays(2); dr["Project"] = projectId; dr["Milestone"] = phaseId; dr["Task"] = taskId; dr["Person"] = ddlUserList.SelectedValue; dr["Duration"] = wed.Text; dr["Billable"] = billable; dr["Description"] = wedDesc.Text; dt.Rows.Add(dr); } if ((!GetNumericValue(thr.Text).Equals(GetNumericValue(othr.Value))) || (GetNumericValue(thr.Text) > 0 && !thrDesc.Text.Equals(othrDesc.Value))) { DataRow dr = dt.NewRow(); dr["ID"] = 0; dr["Date"] = MasterDate.AddDays(3); dr["Project"] = projectId; dr["Milestone"] = phaseId; dr["Task"] = taskId; dr["Person"] = ddlUserList.SelectedValue; dr["Duration"] = thr.Text; dr["Billable"] = billable; dr["Description"] = thrDesc.Text; dt.Rows.Add(dr); } if ((!GetNumericValue(fri.Text).Equals(GetNumericValue(ofri.Value))) || (GetNumericValue(fri.Text) > 0 && !friDesc.Text.Equals(ofriDesc.Value))) { DataRow dr = dt.NewRow(); dr["ID"] = 0; dr["Date"] = MasterDate.AddDays(4); dr["Project"] = projectId; dr["Milestone"] = phaseId; dr["Task"] = taskId; dr["Person"] = ddlUserList.SelectedValue; dr["Duration"] = fri.Text; dr["Billable"] = billable; dr["Description"] = friDesc.Text; dt.Rows.Add(dr); } if ((!GetNumericValue(sat.Text).Equals(GetNumericValue(osat.Value))) || (GetNumericValue(sat.Text)>0 && !satDesc.Text.Equals(osatDesc.Value))) { DataRow dr = dt.NewRow(); dr["ID"] = 0; dr["Date"] = MasterDate.AddDays(5); dr["Project"] = projectId; dr["Milestone"] = phaseId; dr["Task"] = taskId; dr["Person"] = ddlUserList.SelectedValue; dr["Duration"] = sat.Text; dr["Billable"] = billable; dr["Description"] = satDesc.Text; dt.Rows.Add(dr); } if ((!GetNumericValue(sun.Text).Equals(GetNumericValue(osun.Value))) || (GetNumericValue(sun.Text) > 0 && !sunDesc.Text.Equals(osunDesc.Value))) { DataRow dr = dt.NewRow(); dr["ID"] = 0; dr["Date"] = MasterDate.AddDays(6); dr["Project"] = projectId; dr["Milestone"] = phaseId; dr["Task"] = taskId; dr["Person"] = ddlUserList.SelectedValue; dr["Duration"] = sun.Text; dr["Billable"] = billable; dr["Description"] = sunDesc.Text; dt.Rows.Add(dr); } Save(dt,true); gvTime.EditIndex = -1; PopulateDataGrid(); }
protected void inputProject5_SelectedIndexChanged(object sender, EventArgs e) { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); int intProject = 0; intProject = Convert.ToInt16(inputProject5.SelectedValue); if (intProject < 1) return; inputBillable5.Checked = Opposite(ui.IsGlobalProject(intProject)); DataTable dt = new DataTable(); dt = ui.GetPhaseListX(SelectedUserId, intProject); if (dt != null) { inputMilestone5.DataSource = dt; inputMilestone5.DataTextField = "NAME"; inputMilestone5.DataValueField = "PHASE_ID"; inputMilestone5.DataBind(); //inputMilestone5.SelectedValue = 0 } dt = ui.GetTaskList(SelectedUserId.ToString(), intProject); if (dt != null) { inputTask5.DataSource = dt; inputTask5.DataTextField = "NAME"; inputTask5.DataValueField = "TASK_ID"; inputTask5.DataBind(); //inputTask5.SelectedValue = 0; } }
private void Save() { string userid = SelectedUserId.ToString(); string userName = inputUserName.Text.Trim(); if (userid.Equals("0")) { userid = string.Empty; MembershipUser user = Membership.CreateUser(inputUserName.Text, inputPW.Text, inputUserEmail.Text); RoleManagerModule roleManager = new RoleManagerModule(); Roles.AddUserToRole(userName, "USER"); if(chkAdmin.Checked==true) Roles.AddUserToRole(userName, "ADMIN"); if(chkProjectManager.Checked==true) Roles.AddUserToRole(userName, "PM"); inputUserName.Enabled = true; } else { MembershipUser user = Membership.GetUser(userName); if (chkAdmin.Checked == true) { if (!Roles.IsUserInRole(userName, "ADMIN")) Roles.AddUserToRole(userName, "ADMIN"); } else { if (Roles.IsUserInRole(userName, "ADMIN")) Roles.RemoveUserFromRole(userName, "ADMIN"); } if (chkProjectManager.Checked == true) { if (!Roles.IsUserInRole(userName, "PM")) Roles.AddUserToRole(userName, "PM"); } else { if (Roles.IsUserInRole(userName, "PM")) Roles.RemoveUserFromRole(userName, "PM"); } inputUserName.Enabled = false; } StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); ui.SaveUser(userid, inputFirstName.Text, inputLastName.Text, inputMiddleName.Text, inputRole.SelectedValue, inputEmployeeType.SelectedValue, ddlEmpStatus.SelectedValue, inputPW.Text, inputUserName.Text, txtStartDate.Text, txtTermDate.Text, ddlTitle.SelectedValue,inputPTOGroup.SelectedValue,inputUserEmail.Text ); }
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(); }
private void PreloadRecentProjects(string strUser) { // SET MOST RECENT PROJECTS AS DEFAULT DataTable dtSelected = new DataTable(); StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); dtSelected = ui.GetMostRecentProjects(Convert.ToInt16(strUser)); if (dtSelected != null) { if (dtSelected.Rows.Count > 0) { if (dtSelected.Rows[0][1] != null) { inputProject1.SelectedValue = dtSelected.Rows[0][1].ToString(); GetPhasesAndTasks(1); if (dtSelected.Rows.Count > 1) { if (dtSelected.Rows[1][1] != null) { inputProject2.SelectedValue = dtSelected.Rows[1][1].ToString(); GetPhasesAndTasks(2); if (dtSelected.Rows.Count > 2) { if (dtSelected.Rows[1][1] != null) { inputProject3.SelectedValue = dtSelected.Rows[2][1].ToString(); GetPhasesAndTasks(3); if (dtSelected.Rows.Count > 3) { if (dtSelected.Rows[2][1] != null) { inputProject4.SelectedValue = dtSelected.Rows[3][1].ToString(); GetPhasesAndTasks(4); if (dtSelected.Rows.Count > 4) { if (dtSelected.Rows[3][1] != null) { inputProject5.SelectedValue = dtSelected.Rows[4][1].ToString(); GetPhasesAndTasks(5); } } } } } } } } } } } }
private void PopulateUserList() { DataTable dt = new DataTable(); StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); dt = ui.GetUserList(LoggedInUserID.ToString()); // // populate the user list. ddlUserList.DataValueField = "USER_ID"; ddlUserList.DataTextField = "USERNAME"; ddlUserList.DataSource = dt; ddlUserList.DataBind(); // Dim SELECTEDUSERID As Integer = Session("SELECTEDUSERID") // ddlUserList.SelectedValue = SELECTEDUSERID }
private void PopulateDataGrid() { // get the data from database DataTable dtData = new DataTable(); dtData = GetTimeEntryData(); DataTable dt = GetTimeTableSchema(); Boolean bNew = false; StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); string strUser = SelectedUserId.ToString(); int ItemIndex = 0; // to hold the project or task or phase id string ItemName = string.Empty; // item//s name foreach (DataRow drData in dtData.Rows) { DataRow dr; // Determine if there is a row already for the Key: Project+Phase+Task+Billable DataRow[] drA; string strKey = drData["PROJECT_ID"] + "," + drData["PHASE_ID"] + "," + drData["TASK_ID"] + "," + drData["BILLABLE"]; // ok... the next select statement is not working... we are getting duplicate records coming thru Boolean billable = false; if (drData["BILLABLE"] == DBNull.Value) { billable = false; } else { billable = Convert.ToBoolean(drData["BILLABLE"]); } drA = dt.Select("PROJECT = " + drData["PROJECT_ID"] + " AND MILESTONE = " + drData["PHASE_ID"] + " AND TASK = " + drData["TASK_ID"] + " AND BILLABLE = " + billable.ToString()); // I am adding code to loop through and check each one... dr = dt.NewRow(); //Boolean exists = false; //DataRow[] drAdt; //drAdt= decimal oHours = Convert.ToDecimal(drData["HOURS"]); //decimal nhours = Convert.ToDecimal(dr["HOURS"]); //decimal oTotal = Convert.ToDecimal(drData["TOTAL"]); decimal nTotal = 0;// Convert.ToDecimal(dr["TOTAL"]); //decimal nMonday = 0; //if (drData["MONDAY"] != DBNull.Value) Convert.ToDecimal(drData["MONDAY"]); //decimal nTuesday = 0; //if (drData["TUESDAY"] != DBNull.Value) Convert.ToDecimal(drData["TUESDAY"]); //decimal nWednesday = 0; //if (drData["WEDNESDAY"] != DBNull.Value) Convert.ToDecimal(drData["WEDNESDAY"]); //decimal nThursday = 0; //if (drData["THURSDAY"] != DBNull.Value) Convert.ToDecimal(drData["THURSDAY"]); //decimal nFriday = 0; //if (drData["FRIDAY"] != DBNull.Value) Convert.ToDecimal(drData["FRIDAY"]); //decimal nSaturday = 0; //if (drData["SATURDAY"] != DBNull.Value) Convert.ToDecimal(drData["SATURDAY"]); //decimal nSunday = 0; //if (drData["SUNDAY"] != DBNull.Value) Convert.ToDecimal(drData["SUNDAY"]); if (drA.GetLength(0) > 0) { // the Key already exists in the table. Use this row. dr = drA[0]; bNew = false; } else { // the Key was not found. Create a new row dr = dt.NewRow(); dr["ID"] = strKey; if (drData["BILLABLE"] == DBNull.Value) { dr["BILLABLE"] = false; } else { dr["BILLABLE"] = Convert.ToBoolean(drData["BILLABLE"]); } dr["DURATION"] = oHours; ItemIndex = Convert.ToInt16(drData["TASK_ID"]); ItemName = ui.GetTaskName(ItemIndex, strUser); dr["TASK"] = drData["TASK_ID"]; dr["TASKNAME"] = ItemName; ItemIndex = Convert.ToInt16(drData["PHASE_ID"]); ItemName = ui.GetPhaseName(ItemIndex, strUser); dr["MILESTONE"] = drData["PHASE_ID"]; dr["PHASENAME"] = ItemName; ItemIndex = Convert.ToInt16(drData["PROJECT_ID"]); ItemName = ui.GetProjectName(ItemIndex, strUser); dr["PROJECT"] = ItemIndex; dr["PROJECTNAME"] = ItemName; dr["PERSON"] = drData["USER_ID"]; dr["TOTAL"] = 0; bNew = true; } decimal oMonday = 0; if (dr["MONDAY"] != DBNull.Value) oMonday = Convert.ToDecimal(dr["MONDAY"]); decimal oTuesday = 0; if (dr["TUESDAY"] != DBNull.Value) oTuesday = Convert.ToDecimal(dr["TUESDAY"]); decimal oWednesday = 0; if (dr["WEDNESDAY"] != DBNull.Value) oWednesday = Convert.ToDecimal(dr["WEDNESDAY"]); decimal oThursday = 0; if (dr["THURSDAY"] != DBNull.Value) oThursday = Convert.ToDecimal(dr["THURSDAY"]); decimal oFriday = 0; if (dr["FRIDAY"] != DBNull.Value) oFriday = Convert.ToDecimal(dr["FRIDAY"]); decimal oSaturday = 0; if (dr["SATURDAY"] != DBNull.Value) oSaturday = Convert.ToDecimal(dr["SATURDAY"]); decimal oSunday = 0; if (dr["SUNDAY"] != DBNull.Value) oSunday = Convert.ToDecimal(dr["SUNDAY"]); DateTime dtDate = Convert.ToDateTime(drData["BILL_DATE"].ToString()); //strip time?? int Difference = 0; DateTime dtA = MasterDate; //strip time?? Difference = dtDate.Subtract(dtA).Days; if (oHours > 0) { switch (Difference) { case 0: { if (oMonday == 0) { dr["Monday"] = oHours; dr["MonDescription"] = drData["DESCRIPTION"]; } else { dr["Monday"] = oMonday + oHours; } nTotal = oMonday + nTotal; MonTotal = MonTotal + oHours; WeekTotal = WeekTotal + oHours; break; } case 1: { if (oTuesday == 0) { dr["Tuesday"] = oHours; dr["TuesDescription"] = drData["DESCRIPTION"]; } else { dr["Tuesday"] = oTuesday + oHours; } nTotal = oTuesday + nTotal; TueTotal = TueTotal + oHours; WeekTotal = WeekTotal + oHours; break; } case 2: { if (oWednesday == 0) { dr["Wednesday"] = oHours; // 10/ dr["WedDescription"] = drData["DESCRIPTION"]; } else { dr["Wednesday"] = oWednesday + oHours; } nTotal = oWednesday + nTotal; WedTotal = WedTotal + oHours; WeekTotal = WeekTotal + oHours; break; } case 3: { if (oThursday == 0) { dr["Thursday"] = oHours; dr["ThursDescription"] = drData["DESCRIPTION"]; } else { dr["Thursday"] = oThursday + oHours; } nTotal = oThursday + nTotal; ThrTotal = ThrTotal + oHours; WeekTotal = WeekTotal + oHours; break; } case 4: { if (oFriday == 0) { dr["Friday"] = oHours; dr["FriDescription"] = drData["DESCRIPTION"]; } else { dr["Friday"] = oFriday + oHours; } nTotal = oFriday + nTotal; FriTotal = FriTotal + oHours; WeekTotal = WeekTotal + oHours; break; } case 5: { if (oSaturday == 0) { dr["Saturday"] = oHours; dr["SatDescription"] = drData["DESCRIPTION"]; } else { dr["Saturday"] = oSaturday + oHours; } dr["Total"] = oSaturday + nTotal; SatTotal = SatTotal + oHours; WeekTotal = WeekTotal + oHours; break; } case 6: { if (oSunday == 0) { dr["Sunday"] = oHours; dr["SunDescription"] = drData["DESCRIPTION"]; } else { dr["Sunday"] = oSunday + oHours; } nTotal = oSunday + nTotal; SunTotal = SunTotal + oHours; WeekTotal = WeekTotal + oHours; break; } } } else { bNew = false; } if (bNew == true) { dt.Rows.Add(dr); } } dt.AcceptChanges(); gvTime.DataSource = dt; gvTime.DataBind(); if (Locked(MasterDate)) { gvTime.Enabled = false; } else { gvTime.Enabled = true; } //ViewState["MonTotal"] = MonTotal; //VeiwState["TueTotal"] = TueTotal; //VeiwState["WedTotal"] = WedTotal; //VeiwState["ThrTotal"] = ThrTotal; //VeiwState["FriTotal"] = FriTotal; //VeiwState["SatTotal"] = SatTotal; //VeiwState["SunTotal"] = SunTotal; }
protected void gvTime_Delete(Object sender, GridViewDeleteEventArgs e) { int projectId = 0; int taskId = 0; int phaseId = 0; int billable = 0; if (e.Keys["Billable"].ToString().Equals("True")) { billable = 1; } taskId = Convert.ToInt16(e.Keys["Task"].ToString()); projectId = Convert.ToInt16(e.Keys["Project"].ToString()); phaseId = Convert.ToInt16(e.Keys["Milestone"].ToString()); StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); ui.DeleteUserTime(projectId, taskId, phaseId, Convert.ToBoolean(billable), SelectedUserId); PopulateDataGrid(); }
private void PopulateUserTypeList() { StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions(); DataTable dt = ui.GetTerms("EmployeeType"); // populate the EmployeeType dropdown list. inputEmployeeType.DataTextField = "DisplayLabel"; inputEmployeeType.DataValueField = "ID"; inputEmployeeType.DataSource = dt; inputEmployeeType.DataBind(); }