示例#1
0
 public RoomController()
 {
     _roomDao         = new RoomDao();
     _environmentDao  = new EnvironmentDao();
     _roomCategoryDao = new RoomCategoryDao();
     _environments    = _environmentDao.GetAll().ToList();
 }
示例#2
0
        public ActionResult Edit(int id)
        {
            RoomDao roomDao = new RoomDao();
            Room    room    = roomDao.GetById(id);

            return(View(room));
        }
示例#3
0
        public ActionResult Add(Room room)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    RoomDao rDao = new RoomDao();

                    if (rDao.RoomExist(room.Name) == false)
                    {
                        rDao.Create(room);
                    }
                    else
                    {
                        TempData["warning"] = "Stroj pod tímto názvem již existuje!";
                        return(View("Create", room));
                    }

                    TempData["succes"] = "Místnost úspěšně přidána.";
                }
                else
                {
                    return(View("Create", room));
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
            return(RedirectToAction("Index"));
        }
示例#4
0
        //pridat upozorneni pro vypsane teminy
        public ActionResult Delete(int id)
        {
            try
            {
                RoomDao rDao = new RoomDao();
                Room    r    = rDao.GetById(id);

                //je zapotřebí smazat nejdrive vsechny terminy v teto mistnosti, a take rezervace na tyto terminy
                TermDao        tDao   = new TermDao();
                ReservationDao resDao = new ReservationDao();
                IList <Term>   terms  = tDao.GetTermsByRoom(r);
                foreach (Term t in terms)
                {
                    IList <Reservation> reservations = resDao.GetAllReservationsByTerm(t);
                    foreach (Reservation res in reservations)
                    {
                        resDao.Delete(res);
                    }
                    tDao.Delete(t);
                }

                rDao.Delete(r);
                TempData["succes"] = "Místnost " + r.Name +
                                     " byla odstraněna, stejně tak i všechny termíny v této místnosti.";
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
            return(RedirectToAction("Index"));
        }
示例#5
0
        public ActionResult Update(Room room)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    RoomDao rDao = new RoomDao();
                    Room.CapacityCheck(room);

                    rDao.Update(room);

                    TempData["succes"] = "Místnost úspěšně upravena.";
                }
                else
                {
                    return(View("Edit", room));
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
            return(RedirectToAction("Index"));
        }
示例#6
0
        public async Task <IHttpActionResult> Put(int id, [FromBody] RoomType update)
        {
            if (update.pretPeNoapte == 0)
            {
                return(BadRequest("The price cannot be 0"));
            }
            if (update.tipCamera == "")
            {
                return(BadRequest("The room type cannot be blank"));
            }
            if (update.camereDisponibile == 0)
            {
                return(BadRequest("The room's number cannot be 0"));
            }

            var code = await RoomDao.updateRoomTypeAsync(id, update);

            if (code == 1)
            {
                return(Ok("Room type updated"));
            }
            else if (code == 0)
            {
                return(NotFound());
            }
            else
            {
                return(Content(HttpStatusCode.InternalServerError, "Error occured"));
            }
        }
示例#7
0
        public ActionResult Delete(int id)
        {
            try
            {
                RoomDao roomDao = new RoomDao();
                Room    room    = roomDao.GetById(id);

                // TomSko: ještě předtím, než vyčistím jméno, je potřeba, abych smazal starý soubor
                if (room.IllustrationImageName != null)
                {
                    System.IO.File.Delete(Server.MapPath("~/uploads/roomImage/" + room.IllustrationImageName));
                }

                // TomSko: ještě předtím, než vyčistím jméno, je potřeba, abych smazal starý soubor
                if (room.IllustrationThumbImageName != null)
                {
                    System.IO.File.Delete(Server.MapPath("~/uploads/roomThumbImage/" + room.IllustrationThumbImageName));
                }

                roomDao.Delete(room);

                TempData["message-success"] = "Místnost " + room.Name + " byla úspěšně smazána.";
            }
            catch (Exception)
            {
                // mechanismus zachytávání výjimek doporučuje dobře si nastudovat
                throw;
            }

            return(RedirectToAction("Index"));
        }
