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