protected void ImageButtonClearResource_Click(object sender, ImageClickEventArgs e) { using (SqlConnection conn = new SqlConnection(g_sqlConn)) { try { Connect(conn); using (SqlCommand cmd = new SqlCommand("UPDATE tblResources SET AssociatedActionItem=NULL WHERE UserID=@UserID AND ProjectID=@ProjID AND AssociatedActionItem=@ActItem", conn)) { cmd.Parameters.AddWithValue("@UserID", Session["_CurrentUserID"]); cmd.Parameters.AddWithValue("@ProjID", Session["_CurrentProjID"]); cmd.Parameters.AddWithValue("@ActItem", Session["_CurrentActionItemID"]); cmd.ExecuteNonQuery(); } } catch (Exception ex) { Response.Write(String.Format("Error while executing query...{0}", ex.ToString())); } finally { Disconnect(conn); } GridViewAssociateResource.DataBind(); TextBoxResourceAssigned.Text = ""; } }
protected void ButtonNew_Click(object sender, EventArgs e) { if (TextBoxName.Text.Length == 0 || TextBoxDescription.Text.Length == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please enter a name and description for the Action Item.');", true); } else if (TextBoxDateCreated.Text.Length == 0 || TextBoxDateAssigned.Text.Length == 0 || TextBoxExpectedCompletionDate.Text.Length == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please select a date for the Date Created, Date Assigned, and Expected Completion Date fields.');", true); } else { using (SqlConnection conn = new SqlConnection(g_sqlConn)) { try { Connect(conn); using (SqlCommand cmd = new SqlCommand("insert into tblACtionItems(UserID,ProjectID,Name,Description,DateCreated,DateAssigned,ExpectedCompletionDate)" + " values(@UserID, @ProjectID, @Name, @Description,@DateCreated,@DateAssigned, @ExpCompletionDate)", conn)) { cmd.Parameters.AddWithValue("@UserID", Session["_CurrentUserID"]); cmd.Parameters.AddWithValue("@ProjectID", Session["_CurrentProjID"]); cmd.Parameters.AddWithValue("@Name", TextBoxName.Text); cmd.Parameters.AddWithValue("@Description", TextBoxDescription.Text); cmd.Parameters.AddWithValue("@DateCreated", TextBoxDateCreated.Text); cmd.Parameters.AddWithValue("@DateAssigned", TextBoxDateAssigned.Text); cmd.Parameters.AddWithValue("@ExpCompletionDate", TextBoxExpectedCompletionDate.Text); cmd.ExecuteNonQuery(); LoadDefaultStatusListBox(); } } catch (Exception ex) { Response.Write(String.Format("Error while executing query...{0}", ex.ToString())); } finally { Disconnect(conn); } Connect(conn); using (SqlCommand cmd2 = new SqlCommand(String.Format("SELECT ActionItemID FROM tblActionItems WHERE Name='{0}' AND UserID={1} AND ProjectID={2}", TextBoxName.Text, Session["_CurrentUserID"], Session["_CurrentProjID"]), conn)) { SqlDataReader sdr = cmd2.ExecuteReader(); while (sdr.Read()) { Session["_CurrentActionItemID"] = sdr[0].ToString(); } sdr.Close(); } Disconnect(conn); } DropDownListActItemSelect.Items.Clear(); DropDownListActItemSelect.DataBind(); GridViewActionItemsList.DataBind(); GridViewAssociateResource.DataBind(); ImageButtonClearActCompl.Visible = true; ImageButtonClearResource.Visible = true; TextBoxActualCompletionDate.Visible = true; LabelActComplDate.Visible = true; ImageButtonActualCompletionDate.Visible = true; ButtonDelete.Visible = true; ButtonSave.Visible = true; LabelResourceAssigned.Visible = true; TextBoxResourceAssigned.Visible = true; ButtonSelectResource.Visible = true; LabelStatus.Visible = true; TextBoxStatus.Visible = true; ButtonAddStatus.Visible = true; ButtonRemoveStatus.Visible = true; ListBoxStatus.Visible = true; ImageButtonStatusMoveUp.Visible = true; ImageButtonStatusMoveDown.Visible = true; LabelStatusDescr.Visible = true; TextBoxStatusDescription.Visible = true; LabelLastUpdated.Visible = true; TextBoxLastUpdated.Visible = true; } }
protected void ButtonSave_Click(object sender, EventArgs e) { if (TextBoxName.Text.Length == 0 || TextBoxDescription.Text.Length == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please enter a name and description for the Action Item.');", true); } else if (TextBoxDateCreated.Text.Length == 0 || TextBoxDateAssigned.Text.Length == 0 || TextBoxExpectedCompletionDate.Text.Length == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please select a date for the Date Created, Date Assigned, and Expected Completion Date fields.');", true); } else if (TextBoxStatus.Text.Length == 0 || TextBoxStatusDescription.Text.Length == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please select a status and enter a status description.');", true); } else { using (SqlConnection conn = new SqlConnection(g_sqlConn)) { try { Connect(conn); using (SqlCommand cmd2 = new SqlCommand(String.Format("SELECT ActionItemID FROM tblActionItems WHERE Name='{0}' AND UserID={1} AND ProjectID={2}", TextBoxName.Text, Session["_CurrentUserID"], Session["_CurrentProjID"]), conn)) { SqlDataReader sdr = cmd2.ExecuteReader(); while (sdr.Read()) { Session["_CurrentActionItemID"] = sdr[0].ToString(); } sdr.Close(); } using (SqlCommand cmd = new SqlCommand("UPDATE tblActionItems SET Name=@Name, Description=@Description, " + "DateCreated=@DateCreated, DateAssigned=@DateAssigned, ExpectedCompletionDate=@ExpComplDate," + "ActualCompletionDate=@ActComplDate, Status=@Status, StatusDescription=@StatusDescription" + " WHERE UserID=@UserID AND ProjectID=@ProjID AND ActionItemID=@ActionID", conn)) { cmd.Parameters.AddWithValue("@UserID", Session["_CurrentUserID"]); cmd.Parameters.AddWithValue("@ProjID", Session["_CurrentProjID"]); cmd.Parameters.AddWithValue("@ActionID", Session["_CurrentActionItemID"]); cmd.Parameters.AddWithValue("@Name", TextBoxName.Text); cmd.Parameters.AddWithValue("@Description", TextBoxDescription.Text); cmd.Parameters.AddWithValue("@DateCreated", TextBoxDateCreated.Text); cmd.Parameters.AddWithValue("@DateAssigned", TextBoxDateAssigned.Text); cmd.Parameters.AddWithValue("@ExpComplDate", TextBoxExpectedCompletionDate.Text); cmd.Parameters.AddWithValue("@ActComplDate", string.IsNullOrEmpty(TextBoxActualCompletionDate.Text) ? (object)DBNull.Value : TextBoxActualCompletionDate.Text); string prevSelectedVal = ListBoxStatus.SelectedItem.ToString(); SaveListBoxes(); int updatedIndex = 0; for (int i = 0; i < ListBoxStatus.Items.Count; i++) { if (ListBoxStatus.Items[i].ToString().Equals(prevSelectedVal)) { updatedIndex = i; } } cmd.Parameters.AddWithValue("@Status", updatedIndex); cmd.Parameters.AddWithValue("@StatusDescription", TextBoxStatusDescription.Text); cmd.ExecuteNonQuery(); } } catch (Exception ex) { Response.Write(String.Format("Error while executing query...{0}", ex.ToString())); } finally { Disconnect(conn); } } DropDownListActItemSelect.Items.Clear(); DropDownListActItemSelect.DataBind(); GridViewAssociateResource.DataBind(); GridViewActionItemsList.DataBind(); } }
protected void ButtonModalSearch_Click(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection(g_sqlConn)) { Connect(conn); Session["_CurrentActionItemID"] = DropDownListActItemSelect.SelectedValue; this.ListBoxStatus.DataBind(); using (SqlCommand cmd = new SqlCommand(String.Format("SELECT Name, Description, DateCreated, DateAssigned," + "ExpectedCompletionDate, ActualCompletionDate, Status, StatusDescription, UpdateDate " + "FROM tblActionItems WHERE ActionItemID={0} AND UserID={1} AND ProjectID={2}", DropDownListActItemSelect.SelectedValue, Session["_CurrentUserID"], Session["_CurrentProjID"]), conn)) { SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { TextBoxName.Text = SafeGetString(sdr, 0); TextBoxDescription.Text = SafeGetString(sdr, 1); TextBoxDateCreated.Text = SafeGetString(sdr, 2); TextBoxDateAssigned.Text = SafeGetString(sdr, 3); TextBoxExpectedCompletionDate.Text = SafeGetString(sdr, 4); TextBoxActualCompletionDate.Text = SafeGetString(sdr, 5); if (String.IsNullOrEmpty(SafeGetString(sdr, 6))) { TextBoxStatus.Text = ""; } else { ListBoxStatus.SelectedIndex = Int32.Parse(SafeGetString(sdr, 6)); TextBoxStatus.Text = ListBoxStatus.SelectedItem.ToString(); } TextBoxStatusDescription.Text = SafeGetString(sdr, 7); TextBoxLastUpdated.Text = SafeGetString(sdr, 8); } sdr.Close(); } using (SqlCommand cmd2 = new SqlCommand(String.Format("SELECT ActionItemID FROM tblActionItems WHERE Name='{0}' AND UserID={1} AND ProjectID={2}", TextBoxName.Text, Session["_CurrentUserID"], Session["_CurrentProjID"]), conn)) { SqlDataReader sdr = cmd2.ExecuteReader(); while (sdr.Read()) { Session["_CurrentActionItemID"] = sdr[0].ToString(); } sdr.Close(); } using (SqlCommand cmd3 = new SqlCommand(String.Format("SELECT Name FROM tblResources WHERE AssociatedActionItem={0} AND UserID={1} AND ProjectID={2}", Session["_CurrentActionItemID"], Session["_CurrentUserID"], Session["_CurrentProjID"]), conn)) { SqlDataReader sdr = cmd3.ExecuteReader(); TextBoxResourceAssigned.Text = ""; while (sdr.Read()) { TextBoxResourceAssigned.Text = SafeGetString(sdr, 0); } sdr.Close(); } Disconnect(conn); } TextBoxActualCompletionDate.Visible = true; LabelActComplDate.Visible = true; ImageButtonActualCompletionDate.Visible = true; ButtonDelete.Visible = true; ButtonSave.Visible = true; GridViewAssociateResource.DataBind(); ImageButtonClearActCompl.Visible = true; ImageButtonClearResource.Visible = true; LabelResourceAssigned.Visible = true; TextBoxResourceAssigned.Visible = true; ButtonSelectResource.Visible = true; LabelStatus.Visible = true; TextBoxStatus.Visible = true; ButtonAddStatus.Visible = true; ButtonRemoveStatus.Visible = true; ListBoxStatus.Visible = true; ImageButtonStatusMoveUp.Visible = true; ImageButtonStatusMoveDown.Visible = true; LabelStatusDescr.Visible = true; TextBoxStatusDescription.Visible = true; LabelLastUpdated.Visible = true; TextBoxLastUpdated.Visible = true; }