How to update the status of the selected suggestion through Ajax ModalPopUp Window? RSS

• • Reply
  

  matrix388

  Member

  47 Points

  92 Posts

  How to update the status of the selected suggestion through Ajax ModalPopUp Window?

  Jul 02, 2012 04:12 AM|LINK

  I am a new ASP.NET developer and I am developing a web-based suggestions box program for my company where the employees can submit any safety suggestions they have. Now, I am working on the Administration part of this system. The Admin will be able to see all suggestions listed in a table. In the last column of the table, the status will be listed there. When the Admin clicks on the status of one of these suggestion, a new pop-up window (asp.net ajax ModalPopUpExtender) will be appeared with listing all the possible status such as: actioned, approved... etc. And when the Admin selects one of these status, the status of the suggestion will be updated in the database. I wrote the code but still it doesn't update the status of the suggestion,
  
  **so could you please help me in modifying it?**
  
  FYI, I have the following database design:
  
      Employee Table: Username, Name...
      SafetySuggestionsLog: ID, Title, Description, Username, StatusID
      SafetySuggestionsStatus: ID, Status
  
  **ASP.NET code:**

  <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                  <ContentTemplate>
              <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
                              AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="ID"
                              width="900px" CssClass="mGrid"
                              DataSourceID="SqlDataSource1"
                              OnRowDataBound="GridView1_RowDataBound">
                  <AlternatingRowStyle BackColor="White" ForeColor="#284775" CssClass="alt" />
                  <HeaderStyle Font-Bold = "True" ForeColor="Black" Height="20px"/>
                  <Columns>
                      <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
                          ReadOnly="True" SortExpression="ID" />
                      <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
                      <asp:BoundField DataField="Description" HeaderText="Description"
                          SortExpression="Description" />
                      <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                      <asp:BoundField DataField="Username" HeaderText="Username"
                          SortExpression="Username" />
                      <asp:BoundField DataField="DivisionShortcut" HeaderText="DivisionShortcut"
                          SortExpression="DivisionShortcut" />
                      <asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" />
      
                      <%-- This to make status be opened and edited through the Ajax ModalPopUp Window --%>
                      <asp:TemplateField HeaderText="Status">
                          <ItemTemplate>
                              <asp:LinkButton runat="server" ID="lnkSuggestionStatus" Text='<%#Eval("Status")%>'
                                              OnClick="lnkSuggestionStatus_Click">
                              </asp:LinkButton>
                          </ItemTemplate>
                      </asp:TemplateField>
      
                      <%--<asp:HyperLinkField HeaderText="Status"
                          SortExpression="Status" />--%>
                  </Columns>
                  <RowStyle HorizontalAlign="Center" />
              </asp:GridView>
      
              <asp:Button runat="server" ID="btnModalPopUp" style="display:none" />
      
              <AjaxToolkit:ModalPopUpExtender ID="modalPopUpExtender1"
                                              runat="server"
                                              TargetControlID="btnModalPopUp"
                                              PopupControlID="pnlPopUp"
                                              BackgroundCssClass="popUpStyle"
                                              PopupDragHandleControlID="panelDragHandle"
                                              OkControlID="OKButton">
              </AjaxToolkit:ModalPopUpExtender>
      
              <asp:Panel runat="server" ID="pnlPopUp">
      
                          <asp:RadioButtonList ID="StatusList" runat="server" RepeatColumns="1" RepeatDirection="Vertical"
                                                  RepeatLayout="Table" TextAlign="Left" DataSourceID="SuggestionStatusDataSource"
                                                  DataTextField="Status" DataValueField="ID">
                              <asp:ListItem id="option1" runat="server" Value="ACTIONED" />
                              <asp:ListItem id="option2" runat="server" Value="APPROVED" />
                              <asp:ListItem id="option3" runat="server" Value="PENDING" />
                              <asp:ListItem id="option4" runat="server" Value="TRANSFERRED" />
                          </asp:RadioButtonList>
                          <asp:SqlDataSource ID="SuggestionStatusDataSource" runat="server"
                                              ConnectionString="<%$ ConnectionStrings:testConnectionString %>"
                                              SelectCommand="SELECT * FROM [SafetySuggestionsStatus]"></asp:SqlDataSource>
      
                          <asp:Button ID="confirmButton" runat="server" Text="Confirm"
                                      OnClientClick="javascript:return confirm('Are you sure you want to send an email notification about the safety suggestion to the owner?')"
                                      OnClick="btnSendStatus_Click" />
      
                  <asp:Button ID="OKButton" runat="server" Text="Close" />
              </asp:Panel>
              </ContentTemplate>
              </asp:UpdatePanel>

  
  
  
   
  
  **Code-Behind:**

      public void btnSendStatus_Click(object sender, EventArgs e) {
              var statusID = StatusList.SelectedValue;
      
              string connString = "Data Source=localhost\\sqlexpress;Initial Catalog=psspdbTest;Integrated Security=True";
              //For updating the status of the safety suggestion
              string updateCommand = "UPDATE SafetySuggestionsStatus SET ID= @statusID";
              using (SqlConnection conn = new SqlConnection(connString))
              {
                  conn.Open();
                  //using (SqlCommand cmd = new SqlCommand(cmdText, conn))
                  using (SqlCommand cmd = new SqlCommand(updateCommand, conn))
                  {
                      
                      cmd.Parameters.AddWithValue("@ID", statusID);
                      cmd.ExecuteNonQuery();
                  }
              }
      
              SendSuggestionStatusToUser(statusID);
          }
  

  
  
  
  
  

  • Edited by matrix388 on Jul 02, 2012 04:54 AM
• • Reply
  

  Frank Jiang ...

  All-Star

  16006 Points

  1728 Posts

  Microsoft

  Re: How to update the status of the selected suggestion through Ajax ModalPopUp Window?

  Jul 05, 2012 05:21 AM|LINK

  matrix388

  
  **Code-Behind:**

  public void btnSendStatus_Click(object sender, EventArgs e) {
              var statusID = StatusList.SelectedValue;
       
              string connString = "Data Source=localhost\\sqlexpress;Initial Catalog=psspdbTest;Integrated Security=True";
              //For updating the status of the safety suggestion
              string updateCommand = "UPDATE SafetySuggestionsStatus SET ID= @statusID";
              using (SqlConnection conn = new SqlConnection(connString))
              {
                  conn.Open();
                  //using (SqlCommand cmd = new SqlCommand(cmdText, conn))
                  using (SqlCommand cmd = new SqlCommand(updateCommand, conn))
                  {
                       
                      cmd.Parameters.AddWithValue("@ID", statusID);
                      cmd.ExecuteNonQuery();
                  }
              }
              SendSuggestionStatusToUser(statusID);
          }

  Please fix the line: cmd.Parameters.AddWithValue("@ID", statusID);

  cmd.Parameters.AddWithValue("@statusID", statusID);

   

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Marked as answer by Frank Jiang - MSFT on Jul 10, 2012 03:31 PM