public PetsController(PetDAO petDAO, GeneroDAO generoDAO, ClienteDAO clienteDAO,IHostingEnvironment hosting)
{
_petDAO = petDAO;
_generoDAO = generoDAO;
_hosting = hosting;
_clienteDAO = clienteDAO;
}
public Models.Pet SetPet(Models.Pet pet)
{
using (DbConnection database = new SqlConnection(databaseConnectionString))
{
var petDao = new PetDAO()
{
Guid = Guid.NewGuid(),
Name = pet.Name,
CategoryGuid = pet.Category.Guid,
PetStatus = pet.Status,
};
if (CheckIfCategoryExist(pet.Category.Guid, pet) == null)
{
return(null);
}
const string insertQuery = "INSERT INTO PetStore.Pet VALUES (@guid, @name, @categoryGuid, @petStatus)";
database.Execute(insertQuery, petDao);
var newPet = TransformDaoToBusinessLogicPet(petDao);
var tags = CreateTags(pet.Tags, petDao.Guid);
if (tags == null)
{
return(null);
}
newPet.Tags = tags;
return(newPet);
}
}
public async Task <IActionResult> GetPet()
{
using (var petDAO = new PetDAO())
{
return(Json((await petDAO.ReadAll(false))
.ToArray()));
}
}
//UPDATE
public void Editar(Pet pet)
{
PetDAO petDAO = new PetDAO();
if (pet.Nome != "")
{
petDAO.Update(pet);
}
}
public void GravarPet(Pet pet)
{
PetDAO petDAO = new PetDAO();
if (pet.Nome != "")
{
petDAO.Insert(pet);
}
}
public async Task <IActionResult> GetPetSearchResult(string keyword)
{
using (var petDAO = new PetDAO()){
return(Json((petDAO.Context.Cage
.Include(x => x.Product)
.Where(x => x.Product.Name.IndexOf(keyword, StringComparison.OrdinalIgnoreCase) != -1))
.ToArray()));
}
}
public ReservaController(ReservaDAO reservaDAO,
QuartoDAO quartoDAO, PetDAO petDAO, ServicoDAO servicoDAO, ClienteDAO clienteDAO, ItemVendaDAO itemVendaDAO)
{
_reservaDAO = reservaDAO;
_quartoDAO = quartoDAO;
_petDAO = petDAO;
_servicoDAO = servicoDAO;
_clienteDAO = clienteDAO;
_itemVendaDAO = itemVendaDAO;
}
//Buscar Por NOme
public IList <Pet> BuscarNPet(Pet pet)
{
PetDAO petDAO = new PetDAO();
if (pet.Nome != "")
{
IList <Pet> petTemp = petDAO.BuscarPorNomeP(pet.Nome);
return(petTemp);
}
else
{
return(null);
}
}
//BUSCAR PET
public void BuscarPorId(Pet pet)
{
PetDAO petDAO = new PetDAO();
if (pet.CodPet > 0)
{
var petTemp = petDAO.BuscarPorId(pet.CodPet);
pet.Cliente.Codigo = petTemp.Cliente.Codigo;
pet.Nome = petTemp.Nome;
pet.Raca = petTemp.Raca;
pet.Porte = petTemp.Porte;
pet.Sexo = petTemp.Sexo;
pet.Cor = petTemp.Cor;
pet.Especie = petTemp.Especie;
}
}
public void Gravar(Pet pet)
{
PetDAO petDAO = new PetDAO();
if (pet.Nome != null)
{
if (pet.CodPet != 0)
{
petDAO.Update(pet);
}
else
{
petDAO.Insert(pet);
}
}
}
private Models.Pet TransformDaoToBusinessLogicPet(PetDAO petDao)
{
using IDbConnection database = new SqlConnection(databaseConnectionString);
var category = GetCategoryByGuid(petDao.CategoryGuid);
var tags = GetTagsForPet(petDao.Guid);
var photos = GetPhotosForPet(petDao.Guid);
var photoNames = new List <string>();
photos.ForEach(p => photoNames.Add(p.Url));
return(new Models.Pet
{
Guid = petDao.Guid,
Name = petDao.Name,
Category = category,
Status = petDao.PetStatus,
Tags = tags,
PhotoUrls = photoNames,
});
}
public PetBUS()
{
_petDAO = new PetDAO();
}
public PetAPIController(PetDAO petDAO)
{
_petDAO = petDAO;
}
