public IHttpActionResult PosttblRoad(tblRoad tblRoad) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblRoads.Add(tblRoad); try { db.SaveChanges(); } catch (DbUpdateException) { if (tblRoadExists(tblRoad.BIA_No)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tblRoad.BIA_No }, tblRoad)); }
public IHttpActionResult PuttblRoad(int id, tblRoad tblRoad) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblRoad.BIA_No) { return(BadRequest()); } db.Entry(tblRoad).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblRoadExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult update(int BIA_No, string Road_Name, string Miles, int Type_Id) { tblRoad table = new tblRoad(); using (var db = new RoadsEntities()) { table = db.tblRoads.First(em => em.BIA_No == BIA_No); } if (table != null) { table.Road_Name = Road_Name; table.Type_Id = Type_Id; table.Miles = Convert.ToDouble(Miles); } using (var dc = new RoadsEntities()) { dc.Entry(table).State = EntityState.Modified; dc.SaveChanges(); } ModelState.Clear(); return(RedirectToAction("Index")); }
public IHttpActionResult GettblRoad(int id) { tblRoad tblRoad = db.tblRoads.Find(id); if (tblRoad == null) { return(NotFound()); } return(Ok(tblRoad)); }
public IHttpActionResult DeletetblRoad(int id) { tblRoad tblRoad = db.tblRoads.Find(id); if (tblRoad == null) { return(NotFound()); } db.tblRoads.Remove(tblRoad); db.SaveChanges(); return(Ok(tblRoad)); }
public ActionResult create(RoadViewModel tbl) { RoadsEntities db = new RoadsEntities(); tblRoad tb = new tblRoad(); tb.BIA_No = Convert.ToInt32(tbl.BIA_No); tb.Road_Name = tbl.Road_Name; tb.Miles = tbl.Miles; tb.Type_Id = tbl.Type_Id; db.tblRoads.Add(tb); db.SaveChanges(); ModelState.Clear(); return(Index()); }