ASP.NET

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load

        Dim table As New DataTable()
        Using con = New SqlConnection(ConfigurationManager.ConnectionStrings("PersonnelPolicyDB").ConnectionString)
            Using cmd = New SqlCommand("usp_AddABCD", con)
                Using da = New SqlDataAdapter(cmd)
                    cmd.CommandType = CommandType.StoredProcedure
                    cmd.Parameters.AddWithValue("@oderno", "orderno.text")
                    cmd.Parameters.AddWithValue("@orderdate", "orderdate.text")
                    da.Fill(table)
                End Using
            End Using
        End Using
      End Sub



        Dim table As New DataTable()
        Using con = New SqlConnection(ConfigurationManager.ConnectionStrings("PersonnelPolicyDB").ConnectionString)
            Using cmd = New SqlCommand("usp_GetABCD", con)
                Using da = New SqlDataAdapter(cmd)
                    cmd.CommandType = CommandType.StoredProcedure
                    cmd.Parameters.AddWithValue("@orderno", "orderno.text")
                   da.Fill(table)
                End Using
            End Using
        End Using
    End Sub
        
       Private Sub SendPDFEmail(dt As DataTable)
           Using sw As New StringWriter()
               Using hw As New HtmlTextWriter(sw)
                   Dim companyName As String = "my Company"
                   Dim orderNo As Integer = 2303
                   Dim sb As New StringBuilder()
                   sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>")
                   sb.Append("<tr><td align='center' style='background-color: #18B5F0' colspan = '2'>Order Sheet</td></tr>")
                   sb.Append("<tr><td colspan = '2'></td></tr>")
                   sb.Append("<tr><td>Order No:")
                   sb.Append(orderNo)
                   sb.Append("</td><td>Date: ")
                   sb.Append(DateTime.Now)
                   sb.Append(" </td></tr>")
                   sb.Append("<tr><td colspan = '2'>Company Name : ")
                   sb.Append(companyName)
                   sb.Append("</td></tr>")
                   sb.Append("</table>")
                   sb.Append("<br />")
                   sb.Append("<table border = '1'>")
                   sb.Append("<tr>")
                   For Each column As DataColumn In dt.Columns
                       sb.Append("<th style = 'background-color: #D20B0C;color:#ffffff'>")
                       sb.Append(column.ColumnName)
                       sb.Append("</th>")
                   Next
                   sb.Append("</tr>")
                   For Each row As DataRow In dt.Rows
                       sb.Append("<tr>")
                       For Each column As DataColumn In dt.Columns
                           sb.Append("<td>")
                           sb.Append(row(column))
                           sb.Append("</td>")
                       Next
                       sb.Append("</tr>")
                   Next
                   sb.Append("</table>")
                   Dim sr As New StringReader(sb.ToString())
   
                   Dim pdfDoc As New Document(PageSize.A4, 10.0F, 10.0F, 10.0F, 0.0F)
                   Dim htmlparser As New HTMLWorker(pdfDoc)
                   Using memoryStream As New MemoryStream()
                       Dim writer As PdfWriter = PdfWriter.GetInstance(pdfDoc, memoryStream)
                       pdfDoc.Open()
                       htmlparser.Parse(sr)
                       pdfDoc.Close()
                       Dim bytes As Byte() = memoryStream.ToArray()
                       memoryStream.Close()
   
                       Dim mm As New MailMessage("NoReply@domain.com", "myemail@domain.com")
                       mm.Subject = "iTextSharp PDF"
                       mm.Body = "iTextSharp PDF Attachment"
                       mm.Attachments.Add(New Attachment(New MemoryStream(bytes), "iTextSharpPDF.pdf"))
                       mm.IsBodyHtml = True
                       Dim smtp As New SmtpClient()
                       smtp.Host = "myhostname"
                       smtp.EnableSsl = False
                       Dim NetworkCred As New System.Net.NetworkCredential()
                       NetworkCred.UserName = "myusername"
                       NetworkCred.Password = "mypassword"
                       smtp.UseDefaultCredentials = True
                       smtp.Credentials = NetworkCred
                       smtp.Port = 25
                       smtp.Send(mm)
                   End Using
               End Using
           End Using
    End Sub

