Example #1
0
        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");
        }
Example #2
0
 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);
     }
 }
Example #3
0
        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);
            }
        }
Example #4
0
 public BookRoomController()
 {
     _db = new hoteldbEntities();
 }