public async Task <ActionResult> DeleteConfirmed(int id)
{
tb_reserve tb_reserve = await db.tb_reserve.FindAsync(id);
db.tb_reserve.Remove(tb_reserve);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "IDX,cardID,name,roomID,remark")] tb_reserve tb_reserve)
{
if (ModelState.IsValid)
{
db.Entry(tb_reserve).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tb_reserve));
}
public async Task <ActionResult> Create([Bind(Include = "IDX,cardID,name,roomID,remark")] tb_reserve tb_reserve)
{
if (ModelState.IsValid)
{
db.tb_reserve.Add(tb_reserve);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tb_reserve));
}
// GET: tb_reserve/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_reserve tb_reserve = await db.tb_reserve.FindAsync(id);
if (tb_reserve == null)
{
return(HttpNotFound());
}
return(View(tb_reserve));
}
public async Task <ActionResult> DetailsConfirmed(int id)
{
tb_reserve tb_reserve = await db.tb_reserve.FindAsync(id);
db.tb_reserve.Remove(tb_reserve);
await db.SaveChangesAsync();
//tb_room更新预定为false 使用为true
string room_ID = tb_reserve.roomID;
tb_room tb_room = await db.tb_room.Where(room => room.roomID == room_ID).FirstAsync();
tb_room.ispriced = "false";
tb_room.personID = tb_reserve.cardID;
tb_room.isused = "true";
db.Entry(tb_room).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
