ASP.NET

@model ProjectName.Models.Goals
<div>
   <form asp-controller="Goals" asp-action="Create">
      Other form elements

      <select name="months" asp-for="MonthId" class="form-control" asp-items="ViewBag.Months">

      </select>

      <input type="submit" value="Save" class="btn btn-primary" />
   </form>
</div>

public class Goals
    {
        [Display(Name = "Code")]
        public Int32 GoalId { get; set; }

        public String GoalName{ get; set; }
        public Months Month{ get; set; }
        public Int32 MonthId{ get; set; }
        ....
        Other properties

    }

public class Months
{
    [Key]
    [Display(Name = "Code")]
    public Int32 MonthId { get; set; }
    [Display(Name = "Designation")]
    public String Designation{ get; set; }
}

public IActionResult Create(Goals goal)
{
   if (ModelState.IsValid)
   {
      _context.Goals.Add(goal);
      _context.SaveChanges();
   }
   return View("~/../Create.cshtml");
}

        var template;
        if (paramType === 'Date Range') {
            var multiple = "multiple='multiple'";
            template =
            '<div id="Param_' + Id + '">' +
                '<div class="parameterHeader ui-widget-header ui-corner-top">' + paramDisplayName + '</div>' +
                '<div class="parameterItem ui-widget-content ui-corner-bottom" ' + multiple + '>' +
                    '<div class="parameterFieldResize parameterField">' +
                        '<input class="parameterDateRangePicker clearable" placeholder="Start" type="text" name="' + paramName + '_1_Start" id="' + paramName + '_1_Start" />' +
                        '<input class="parameterDateRangePicker clearable" placeholder="End" type="text" name="' + paramName + '_1_End" id="' + paramName + '_1_End" />' +
                    '</div>' +<br />
                '</div>' +
            '</div>';

<pre>
        //Insert HTML
        this.JQElem = $(template);
        initialParent.append(this.JQElem);            

        $('#' + paramName + '_1_Start').datepicker({
            onSelect: function (dateText) {
                $(this).trigger("input");
                if (typeof me.values[this.id.split('_')[1]] === 'undefined')
                    me.values[this.id.split('_')[1]] = {};
                me.values[this.id.split('_')[1]]['Start'] = dateText;
            }
        });
        $('#' + paramName + '_1_End').datepicker({
            onSelect: function (dateText) {
                $(this).trigger("input");
                if (typeof me.values[this.id.split('_')[1]] === 'undefined')
                    me.values[this.id.split('_')[1]] = {};
                me.values[this.id.split('_')[1]]['End'] = dateText;
            }
        });
        $("#" + paramName + '_1_Start').change(function (event) {
            //convert to 4 digit year (always will be in the 20's)
            var dateString = this.value;
            if (/^\d{1,2}\/\d{1,2}\/\d{2}$/.test(dateString)) {
                dateString = dateString.substring(0, dateString.length - 2) + '20' + dateString.substring(dateString.length - 2, dateString.length);
                this.value = dateString;
            }
            if (isValidDate(dateString)) {
                if (typeof me.values[paramName + '_1'] === 'undefined')
                    me.values[this.id.split('_')[1]] = {};
                me.values[this.id.split('_')[1]]['Start'] = dateString;
            } else if (typeof me.values[this.id.split('_')[1]] !== 'undefined' && typeof me.values[this.id.split('_')[1]]['Start'] !== 'undefined') {
                if (typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
                    delete me.values[this.id.split('_')[1]];
                else
                    delete me.values[this.id.split('_')[1]];
            }
        });
        $("#" + paramName + '_1_End').change(function (event) {
            //convert to 4 digit year (always will be in the 20's)
            var dateString = this.value;
            if (/^\d{1,2}\/\d{1,2}\/\d{2}$/.test(dateString)) {
                dateString = dateString.substring(0, dateString.length - 2) + '20' + dateString.substring(dateString.length - 2, dateString.length);
                this.value = dateString;
            }
            if (isValidDate(dateString)) {
                if (typeof me.values[this.id.split('_')[1]] === 'undefined')
                    me.values[this.id.split('_')[1]] = {};
                me.values[this.id.split('_')[1]]['End'] = dateString;
            } else if (typeof me.values[this.id.split('_')[1]] !== 'undefined' && typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
                if (typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')                        
                    delete me.values[this.id.split('_')[1]];
                else
                    delete me.values[this.id.split('_')[1]];
        });

I want to create a single page on which i can perform full crud operation using dropdownlist, radiobuttonlist, checkbox ,checkbox inside dropdown in a gridview.

and at the left side of each row in gridview should be insert, delete and update.

and should be a button on which click we can see the deleted rows.

please send the code with database script file.

<div class="col-md-3">
                       
                <label class="switch2">
                <input class="switch-input2" type="checkbox" id="contractselection" name="contractselection" runat="server"/>
                  
                  
             </label>            
          </div>
          <div class="col-xs-4">  
           
            <div class="contractrow">                  
            <label for="exampleInputCity">Contract:*:</label>
             <asp:TextBox ID="contractnumber" class="form-control" name="contractnumber" placeholder="" runat="server"></asp:TextBox>           
            </div>  
             <asp:RequiredFieldValidator ID="rfvcontractnumber"    runat="server" ControlToValidate ="contractnumber"   ErrorMessage="Please enter a Contract">   
                </asp:RequiredFieldValidator>           
             <div class="orderrow">                  
            <label for="exampleInputCity">Solicitation:*:</label>
             <asp:TextBox ID="ordernumber" class="form-control" name="ordernumber" placeholder="" runat="server"></asp:TextBox>           
            </div> 
             <asp:RequiredFieldValidator ID="rfvsolicitationnumber"    runat="server" ControlToValidate ="ordernumber"   ErrorMessage="Please enter a Order">   
                </asp:RequiredFieldValidator>                
             </div>   
          </div>
          </div>       

<script type="text/javascript">
    $(function () {
        $(".contractrow").show();
        $(".switch-input2").click(function () {
            if ($(this).is(":checked")) {
                $(".contractrow").show();
            } else {
                $(".solicitationrow").hide();
            }
        });
    });
</script>

<label class="switch">
	<input class="switch-input" type="checkbox" id="orderselection" name="orderselection" runat="server" />
	 
	 
</label>

<label for="exampleOrderNumber">Are Redelegations Authorized?<label for="exampleInputCity">:</label>           
             <label class="switch">
                <input class="switch-input" type="checkbox" id="authredelegation" name="authredelegation" runat="server" />
                  
                  
             </label>

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