C# Online Compiler | .NET Fiddle

<no name> by Anonymous

using System;
using System.ComponentModel.DataAnnotations;

namespace HelloWorldMvcApp
{
	public class MstLibraryCard { 
		public Int32 Id { get; set; }
								 public Int32 LibraryCardNumber { get; set; } 
		public Int32 ManualLibraryCardNumber { get; set; } 
		public Int32 BorrowerId { get; set; } 
		public Boolean IsPrinted { get; set; } 
		public Int32 LibraryInChargeUserId { get; set; } 
		public String FootNote { get; set; } 
		public Int32 CreatedByUserId { get; set; } 
		public String CreatedDate { get; set; } 
		public Int32 UpdatedByUserId { get; set; } 
		public String UpdatedDate { get; set; }
								}

Model

​x
 
using System;
using System.ComponentModel.DataAnnotations;
​
namespace HelloWorldMvcApp
{
    public class MstLibraryCard { 
        public Int32 Id { get; set; }
                                 public Int32 LibraryCardNumber { get; set; } 
        public Int32 ManualLibraryCardNumber { get; set; } 
        public Int32 BorrowerId { get; set; } 
        public Boolean IsPrinted { get; set; } 
        public Int32 LibraryInChargeUserId { get; set; } 
        public String FootNote { get; set; } 
        public Int32 CreatedByUserId { get; set; } 
        public String CreatedDate { get; set; } 
        public Int32 UpdatedByUserId { get; set; } 
        public String UpdatedDate { get; set; }
                                }

@model HelloWorldMvcApp.SampleViewModel
@{
	Layout = null;
}

<!DOCTYPE html>
<!-- template from http://getbootstrap.com/getting-started -->

<html lang="en">
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<title>Bootstrap 101 Template</title>

		<!-- CSS Includes -->
		<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css">
		
		<style type="text/css">

			.field-validation-error {
				color: #ff0000;
			}

		</style>
	</head>
	
	<body>
		<div class="container">
			<div class="col-md-6 col-md-offset-3">
				<h1>Hello Stranger</h1>
	
				@using (Html.BeginForm())
				{
					<div class="form-group">
						@Html.LabelFor(m => m.Question)
						@Html.TextBoxFor(model => model.Question, new {@class="form-control"}) 
						@Html.ValidationMessageFor(model => model.Question)
					</div>
				
					<button type="button" class="btn btn-success submit">Ask</button>
				}
	
				<br/><br/>
				<div class="alert alert-warning fade">
					<img src="https://dl.dropboxusercontent.com/s/lq0mgxtxtc4uj1e/morph.jpg?dl=1&token_hash=AAGm5lEcLzicmV_-T4h6Hc_3iBvhKVerZlOjvGP_vjpoJQ" /><br/><br/>
					<strong><span class="alert-content"></span></strong>
				</div>
			</div>
		</div>

		<!-- JS includes -->
		<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
		<script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
	
		<script src="//ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.min.js"></script>
		<script src="//ajax.aspnetcdn.com/ajax/mvc/4.0/jquery.validate.unobtrusive.min.js"></script>
		
		<script type="text/javascript">
		
			function openAlert(txt) {
				$('.alert-content').text(txt);
				$('.alert').addClass('in');
			}
		
			function closeAlert() {
				$('.alert').removeClass('in');
			}
		
			$(function(){
				var answer = '@Model.Answer';
		
				if(answer && answer != '') 
					openAlert(answer);
		
				$('#Question').change(closeAlert);
				$('#Question').keyup(closeAlert);
		
				$('.submit').click(function(){
					if($('form').valid()) {
					
						$.ajax({
							url: '@Url.RouteUrl(new{ action="GetAnswer", controller="Home"})',
							data: {Answer: '', Question: $('#Question').val()},
								type: 'POST',
								dataType: 'json',
								contentType: "application/json; charset=utf-8",
								success: function(resp) {
								openAlert(resp);
						}});
					}
					else {
						closeAlert();
					}
				});
			
			});

		</script>
	</body>
</html>

View

 
@model HelloWorldMvcApp.SampleViewModel
@{
    Layout = null;
}
​
<!DOCTYPE html>
<!-- template from http://getbootstrap.com/getting-started -->
​
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>Bootstrap 101 Template</title>
​
        <!-- CSS Includes -->
        <link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css">
        
        <style type="text/css">
​
            .field-validation-error {
                color: #ff0000;
            }
​
        </style>
    </head>
    
