static void Main(string[] args) { var context = new VeterinaryContext(); context.Database.EnsureDeleted(); context.Database.EnsureCreated(); for (int i = 1; i < 20; i++) { var Pet = new Pet() { Type = "Pitbull_" + i, ParentId = i }; context.Pets.Add(Pet); context.Persons.Add(new Person { FirstName = "Moro_" + i, LastName = "Joro_" + i, }); } context.SaveChanges(); var persons = context.Persons .Select(x => new { FullName = x.FirstName + ' ' + x.LastName, Pets = String.Join(", ", x.Pets.Select(x => x.Type)) }) .ToList(); var firstPerson = context.Persons.FirstOrDefault(); context.Persons.Remove(firstPerson); context.SaveChanges(); //foreach (var person in persons) //{ // Console.WriteLine(person.FullName); // Console.WriteLine(person.Pets); //} }
public JsonResult CreateOwner(Owner owner) { var status = true; if (owner.OwnerName != String.Empty & owner.OwnerLastName != String.Empty) { db.Owners.Add(owner); db.SaveChanges(); } else { status = false; } return(new JsonResult { Data = new { status = status, ownerId = owner.OwnerId } }); }
public JsonResult CreateVaccine(Vaccine vaccine) { if (!db.Vaccines.ToList().Exists(v => v.PetId == vaccine.PetId & v.VaccineNumber == vaccine.VaccineNumber)) { vaccine.Pet = db.Pets.Find(vaccine.PetId); db.Vaccines.Add(vaccine); db.SaveChanges(); var specie = vaccine.Pet.PetSpecie == Species.Canina ? "Canina" : "Felina"; return(new JsonResult { Data = new { status = true, vaccineId = vaccine.VaccineId, owner = vaccine.Pet.Owner.OwnerFullName, pet = vaccine.Pet.PetName, specie = specie, date = vaccine.VaccineDate.ToString("yyyy-MM-dd") + "." + vaccine.VaccineDate.ToString("D") } }); } return(new JsonResult { Data = new { status = false } }); }
// GET: LandingPage public ActionResult Index() { var owners = (from s in db.Surgeries.ToList() where !s.SurgeryPatientFrequent & s.SurgeryDate < DateTime.Today select s.Pet.Owner); db.Owners.RemoveRange(owners); db.SaveChanges(); ViewBag.Vaccines = db.Vaccines.Count(v => v.VaccineDate == DateTime.Today & v.VaccineNumber != 1); ViewBag.Surgeries = db.Surgeries.Count(s => s.SurgeryDate == DateTime.Today); ViewBag.Showers = db.Showers.Count(sh => sh.ShowerDate == DateTime.Today); return(View()); }
public JsonResult CreatePet(Pet pet) { pet.Owner = db.Owners.Find(pet.OwnerId); db.Pets.Add(pet); db.SaveChanges(); return(new JsonResult { Data = new { PetId = pet.PetId, OwnerName = pet.Owner.OwnerFullName } }); }
public JsonResult CreateShower(Shower shower) { if (shower.ShowerDate != null) { Pet pet = db.Pets.Find(shower.PetId); if (pet != null) { shower.PetName = pet.PetName; shower.Owner = pet.Owner.OwnerFullName; shower.OwnerPhone = pet.Owner.OwnerPhone; if (pet.PetSpecie == Species.Canina) { shower.PetSpecie = "Canina"; } else { shower.PetSpecie = "Felina"; } } db.Showers.Add(shower); db.SaveChanges(); return(new JsonResult { Data = new { status = true, showerId = shower.ShowerId, petId = shower.PetId, petname = shower.PetName, owner = shower.Owner, ownerPhone = shower.OwnerPhone, specie = shower.PetSpecie, date = shower.ShowerDate.ToString("yyyy-MM-dd"), dateTitle = shower.ShowerDate.ToString("D") } }); } else { return(new JsonResult { Data = new { status = false } }); } }
public JsonResult CreateSurgeryType(SurgeryType surgeryType) { var exist = db.SurgeryTypes.ToList().Exists(st => st.SurgeryTypeName == surgeryType.SurgeryTypeName); if (exist) { return(new JsonResult { Data = new { status = false } }); } else { db.SurgeryTypes.Add(surgeryType); db.SaveChanges(); return(new JsonResult { Data = new { status = true, surgeryTypeId = surgeryType.SurgeryTypeId } }); } }