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