public ActionResult DeleteTmp(int id) { try { tbl_TmpBookingInfo tbl_TmpBookingInfo = db.tbl_TmpBookingInfo.Find(id); db.tbl_TmpBookingInfo.Remove(tbl_TmpBookingInfo); db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { return(null); } }
public string GetNewBookRoomResponse([FromUri] int roomid, string roomtype, string frmdt, string todt, string custname, string totalamt, string trantype) { //using (var ctx = new hoteldbEntities()) //{ //ctx.tbl_TmpBookingInfo.Add(new tbl_TmpBookingInfo() //{ // room_id = Bookmyroom.room_id, // room_type = Bookmyroom.room_type, // from_dt = Convert.ToDateTime(Bookmyroom.from_dt), // to_dt = Convert.ToDateTime(Bookmyroom.to_dt), // cust_name = Bookmyroom.cust_name, // total_amt = Bookmyroom.total_amt, // transactn_type = Bookmyroom.transactn_type //}); //ctx.SaveChanges(); hoteldbEntities _db = new hoteldbEntities(); tbl_TmpBookingInfo objTbl = new tbl_TmpBookingInfo(); objTbl.room_id = roomid; objTbl.room_type = roomtype; objTbl.from_dt = Convert.ToDateTime(frmdt); objTbl.to_dt = Convert.ToDateTime(todt); objTbl.cust_name = custname; objTbl.total_amt = Convert.ToDouble(totalamt); objTbl.transactn_type = trantype; _db.tbl_TmpBookingInfo.Add(objTbl); _db.SaveChanges(); //} // return Ok(); return("yes"); }
public ActionResult Create([Bind(Include = "room_id,room_name,room_type,room_price")] tbl_RoomInfo tbl_RoomInfo) { try { if (ModelState.IsValid) { db.tbl_RoomInfo.Add(tbl_RoomInfo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_RoomInfo)); } catch (Exception ex) { return(null); } }