示例#1
0
        public static bool HuntIsValid(string id)
        {
            Int32 hId;
            var   context = new RabbitDBContext();
            var   cn      = new SqliteConnection(((DbContext)context).Database.GetDbConnection().ConnectionString);

            try
            {
                if (!Int32.TryParse(id, out hId))
                {
                    return(false);
                }

                cn.Open();

                var    cmd    = new SqliteCommand("select count(*) from Contests where ID = " + hId.ToString() + " and Closed = 0", cn);
                string result = cmd.ExecuteScalar().ToString();

                Int32 count;
                if (Int32.TryParse(result, out count) && count > 0)
                {
                    return(true);
                }

                return(false);
            }
            finally
            {
                if (cn.State != System.Data.ConnectionState.Closed)
                {
                    cn.Close();
                }
            }
        }
示例#2
0
 public ActionResult Index()
 {
     using (var context = new RabbitDBContext())
     {
         return(View(context.Hunts.OrderByDescending(c => c.Id).ToList()));
     }
 }
示例#3
0
 // DELETE api/hunt/5
 public void Delete(string id)
 {
     using (var context = new RabbitDBContext())
     {
         string q = string.Format("DELETE FROM Hunt WHERE Id = {0}", id);
         context.Database.ExecuteSqlCommand(q);
     }
 }
示例#4
0
        public IEnumerable <Hunt> Get()
        {
            var hunts = new List <Hunt>();

            using (var context = new RabbitDBContext())
            {
                var q = from c in context.Hunts
                        select c;
                hunts = q.ToList();
            }

            return(hunts);
        }
示例#5
0
        public Hunt Get(int id)
        {
            Hunt hunt = null;

            using (var context = new RabbitDBContext())
            {
                var q = from c in context.Hunts
                        where c.Id == id
                        select c;
                hunt = q.FirstOrDefault();
            }

            return(hunt);
        }
示例#6
0
        void Application_Start(object sender, EventArgs e)
        {
            // Code that runs on application startup
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            var context = new RabbitDBContext();

            if (!context.AllMigrationsApplied())
            {
                context.Database.Migrate();
            }
            context.EnsureSeedData();
        }
示例#7
0
        public static void Main(string[] args)
        {
            var context = new RabbitDBContext();

            if (!context.AllMigrationsApplied())
            {
                context.Database.Migrate();
            }
            context.EnsureSeedData();

            var test = context.Hunts.Include(h => h.Animals).FirstOrDefault();

            Console.WriteLine(test.PhoneNumber);
            Console.WriteLine(test.Animals.Count());
        }
示例#8
0
        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, RabbitDBContext serverContext)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
                app.UseDatabaseErrorPage();
            }
            else
            {
                app.UseExceptionHandler("/Home/Error");
            }

            app.UseStaticFiles();

            if (!serverContext.AllMigrationsApplied())
            {
                serverContext.Database.Migrate();
            }
            serverContext.EnsureSeedData();

            app.UseAuthentication();

            /* TODO
             * // Add external authentication middleware below. To configure them please see https://go.microsoft.com/fwlink/?LinkID=532715
             * app.UseJwtBearerAuthentication(new JwtBearerOptions
             * {
             *  AutomaticAuthenticate = true,
             *  AutomaticChallenge = true,
             *  TokenValidationParameters = new TokenValidationParameters
             *  {
             *      ValidateIssuer = true,
             *      ValidIssuer = "https://issuer.example.com",
             *
             *      ValidateAudience = true,
             *      ValidAudience = "https://yourapplication.example.com",
             *
             *      ValidateLifetime = true,
             *  }
             * });
             */

            app.UseMvc(routes =>
            {
                routes.MapRoute(
                    name: "default",
                    template: "{controller=Home}/{action=Index}/{id?}");
            });
        }
 public BaseAPIController(RabbitDBContext db, IMapper mapper)
 {
     this.db     = db;
     this.mapper = mapper;
 }