    <body>
        <div class="container">
            <div class="col-md-6 col-md-offset-3">
                <h1>Hello Stranger</h1>
    
                @using (Html.BeginForm())
                {
                    <div class="form-group">
                        @Html.LabelFor(m => m.Question)
                        @Html.TextBoxFor(model => model.Question, new {@class="form-control"}) 
                        @Html.ValidationMessageFor(model => model.Question)
                    </div>
                
                    <button type="button" class="btn btn-success submit">Ask</button>
                }
    
                <br/><br/>
                <div class="alert alert-warning fade">
                    <img src="https://dl.dropboxusercontent.com/s/lq0mgxtxtc4uj1e/morph.jpg?dl=1&token_hash=AAGm5lEcLzicmV_-T4h6Hc_3iBvhKVerZlOjvGP_vjpoJQ" /><br/><br/>
                    <strong><span class="alert-content"></span></strong>
                </div>
            </div>
        </div>
​
        <!-- JS includes -->
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
        <script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
    
        <script src="//ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.min.js"></script>
        <script src="//ajax.aspnetcdn.com/ajax/mvc/4.0/jquery.validate.unobtrusive.min.js"></script>
        
        <script type="text/javascript">
        
            function openAlert(txt) {
                $('.alert-content').text(txt);
                $('.alert').addClass('in');
            }
        
            function closeAlert() {
                $('.alert').removeClass('in');
            }
        
            $(function(){
                var answer = '@Model.Answer';
        
                if(answer && answer != '') 
                    openAlert(answer);
        
                $('#Question').change(closeAlert);
                $('#Question').keyup(closeAlert);
        
                $('.submit').click(function(){
                    if($('form').valid()) {
                    
                        $.ajax({
                            url: '@Url.RouteUrl(new{ action="GetAnswer", controller="Home"})',
                            data: {Answer: '', Question: $('#Question').val()},
                                type: 'POST',
                                dataType: 'json',
                                contentType: "application/json; charset=utf-8",
                                success: function(resp) {
                                openAlert(resp);
                        }});
                    }
                    else {
                        closeAlert();
                    }
                });
            
            });
​
        </script>
    </body>
</html>
​

	public class MstLibraryCardController : ApiController
    {
        Data.ITElec4dbDataContext db = new Data.ITElec4dbDataContext();

        [HttpGet, Route("list")]
        public List<Api_Models.MstLibraryCard_ApiModel> GetLibraryCards()
        {

            var librarycard = from d in db.MstLibraryCard
                          select new Api_Models.MstLibraryCard_ApiModel
                          {
                              Id = d.Id,
							  ManualLibraryCardNumber = d.ManualLibraryCardNumber,
							  BorrowerId = d.BorrowerId,
		             		  IsPrinted = d.IsPrinted,
							  LibraryInChargeUserId = d.LibraryInChargeUserId,
							  FootNote = d.FootNote,
							  CreatedByUserId = d.CreatedByUserId,
							  CreatedDate = d.CreatedDate,
							  UpdatedByUserId = d.UpdatedByUserId,
							  UpdatedDate = d.UpdatedDate
                          };

            return librarycard.OrderByDescending(d => d.ManualLibraryCardNumber).ToList();
        }

        [HttpGet, Route("detail/{id}")]
        public Api_Models.MstLibraryCard_ApiModel GetLibraryCard(String id)
        {

            var librarycard = from d in db.MstLibraryCard
                          where d.Id == Convert.ToInt32(id)
                          select new Api_Models.MstLibraryCard_ApiModel
                          {
                              Id = d.Id,
							  ManualLibraryCardNumber = d.ManualLibraryCardNumber,
							  BorrowerId = d.BorrowerId,
		             		  IsPrinted = d.IsPrinted,
							  LibraryInChargeUserId = d.LibraryInChargeUserId,
							  FootNote = d.FootNote,
							  CreatedByUserId = d.CreatedByUserId,
							  CreatedDate = d.CreatedDate,
							  UpdatedByUserId = d.UpdatedByUserId,
							  UpdatedDate = d.UpdatedDate
                          };

            return librarycard.FirstOrDefault();
        }

