public static void TakeTime()
        {
            CleaningTimeCollectionList.Clear();
            string query = "SELECT * FROM hotel.cleaning_time;";
            List <Dictionary <string, string> > UR = Database.Select(query, CleaningTime.CleaningTimeKeys);

            if (UR.Count != 0)
            {
                foreach (var item in UR)
                {
                    CleaningTime ur = new CleaningTime(Int32.Parse(item["id"]),
                                                       item["cleaning_time"]);
                    CleaningTimeCollectionList.Add(ur);
                }
            }
        }
        public static int NameToId(string _name)
        {
            CleaningTime tmp = CleaningTimeCollectionList.Find(x => x.Name == _name);

            return(tmp.Id);
        }