// 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;
}
