C# Mail: why this function cannot send emails?
===

In a web-based ASP.NET suggestions box program, the Admin will be able to see all suggestions listed in a GridView control with the username of the owner. In the last column of the GridView, 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. Everything works fine. What I want to do now is when the user updates the status of anyone of the suggestions, an email notification will be sent to the owner regarding the update of status of his suggestion. 

I already wrote the Mail function but I don't know why it does not send any email and I am getting this error while debugging the code:

<b><i>Use of unassigned local variable 'description'</i></b>

I already assigned it to the value of the [Description] column in the database but I don't know why I am getting this error.

<b><u>Could anyone help me with this?</u></b>

I am really struggling with getting the username of that updated suggestion. 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="No." 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="Division" 
                        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:HiddenField ID="HiddenField1" runat="server"/>
    
            <asp:Panel runat="server" ID="pnlPopUp" CssClass="popUpStyle">
                
                        <asp:RadioButtonList ID="StatusList" runat="server" RepeatColumns="1" RepeatDirection="Vertical"
                                                RepeatLayout="Table" TextAlign="Right" 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:**

    protected void lnkSuggestionStatus_Click(object sender, EventArgs e)
        {
            LinkButton lnkSuggestionStatus = sender as LinkButton;
    
            //var safetySuggestionsId = 
    
            //get reference to the row selected 
            GridViewRow gvrow = (GridViewRow)lnkSuggestionStatus.NamingContainer;
    
            //set the selected index to the selected row so that the selected row will be highlighted
            GridView1.SelectedIndex = gvrow.RowIndex;
    
            //This HiddenField used to store the value of the ID
            HiddenField1.Value = GridView1.DataKeys[gvrow.RowIndex].Value.ToString();
            //ViewState["Username"] = gvrow.Cells[4].Text;
    
            //show the modalPopUp
            modalPopUpExtender1.Show();
        }
    
        public void btnSendStatus_Click(object sender, EventArgs e) {
            //get the ID of the selected suggestion/row
            var statusID = StatusList.SelectedValue;
            var safetySuggestionsID = HiddenField1.Value;
    
            string connString = "Data Source=localhost\\sqlexpress;Initial Catalog=psspdbTest;Integrated Security=True";
            //For updating the status of the safety suggestion
            string updateCommand = "UPDATE SafetySuggestionsLog SET StatusID= @statusID where ID=@SafetySuggestionsID";
            using (SqlConnection conn = new SqlConnection(connString))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(updateCommand, conn))
                {
                    cmd.Parameters.AddWithValue("@statusID", Convert.ToInt32(statusID));
                    cmd.Parameters.AddWithValue("@SafetySuggestionsID", Convert.ToInt32(HiddenField1.Value));
                    cmd.ExecuteNonQuery();
                }
                //reset the value of hiddenfield
                HiddenField1.Value = "-1";
            }
    
            GridView1.DataBind();
    
    
            SendSuggestionStatusToUser(safetySuggestionsID);
        }
    
        protected void SendStatusByEmail(string toAddresses, string fromAddress, string MailSubject, string MessageBody, bool isBodyHtml)
        {
            SmtpClient sc = new SmtpClient("MAIL.Aramco.com");
            try
            {
                MailMessage msg = new MailMessage();
                msg.From = new MailAddress("pssp@aramco.com", "PMOD Safety Services Portal (PSSP)");
    
                // In case the mail system doesn't like no to recipients. This could be removed
                //msg.To.Add("pssp@aramco.com");
    
                msg.Bcc.Add(toAddresses);
                msg.Subject = MailSubject;
                msg.Body = MessageBody;
                msg.IsBodyHtml = isBodyHtml;
                sc.Send(msg);
            }
            catch (Exception ex)
            {
                throw ex;
            }
    
        }
    
        protected void SendSuggestionStatusToUser(string suggestionID)
        {
            string connString = "Data Source=localhost\\sqlexpress;Initial Catalog=psspdbTest;Integrated Security=True";
            
            string safetySuggestionID = suggestionID.ToString();
            //string username = ViewState["Username"].ToString();
    
            //The following connection is to get the username of the suggestion Owner
            //and append (@aramco.com) to it.
            using (SqlConnection conn = new SqlConnection(connString))
            {
                var sbEmailAddresses = new System.Text.StringBuilder(2000);
    
                //initiate the varibles that will be retreived from the database
                string username;
                string description;
                string status;
    
                // Open DB connection.
                conn.Open();
    
                string cmdText2 = @"SELECT Username, Description, Status FROM dbo.SafetySuggestionsLog SSL INNER JOIN SafetySuggestionsStatus SSS
                                    ON (SSL.StatusID = SSS.ID) WHERE (SSL.ID = @safetySuggestionID)";
                using (SqlCommand cmd = new SqlCommand(cmdText2, conn))
                {
                    cmd.Parameters.AddWithValue("@SafetySuggestionID", Convert.ToInt32(HiddenField1.Value));
                    SqlDataReader reader = cmd.ExecuteReader();
                    if (reader != null)
                    {
                        if (reader.Read())
                        {
                            username = reader["Username"].ToString();
                            description = reader["Description"].ToString();
                            status = reader["Status"].ToString();
                            sbEmailAddresses.Append(username).Append("aramco.com");
                        }
                    }
    
                    var sEMailAddresses = sbEmailAddresses.ToString();
                    string body = @"Good day, &lt;br /&gt;&lt;br /&gt;
                                    <b> We just would like to notify you that your following safety suggestion: </b>"
                                        + description +
                                        @"&lt;br /&gt;&lt;br /&gt;
                                has been.
                                &lt;br /&gt; &lt;br /&gt;&lt;br /&gt; &lt;br /&gt;
                                This email was generated using the &lt;a href='http://pmv/pssp/Default.aspx'&gt;PMOD Safety Services Portal (PSSP) &lt;/a&gt;. 
                                Please do not reply to this email.
                                ";
                    SendStatusByEmail(sbEmailAddresses.ToString(), "", "Notification of Your Safety Suggestion", body, true);
                    sbEmailAddresses.Clear();
                    reader.Close();
    
    
                }
    
                conn.Close();
            }
        }


***Note: I know that I should not post a lengthy code here, but because I want to explain to you my work and to get your help.***
