Esempio n. 1
0
        public RoomOccupiedStatus GetOccupiedStatusById(int id)
        {
            //MySqlConnection con =
            //       new MySqlConnection(
            //           "Server=roomcheckaurora.cluster-cshbhaowu4cu.eu-west-1.rds.amazonaws.com;Port=3306;database=RoomCheckDB;User Id=s00142227;Password=Lollipop12;charset=utf8");
            RoomOccupiedStatus occStatus = new RoomOccupiedStatus();

            try
            {
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();

                    using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM RoomOccupiedStatusTbl where ID = @id;", con))
                    {
                        cmd.Parameters.AddWithValue("@id", id);
                        using (MySqlDataReader reader = cmd.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                occStatus.Description = (string)reader["Description"];
                                occStatus.IconPath    = (string)reader["IconPath"];
                            }
                        }
                    }
                }
            }
            catch (MySqlException ex)
            {
                //Toast.MakeText(this, ex.ToString(), ToastLength.Long).Show();
            }
            finally
            {
                con.Close();
            }

            return(occStatus);
        }
Esempio n. 2
0
        public override View GetView(int position, View convertView, ViewGroup parent)
        {
            var item = items[position];

            View view = convertView ?? context.LayoutInflater.Inflate(Resource.Layout.MyRooms, null);

            //TODO: see how often this method is getting called and if there are any changes i can make to optimise

            RoomOccupiedStatus roomOccStatus   = item.OccupiedStatus;
            RoomCleanStatus    roomCleanStatus = item.CleanStatus;
            RoomType           roomType        = item.RoomType;

            ImageView imgRoomIcon = view.FindViewById <ImageView>(Resource.Id.imgRoomIcon);

            //populate room number labels
            view.FindViewById <TextView>(Resource.Id.lblRoomNo).Text = item.RoomNo;

            //change icon to reflect occupied status
            var roomOccResourceId = (int)typeof(Resource.Drawable).GetField(roomOccStatus.IconPath).GetValue(null);

            imgRoomIcon.SetImageResource(roomOccResourceId);

            //change border colour to reflect cleaning status
            //var background = (int)typeof(Resource.Drawable).GetField(roomCleanStatus.BorderImage).GetValue(null);
            //view.FindViewById<ImageView>(Resource.Id.imgRoomIcon).SetBackgroundResource(background);

            //change background color to reflect cleaning status
            LinearLayout listItem = view.FindViewById <LinearLayout>(Resource.Id.llMyRoomsListItem);

            listItem.SetBackgroundColor(Android.Graphics.Color.ParseColor(roomCleanStatus.BorderImage));

            //TODO: if room type is empty grey out the icon and border (room occupied status shoud alw-ays be unoccupied on empty rooms
            if (roomType.Description == "Empty")
            {
                roomOccResourceId = (int)typeof(Resource.Drawable).GetField("Unoccupied").GetValue(null);
                imgRoomIcon.SetImageResource(roomOccResourceId);

                view.FindViewById <TextView>(Resource.Id.lblRoomNo).SetTextColor(Android.Graphics.Color.ParseColor("#808080"));
                listItem.SetBackgroundColor(Android.Graphics.Color.ParseColor("#e6e6e6"));
            }

            //If there is a note on the room - show the note icon
            ImageView imgNote = view.FindViewById <ImageView>(Resource.Id.imgNote);


            //guest request overrides note - if there are both, the cleaner will have to
            //view details anyways and will see both
            if (!string.IsNullOrEmpty(item.GuestRequest))
            {
                var resourceId = (int)typeof(Resource.Drawable).GetField("GuestRequest").GetValue(null);
                imgNote.SetImageResource(resourceId);
                imgNote.Visibility = ViewStates.Visible;
            }
            else
            {
                imgNote.Visibility = ViewStates.Invisible;
                if (!string.IsNullOrEmpty(item.Note))
                {
                    var resourceId = (int)typeof(Resource.Drawable).GetField("Info").GetValue(null);
                    imgNote.SetImageResource(resourceId);
                    imgNote.Visibility = ViewStates.Visible;
                }
                else
                {
                    imgNote.Visibility = ViewStates.Invisible;
                }
            }



            //Check if there is currently an event for the room and show icon
            ImageView imgEventNotification = view.FindViewById <ImageView>(Resource.Id.imgEventNotification);

            if (item.Events.Count > 0)
            {
                List <Event> roomEvents = item.Events;
                foreach (Event e in roomEvents)
                {
                    //TODO: remove .TimeOfDay (just there for test purposes)
                    if (DateTime.Now.TimeOfDay >= e.StartTime.TimeOfDay && DateTime.Now.TimeOfDay < e.EndTime.TimeOfDay)
                    {
                        EventType et = e.EventType;
                        //show the notification icon
                        var eventNotifResourceId = (int)typeof(Resource.Drawable).GetField(et.IconPath + "Small").GetValue(null);
                        imgEventNotification.SetImageResource(eventNotifResourceId);
                        imgEventNotification.Visibility = ViewStates.Visible;

                        //Guest is away at an event - we can change their occupied status to unoccupied
                        //TODO: implement properly (actually update database here or else have a sql job to handle this)
                        var roomOccResourceIdAway = (int)typeof(Resource.Drawable).GetField("Unoccupied").GetValue(null);
                        imgRoomIcon.SetImageResource(roomOccResourceIdAway);
                    }
                    else
                    {
                        imgEventNotification.Visibility = ViewStates.Invisible;
                    }
                }
            }


            return(view);
        }
