ASP.NET

ALTER PROCEDURE [dbo].[sp_getcheck]
@ID int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.

SET NOCOUNT ON;
If NOT EXISTS(select * from mytable where ID=@ID)
  BEGIN
	RAISERROR (
    'ID number entered %d is invalid',
    11,
    1,
    @ID);
  END
END

protected void chk_Click(object sender, EventArgs e)
{

    if (!string.IsNullOrEmpty(checknumber.Text))
    {
        SqlConnection Conn = default(SqlConnection);

        //Read in connection String
        Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Constr"].ConnectionString);
        Conn.Open();

        SqlCommand cmd = new SqlCommand("sp_getcheck", Conn);
        //Retrieve the value of the output parameter

        //Add the output parameter to the command object
        cmd.Parameters.AddWithValue("@ID", checknumber.Text);
        SqlParameter outPutParameter = new SqlParameter();
        SqlDataReader dr = cmd.ExecuteReader();

        //Retrieve the value of the output parameter

        if (dr.Read())
        {
            try
            {
                //we add a hidden field called IsValid to the markup and set the IsValid value in the event handler here.
                imgstatus.ImageUrl = "images/Icon_Available.gif";
                lblStatus.ForeColor = Color.Green;

                //redirect based on value of hidden form field called evalue
                var evalue = hequipID.Value;
                if (evalue == "1")
                {
                    Response.Redirect("Air.aspx?pageId=1");
                }
                if (evalue == "2")
                {
                    Response.Redirect("Land.aspx?pageId=2");
                }

                //ID exists, get form fields and store db values in them:
                //txtfname.Text = (dr["FullName"].ToString());

            }
            catch (SqlException ex)
            {
                //Something is wrong with this taxpayer's account.
                imgstatus.ImageUrl = "images/NotAvailable.jpg";
                lblStatus.ForeColor = Color.Red;
                lblStatus.Text = ex.Message;
                chk.BackColor = Color.Silver;
                System.Threading.Thread.Sleep(2000);
            }
        }
    }
  }

context.MapRoute(
                "Space_default",
                "Space/{Value}/{controller}/{action}/{id}",
                new { action = "Index", id = UrlParameter.Optional }
            );

public class OverviewController : Controller
{
    string myValue = (int)RouteData.Values["Value"];

    [CourseAccess(CourseId = myValue)]
    public ActionResult Index(int CourseId)
    {...

code in MultiJobChange.js file

MultiJobChange = {
    loadMultiJobChange: function (employeeID) {
        $.get("/BSCSecurityAddressBookWeb/api/MultiJobChangeApi/Get").then(function (data) {

<pre>
        var list = $("#ddlEmployees");
        var selectedValue = list.val();

        list.empty();

        $.each(data, function (index, userList) {
            $("<option>").attr("value", userList.EmployeeID).text(applicationgroup.LastName).appendTo(list);
        }); 

    $("#btnClearList").click(function (event) {
        $("#lbxEmployees").empty();
    });

    $("#btnRemoveEmployee").click(function (event) {
        $("#lbxEmployees option:selected").remove();
    });
}

    var list = $("#ddlApplicationGroup");
    var selectedValue = list.val();

    list.empty();

    $.each(data.ApplicationGroups, function (index, applicationgroup) {
        $("<option>").attr("value", applicationgroup.ApplicationGroupID).text(applicationgroup.ApplicationGroupName).appendTo(list);
    });

    if ((selectedValue == null) || (selectedValue == undefined)) {
        list.prepend("<option value='-1' selected='selected'>Select value</option>");
        if ((list[0] != undefined) && (list[0] != null))
            list[0].selectedIndex = 0;
    }
    else {
        list.val(selectedValue);
    }

    var list = $("#ddlReportPack");
    var selectedValue = list.val();

    list.empty();

    $.each(data.ReportPacks, function (index, reportpack) {
        $("<option>").attr("value", reportpack.ReportPackID).text(reportpack.ReportPackName).appendTo(list);
    });

    if ((selectedValue == null) || (selectedValue == undefined)) {
        list.prepend("<option value='-1' selected='selected'>Select value</option>");
        if ((list[0] != undefined) && (list[0] != null))
            list[0].selectedIndex = 0;
    }
    else {
        list.val(selectedValue);
    }

});

$("#btnMultiJobChange").click(function (event) {
    MultiJobChange.loadMultiJobChange();
    window.open('/BSCSecurityAddressBookWeb/MultiJobChange/', '_self', false);        
});

Code in Employee/Index.js file

Controller methods:

public class MultiJobChangeApiController : ApiController

{"Message":"An error has occurred.","ExceptionMessage":"The 'ObjectContent`1' type failed to serialize the response body for content type 'application/json; charset=utf-8'.",
"ExceptionType":"System.InvalidOperationException","StackTrace":null,"InnerException":{"Message":"An error has occurred.","ExceptionMessage":
"The operation cannot be completed because the DbContext has been disposed.","ExceptionType":"System.InvalidOperationException","StackTrace":"   
at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()\r\n   at System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator()\r\n   at 
System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.IEnumerable.GetEnumerator()\r\n   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeList
(JsonWriter writer, IEnumerable values, JsonArrayContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)\r\n   at 
Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeValue(JsonWriter writer, Object value, JsonContract valueContract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerProperty)\r\n   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.Serialize(JsonWriter jsonWriter, Object value, Type objectType)\r\n   at Newtonsoft.Json.JsonSerializer.SerializeInternal(JsonWriter jsonWriter, Object value, Type objectType)\r\n   at System.Net.Http.Formatting.BaseJsonMediaTypeFormatter.WriteToStream(Type type, Object value, Stream writeStream, Encoding effectiveEncoding)\r\n   at System.Net.Http.Formatting.JsonMediaTypeFormatter.WriteToStream(Type type, Object value, Stream writeStream, Encoding effectiveEncoding)\r\n   at System.Net.Http.Formatting.BaseJsonMediaTypeFormatter.WriteToStream(Type type, Object value, Stream writeStream, HttpContent content)\r\n   at System.Net.Http.Formatting.BaseJsonMediaTypeFormatter.WriteToStreamAsync(Type type, Object value, Stream writeStream, HttpContent content, TransportContext transportContext, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.WebHost.HttpControllerHandler.<WriteBufferedResponseContentAsync>d__1b.MoveNext()"}}

        public List<UserList> Get()
        {
            dynamic model = null;
            using (AppDevSecEntities ctx = new AppDevSecEntities())
            {
                var temp = ctx.UserLists.OrderByDescending(x => x.LastName);
                if (temp != null)
                    model = temp.ToList<UserList>();
            }
            return model;
        }

Purchased:<asp:radiobuttonlist ID="rblType" runat="server" ValidationGroup ="stype" RepeatDirection="Horizontal" TextAlign="Right" style="display:inline;">
                <asp:ListItem Text="Yes" />
                <asp:ListItem Text="No" />
               </asp:RadioButtonList>
               <asp:RequiredFieldValidator id="RequiredFieldValidator1"
               ControlToValidate="rblType"
               ErrorMessage="required"
               ValidationGroup ="stype"
               runat="server"/>