public void addAppointmentDetails(AppointmentModel appointmentModel)
{
var registeredOwnerID = GetRegistredOwnerId(appointmentModel.Owner_FirstName, appointmentModel.Owner_LastName, appointmentModel.MobileNumber);
var registeredPetID = GetRegisterdPetID(appointmentModel.PetName, appointmentModel.BreedName, registeredOwnerID);
using (VetDBEntities db = new VetDBEntities())
{
if (registeredOwnerID == 0)
{
Communication_Address address = new Communication_Address();
address.AddressLane1 = appointmentModel.AddressLane1;
address.AdressLane2 = appointmentModel.AdressLane2;
address.City = appointmentModel.City;
db.Communication_Address.Add(address);
db.SaveChanges();
int addressID = address.ID;
Owner owner = new Owner();
owner.FirstName = appointmentModel.Owner_FirstName;
owner.LastName = appointmentModel.Owner_LastName;
owner.MobileNumber = appointmentModel.MobileNumber;
owner.AddressID = addressID;
db.Owners.Add(owner);
db.SaveChanges();
registeredOwnerID = owner.ID;
}
if (registeredPetID == 0)
{
Pet_Details pet = new Pet_Details();
pet.PetName = appointmentModel.PetName;
pet.BreedName = appointmentModel.BreedName;
pet.DateOfBirth = appointmentModel.DateOfBirth;
pet.Pedegree = appointmentModel.Pedegree;
db.Pet_Details.Add(pet);
db.SaveChanges();
registeredPetID = pet.ID;
}
Treatement_Details treatment = new Treatement_Details();
treatment.TreatementDate = appointmentModel.TreatementDate;
treatment.TreatementCost = appointmentModel.TreatementCost;
treatment.Notes = appointmentModel.Notes;
treatment.PetID = registeredPetID;
db.Treatement_Details.Add(treatment);
db.SaveChanges();
Pet_Owner petOwner = new Pet_Owner();
petOwner.OwnerID = registeredOwnerID;
petOwner.PetID = registeredPetID;
db.Pet_Owner.Add(petOwner);
db.SaveChanges();
}
}
public int GetRegisterdPetID(string petName, string breed, int ownerId)
{
using (VetDBEntities db = new VetDBEntities())
{
if (ownerId != 0)
{
var pet = db.Pet_Details.Where(p => (p.PetName.Equals(petName)) && (p.BreedName.Equals(breed))).FirstOrDefault();
if (pet != null)
{
return(pet.ID);
}
}
return(0);
}
}
public int GetRegistredOwnerId(string FirstName, string lastName, string MobileNumber)
{
using (VetDBEntities db = new VetDBEntities())
{
var owner = db.Owners.Where(o => (o.FirstName.Equals(FirstName)) && (o.LastName.Equals(lastName)) && (o.MobileNumber.Equals(MobileNumber))).FirstOrDefault();
if (owner != null)
{
return(owner.ID);
}
else
{
return(0);
}
}
}