        [HttpPost, Route("librarycard/add")]
        public HttpResponseMessage AddLibraryCard(Api_Models.MstLibraryCard_ApiModel objLibraryCard, String Id)
        {
            try
            {
                Data.MstLibraryCard newLibraryCard = new Data.MstLibraryCard
                {
                     ManualLibraryCardNumber = objLibraryCard.ManualLibraryCardNumber,
							  BorrowerId = objLibraryCard.BorrowerId,
		             		  IsPrinted = objLibraryCard.IsPrinted,
							  LibraryInChargeUserId = objLibraryCard.LibraryInChargeUserId,
							  FootNote = objLibraryCard.FootNote,
							  CreatedByUserId = objLibraryCard.CreatedByUserId,
							  CreatedDate = objLibraryCard.CreatedDate,
							  UpdatedByUserId = objLibraryCard.UpdatedByUserId,
							  UpdatedDate = objLibraryCard.UpdatedDate
                };
                db.MstLibraryCard.InsertOnSubmit(newLibraryCard);
                db.SubmitChanges();

                return Request.CreateResponse(HttpStatusCode.OK);
            }
            catch (Exception e)
            {
                return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message);
            }
        }

        [HttpPut, Route("librarycard/update/{id}")]
        public HttpResponseMessage SaveLibraryCard(Api_Models.MstLibraryCard_ApiModel objLibraryCard, String Id)
        {
            try
            {
                var librarycard = from d in db.MstLibraryCard
                             where d.Id == Convert.ToInt32(Id)
                             select d;

                if (librarycard.Any())
                {
                    var updateLibraryCard = librarycard.FirstOrDefault();
    
                		updateLibraryCard.ManualLibraryCardNumber = objLibraryCard.ManualLibraryCardNumber;
							  updateLibraryCard.BorrowerId = objLibraryCard.BorrowerId;
		             		  updateLibraryCard.IsPrinted = objLibraryCard.IsPrinted;
							  updateLibraryCard.LibraryInChargeUserId = objLibraryCard.LibraryInChargeUserId;
							  updateLibraryCard.FootNote = objLibraryCard.FootNote;
							  updateLibraryCard.CreatedByUserId = objLibraryCard.CreatedByUserId;
							  updateLibraryCard.CreatedDate = objLibraryCard.CreatedDate;
							  updateLibraryCard.UpdatedByUserId = objLibraryCard.UpdatedByUserId;
							  updateLibraryCard.UpdatedDate = objLibraryCard.UpdatedDate;
                    db.MstLibraryCard.InsertOnSubmit(updateLibraryCard);
                    db.SubmitChanges();

                    return Request.CreateResponse(HttpStatusCode.OK);
                }
                else
                {
                    return Request.CreateResponse(HttpStatusCode.NotFound, "Library Card not found!");
                }
            }
            catch (Exception e)
            {
                return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message);
            }
        }

        [HttpDelete, Route("librarycard/delete/{id}")]
        public HttpResponseMessage DeleteLibraryCard(String Id)
        {
            try
            {
                var librarycard = from d in db.MstLibraryCard
                             where d.Id == Convert.ToInt32(Id)
                             select d;

                if (librarycard.Any())
                {
                    db.MstLibraryCard.DeleteOnSubmit(librarycard.FirstOrDefault());
                    db.SubmitChanges();

                    return Request.CreateResponse(HttpStatusCode.OK);
                }
                else
                {
                    return Request.CreateResponse(HttpStatusCode.NotFound, "Library Card not found!");
                }
            }
            catch (Exception e)
            {
                return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message);
            }
       }
}

