public List <ProjectTaskModel> GetAllProjectTasksByProjectd(string projectId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjectTasksByProjectd(projectId); return(MapProjectTaskDataTable(result)); }
/// <summary> /// Populate comboBoxModule depending on the selected project /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void comboBoxProject_SelectedIndexChanged(object sender, EventArgs e) { comboBoxModule.Items.Clear(); List <Module> modules = new List <Module>(); if (DbConnector.OpenSQLConnection()) // Open connection to the database { // Connection opened ProjectDataAccess project = new ProjectDataAccess(); int projectId = project.FindProjectByProjectName(comboBoxProject.Text); ModuleDataAccess module = new ModuleDataAccess(); modules = module.FindModuleByProject(Convert.ToInt32(projectId)); } else { // Connection could not be opened MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (modules != null) { // Populate comboBoxes with data foreach (Module m in modules) { comboBoxModule.Items.Add(m.ModuleName); } } }
public ProjectModel GetCompleteProjectDetailWithTasks(string projectId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetCompleteProjectDetailWithTasks(projectId); return(MapProjectDetailsWithTasksAsList(result)); }
public List <ExpenseCategoryModel> GetAllExpenseCategory() { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllExpenseCategory(); return(MapDataTableToExpenseCategory(result)); }
public List <ProjectExpenseModel> GetAllProjectExpenses(string pageNumber, string searchTerm, string category) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjectExpenses(pageNumber, searchTerm, category); return(MapProjectExpense(result)); }
/// <summary> /// Populate the datagridview with search result /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSearchModules_Click(object sender, EventArgs e) { if (DbConnector.OpenSQLConnection()) // Open connection to the database { // Connection opened ModuleDataAccess module = new ModuleDataAccess(); dgvModule.AutoGenerateColumns = false; // To only show the columns needed dgvModule.DataSource = module.SearchModules(txtSearchModules.Text.Trim()); if (dgvModule.RowCount != 0) { ProjectDataAccess project = new ProjectDataAccess(); var result = project.FindProject(Convert.ToInt32(dgvModule.Rows[0].Cells[1].Value)).ProjectName; for (int i = 0; i < dgvModule.RowCount; i++) { dgvModule.Rows[i].Cells[2].Value = result; } } } else { // Connection could not be opened MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DbConnector.CloseSQLConnection(); // Close connection to the database }
/// <summary> /// Method for populating the DataDridView /// </summary> public void populateDataGridView(int projectId) { this.projectId = projectId; if (DbConnector.OpenSQLConnection()) // Open connection to the database { // Connection opened ModuleDataAccess module = new ModuleDataAccess(); dgvModule.AutoGenerateColumns = false; // To only show the columns needed dgvModule.DataSource = module.GetAllModules(projectId); ProjectDataAccess project = new ProjectDataAccess(); projectName = project.FindProject(projectId).ProjectName; for (int i = 0; i < dgvModule.RowCount; i++) { dgvModule.Rows[i].Cells[2].Value = projectName; } txtSearchModules.Text = ""; Modules_Tab_Child.getInstance().clearModuleText(); } else { // Connection could not be opened MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DbConnector.CloseSQLConnection(); // Close connection to the database }
public List <ProjectModel> GetAllProjects(int pageNumber, string searchTerm, int numberOfRecords, bool showHiddenProjects, string userID) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjects(pageNumber, searchTerm, numberOfRecords, showHiddenProjects, userID); return(ConvertProjectDataTableToList(result)); }
//public List<ProjectSubTaskBasicModel> GetAllProjectSubTasksByUserId(string userId, string date) //{ // ProjectDataAccess obj = new ProjectDataAccess(); // var result = obj.GetAllProjectSubTasksByUserId(userId, date); // return ConvertProjectSubTasksDataTableToList(result); //} public ProjectSubTaskModel GetProjectSubTaskDetailsById(string subTaskId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetProjectSubTaskDetailsById(subTaskId); return(MapProjectSubTaskDetails(result)); }
public List <ProjectBasicModel> GetAllProjectNamesAndId(string userID) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjectNamesAndId(userID); return(ConvertProjectBasicDataTableToList(result)); }
public bool CreateProjectSubTask(ProjectSubTaskModel subTask) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.CreateProjectSubTask(subTask); return(result); }
public bool UpdateProjectSubTask(ProjectSubTaskModel subTask, bool isPostponed, int reAssignedUserId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.UpdateProjectSubTask(subTask); return(result); }
public List <ProjectSubTaskModel> GetAllProjectSubTasksByTaskIdAndUserId(string taskId, string userId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjectSubTasksByTaskIdAndUserId(taskId, userId); return(ConvertProjectSubTasksDataTableToList(result)); }
public List <ProjectTaskBasicModel> GetAllProjectTasksByPhasesId(string phaseId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjectTasksByPhaseId(phaseId); return(ConvertProjectTasksDataTableToList(result)); }
public List <ProjectPhaseBasicModel> GetAllProjectPhasesById(string projectId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjectPhasesById(projectId); return(ConvertProjectPhasesDataTableToList(result)); }
public List <ProjectIncome> GetAllProjectIncome(string pageNumber, string searchTerm, string fromDate, string toDate) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjectIncome(pageNumber, searchTerm, fromDate, toDate); return(MapProjectIncome(result)); }
public ProjectModel GetProjectDetailsById(string projectId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetProjectDetailsById(projectId); return(MapProjectDetailsDataTable(result)); }
public int AddProjectTask(ProjectTaskModel taskModel, int phaseId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.AddProjectTask(taskModel, phaseId); return(result); }
public byte[] GetProjectIncomeExcel(string pageNumber, string searchTerm, string fromDate, string toDate) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.GetAllProjectIncome(pageNumber, searchTerm, fromDate, toDate); string[] columns = { Convert.ToString(result.Rows[0]["TotalIncome"]) }; return(EnquiryBusinessLogic.ExportExcel(MapDataTableForProjectIncome(result), "Project Income", false, columns)); }
public static async Task <IActionResult> ProjectDelete( [HttpTrigger(AuthorizationLevel.Anonymous, "delete", Route = "projects/{projectId}")] HttpRequest req, ILogger log, int projectId) { using (var da = new ProjectDataAccess(conStr)) { return(new OkObjectResult(await da.QueryAsync <Project>(string.Format(SQLStatements.TemplateDelete, "Projects", projectId)))); } }
public static async Task <IActionResult> ProjectGet( [HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "projects")] HttpRequest req, ILogger log) { using (var da = new ProjectDataAccess(conStr)) { return(new OkObjectResult(await da.Get())); } }
public int AddProjectPhase(ProjectPhaseModel phaseModel, int projectId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.AddProjectPhase(phaseModel, projectId); foreach (ProjectTaskModel taskModel in phaseModel.ProjectTasks) { AddProjectTask(taskModel, result); } return(result); }
protected void EmployeeIDDropDownList_SelectedIndexchanged(object sender, EventArgs e) { ProjectDetailsModel projmodel = new ProjectDetailsModel(); ProjectDataAccess projdata = new ProjectDataAccess(); projmodel = projdata.GetProjectDetails(Convert.ToInt32(EmployeeIDDropDownList.SelectedValue)); Project_NameTextBox.Text = projmodel.Project_Name; Client_NameTextBox.Text = projmodel.Client_Name; LocationTextBox.Text = projmodel.Location; RolesTextBox.Text = projmodel.Roles; }
public MockBusiness( UserDataAccess userDataAccess, FeedbackSeasonDataAccess feedbackSeasonDataAccess, ProjectDataAccess projectDataAccess, CompetenceDataAccess competenceDataAccess ) { _userDataAccess = userDataAccess; _feedbackSeasonDataAccess = feedbackSeasonDataAccess; _projectDataAccess = projectDataAccess; _competenceDataAccess = competenceDataAccess; }
public static async Task <IActionResult> ProjectCreate( [HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "projects")] HttpRequest req, ILogger log) { string requestBody = await new StreamReader(req.Body).ReadToEndAsync(); dynamic data = JsonConvert.DeserializeObject <Project>(requestBody); using (var da = new ProjectDataAccess(conStr)) { return(new OkObjectResult(await da.CreateAsync(data))); } }
public int UpdateProject(ProjectModel project, string selectedUsers) { ProjectDataAccess obj = new ProjectDataAccess(); var projectId = project.ProjectId; obj.UpdateProject(project); foreach (ProjectPhaseModel phaseModel in project.ProjectPhases) { UpdateProjectPhase(phaseModel, projectId); } obj.UpdateUsersAccessToProject(selectedUsers, projectId, "1"); return(projectId); }
public int AddNewProject(ProjectModel project, string selectedUsers) { selectedUsers = selectedUsers.TrimEnd(',').Trim(); ProjectDataAccess obj = new ProjectDataAccess(); var projectId = obj.AddNewProject(project); foreach (ProjectPhaseModel phaseModel in project.ProjectPhases) { AddProjectPhase(phaseModel, projectId); } obj.ProvideUsersAccessToProject(selectedUsers, projectId, "1"); return(projectId); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ProjectDataAccess obj = new ProjectDataAccess(); List <int> EmpIDList = obj.GetEmployeeID(); int i = 0; foreach (int EmpID in EmpIDList) { EmployeeIDDropDownList.Items.Insert(i, new ListItem(EmpID.ToString())); i++; } } UnobtrusiveValidationMode = UnobtrusiveValidationMode.None; }
public string GetUsersWithAccessForProject(string projectId) { ProjectDataAccess obj = new ProjectDataAccess(); var dt = obj.GetUsersWithAccessForProject(projectId); var result = string.Empty; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { result += dr["UserId"].ToString() + ","; } } return(result.TrimEnd(',').Trim()); }
public int UpdateProjectTask(ProjectTaskModel taskModel, int phaseId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = 0; if (taskModel.ProjectTaskId > 0) { result = taskModel.ProjectTaskId; obj.UpdateProjectTask(taskModel); } else { result = obj.AddProjectTask(taskModel, phaseId); } return(result); }