protected void projectView_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow updatableRow = projectView.Rows[e.RowIndex] as GridViewRow; if (updatableRow != null) { TextBox tProjectName = updatableRow.FindControl("tProjectName") as TextBox; DropDownList ddlPriority = updatableRow.FindControl("ddlPriority") as DropDownList; DropDownList ddlEnvName = updatableRow.FindControl("ddlEnvName") as DropDownList; HiddenField hPrjGuid = updatableRow.FindControl("projectID") as HiddenField; if (tProjectName != null && ddlPriority != null && ddlEnvName != null && hPrjGuid != null) { BCCTaskProject project = new BCCTaskProject(); Guid projectGuid = new Guid(hPrjGuid.Value); project.ProjectID = projectGuid; project.ProjectName = tProjectName.Text; int priority = 1; Int32.TryParse(ddlPriority.SelectedValue, out priority); project.ProjectPriority = priority; project.ProjectEnvironment = ddlEnvName.SelectedValue; BCCTaskProject.UpdateTaskProject(project); } } // Refresh the data projectView.EditIndex = -1; FillProjects(); }
protected void projectView_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Add") { TextBox tNewProjectName = projectView.FooterRow.FindControl("tNewProjectName") as TextBox; DropDownList ddlNewPriority = projectView.FooterRow.FindControl("ddlNewPriority") as DropDownList; DropDownList ddlNewEnvName = projectView.FooterRow.FindControl("ddlNewEnvName") as DropDownList; if (tNewProjectName != null && ddlNewPriority != null && ddlNewEnvName != null) { BCCTaskProject project = new BCCTaskProject(); project.ProjectEnvironment = ddlNewEnvName.SelectedValue; project.ProjectName = tNewProjectName.Text; int priority = 1; Int32.TryParse(ddlNewPriority.SelectedValue, out priority); project.ProjectPriority = priority; BCCTaskProject.AddTaskProject(project); } FillProjects(); } else if (e.CommandName == "AddOnEmpty") { TextBox tNewProjectName = projectView.Controls[0].Controls[0].FindControl("tNewProjectName") as TextBox; DropDownList ddlNewPriority = projectView.Controls[0].Controls[0].FindControl("ddlNewPriority") as DropDownList; DropDownList ddlNewEnvName = projectView.Controls[0].Controls[0].FindControl("ddlNewEnvName") as DropDownList; if (tNewProjectName != null && ddlNewPriority != null && ddlNewEnvName != null) { BCCTaskProject project = new BCCTaskProject(); project.ProjectEnvironment = ddlNewEnvName.SelectedValue; project.ProjectName = tNewProjectName.Text; int priority = 1; Int32.TryParse(ddlNewPriority.SelectedValue, out priority); project.ProjectPriority = priority; if (!(project.ProjectEnvironment.Equals(string.Empty))) { BCCTaskProject.AddTaskProject(project); } else { DisplayError("You must create an Environment before you can create a Project."); } } FillProjects(); } }
protected void projectView_RowUDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow deletedRow = projectView.Rows[e.RowIndex] as GridViewRow; if (deletedRow != null) { Label lblProjectName = deletedRow.FindControl("lblProjectName") as Label; Label lblEnvName = deletedRow.FindControl("lblEnvName") as Label; Label lblProjectPriority = deletedRow.FindControl("lblProjectPriority") as Label; HiddenField hGuid = deletedRow.FindControl("projectID") as HiddenField; Guid projectGuid = new Guid(hGuid.Value); BCCTaskProject project = new BCCTaskProject(); project.ProjectID = projectGuid; project.ProjectName = lblProjectName.Text; int priority = 1; Int32.TryParse(lblProjectPriority.Text, out priority); project.ProjectPriority = priority; project.ProjectEnvironment = lblEnvName.Text; project.ProjectVisible = 0; BCCTaskProject.UpdateTaskProject(project); BCCTaskProject.ProjectActivation(project); } // Refresh the data projectView.EditIndex = -1; FillProjects(); FillArchivedProjects(); FillTasks(); FillArchivedTasks(); }
protected void archivedProjects_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Activate") { GridViewRow clickedRow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); HiddenField hGuid = clickedRow.FindControl("projectID") as HiddenField; if (hGuid != null) { BCCTaskProject project = new BCCTaskProject(); Guid projectGuid = new Guid(hGuid.Value); project.ProjectID = projectGuid; project.ProjectVisible = 1; BCCTaskProject.ProjectActivation(project); FillProjects(); FillArchivedProjects(); } } }
private void FillProjects() { BCCTaskProject project = new BCCTaskProject(); project.ProjectVisible = 1; DataTable dtEnv = BCCTaskProject.RetrieveProjects(project); if (dtEnv != null) { projectView.DataSource = dtEnv; projectView.DataBind(); projectView.Visible = true; } }
private void FillArchivedProjects() { BCCTaskProject project = new BCCTaskProject(); project.ProjectVisible = 0; DataTable dtEnv = BCCTaskProject.RetrieveProjects(project); if (dtEnv != null) { archivedProjects.DataSource = dtEnv; archivedProjects.DataBind(); archivedProjects.Visible = true; } }
/// <summary> /// Update Task Project /// </summary> /// <param name="taskProject"></param> /// <returns>Data table</returns> public static DataTable UpdateTaskProject(BCCTaskProject taskProject) { DataTable dt = null; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["authStore"].ConnectionString)) { SqlCommand command = new SqlCommand("[dbo].[bcc_TaskList_UpdateProject]", connection); command.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@projectID", taskProject.ProjectID); command.Parameters.Add(param); param = new SqlParameter("@projectName", taskProject.ProjectName.Trim()); command.Parameters.Add(param); param = new SqlParameter("@envName", taskProject.ProjectEnvironment); command.Parameters.Add(param); param = new SqlParameter("@projectPriority", taskProject.ProjectPriority); command.Parameters.Add(param); param = new SqlParameter("@showFlag", taskProject.ProjectVisible); command.Parameters.Add(param); connection.Open(); SqlDataReader reader = command.ExecuteReader(); dt = new DataTable(); dt.Load(reader); } return dt; }
/// <summary> /// Retrieve Projects /// </summary> /// <param name="taskProject"></param> /// <returns>Data table</returns> public static DataTable RetrieveProjects(BCCTaskProject taskProject) { DataTable dt = null; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["authStore"].ConnectionString)) { SqlCommand command = new SqlCommand("[dbo].[bcc_TaskList_Projects]", connection); command.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@showFlag", taskProject.ProjectVisible); command.Parameters.Add(param); connection.Open(); SqlDataReader reader = command.ExecuteReader(); dt = new DataTable(); dt.Load(reader); } return dt; }