public ActionResult Index ()
         {
             CatalogModel m = new CatalogModel ();
             m.LocalCodeColumn = 1;
             m.PriceColumn = 2;
             m.SelectedClientList = m.GetClientSelectedItems ();
             return View (m);
         }

Select Client: @ Html.DropDownListFor (m => m.SelectedClientList, Model.GetClientSelectedItems (), "--Select--", new {@id = "ddlClient"})

public IEnumerable<SelectListItem> GetClientSelectedItems()
        {
            // Function GetListClient() return IEnumerable<SelectListItem> 
            IEnumerable<SelectListItem> listClient = dataServices.GetClients();
            return listClient;
        }

<div id="myModal" class="modal fade" role="dialog">
  <div class="modal-dialog">
    <!-- Modal content-->
    <div class="modal-content">

      <div class="modal-header">
        Point of Contact
      </div>
      <div class="modal-body">
      <div class="name-text-container">  
        <span id="fname-text">First Name:</span>
        <span id="mname-text">MI:</span>
        <span id="lname-text">Last name*:</span><br>
      </div>

      <div class="name-input-container">
        <form>
          <input id="fname-input" type="text" name="fname" size="15">
          <input id="mname-input" type="text" name="mname" maxlength="1" size="1">
          <input id="lname-input" type="text" name="lname" size="16"><br>
        </form>
      </div>

      <div class="email-text-container">
        <span id="email-text">Email*:</span><br>
      </div>

      <div class="email-input-container">
        <form>
          <input id="email-input" type="text" name="email" size="47"><br>
        </form>
      </div>

      <div class="contact-text-container">
        <span id="telephone-text">Telephone:</span>
        <span id="fax-text">Fax:</span><br>
      </div>

      <div class="contact-input-container">
        <form>
          <input id="telephone-input" type="text" name="telephone" size="20">
          <input id="fax-input" type="text" name="fax" size="19"><br>
        </form>
      </div>

      

    </div>
    <!--End of modal body -->

      <div class="modal-footer">
          <button type="button" data-dismiss="modal">Cancel</button>
          <button type="button" data-dismiss="modal">Save</button>
      </div>

SqlConnection con;
                 con = new SqlConnection(@"Data Source=SEPEHR;Integrated Security=True;server=(local);Database=TestDatabaseByYall");
                 con.Open();
                 SqlCommand cmd;
                 cmd = new SqlCommand("INSERT INTO tbl_CustInfo (codemeli,mydate,name,idnasb,iddevice,email,mobile,tel,adress)" + "VALUES (@codemeli,@mydate,@name,@idnasb,@iddevice,@email,@mobile,@tel,@adress)", con);
                cmd.Parameters.AddWithValue("@codemeli", txtcodemeli.Text.Trim().ToString());
                 cmd.Parameters.AddWithValue("@mydate", mydat);
                 statuse = false;
                 cmd.Parameters.AddWithValue("@name", txtname.Text);
                 cmd.Parameters.AddWithValue("@idnasb", dridnasb.SelectedItem.Value);
                 cmd.Parameters.AddWithValue("@iddevice", drdevice.SelectedItem.Value);
                 cmd.Parameters.AddWithValue("@email", txtemail.Text.Trim());
                 cmd.Parameters.AddWithValue("@mobile", txtmobile.Text.Trim().ToString());
                 cmd.Parameters.AddWithValue("@tel", txttel.Text.Trim().ToString());
                 cmd.Parameters.AddWithValue("@adress", txtAdress.Text.Trim());
                 cmd.ExecuteNonQuery();
                 lblresult.Text = "Successful!";

                SqlCommand cmd2;
                string vart="1";
                string varf="0";
                cmd2 = new SqlCommand("INSERT INTO tbl_Customer_Statuse (idcustomer,level1,level2,level3,level4,Complate)" + "VALUES (@codemeli,@level1,@level2,@level3,@level14,@Complate)", con);
                cmd2.Parameters.AddWithValue("@codemeli",txtcodemeli.Text.Trim());
                cmd2.Parameters.AddWithValue("@level1",vart);
                cmd2.Parameters.AddWithValue("@level2",varf);
                cmd2.Parameters.AddWithValue("@level3",varf);
                cmd2.Parameters.AddWithValue("@level4",varf);
                cmd2.Parameters.AddWithValue("@Complate",varf);
                cmd2.ExecuteNonQuery();
                con.Close();