public RequestController(ProjectGateway projectGateway, RequestGateway requestGateway, DiggosService diggosService, GetAccessUser getAccessUser) { _projectGateway = projectGateway; _requestGateway = requestGateway; _diggosService = diggosService; _getAccessUser = getAccessUser; }
/// <summary> /// Loads all open project of employee into project DDL /// </summary> private void LoadAllOpenProject() { try { string employeeId = Session["userID"].ToString(); ProjectGateway ProjectGatewayObject = new ProjectGateway(); int noOfProject = ProjectGatewayObject.SelectAllOpenProjects(employeeId).Count; projectDropDownList.DataSource = ProjectGatewayObject.SelectAllOpenProjects(employeeId); //Admin can remove an employee from a project only if he is a member of it projectDropDownList.DataTextField = "Title"; projectDropDownList.DataValueField = "ID"; projectDropDownList.DataBind(); if (noOfProject.Equals(0)) { errorLabel.Text = "Admin is not a member of any project. Admin cant remove any employee"; } } catch (SqlException sqlExceptionObject) { errorLabel.Text = sqlExceptionObject.Message; } catch (Exception exceptionObject) { errorLabel.Text = exceptionObject.Message; } }
protected void projectIdDropDownList_SelectedIndexChanged(object sender, EventArgs e) { if (projectIdDropDownList.SelectedIndex.Equals(0)) { titleTextBox.Text = ""; descriptionTextBox.Text = ""; startDateTextBox.Text = ""; estimateDateTextBox.Text = ""; projectStatusLabel.Text = ""; errorLabel.Text = ""; successLabel.Text = ""; clientNameDropDownList.Items.Clear(); FillClientDropmDownList(); return; } try { ProjectGateway ProjectGatewayObject = new ProjectGateway(); Project projectObject = ProjectGatewayObject.SelectProject(projectIdDropDownList.Text); titleTextBox.Text = projectObject.Title; descriptionTextBox.Text = projectObject.Description; startDateTextBox.Text = projectObject.StartDate.ToString(); estimateDateTextBox.Text = projectObject.EstimateTime.ToString(); projectStatusLabel.Text = projectObject.Status.ToString(); clientNameDropDownList.Text = projectObject.ClientId; } catch (SqlException sqlExceptionObj) { errorLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorLabel.Text = exceptionObj.Message; } }
/// <summary> /// Fills project DDL /// </summary> private void FillProjectDropDownList() { try { string employeeId = Session["userID"].ToString(); ProjectGateway ProjectGatewayObject = new ProjectGateway(); projectDropDownList.DataSource = ProjectGatewayObject.GetProjectsOfUser(employeeId); projectDropDownList.DataTextField = "Title"; projectDropDownList.DataValueField = "ID"; projectDropDownList.DataBind(); if (ProjectGatewayObject.GetProjectsOfUser(employeeId).Count == 0) { errorLabel.Text = "Admin is not a member of any project. Can't create task for any project."; } } catch (SqlException sqlExceptionObj) { errorLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorLabel.Text = exceptionObj.Message; } }
protected void saveButton_Click(object sender, EventArgs e) { Project projectObj = null; ProjectGateway ProjectGatewayObject = null; try { projectObj = new Project(); projectObj.ID = idLabel.Text; projectObj.Title = nameLabel.Text; projectObj.Description = descriptionLabel.Text; projectObj.StartDate = Convert.ToDateTime(startDateLabel.Text); projectObj.EstimateTime = Convert.ToDateTime(estimateTimeLabel.Text); projectObj.ClientId = clientIdLabel.Text; projectObj.Employee_Id = employeeIDs; projectObj.Status = statusLabel.Text; ProjectGatewayObject = new ProjectGateway(); string message = ProjectGatewayObject.InsertProject(projectObj).ToString(); Response.Redirect("ProjectCreateUIPage.aspx?" + "&message =" + Server.UrlEncode(message)); } catch (PrimaryKeyException primaryKeyExceptionObj) { errorMessageLabel.Text = primaryKeyExceptionObj.Message; } catch (SqlException sqlExceptionObj) { errorMessageLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorMessageLabel.Text = exceptionObj.Message; } }
protected void closeProjectButton_Click(object sender, EventArgs e) { if (projectDropDownList.SelectedIndex.Equals(0)) { errorLabel.Text = "Please select a project"; return; } try { Project projectObject = new Project(); projectObject.ID = projectDropDownList.SelectedItem.Value; projectObject.Status = "Close"; ProjectGateway ProjectGatewayObject = new ProjectGateway(); string message = ProjectGatewayObject.CloseProject(projectObject).ToString(); successLabel.Text = "Project has been closed"; errorLabel.Text = ""; LoadAllOpenProject(); } catch (SqlException sqlExceptionObject) { errorLabel.Text = sqlExceptionObject.Message; } catch (Exception exceptionObject) { errorLabel.Text = exceptionObject.Message; } }
/// <summary> /// Remove an employee from project /// </summary> private void RemoveEmployee() { try { Project projectObject = new Project(); projectObject.ID = projectDropDownList.SelectedItem.Value; projectObject.Employee_Id = employeeDropDownList.SelectedItem.Value; ProjectGateway ProjectGatewayObject = new ProjectGateway(); string employeeRemoveStatus = ProjectGatewayObject.RemoveEmployeeFromProject(projectObject).ToString(); successLabel.Text = employeeRemoveStatus; if (successLabel.Text == "True") { successLabel.Text = "Removed the employee to the project"; } errorLabel.Text = ""; } catch (SqlException sqlExceptionObject) { errorLabel.Text = sqlExceptionObject.Message; } catch (Exception exceptionObject) { errorLabel.Text = exceptionObject.Message; } }
/// <summary> /// Loads all open project of employee into project DDL /// </summary> private void LoadAllOpenProject() { try { string employeeId = Session["userID"].ToString(); ProjectGateway ProjectGatewayObject = new ProjectGateway(); projectDropDownList.DataSource = ProjectGatewayObject.SelectAllOpenProjects(); projectDropDownList.DataTextField = "Title"; projectDropDownList.DataValueField = "ID"; projectDropDownList.DataBind(); if (ProjectGatewayObject.SelectAllOpenProjects().Count == 0) { errorLabel.Text = "Admin is not a member of any project yet. Can't add employee(s) to any project"; } } catch (SqlException sqlExceptionObject) { errorLabel.Text = sqlExceptionObject.Message; } catch (Exception exceptionObject) { errorLabel.Text = exceptionObject.Message; } }
public DiggosController(ProjectHub projectHub, RequestGateway requestGateway, ProjectGateway projectGateway, DGraphGateway dGraphGateway, GraphHub graphHub) { _projectGateway = projectGateway; _requestGateway = requestGateway; _dGraphGateway = dGraphGateway; _projectHub = projectHub; _graphHub = graphHub; }
/// <summary> /// Load project Information /// </summary> private void LoadProjectInfo() { ProjectGateway ProjectGatewayObject = new ProjectGateway(); Project projectObject = ProjectGatewayObject.SelectProject(projectDropDownList.SelectedItem.Value); clientIdLabel.Text = projectObject.Client_Name; projectStatusLabel.Text = projectObject.Status; }
public ProjectController(ProjectGateway projectGateway, UserGateway userGateway, RequestGateway requestGateway, ProjectHub projectHub, DGraphGateway dGraphGateway, GetAccessUser getAccessUser) { _projectGateway = projectGateway; _userGateway = userGateway; _requestGateway = requestGateway; _projectHub = projectHub; _dGraphGateway = dGraphGateway; _getAccessUser = getAccessUser; }
protected void saveButton_Click(object sender, EventArgs e) { successLabel.Text = ""; if (projectDropDownList.SelectedIndex.Equals(0)) { errorLabel.Text = "Please select a project"; return; } else if (selectedEmployeeListBox.Items.Count == 0) { errorLabel.Text = "Please select employee(s)"; return; } string employeeNames = string.Empty; string employeeIDs = string.Empty; try { foreach (ListItem item in selectedEmployeeListBox.Items) { employeeNames += item.Text + ","; employeeIDs += item.Value + ","; } //removes the last coma from the string employeeNames = employeeNames.Substring(0, employeeNames.Length - 1); employeeIDs = employeeIDs.Substring(0, employeeIDs.Length - 1); Project projectObject = new Project(); projectObject.ID = projectDropDownList.SelectedItem.Value; projectObject.Employee_Id = employeeIDs; ProjectGateway ProjectGatewayObject = new ProjectGateway(); successLabel.Text = ProjectGatewayObject.AddEmployeeToProject(projectObject).ToString(); if (successLabel.Text == "True") { successLabel.Text = "Added the new employee to the project"; } errorLabel.Text = ""; nonMemberEmployeeListBox.Items.Clear(); selectedEmployeeListBox.Items.Clear(); FillEmployeeListBox(); } catch (SqlException sqlExceptionObj) { errorLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorLabel.Text = exceptionObj.Message; } }
protected void updateButton_Click(object sender, EventArgs e) { bool message = false; if (!CheckInputValues()) { return; } Project projectObj = new Project(); projectObj.ID = projectIdDropDownList.Text; projectObj.Title = titleTextBox.Text; projectObj.Description = descriptionTextBox.Text; projectObj.StartDate = Convert.ToDateTime(startDateTextBox.Text); projectObj.EstimateTime = Convert.ToDateTime(estimateDateTextBox.Text); projectObj.ClientId = clientNameDropDownList.SelectedValue; //projectObj.Employee_Id = assignedToDropDownList.Text; projectObj.Status = projectStatusLabel.Text; try { ProjectGateway ProjectGatewayObject = new ProjectGateway(); message = ProjectGatewayObject.UpdateProject(projectObj); successLabel.Text = message.ToString(); errorLabel.Text = ""; } catch (SqlException sqlExceptionObj) { errorLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorLabel.Text = exceptionObj.Message; } successLabel.Text = message.ToString(); if (successLabel.Text == "True") { errorLabel.Text = ""; successLabel.Text = "Project details has been updated"; } else { successLabel.Text = ""; errorLabel.Text = "Project details has not been updated"; } LoadProjectData(); }
/// <summary> /// Fills up projectGridView /// </summary> private void LoadProjectData() { try { ProjectGateway projectGatewayObj = new ProjectGateway(); projectGridView.DataSource = projectGatewayObj.GetProjectTable(); projectGridView.DataBind(); } catch (SqlException sqlExceptionObj) { errorLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorLabel.Text = exceptionObj.Message; } }
/// <summary> /// Loads all open project of employee into project DDL /// </summary> private void LoadAllOpenProject() { try { string employeeId = Session["userID"].ToString(); ProjectGateway ProjectGatewayObject = new ProjectGateway(); projectDropDownList.DataSource = ProjectGatewayObject.SelectAllOpenProjects(employeeId); projectDropDownList.DataTextField = "title"; projectDropDownList.DataValueField = "ID"; projectDropDownList.DataBind(); } catch (SqlException sqlExceptionObject) { errorLabel.Text = sqlExceptionObject.Message; } catch (Exception exceptionObject) { errorLabel.Text = exceptionObject.Message; } }
/// <summary> /// Fills up projectListBulletedList DDL /// </summary> private void FillProjectsOfUser() { try { ProjectGateway ProjectGatewayObject = new ProjectGateway(); numberOfProjectsLabel.Text = ProjectGatewayObject.GetProjectsOfUser(employeeId).Count + " Project(s) Assigned to this employee"; projectListBulletedList.DataSource = ProjectGatewayObject.GetProjectsOfUser(employeeId); projectListBulletedList.DataTextField = "title"; projectListBulletedList.DataValueField = "id"; projectListBulletedList.DataBind(); } catch (SqlException sqlExceptionObj) { errorLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorLabel.Text = exceptionObj.Message; } }
/// <summary> /// Fills up projectDropDownList DDL /// </summary> private void LoadProjectDropDownList() { try { ProjectGateway ProjectGatewayObject = new ProjectGateway(); projectDropDownList.DataSource = ProjectGatewayObject.SelectAllOpenProjects(); projectDropDownList.DataTextField = "Title"; projectDropDownList.DataValueField = "ID"; projectDropDownList.DataBind(); if (ProjectGatewayObject.SelectAllOpenProjects().Count == 0) { errorLabel.Text = "No project is created yet"; } } catch (SqlException sqlExceptionObj) { errorLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorLabel.Text = exceptionObj.Message; } }
/// <summary> /// Fills up projectIdDropDownList DDL /// </summary> private void FillProjectIdDropDownList() { try { ProjectGateway ProjectGatewayObject = new ProjectGateway(); projectIdDropDownList.DataSource = ProjectGatewayObject.GetProjectsOfUser(Session["userID"].ToString()); projectIdDropDownList.DataTextField = "ID"; projectIdDropDownList.DataValueField = "ID"; projectIdDropDownList.DataBind(); if (ProjectGatewayObject.GetProjectsOfUser(Session["userID"].ToString()).Count == 0) { errorLabel.Text = "Admin is not a member of any project yet. Can't edit any project information"; } } catch (SqlException sqlExceptionObj) { errorLabel.Text = sqlExceptionObj.Message; } catch (Exception exceptionObj) { errorLabel.Text = exceptionObj.Message; } }
public GraphController(ProjectGateway projectGateway, DGraphGateway dGraphGateway, GetAccessUser getAccessUser) { _projectGateway = projectGateway; _dGraphGateway = dGraphGateway; _getAccessUser = getAccessUser; }
public GetAccessUser(UserGateway userGateway, ProjectGateway projectGateway) { _userGateway = userGateway; _projectGateway = projectGateway; }
public ProjectController() { db = new ProjectGateway(); }
public ProjectManager() { this.projectGateway = new ProjectGateway(); }
public ProjectManager() { projectGateway = new ProjectGateway(); taskGateway = new TaskGateway(); }
/// <summary> /// Checks if admin can remove a employee /// </summary> /// <returns>true if admin can remove employee else false</returns> private bool CheckForEmployeeRemove() { successLabel.Text = ""; try { string employeeId = Session["userID"].ToString(); ProjectGateway ProjectGatewayObject = new ProjectGateway(); int numberOfProject = ProjectGatewayObject.SelectAllOpenProjects(employeeId).Count; //Admin can remove an employee from a project only if he is a member of it //This counts the number of projects admin have EmployeeGateway EmployeeGatewayObject = new EmployeeGateway(); int numberOfEmployee = EmployeeGatewayObject.GetAllEmployeesOfAProject(projectDropDownList.SelectedItem.Value).Count; //If there is only one project member then he cant be removed //This counts the number of members of the selected project UserGateway UserGatewayObjrct = new UserGateway(); if (projectDropDownList.SelectedIndex.Equals(0)) // Item in index 0 is "-Select-" and not a valid item. So must not use { errorLabel.Text = "Please select a project"; return(false); } else if (numberOfProject == 0) { errorLabel.Text = "Admin is not a member of any project. Admin cant remove any employee"; return(false); } else if (numberOfEmployee == 1) { errorLabel.Text = "Only Admin is employee of the ptoject. Cant remove!"; return(false); } else if (employeeDropDownList.SelectedIndex.Equals(0)) // Item in index 0 is "-Select-" and not a valid item. So must not use { errorLabel.Text = "Please select an employee to remove"; return(false); } else if (UserGatewayObjrct.GetUserType(employeeDropDownList.SelectedItem.Value).ToString() == "True") { errorLabel.Text = "Admin cant be removed"; return(false); } else { return(true); } } catch (NonUserEmployeeException nonUserEmployeeExceptionObject) { /*This exception occours when employee is not a user * but is a member of a project * A non user employee can be removed from the project * so true is returned * Admin will not be aware of this event as errorLabel.text will be removed when non user employee successfully removed * */ errorLabel.Text = nonUserEmployeeExceptionObject.Message + "Can be removed"; return(true); } catch (SqlException sqlExceptionObject) { errorLabel.Text = sqlExceptionObject.Message; return(false); } catch (Exception exceptionObject) { errorLabel.Text = exceptionObject.Message; return(false); } }