private List <dynamic> getSaleLine(Sale_Pet sale)
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
return(getSaleLineList(db.Sale_Line_Pet.Include(pp => pp.Pet).Include(PP => PP.Pet.Pet_Type).ToList()));
}
public List <dynamic> GetAllSales()
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
return(getSaleList(db.Sale_Pet.ToList()));
}
public List <dynamic> getAllPetTypes()
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
return(getPetTypeList(db.Pet_Type.ToList()));
}
public List <dynamic> getAllPets()
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
return(getPetList(db.Pets.Include(pp => pp.Pet_Type).ToList()));
}
public List <dynamic> GetAllSalesWithPets()
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
List <Sale_Pet> sales = db.Sale_Pet.Include(pp => pp.Sale_Line_Pet).ToList();
return(GetAllSalesWithPets(sales));
}
public List <dynamic> CreatePetType([FromBody] Pet_Type petType)
{
if (petType != null)
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
db.Pet_Type.Add(petType);
db.SaveChanges();
return(getAllPetTypes());
}
else
{
return(null);
}
}
public List <dynamic> CreatePets([FromBody] List <Pet> pets)
{
if (pets != null)
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
db.Pets.AddRange(pets);
db.SaveChanges();
return(getAllPets());
}
else
{
return(null);
}
}
public List <dynamic> UpdatePetType([FromBody] Pet_Type pet_Type)
{
if (pet_Type != null)
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
Pet_Type objPrev = db.Pet_Type.Where(p => p.Pet_Type_ID == pet_Type.Pet_Type_ID).FirstOrDefault();
objPrev.Pet_Type1 = pet_Type.Pet_Type1;
db.SaveChanges();
return(getAllPetTypes());
}
else
{
return(null);
}
}
public List <dynamic> UpdatePet([FromBody] Pet pet)
{
if (pet != null)
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
Pet objPrev = db.Pets.Where(p => p.Pet_ID == pet.Pet_ID).FirstOrDefault();
objPrev.Pet_Type_ID = pet.Pet_Type_ID;
objPrev.Pet_Price = pet.Pet_Price;
objPrev.Pet_Quantitiy = pet.Pet_Quantitiy;
db.SaveChanges();
return(getAllPets());
}
else
{
return(null);
}
}
public List <dynamic> DeletePet([FromBody] Pet pet)
{
PetDBEntities db = new PetDBEntities();
db.Configuration.ProxyCreationEnabled = false;
Pet objPrev = db.Pets.Where(p => p.Pet_ID == pet.Pet_ID).FirstOrDefault();
if (objPrev != null)
{
db.Pets.Remove(objPrev);
db.SaveChanges();
return(getAllPets());
}
else
{
return(null);
}
}
