public IHttpActionResult PutPM_DB(int id, PM_DB pM_DB)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != pM_DB.PM_PK)
{
return(BadRequest());
}
db.Entry(pM_DB).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PM_DBExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <ActionResult> Create([Bind(Include = "PM_PK,ThingName,Time,Dust,AQI,Temp,Hum,Lat,Lon,DateTime")] PM_DB pM_DB)
{
if (ModelState.IsValid)
{
pM_DB.DateTime = DateTime.Now;
pM_DB.Time = DateTime.Now.ToString();
try
{
db.PM_DB.Add(pM_DB);
await db.SaveChangesAsync();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
return(RedirectToAction("Index"));
}
return(View(pM_DB));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
PM_DB pM_DB = await db.PM_DB.FindAsync(id);
db.PM_DB.Remove(pM_DB);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "PM_PK,ThingName,Time,Dust,AQI,Temp,Hum,Lat,Lon")] PM_DB pM_DB)
{
if (ModelState.IsValid)
{
db.Entry(pM_DB).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(pM_DB));
}
public IHttpActionResult GetPM_DB(int id)
{
PM_DB pM_DB = db.PM_DB.Find(id);
if (pM_DB == null)
{
return(NotFound());
}
return(Ok(pM_DB));
}
public IHttpActionResult PostPM_DB(PM_DB pM_DB)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
pM_DB.DateTime = DateTime.Now;
db.PM_DB.Add(pM_DB);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = pM_DB.PM_PK }, HttpStatusCode.OK));
}
// GET: PM_DB/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PM_DB pM_DB = await db.PM_DB.FindAsync(id);
if (pM_DB == null)
{
return(HttpNotFound());
}
return(View(pM_DB));
}
public async Task <ActionResult> GetPeriodData(string time)
{
if (time == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PM_DB pM_DB = await db.PM_DB.FindAsync(time);
if (pM_DB == null)
{
return(HttpNotFound());
}
return(View(pM_DB));
}
public IHttpActionResult DeletePM_DB(int id)
{
PM_DB pM_DB = db.PM_DB.Find(id);
if (pM_DB == null)
{
return(NotFound());
}
db.PM_DB.Remove(pM_DB);
db.SaveChanges();
return(Ok(pM_DB));
}
