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

Account of Mr. Walton
-------------------
Current saving balance is $188
Current chequing balance is $288
Current rrsp balance is $288

Select one of the following

1. Withdraw from savings account
2. Deposit to savings account
3. Withdraw from chequing account
4. Deposit to chequing account
5. Withdraw from rrsp account
6. Deposit to rrsp account
7. Print transactions

Cached Result
Last Run:	12:31:44 pm
Compile:	0.126s
Execute:	0s
Memory:	40kb
CPU:	0s

View IL Code