public ActionResult DeleteConfirmed(decimal id)
{
TB_ROOM tb_room = db.TB_ROOM.Single(t => t.ROOM_ID == id);
db.TB_ROOM.Remove(tb_room);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Room/Details/5
public ActionResult Details(decimal id = 0)
{
TB_ROOM tb_room = db.TB_ROOM.Single(t => t.ROOM_ID == id);
if (tb_room == null)
{
return(HttpNotFound());
}
return(View(tb_room));
}
//
// GET: /Room/Edit/5
public ActionResult Edit(decimal id = 0)
{
TB_ROOM tb_room = db.TB_ROOM.Single(t => t.ROOM_ID == id);
if (tb_room == null)
{
return(HttpNotFound());
}
ViewBag.ROOM_BUILD = new SelectList(db.TB_M_BUILDING, "BUILDING_ID", "BUILDING_NAME", tb_room.ROOM_BUILD);
ViewBag.ROOM_FOR_LEVEL = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_room.ROOM_FOR_LEVEL);
return(View(tb_room));
}
public ActionResult Create(TB_ROOM tb_room)
{
if (ModelState.IsValid)
{
tb_room.ROOM_FLOOR = 0;
db.TB_ROOM.Add(tb_room);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ROOM_BUILD = new SelectList(db.TB_M_BUILDING, "BUILDING_ID", "BUILDING_NAME", tb_room.ROOM_BUILD);
ViewBag.ROOM_FOR_LEVEL = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_room.ROOM_FOR_LEVEL);
return(View(tb_room));
}
public ActionResult Edit(TB_ROOM tb_room)
{
if (ModelState.IsValid)
{
tb_room.ROOM_FLOOR = 0;
var _update = db.TB_ROOM.FirstOrDefault(f => f.ROOM_ID == tb_room.ROOM_ID);
if (_update != null)
{
//ROOM_ID =ROOM_ID
_update.ROOM_FOR_LEVEL = tb_room.ROOM_FOR_LEVEL;
_update.ROOM_BUILD = tb_room.ROOM_BUILD;
_update.ROOM_FLOOR = tb_room.ROOM_FLOOR;
_update.ROOM_NUMBER = tb_room.ROOM_NUMBER;
_update.ROOM_SEAT_COUNT = tb_room.ROOM_SEAT_COUNT;
_update.ROOM_COMMITTEE_COUNT = tb_room.ROOM_COMMITTEE_COUNT;
_update.ROOM_ROW = tb_room.ROOM_ROW;
_update.ROW_1 = tb_room.ROW_1;
_update.ROW_2 = tb_room.ROW_2;
_update.ROW_3 = tb_room.ROW_3;
_update.ROW_4 = tb_room.ROW_4;
_update.ROW_5 = tb_room.ROW_5;
_update.ROW_6 = tb_room.ROW_6;
_update.ROW_7 = tb_room.ROW_7;
_update.ROW_8 = tb_room.ROW_8;
_update.ROW_9 = tb_room.ROW_9;
_update.ROW_10 = tb_room.ROW_10;
_update.ROW_11 = tb_room.ROW_11;
_update.ROW_12 = tb_room.ROW_12;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ROOM_BUILD = new SelectList(db.TB_M_BUILDING, "BUILDING_ID", "BUILDING_NAME", tb_room.ROOM_BUILD);
ViewBag.ROOM_FOR_LEVEL = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_room.ROOM_FOR_LEVEL);
return(View(tb_room));
}