public IHttpActionResult Puttblpassenger_table(string id, tblpassenger_table tblpassenger_table)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblpassenger_table.PassengerID)
{
return(BadRequest());
}
db.Entry(tblpassenger_table).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblpassenger_tableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Posttblpassenger_table(tblpassenger_table tblpassenger_table)
{
db.sp_insertpassengers(tblpassenger_table.TicketID, tblpassenger_table.PName, tblpassenger_table.Gender, tblpassenger_table.SeatID, tblpassenger_table.Age);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//db.tblpassenger_table.Add(tblpassenger_table);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblpassenger_table.PassengerID }, tblpassenger_table));
}
public IHttpActionResult Deletetblpassenger_table(string id)
{
tblpassenger_table tblpassenger_table = db.tblpassenger_table.Find(id);
if (tblpassenger_table == null)
{
return(NotFound());
}
db.tblpassenger_table.Remove(tblpassenger_table);
db.SaveChanges();
return(Ok(tblpassenger_table));
}