示例#8
0
        public ActionResult Create(Room room)
        {
            if (ModelState.IsValid)
            {
                var dao = new RoomDao();

                //lấy id trong session đăng nhập của quản trị lưu vào phiên tạo mới user
                var session = (UserLogin)Session[CommonConstants.USER_SESSION];
                room.CreatedBy   = session.UserName;
                room.CreatedDate = DateTime.Now;

                long id = dao.Insert(room);
                if (id > 0)
                {
                    SetAlert("Thêm chấm công nhân viên thành công", "success");
                    return(RedirectToAction("Index", "Room"));
                }
                else
                {
                    ModelState.AddModelError("", "Thêm chấm nhân viên công không thành công");
                }
            }
            SetViewDepartment();
            SetAlert("Error", "error");
            return(RedirectToAction("Index", "Room"));
        }
示例#9
0
        public async Task <IHttpActionResult> Post([FromBody] RoomType room)
        {
            try
            {
                if (room.pretPeNoapte == 0)
                {
                    return(BadRequest("The price cannot be 0"));
                }
                if (room.tipCamera == "")
                {
                    return(BadRequest("The room type cannot be blank"));
                }
                if (room.camereDisponibile == 0)
                {
                    return(BadRequest("The room's number cannot be 0"));
                }

                if (await RoomDao.addRoomTypeAsync(room) == 1)
                {
                    return(Content(HttpStatusCode.Created, "Room type created"));
                }
                else
                {
                    return(Content(HttpStatusCode.InternalServerError, "Error occured"));
                }
            }
            catch (NullReferenceException e)
            {
                return(Content(HttpStatusCode.BadRequest, e));
            }
        }
示例#10
0
        public ActionResult Edit(int id)
        {
            var room = new RoomDao().ViewDetail(id);

            SetViewDepartment();
            return(View(room));
        }
        public async Task <IActionResult> DeleteRoom(int id)
        {
            var data  = new RoomDao().Delete(id);
            var value = await new RoomDao().GeList();

            return(RedirectToAction("Rooms", value));
        }
示例#12
0
        /// <summary>
        /// Load game data
        /// </summary>
        private static void tryGameData()
        {
            ValueManager.Instance.Load();
            ItemManager.Instance.Load();
            CatalogueManager.Instance.Load();
            RoomManager.Instance.Load();
            NavigatorManager.Instance.Load();
            MessageHandler.Instance.Load();

            /*int defId = 2300;
             * foreach (int fx in "1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,25,26,27,28,29,3,4,5,6,7,8,9,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140".ToIntArray(','))
             * {
             *  if (fx > 26)
             *  {
             *      if (fx != 28 && fx != 29 && fx != 30 && fx != 33 && fx != 34 && fx != 35 && fx != 36 && fx != 37 && fx != 38 && fx != 39 && fx != 40 && fx != 41 && fx != 42 && fx != 43
             *          && fx != 45 && fx != 46 && fx != 49 && fx != 50 && fx != 51 && fx != 52 && fx != 55 && fx != 56 && fx != 57 && fx != 58 && fx != 68 && fx != 77 && fx != 65 && fx != 96 && fx != 97 && fx != 98
             *           && fx != 101 && fx != 102 && fx != 103 && fx != 95) {
             *          defId++;
             *          Console.WriteLine($"INSERT INTO `catalogue_items` (`sale_code`, `page_id`, `order_id`, `price_coins`, `price_pixels`, `hidden`, `amount`, `definition_id`, `item_specialspriteid`, `is_package`) VALUES ('avatar_effect{fx}', '60', 1, 0, 89, 0, 1, {defId}, '{fx}', 0);");
             *          Console.WriteLine($"INSERT INTO `item_definitions` (`id`, `sprite`, `name`, `description`, `sprite_id`, `length`, `width`, `top_height`, `max_status`, `behaviour`, `interactor`, `is_tradable`, `is_recyclable`, `drink_ids`, `rental_time`) VALUES ({defId}, 'avatar_effect{fx}', NULL, NULL, {fx}, 0, 0, 0, '0', 'effect,requires_rights_for_interaction', 'default', 1, 1, '', -1);");
             *      }
             *  }
             * }*/

            RoomDao.ResetVisitorCounts();
        }
示例#13
0
        public ActionResult Edit(int id)
        {
            RoomDao rDao = new RoomDao();

            ViewBag.Mark = "Room";

            return(View(rDao.GetById(id)));
        }
