コード例 #1
0
        // Add new route to the saved route in the DB.
        private void addToSavedRoute(smart_trip_dbEntities se, List <sites> newRoute, int cityId)
        {
            var route = new routes();

            route.name        = "Route number " + (se.routes.Count() + 1).ToString();
            route.city_id     = cityId;
            route.user_id     = ADMIN_ID;
            route.sites       = getSitesString(newRoute);
            route.image_url   = NEW_YORK_IMAGE_URL;
            route.rate        = DEFAULT_RATE;
            route.description = DEFAULT_DESCRIPTION;
            se.routes.Add(route);
            se.SaveChanges();
        }
コード例 #2
0
        public HttpResponseMessage login(UserConnection user)
        {
            using (smart_trip_dbEntities se = new smart_trip_dbEntities())
            {
                var user_ = getUserIfExists(se, user.userName, user.password, user.deviceToken);
                if (user_ == null)
                {
                    user_              = new users();
                    user_.uname        = user.userName;
                    user_.password     = user.password;
                    user_.device_token = user.deviceToken;
                    se.users.Add(user_);
                    se.SaveChanges();
                }

                var cities            = se.cities.ToList();
                var sites             = se.sites.Where(s => s.city_id == 1).ToList();
                var categories        = se.sites_types.ToList();
                var recommandedRoutes = se.routes.Where(s => s.rate != null && s.rate >= 4).ToList();

                return(rh.HandleResponse(new { user = user_, sites = sites, cities = cities, categories = categories, recommanded_routes = recommandedRoutes }));
            }
        }