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