// POST api/Inquiry public HttpResponseMessage PostInquiry(Inquiry inquiry) { if (ModelState.IsValid) { //db.Inquiries.Add(inquiry); // db.SaveChanges(); Way_collection way_collection = db.Add_inquiry(inquiry); // HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, inquiry); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, way_collection); // response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = inquiry.ID_inquiry })); return response; } else { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } }
// PUT api/Inquiry/5 public HttpResponseMessage PutInquiry(int id, Inquiry inquiry) { if (!ModelState.IsValid) { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } if (id != inquiry.ID_inquiry) { return Request.CreateResponse(HttpStatusCode.BadRequest); } db.Entry(inquiry).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex); } return Request.CreateResponse(HttpStatusCode.OK); }
public Way_collection Add_inquiry(Inquiry inquiry) { String[] ID_transport = inquiry.ID_transport.Split('.'); ; Way_collection obj = new Way_collection(); // DateTime DataTime_with = DateTime.Parse(inquiry.Data + "" + inquiry.Time_with); // DateTime DataTime_before = DateTime.Parse(inquiry.Data + "" + inquiry.Time_with); using (var connection1 = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSQL"].ToString())) { connection1.Open(); foreach (string element in ID_transport) { if (element.Length != 0) { using (var command1 = new SqlCommand(String.Format(@"SELECT * FROM WAY WHERE Start = '" + inquiry.Start + "' AND Finish = '" + inquiry.Finish + "' AND (Data_Time >= '" + (inquiry.Data + " " + inquiry.Time_with) + "' AND Data_Time <='" + (inquiry.Data + " " + inquiry.Time_before) + "') AND Transport_id = '" + Convert.ToInt32(element) + "'"))) { command1.Connection = connection1; using (var reader = command1.ExecuteReader()) { while (reader.Read()) { obj.Way_col.Add(new Way(Convert.ToInt32(reader["ID_WAY"].ToString()), (reader["Start"].ToString()), (reader["Finish"].ToString()), (reader["Data_Time"].ToString()), Convert.ToInt32(reader["Count_Free"].ToString()), (reader["Infa"].ToString()), Convert.ToInt32(reader["Transport_id"].ToString()), Convert.ToInt32(reader["ID_main_USER"].ToString()))); } } } } } } return obj; }