public List <string> All() { using (var db = new KittenAppContext()) { var all = db .Kittens .Select(k => new KittenViewModel { Name = k.Name, Age = k.Age, Breed = k.Breed.Name, }); var kittens = all .Select(vm => $@"<div class=""col-4""> <img class=""img-thumbnail"" src=""{BreedHelper.GetImgSource(vm.Breed)}"" alt=""{vm.Name}'s photo"" /> <div> <h5>Name: {vm.Name}</h5> <h5>Age: {vm.Age}</h5> <h5>Breed: {vm.Breed}</h5> </div> </div>") .ToList(); return(kittens); } }
public bool Add(string name, int age, string breed) { using (var db = new KittenAppContext()) { var validBreed = db .Breeds .FirstOrDefault(b => b.Name == breed); if (validBreed == null) { return(false); } var kitten = new Kitten { Name = name, Age = age, Breed = validBreed }; db.Kittens.Add(kitten); db.SaveChanges(); return(true); } }
public KittensController() { this.kittens = new KittensService(); using (var db = new KittenAppContext()) { if (!db.Breeds.Any()) { db.Breeds.Add(new Breed { Name = "Street Transcended" }); db.Breeds.Add(new Breed { Name = "American Shorthair" }); db.Breeds.Add(new Breed { Name = "Munchkin" }); db.Breeds.Add(new Breed { Name = "Siamese" }); db.SaveChanges(); } } }
public static void Main() { var context = new KittenAppContext(); var server = new WebServer( 42420, new ControllerRouter(), new ResourceRouter()); MvcEngine.Run(server, new KittenAppContext()); }
public User Find(string username, string password) { using (var db = new KittenAppContext()) { var user = db .Users .AsQueryable() .FirstOrDefault(t => t.Username == username && t.PasswordHash == PasswordUtilities.GetPasswordHash(password)); return(user); } }
public User Create(string username, string email, string password) { using (var db = new KittenAppContext()) { if (string.IsNullOrWhiteSpace(username) || string.IsNullOrWhiteSpace(password) || string.IsNullOrWhiteSpace(email)) { return(null); } User userExists = null; if (db.Users.Any()) { userExists = db .Users .AsQueryable() .FirstOrDefault(u => u.Username == username || u.Email == email); } if (userExists != null) { return(null); } var user = new User { Username = username, Email = email, PasswordHash = PasswordUtilities.GetPasswordHash(password), }; db.Users.Add(user); db.SaveChanges(); return(user); } }
public UsersService() { this.db = new KittenAppContext(); }