示例#14
0
        public void Handle(Player player, Request request)
        {
            var roomList = RoomManager.SortRooms(
                RoomManager.Instance.ReplaceQueryRooms(RoomDao.GetUserRooms(player.Details.Id))
                );

            player.Send(new FlatListComposer(2, roomList, null));
        }
 public EquipmentController()
 {
     _roomDao              = new RoomDao();
     _environmentDao       = new EnvironmentDao();
     _equipmentDao         = new EquipmentDao();
     _equipmentCategoryDao = new EquipmentCategoryDao();
     _equipmentStatusDao   = new EquipmentStatusDao();
 }
        public void Handle(Player player, Request request)
        {
            var roomList = RoomManager.Instance.ReplaceQueryRooms(
                RoomDao.GetPopularFlats()
                );

            player.Send(new FlatListComposer(2, roomList, NavigatorManager.Instance.GetPopularPromotion()));
        }
示例#17
0
 public ActionResult Create(Phong model)
 {
     if (ModelState.IsValid)
     {
         var dao = new RoomDao();
     }
     return(View(model));
 }
        public void Handle(Player player, Request request)
        {
            var roomList = RoomManager.SortRooms(
                RoomManager.Instance.ReplaceQueryRooms(RoomDao.SearchTags(request.ReadString()))
                );

            player.Send(new FlatListComposer(2, roomList, null));
        }
        internal static RoomDao getRoom()
        {
            if (roomDao == null)
            {
                roomDao = new RoomDao(ConnectionProvider.getProvide());
            }

            return(roomDao);
        }
示例#20
0
        // GET: Admin/Room
        public ActionResult Index()
        {
            RoomDao      rDao = new RoomDao();
            IList <Room> r    = rDao.GetAll();

            ViewBag.Mark = "Room";

            return(View(r));
        }
示例#21
0
        public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
        {
            var session = (UserLogin)Session[CommonConstants.USER_SESSION];
            var dao     = new RoomDao();
            var model   = dao.ListAllPaging(searchString, page, pageSize, session.DepartmentID);

            ViewBag.SearchString = searchString;

            return(View(model));
        }
示例#22
0
 public bool Update(Room Room)
 {
     if (string.IsNullOrEmpty(Room.ID))
     {
         throw new Exception("没有房间ID");
     }
     ISqlMapper mapper = MapperHelper.GetMapper();
     RoomDao dao = new RoomDao(mapper);
     return dao.Update(new RoomUpdateForm { Entity = Room, RoomQueryForm = new RoomQueryForm { ID = Room.ID } });
 }
示例#23
0
 public bool Delete(string id)
 {
     if (string.IsNullOrEmpty(id))
     {
         throw new Exception("没有房间ID");
     }
     ISqlMapper mapper = MapperHelper.GetMapper();
     RoomDao dao = new RoomDao(mapper);
     return dao.Delete(new RoomQueryForm { ID = id });
 }
示例#24
0
 public ControlController()
 {
     _userDao            = new UserDao();
     _roomDao            = new RoomDao();
     _environmentDao     = new EnvironmentDao();
     _controlDao         = new ControlDao();
     _controlStatusDao   = new ControlStatusDao();
     _controlCategoryDao = new ControlCategoryDao();
     _equipmentDao       = new EquipmentDao();
 }
示例#25
0
 public TicketController()
 {
     _ticketDao         = new TicketDao();
     _ticketCategoryDao = new TicketCategoryDao();
     _ticketStatusDao   = new TicketStatusDao();
     _userDao           = new UserDao();
     _environmentDao    = new EnvironmentDao();
     _equipmentDao      = new EquipmentDao();
     _roomDao           = new RoomDao();
 }
示例#26
0
        public void Handle(Player player, Request request)
        {
            int maxRoomsAllowed = ValueManager.Instance.GetInt("max.rooms.allowed");

            if (player.IsSubscribed)
                maxRoomsAllowed = ValueManager.Instance.GetInt("max.rooms.allowed.subscribed");

            player.Send(new CanCreateRoomComposer(
                maxRoomsAllowed >= RoomDao.CountUserRooms(player.Details.Id),
                maxRoomsAllowed)
            );
        }
