// 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(); } } } }