// PUT api/Way/5
        public HttpResponseMessage PutWay(int id, Way way)
        {
            if (!ModelState.IsValid)
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
            }

            if (id != way.ID_WAY)
            {
                return Request.CreateResponse(HttpStatusCode.BadRequest);
            }

            db.Entry(way).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException ex)
            {
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
            }

            return Request.CreateResponse(HttpStatusCode.OK);
        }
 public Info_about_way()
 {
     Id = 0;
     User_main = new Registration();
     Way_info = new Way();
     Companion = new Collection<Registration>();
     On_me = new Collection<int>();
 }
 // POST api/Way
 public HttpResponseMessage PostWay(Way way)
 {
     if (ModelState.IsValid)
     {
        // db.Ways.Add(way);
         //db.SaveChanges();
         db.AddWay(way);
         HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, way);
         //response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = way.ID_WAY }));
         return response;
     }
     else
     {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
     }
 }
        public void AddWay(Way obj)
        {
            using (var connection1 = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSQL"].ToString()))
               {
               if (obj.ID_WAY == 1)
               {
                   using (var command1 = new SqlCommand(String.Format(@"INSERT  INTO WAY
                                                   (Start, Finish, Data_Time,Count_Free, Infa,Transport_id,ID_main_USER)
                                                    Values(@Start, @Finish, @Data_Time, @Count_Free,@Infa,@Transport_id,@ID_main_USER)
                                                   ")))
                   {
                       command1.Parameters.AddWithValue("@Start", obj.Start);
                       command1.Parameters.AddWithValue("@Finish", obj.Finish);
                       command1.Parameters.AddWithValue("@Data_Time", obj.Data_Time);
                       command1.Parameters.AddWithValue("@Count_Free", obj.Count_Free);
                       command1.Parameters.AddWithValue("@Infa", obj.Infa);
                       command1.Parameters.AddWithValue("@Transport_id", obj.Transport_id);
                       command1.Parameters.AddWithValue("@ID_main_USER", obj.Id_main);

                       command1.Connection = connection1;
                       connection1.Open();
                       command1.ExecuteNonQuery();

                   }
               }
               else
               {
                   String str = obj.Data_Time.ToString();
                   using (var command1 = new SqlCommand(String.Format(@"UPDATE  WAY
                                                    set Start = '" + obj.Start +
                                                    "', Finish = '" + obj.Finish +
                                                    "', Data_Time = '" + str +
                                                    "', Count_Free = '" + obj.Count_Free +
                                                    "', Infa = '" + obj.Infa +
                                                    "', Transport_id = '" + obj.Transport_id +
                                                    "' Where  ID_WAY = " + obj.ID_WAY)))

                   {
                       command1.Connection = connection1;
                       connection1.Open();
                       command1.ExecuteNonQuery();
                   }
               }
               }
        }