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 HttpResponseMessage GetRoomPrice(int roomid) { using (hoteldbEntities dc = new hoteldbEntities()) { var rid = (from r in dc.tbl_RoomInfo where r.room_id == roomid select r.room_price).Single(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, Convert.ToDouble(rid)); return(response); } }
public HttpResponseMessage Get(string roomType, string dtFrom, string dtTo) { string username = Thread.CurrentPrincipal.Identity.Name; DateTime dtf = Convert.ToDateTime(dtFrom); DateTime dtt = Convert.ToDateTime(dtTo); List <tbl_RoomInfo> roomList1 = new List <tbl_RoomInfo>(); List <tbl_RoomInfo> roomList2 = new List <tbl_RoomInfo>(); using (hoteldbEntities dc = new hoteldbEntities()) { var rid = (from r in dc.tbl_RoomInfo join rb in dc.tbl_BookingInfo on r.room_id equals rb.room_id where r.room_type == roomType && (rb.from_dt >= dtf && rb.to_dt <= dtt) && r.room_id == rb.room_id select rb.room_id).Distinct().ToArray(); roomList2 = dc.tbl_RoomInfo.Where(x => x.room_type == roomType).ToList(); roomList1 = roomList2.Where(x => !rid.Contains(x.room_id)).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, roomList1); return(response); } }
public BookRoomController() { _db = new hoteldbEntities(); }