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); }