public static void Update(Reservations reservations)
        {
            var sql = string.Format("Update Reservations set ClientID = '{0}' , HallID = {1}, Date = '{2} Where ResID = {3}", reservations.ClientId, reservations.HallId, reservations.Date, reservations.ReservationId);

            MyDB.GetInstance().ExecuteSql(sql);
        }