Controller

 
    public class MstLibraryCardController : ApiController
    {
        Data.ITElec4dbDataContext db = new Data.ITElec4dbDataContext();
​
        [HttpGet, Route("list")]
        public List<Api_Models.MstLibraryCard_ApiModel> GetLibraryCards()
        {
​
            var librarycard = from d in db.MstLibraryCard
                          select new Api_Models.MstLibraryCard_ApiModel
                          {
                              Id = d.Id,
                              ManualLibraryCardNumber = d.ManualLibraryCardNumber,
                              BorrowerId = d.BorrowerId,
                              IsPrinted = d.IsPrinted,
                              LibraryInChargeUserId = d.LibraryInChargeUserId,
                              FootNote = d.FootNote,
                              CreatedByUserId = d.CreatedByUserId,
                              CreatedDate = d.CreatedDate,
                              UpdatedByUserId = d.UpdatedByUserId,
                              UpdatedDate = d.UpdatedDate
                          };
​
            return librarycard.OrderByDescending(d => d.ManualLibraryCardNumber).ToList();
        }
​
        [HttpGet, Route("detail/{id}")]
        public Api_Models.MstLibraryCard_ApiModel GetLibraryCard(String id)
        {
​
            var librarycard = from d in db.MstLibraryCard
                          where d.Id == Convert.ToInt32(id)
                          select new Api_Models.MstLibraryCard_ApiModel
                          {
                              Id = d.Id,
                              ManualLibraryCardNumber = d.ManualLibraryCardNumber,
                              BorrowerId = d.BorrowerId,
                              IsPrinted = d.IsPrinted,
                              LibraryInChargeUserId = d.LibraryInChargeUserId,
                              FootNote = d.FootNote,
                              CreatedByUserId = d.CreatedByUserId,
                              CreatedDate = d.CreatedDate,
                              UpdatedByUserId = d.UpdatedByUserId,
                              UpdatedDate = d.UpdatedDate
                          };
​
            return librarycard.FirstOrDefault();
        }
​
        [HttpPost, Route("librarycard/add")]
        public HttpResponseMessage AddLibraryCard(Api_Models.MstLibraryCard_ApiModel objLibraryCard, String Id)
        {
            try
            {
                Data.MstLibraryCard newLibraryCard = new Data.MstLibraryCard
                {
                     ManualLibraryCardNumber = objLibraryCard.ManualLibraryCardNumber,
                              BorrowerId = objLibraryCard.BorrowerId,
                              IsPrinted = objLibraryCard.IsPrinted,
                              LibraryInChargeUserId = objLibraryCard.LibraryInChargeUserId,
                              FootNote = objLibraryCard.FootNote,
                              CreatedByUserId = objLibraryCard.CreatedByUserId,
                              CreatedDate = objLibraryCard.CreatedDate,
                              UpdatedByUserId = objLibraryCard.UpdatedByUserId,
                              UpdatedDate = objLibraryCard.UpdatedDate
                };
                db.MstLibraryCard.InsertOnSubmit(newLibraryCard);
                db.SubmitChanges();
​
                return Request.CreateResponse(HttpStatusCode.OK);
            }
            catch (Exception e)
            {
                return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message);
            }
        }
​
        [HttpPut, Route("librarycard/update/{id}")]
        public HttpResponseMessage SaveLibraryCard(Api_Models.MstLibraryCard_ApiModel objLibraryCard, String Id)
        {
            try
            {
                var librarycard = from d in db.MstLibraryCard
                             where d.Id == Convert.ToInt32(Id)
                             select d;
​
                if (librarycard.Any())
                {
                    var updateLibraryCard = librarycard.FirstOrDefault();
    
                        updateLibraryCard.ManualLibraryCardNumber = objLibraryCard.ManualLibraryCardNumber;
                              updateLibraryCard.BorrowerId = objLibraryCard.BorrowerId;
                              updateLibraryCard.IsPrinted = objLibraryCard.IsPrinted;
                              updateLibraryCard.LibraryInChargeUserId = objLibraryCard.LibraryInChargeUserId;
                              updateLibraryCard.FootNote = objLibraryCard.FootNote;
                              updateLibraryCard.CreatedByUserId = objLibraryCard.CreatedByUserId;
                              updateLibraryCard.CreatedDate = objLibraryCard.CreatedDate;
                              updateLibraryCard.UpdatedByUserId = objLibraryCard.UpdatedByUserId;
                              updateLibraryCard.UpdatedDate = objLibraryCard.UpdatedDate;
                    db.MstLibraryCard.InsertOnSubmit(updateLibraryCard);
                    db.SubmitChanges();
​
                    return Request.CreateResponse(HttpStatusCode.OK);
                }
                else
                {
                    return Request.CreateResponse(HttpStatusCode.NotFound, "Library Card not found!");
                }
            }
            catch (Exception e)
            {
                return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message);
            }
        }
​
        [HttpDelete, Route("librarycard/delete/{id}")]
        public HttpResponseMessage DeleteLibraryCard(String Id)
        {
            try
            {
                var librarycard = from d in db.MstLibraryCard
                             where d.Id == Convert.ToInt32(Id)
                             select d;
​
                if (librarycard.Any())
                {
                    db.MstLibraryCard.DeleteOnSubmit(librarycard.FirstOrDefault());
                    db.SubmitChanges();
​
                    return Request.CreateResponse(HttpStatusCode.OK);
                }
                else
                {
                    return Request.CreateResponse(HttpStatusCode.NotFound, "Library Card not found!");
                }
            }
            catch (Exception e)
            {
                return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message);
            }
       }
}

View in Full Screen

View IL Code