// GET: Home public ActionResult Index() { PetContext petContext = new PetContext(); List <Pet> pets = petContext.Pets.ToList(); return(View(pets)); }
public PetsRepository(PetContext context) { _context = context; if (_context.Pets.Count() == 0) { _context.Pets.AddRange( new Pet { Name = "Opie", Breed = "Shih Tzu", PetType = PetType.Dog }, new Pet { Name = "Reggie", Breed = "Beagle", PetType = PetType.Dog }, new Pet { Name = "Diesel", Breed = "Bombay", PetType = PetType.Cat }, new Pet { Name = "Lucy", Breed = "Maine Coon", PetType = PetType.Cat }); _context.SaveChanges(); } }
public Usuario LerPorID(int id) { using (PetContext db = new PetContext()) { return(db.Usuario.Find(id)); } }
public List <Usuario> Listar() { using (PetContext pet = new PetContext()) { return(pet.Usuario.ToList()); } }
public ActionResult Pets() { PetContext petContext = new PetContext(); //petContext class List <Pet> pet = petContext.Pets.ToList(); //store db contents into Pet object return(View(pet)); }
public List <Animal> LerAnimaisUsuario(int id) { using (PetContext db = new PetContext()) { return(db.Usuario.Find(id).Animais.ToList()); } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, PetContext petContext) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } app.UseMvc(); petContext.Database.EnsureCreated(); petContext.Dogs.RemoveRange(petContext.Dogs); petContext.SaveChanges(); petContext.Owners.RemoveRange(petContext.Owners); petContext.SaveChanges(); for (int i = 0; i < 10; i++) { petContext.Owners.Add(new Owner { Name = "Name" + i, Age = i }); petContext.SaveChanges(); } for (int i = 0; i < 10; i++) { petContext.Dogs.Add(new Dog { Name = "Name" + i, Breed = "Breed" + i, Owner = petContext.Owners.FirstOrDefault(owner => owner.Name == "Name" + i) }); petContext.SaveChanges(); } }
public PetControllerTests() { var context = new PetContext(); var repo = new PetRepository(context); underTest = new PetController(repo); }
public List <Animal> LerAnimaisUsuariologado(int id) { using (PetContext pet = new PetContext()) { return(pet.Animais.Include("Usuario").Where(c => c.UsuarioID == id).ToList()); } }
public List <Animal> LerTodos() { using (PetContext pet = new PetContext()) { return(pet.Animais.ToList()); } }
public List <Animal> Listar() { using (PetContext pet = new PetContext()) { return(pet.Animais.Include("Usuario").OrderByDescending(animal => animal.ID).Take(5).ToList()); } }
public Animal LerPorID(int id) { using (PetContext db = new PetContext()) { return(db.Animais.Find(id)); } }
/// <summary> /// 添加宠物 /// </summary> /// <param name="info"></param> /// <param name="group"></param> /// <param name="account"></param> /// <param name="sex"></param> /// <param name="nickName"></param> public async Task <UserPet> AddPetAsync(PetInfo info, string group, string account, Gender sex, string nickName) { // 初始化宠物信息 var pet = new UserPet() { Account = account, Age = 1, Attack = info.Attack, Enable = true, Face = info.Face, Healthy = 100, Group = group, Intellect = info.Intellect, Mood = 100, Quality = RandQuality(), Sex = sex, PetId = info.Id, Name = info.Name, NickName = nickName }; // 根据品质增长属性值 IncrementPropByQuality(pet); // 添加信息 PetContext.UserPets.Add(pet); // 保存信息 await PetContext.SaveChangesAsync(); return(pet); }
public ActionResult Find(string name) { //This will not work. Instead of single, use Find. PetContext petContext = new PetContext(); Pet foundPet = petContext.Pets.Single(p => p.Name == name); return(View(foundPet)); }
public IHttpActionResult AddPet(Pet pet) { var db = new PetContext(); db.Petsn.Add(pet); db.SaveChanges(); return(Ok(pet)); }
public ActionResult Directory(int id) //actions can take in arguments { PetContext petContext = new PetContext(); //match up an id with an id in the database Pet pet = petContext.Pets.Single(p => p.Id == id); return(View(pet)); }
// GET: Pets public ActionResult Index(int id) { //return a single row from database PetContext petContext = new PetContext(); //lambda expressions Pet pet = petContext.Pets.Single(itam => itam.Id == id); return(View(pet)); }
public OwnerType(PetContext dogContext) { Field(x => x.Id).Description("Owner Id"); Field(x => x.Name).Description("Owner Name"); Field(x => x.Age).Description("Owner Age"); Field <ListGraphType <DogType> >("dogs", resolve: context => dogContext.Dogs.Where(dog => context.Source.Dogs.Contains(dog))); }
public void RegistrarAnimalResgatado(int id, Status status) { using (PetContext ctx = new PetContext()) { Animal animal = ctx.Animais.FirstOrDefault(c => c.ID == id); animal.Status = status; ctx.SaveChanges(); } }
public DogType(PetContext ownerContext) { Field(x => x.Id).Description("Dog Id"); Field(x => x.Name).Description("Dog Name"); Field(x => x.Breed).Description("Dog Breed"); Field <OwnerType>("owner", resolve: context => context.Source.Owner); }
public CuentaController( PetContext c, UserManager <IdentityUser> um, SignInManager <IdentityUser> sim ) { _context = c; _userManager = um; _signInManager = sim; }
public ShopUnitOfWork() { var optionsBuilder = new DbContextOptionsBuilder <PetContext>(); var options = optionsBuilder .UseLazyLoadingProxies() .UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=petwebappdb;Trusted_Connection=True;") .Options; db = new PetContext(options); }
public Usuario Autenticar(string email, string senha) { if (string.IsNullOrWhiteSpace(email)) { ErrorField error = new ErrorField() { PropertyName = "Email", Error = "Nome de usuário deve ser informado" }; erros.Add(error); } if (string.IsNullOrWhiteSpace(senha)) { ErrorField error = new ErrorField() { PropertyName = "Senha", Error = "Senha deve ser informada." }; erros.Add(error); } else if (senha.Length < 5 || senha.Length > 15) { ErrorField error = new ErrorField() { PropertyName = "Senha", Error = "Senha deve conter entre 5 e 15 caracteres." }; erros.Add(error); } else if (!VerificarSenhaValida(senha)) { ErrorField error = new ErrorField() { PropertyName = "Senha", Error = "Senha deve conter pelo menos 1 letra maiúscula e 1 número." }; erros.Add(error); } if (erros.Count != 0) { throw new PetShopException(erros); } //string senhaHasheada = HashUtils.HashPassword(senha); using (PetContext ctx = new PetContext()) { //select * from usuarios where username = '******' and passoword = '09ur98ucvsf89f' Usuario user = ctx.Usuario.FirstOrDefault(u => u.Email == email && u.Senha == senha); return(user); } }
public void Configure(IApplicationBuilder app, PetContext ctx) { ctx.Database.EnsureDeleted(); ctx.Database.EnsureCreated(); app.UseStaticFiles(); app.UseRouting(); app.UseEndpoints(endpoints => { endpoints.MapControllerRoute("Default", "{controller=Home}/{action=Index}/{id?}"); }); }
public PetsRepository(PetContext context) { _context = context; if (_context.Pets.Count() == 0) { _context.Pets.AddRange( new Pet { Name = "Opie 奥比", Breed = "Shih Tzu 狮子狗", PetType = PetType.Dog }, new Pet { Name = "Reggie 雷吉", Breed = "Beagle 猎兔犬", PetType = PetType.Dog }, new Pet { Name = "Diesel 迪赛", Breed = "Bombay 孟买猫", PetType = PetType.Cat }, new Pet { Name = "Lucy 露西", Breed = "Maine Coon 缅因猫", PetType = PetType.Cat }, new Pet { Name = "gou zi 狗子", Breed = "Chinese pastoral dog 中华田园犬", PetType = PetType.Dog }); _context.SaveChanges(); } }
public void Excluir(Usuario usuario) { if (usuario.ID <= 0) { ErrorField error = new ErrorField() { Error = "Endereço de ID inválido", PropertyName = "ID" }; erros.Add(error); } if (erros.Count != 0) { throw new PetShopException(erros); } using (PetContext pet = new PetContext()) { pet.Entry <Usuario>(usuario).State = System.Data.Entity.EntityState.Deleted; pet.SaveChanges(); } }
public MascotaController(PetContext c) { _context = c; }
public OrderRepository(PetContext context) { this.db = context; }
public GetPetsByUsernameQueryHandler(PetContext petContext) { PetContext = petContext; }
public GetPetsBySpeciesQueryHandler(PetContext petContext) { PetContext = petContext; }