public ActionResult Index() { ViewBag.Title = "Home Page"; using (var ctx = new Database.DBContainer()) { } return View(); }
public ActionResult Index(int id) { using (var db = new Database.DBContainer()) { var photo = db.Photos.Find(id); return File(photo.Data, "image/jpg"); } }
public static Database.DBContainer GetContext() { var ctx = new Database.DBContainer(); ctx.Configuration.LazyLoadingEnabled = false; return ctx; }
static void Main(string[] args) { using (var context = new Database.DBContainer()) { //context.Users.Add(new Database.User { FirstName = "John", LastName = "Smith", Facebook_Id = "bigboy" }); //context.SaveChanges(); //var usr = context.Users.FirstOrDefault(q => q.Id == 2); //var hunt1 = context.Hunts.FirstOrDefault(q => q.Id == 1); //hunt1.Members.Add(new Database.Membership { User = usr }); //var hunt2 = context.Hunts.FirstOrDefault(q => q.Id == 2); //hunt2.Members.Add(new Database.Membership { User = usr }); //context.SaveChanges(); // //var hunt = new Database.Hunt(); // //hunt.Name = "hunt 2"; // //hunt.Start = DateTime.Now.AddDays(1); // //hunt.Finish = DateTime.Now.AddDays(31); // //hunt.Owner = usr; // //hunt.InviteCode = "GHIJKL"; // //hunt.DateCreated = DateTime.Now; // //context.Hunts.Add(hunt); // //context.SaveChanges(); // context.Waypoints.Add(new Database.Waypoint // { // Hunt = hunt, // Lat = -11.252888, // Long = 146.801508, // Name = "WP1", // Order = 1 // }); // context.Waypoints.Add(new Database.Waypoint // { // Hunt = hunt, // Lat = -11.285702, // Long = 146.788032, // Name = "WP2", // Order = 2 // }); // context.Waypoints.Add(new Database.Waypoint // { // Hunt = hunt, // Lat = -11.312839, // Long = 146.759022, // Name = "WP3", // Order = 3 // }); // context.SaveChanges(); // //var img1 = System.IO.File.ReadAllBytes(@"D:\imgs\20.jpg"); // //var img2 = System.IO.File.ReadAllBytes(@"D:\imgs\21.jpg"); // //var img3 = System.IO.File.ReadAllBytes(@"D:\imgs\22.jpg"); var wp1 = context.Waypoints.FirstOrDefault(q => q.Id == 1); var wp2 = context.Waypoints.FirstOrDefault(q => q.Id == 2); var wp3 = context.Waypoints.FirstOrDefault(q => q.Id == 3); // //wp1.Photos.Add(new Database.Photo { Data = img1 }); wp1.Lat = -19.327667; wp1.Long = 146.756270; wp2.Lat = -19.327736; wp2.Long = 146.756954; wp3.Lat = -19.328262; wp3.Long = 146.757137; // // wp3.Photos.Add(new Database.Photo { Data = img3 }); // wp1.Clues.Add(new Database.Clue { Description = "Yo mama" }); // wp2.Clues.Add(new Database.Clue { Description = "so butch," }); // wp3.Clues.Add(new Database.Clue { Description = "she threw the shot-put in high-school." }); context.SaveChanges(); } }