Esempio n. 3
0
        protected override void OnCreate(Bundle savedInstanceState)
        {
            base.OnCreate(savedInstanceState);

            SetContentView(Resource.Layout.RoomDetails);

            // Create your application here
            var toolbar = FindViewById <Toolbar>(Resource.Id.toolbar);

            SetActionBar(toolbar);
            ActionBar.Title = "Room Details";

            roomID = Intent.GetIntExtra("RoomID", 0);

            room = dbr.GetRoomById(roomID);

            //Get all fields on screen
            TextView txtRoomNo        = FindViewById <TextView>(Resource.Id.txtRoomNo);
            TextView txtRoomType      = FindViewById <TextView>(Resource.Id.txtRoomType);
            TextView txtRoomOccStatus = FindViewById <TextView>(Resource.Id.txtRoomOccupiedStatus);
            EditText txtNote          = FindViewById <EditText>(Resource.Id.txtNote);

            txtGuestRequest = FindViewById <EditText>(Resource.Id.txtGuestRequest);
            ImageView imgRoomType      = FindViewById <ImageView>(Resource.Id.imgRoomType);
            ImageView imgRoomOccStatus = FindViewById <ImageView>(Resource.Id.imgRoomOccupiedStatus);
            TextView  txtRoomClean     = FindViewById <TextView>(Resource.Id.txtCleanStatus);



            //populate the spinner
            Spinner sprRoomClean = FindViewById <Spinner>(Resource.Id.sprRoomClean);

            cleanstatuses = dbr.GetAllCleaningStatuses();
            RoomCleanSpinnerAdapter adapter = new RoomCleanSpinnerAdapter(this, cleanstatuses);

            sprRoomClean.Adapter       = adapter;
            sprRoomClean.ItemSelected += SprRoomCleanOnItemSelected;



            //Get statuses
            RoomType           roomType        = dbr.GetRoomTypeById(room.RoomTypeID);
            RoomOccupiedStatus roomOccStatus   = dbr.GetOccupiedStatusById(room.OccupiedStatusID);
            RoomCleanStatus    roomCleanStatus = dbr.GetCleanStatusById(room.CleanStatusID);

            //Populate fields
            txtRoomType.Text      = roomType.Description;
            txtRoomOccStatus.Text = roomOccStatus.Description;
            txtRoomNo.Text        = "Room " + room.RoomNo;
            txtNote.Text          = room.Note;
            txtGuestRequest.Text  = room.GuestRequest;
            txtRoomClean.Text     = roomCleanStatus.Description;


            //Attempts at getting the resource id from the string stored in the database:

            //Attempt 1:
            //int resourceId = Resources.GetIdentifier(
            //   roomType.IconPath, "drawable", GetPackageName());
            //imgRoomType.SetImageResource(resourceId);

            //Attempt 2
            //int resImage = Resources.GetIdentifier(roomType.IconPath, "drawable", PackageName);

            //Attempt 3
            //int id = Resources.GetIdentifier("drawable/" + roomType.IconPath, null, null);

            //Attempt 4
            int roomTypeResourceId = (int)typeof(Resource.Drawable).GetField(roomType.IconPath).GetValue(null);

            imgRoomType.SetImageResource(roomTypeResourceId);

            int roomOccupiedResourceId = (int)typeof(Resource.Drawable).GetField(roomOccStatus.IconPath).GetValue(null);

            imgRoomOccStatus.SetImageResource(roomOccupiedResourceId);

            Button btnSave = FindViewById <Button>(Resource.Id.btnSave);

            btnSave.Click += BtnSaveOnClick;

            ImageButton btnCompleteRequest = FindViewById <ImageButton>(Resource.Id.btnCompleteRequest);

            btnCompleteRequest.Click += BtnCompleteRequestOnClick;

            //TODO: set room clean status spinner to have the rooms status selected rather than just the first value
            //sprCleanStat.SelectedItem = sprCleanStat
            RoomCleanStatus rc = dbr.GetCleanStatusById(room.CleanStatusID);

            sprRoomClean.SetSelection(room.CleanStatusID - 1);

            //TODO: move all this to a separate method with the room id
            //TODO: check if there is an event on the room today and display here with time
            //TODO: move database operations to main rooms page
            LinearLayout llEvent      = FindViewById <LinearLayout>(Resource.Id.llEventLayout);
            TextView     txtEvent     = FindViewById <TextView>(Resource.Id.txtEventType);
            ImageView    imgEventType = FindViewById <ImageView>(Resource.Id.imgEventType);
            TextView     txtEventTime = FindViewById <TextView>(Resource.Id.txtEventTime);

            if (dbr.CheckEvents(room.ID))
            {
                List <Event> events = dbr.EventsForRoom(room.ID);

                //TODO: check which event is happening right now or just use first in the list
                //TODO: maybe change the layout to an expandable list of events instead of just displaying one?
                Event     currentEvent = events[0];
                EventType eventType    = dbr.GetEventTypeByID(currentEvent.EventTypeID);

                //set image, text for event
                int eventTypeResourceId = (int)typeof(Resource.Drawable).GetField(eventType.IconPath).GetValue(null);
                imgEventType.SetImageResource(eventTypeResourceId);
                txtEvent.Text     = currentEvent.Description;
                txtEventTime.Text = string.Format("{0} - {1}", currentEvent.StartTime.TimeOfDay, currentEvent.EndTime.TimeOfDay);


                llEvent.Visibility = ViewStates.Visible;
            }
        }