示例#27
0
        public async Task <IHttpActionResult> Get(int id)
        {
            var found = await RoomDao.findRoomTypeByIdAsync(id);

            if (found == null)
            {
                return(NotFound());
            }
            else
            {
                return(Ok(found));
            }
        }
示例#28
0
        // GET: /Rooms/
        public ActionResult Index(int?page)
        {
            const int itemsOnPage = 6;
            int       pg          = page.HasValue ? page.Value : 1;
            int       totalRooms;

            RoomDao      roomDao          = new RoomDao();
            IList <Room> listRoomsPerPage = roomDao.GetRoomsPaged(itemsOnPage, pg, out totalRooms);

            ViewBag.Pages       = (int)Math.Ceiling((double)totalRooms / (double)itemsOnPage);
            ViewBag.CurrentPage = pg;

            return(View("Index", listRoomsPerPage));
        }
        public void Handle(Player player, Request request)
        {
            var room = player.RoomUser.Room;

            if (room == null)
            {
                return;
            }


            room.Data.IsMuted = !room.Data.IsMuted;

            player.Send(new RoomMuteSettingsComposer(room.Data.IsMuted));
            RoomDao.SaveRoom(room.Data);
        }
示例#30
0
        /// <summary>
        /// Get room instance, else return newly created instance if room exists
        /// </summary>
        public Room GetRoom(int roomId)
        {
            if (Rooms.TryGetValue(roomId, out var room))
            {
                return(room);
            }

            var data = RoomDao.GetRoomData(roomId);

            if (data != null)
            {
                return(new Room(data));
            }

            return(null);
        }
示例#31
0
        private void FrmRoomManager_Load(object sender, EventArgs e)
        {
            romsty = RoomDao.SelectRoomAll();
            for (int i = 0; i < romsty.Count; i++)
            {
                romt              = new ucRoomList(this);
                romt.Tag          = romsty[i].RoomNo;
                romt.romCustoInfo = romsty[i];
                flpRoom.Controls.Add(romt);
            }

            lblCanUse.Text   = RoomService.SelectCanUseRoomAllByRoomState().ToString();
            lblCheck.Text    = RoomService.SelectNotUseRoomAllByRoomState().ToString();
            lblNotClear.Text = RoomService.SelectNotClearRoomAllByRoomState().ToString();
            lblFix.Text      = RoomService.SelectFixingRoomAllByRoomState().ToString();
        }
示例#32
0
        public ActionResult SelectKTV(int page = 1, int pageSize = 10)
        {
            var dao     = new EmployeeDao();
            var session = (UserLogin)Session[CommonConstants.USER_SESSION];

            string searchString = null;

            var model = dao.ListAllPagingKTVStatus(searchString, page, pageSize, session.DepartmentID, "KTV");

            List <TimerModel> list = new List <TimerModel>();

            WebAppDbContext db = new WebAppDbContext();

            var daoRoom   = new RoomDao();
            var modelRoom = daoRoom.ListAllPaging(searchString, page, pageSize, session.DepartmentID);

            var rooms = modelRoom;

            foreach (var item in rooms)
            {
                DateTime now = DateTime.Now;

                foreach (var temp in item.OrderDetails.Where(x => x.DailyList.Status == true).OrderByDescending(x => x.ID).Take(1))
                {
                    if (temp.DailyEmployees.Sum(x => x.Tip) < 1)
                    {
                        foreach (var ktv in temp.DailyEmployees)
                        {
                            list.Add(new TimerModel
                            {
                                Name            = ktv.Employee.Code,
                                ReleaseDateTime = temp.TimeOut.Subtract(new DateTime(1970, 1, 1).AddHours(7)).TotalMilliseconds,
                                Message         = string.Concat(item.Name, " hết giờ")
                            });
                        }
                    }
                }
            }

            ViewBag.UserGroup = session.GroupID;
            ViewBag.TimerList = list;

            ViewBag.SearchString = searchString;

            return(View(model));
        }
示例#33
0
 public string Add(Room Room)
 {
     ISqlMapper mapper = MapperHelper.GetMapper();
     RoomDao dao = new RoomDao(mapper);
     return dao.Add(Room);
 }
示例#34
0
 public List<Room> Query(RoomQueryForm form)
 {
     ISqlMapper mapper = MapperHelper.GetMapper();
     RoomDao dao = new RoomDao(mapper);
     return dao.Query(form);
 }