/// <summary>
        /// Edit Api
        /// </summary>
        /// <param name="id"></param>
        /// <param name="trainingdetails"></param>
        /// <returns></returns>

        public HttpResponseMessage Put(int id, [FromBody] TrainingDetail trainingdetails)
        {
            try
            {
                using (AdventureWorks2014Entities2 entities = new AdventureWorks2014Entities2())
                {
                    var entity = entities.TrainingDetails.FirstOrDefault(e => e.id == id);
                    if (entity == null)
                    {
                        return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id = " + id.ToString() + "NotFound to update"));
                    }
                    else
                    {
                        entity.Name      = trainingdetails.Name;
                        entity.StartDate = trainingdetails.StartDate;
                        entity.EndDate   = trainingdetails.EndDate;
                        entities.SaveChanges();
                        return(Request.CreateResponse(HttpStatusCode.OK, entity));
                    }
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
            }
        }
        /// <summary>
        /// Get Api for all records
        /// </summary>
        /// <returns></returns>
        public IEnumerable <DataAccess.TrainingDetail> Get()
        {
            List <TrainingDetail> obj = null;

            using (AdventureWorks2014Entities2 entities = new AdventureWorks2014Entities2())
            {
                if (entities != null)
                {
                    obj = entities.TrainingDetails.ToList();
                }
                return(obj);
            }
        }
 /// <summary>
 /// Get Api by Id
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public HttpResponseMessage Get(int id)
 {
     using (AdventureWorks2014Entities2 entities = new AdventureWorks2014Entities2())
     {
         var entity = entities.TrainingDetails.FirstOrDefault(e => e.id == id);
         if (entity != null)
         {
             return(Request.CreateResponse(HttpStatusCode.OK, entity));
         }
         else
         {
             return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id = " + id.ToString() + "NotFound"));
         }
     }
 }
        /// <summary>
        /// Post Api
        /// </summary>
        /// <param name="trainingdetails"></param>
        /// <returns></returns>

        public HttpResponseMessage Post([FromBody] TrainingDetail trainingdetails)
        {
            try
            {
                HttpResponseMessage message = null;
                using (AdventureWorks2014Entities2 entities = new AdventureWorks2014Entities2())
                {
                    if (entities != null)
                    {
                        entities.TrainingDetails.Add(trainingdetails);
                        entities.SaveChanges();
                        message = Request.CreateResponse(HttpStatusCode.Created, trainingdetails);
                        message.Headers.Location = new Uri(Request.RequestUri + @"\" + trainingdetails.id.ToString());
                    }

                    return(message);
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadGateway, ex));
            }
        }