private void UpdatePrescriptionAsPaid(Prescription prescription, SqlConnection connection)
{
string UpdateQuery = Utility.ReadSQLQueryFromFile("UpdatePrescriptionAsPaid.txt");
SQLQuery updateSQLQuery = new SQLQuery(UpdateQuery);
updateSQLQuery.AddParameter("@prescriptionid", prescription.prescriptionID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(updateSQLQuery, connection);
if (sQLQueryResult.code != 0)
{
throw sQLQueryResult.exception;
}
}
private void CreatePrivateCustomer(PrivateCustomer privateCustomer)
{
string query = Utility.ReadSQLQueryFromFile("CreatePrivateCustomer.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@customerID", privateCustomer.customerID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantCreateCustomer("", sQLQueryResult.exception);
}
}
private List <Cage> GetCageList(SQLQueryResult sQLQueryResult)
{
List <Cage> cages = new List <Cage>();
for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++)
{
int cageID = (int)sQLQueryResult.dataTable.Rows[i]["CageID"];
int speciesID = (int)sQLQueryResult.dataTable.Rows[i]["SpeciesID"];
string speciesName = (string)sQLQueryResult.dataTable.Rows[i]["SpeciesName"];
Species species = SpeciesFactory.Instance().CreateSpecies(speciesID, speciesName);
cages.Add(CageFactory.Instance().CreateCage(cageID, species));
}
return(cages);
}
public List <Treatment> GetTreatment(int treatmentID)
{
string query = Utility.ReadSQLQueryFromFile("GetTreatment.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@treatmentID", treatmentID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
List <Treatment> treatments = new List <Treatment>();
treatments = GetTreatmentList(sQLQueryResult);
return(treatments);
}
public DateTime GetLastUpdate()
{
string query = Utility.ReadSQLQueryFromFile("GetLastUpdate.txt");
SQLQuery sQLQuery = new SQLQuery(query);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code == 0)
{
return((DateTime)sQLQueryResult.dataTable.Rows[0]["UpdateTime"]);
}
else
{
throw new DateNotFound("", sQLQueryResult.exception);
}
}
public string DeleteTreatment(int treatmentID)
{
string query = Utility.ReadSQLQueryFromFile("DeleteTreatment.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@treatmentID", treatmentID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantDeleteTreatmentException("", sQLQueryResult.exception);
}
return("ok");
}
public string UpdateMedicinePriceDate(MedicinePrice medicinePrice)
{
string query = Utility.ReadSQLQueryFromFile("UpdateMedicinPriceDate.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@newdate", medicinePrice.date.ToString(), SqlDbType.DateTime);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code == 0)
{
return("ok");
}
else
{
throw new DateNotUpdated("", sQLQueryResult.exception);
}
}
private List <Animal> GetAnimalList(SQLQueryResult sQLQueryResult)
{
List <Animal> animals = new List <Animal>();
for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++)
{
Employee employee = null;
if (sQLQueryResult.dataTable.Rows[i].IsNull("EmployeeID"))
{
}
else
{
string titleName = (string)sQLQueryResult.dataTable.Rows[i]["TitleName"];
int titleID = (int)sQLQueryResult.dataTable.Rows[i]["TitleID"];
Title title = TitleFactory.Instance().CreateTitle(titleName, titleID);
string employeeName = (string)sQLQueryResult.dataTable.Rows[i]["EmployeeName"];
int employeeID = (int)sQLQueryResult.dataTable.Rows[i]["EmployeeID"];
bool employeeActive = (bool)sQLQueryResult.dataTable.Rows[i]["EmployeeActive"];
employee = EmployeeFactory.Instance().CreateEmployee(employeeID, employeeName, employeeActive, title);
}
int CustomerID = (int)sQLQueryResult.dataTable.Rows[i]["CustomerID"];
string customerName = (string)sQLQueryResult.dataTable.Rows[i]["customername"];
string customeradress = (string)sQLQueryResult.dataTable.Rows[i]["Adress"];
string customerphone = (string)sQLQueryResult.dataTable.Rows[i]["Phone"];
string customeremail = (string)sQLQueryResult.dataTable.Rows[i]["Email"];
bool customeractive = (bool)sQLQueryResult.dataTable.Rows[i]["Active"];
Customer customer = CustomerFactory.Instance().CreateCustomer(CustomerID, customerName, customeradress, customerphone, customeremail, customeractive, 0);
int animalID = (int)sQLQueryResult.dataTable.Rows[i]["AnimalID"];
string name = (string)sQLQueryResult.dataTable.Rows[i]["Name"];
DateTime birthday = (DateTime)sQLQueryResult.dataTable.Rows[i]["BirthYear"];
int speciesID = (int)sQLQueryResult.dataTable.Rows[i]["Speciesid"];
string speciesName = (string)sQLQueryResult.dataTable.Rows[i]["SpeciesName"];
Species species = SpeciesFactory.Instance().CreateSpecies(speciesID, speciesName);
double weight = Convert.ToDouble((decimal)sQLQueryResult.dataTable.Rows[i]["Weight"]);
bool gender = (bool)sQLQueryResult.dataTable.Rows[i]["Gender"];
bool active = (bool)sQLQueryResult.dataTable.Rows[i]["Active"];
animals.Add(AnimalFactory.Instance().CreateAnimal(customer, animalID, name, birthday, species, weight, gender, employee, true));
}
return(animals);
}
public List <Cage> GetAllCages()
{
string query = Utility.ReadSQLQueryFromFile("GetAllCages.txt");
SQLQuery sQLQuery = new SQLQuery(query);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantFindCagesException("", sQLQueryResult.exception);
}
List <Cage> cages = new List <Cage>();
cages = GetCageList(sQLQueryResult);
return(cages);
}
private void CreateBusinessCustomer(BusinessCustomer businessCustomer)
{
SqlConnection con = new SqlConnection(Utility.connectionString);
string query = Utility.ReadSQLQueryFromFile("CreateBusinessCustomer.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@cvr", businessCustomer.cvr.ToString(), SqlDbType.Int);
sQLQuery.AddParameter("@businesscustomerID", businessCustomer.customerID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantCreateCustomer("", sQLQueryResult.exception);
}
}
public List <OperationRoom> GetAllOperationRooms()
{
string query = Utility.ReadSQLQueryFromFile("GetAllOperationRooms.txt");
SQLQuery sQLQuery = new SQLQuery(query);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantFindOperationRoomsException("", sQLQueryResult.exception);
}
List <OperationRoom> operationRooms = new List <OperationRoom>();
operationRooms = GetAllOperationRooms(sQLQueryResult);
return(operationRooms);
}
public Customer CreateCustomer(Customer customer)
{
SqlConnection con = new SqlConnection(Utility.connectionString);
string query = Utility.ReadSQLQueryFromFile("CreateCustomer.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@phone", customer.phone.ToString(), SqlDbType.VarChar);
sQLQuery.AddParameter("@name", customer.name.ToString(), SqlDbType.VarChar);
sQLQuery.AddParameter("@address", customer.address.ToString(), SqlDbType.VarChar);
sQLQuery.AddParameter("@email", customer.email.ToString(), SqlDbType.VarChar);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantCreateCustomer("", sQLQueryResult.exception);
}
int customerID = (int)sQLQueryResult.dataTable.Rows[0]["CustomerID"];
customer.UpdateID(customerID);
if (customer.GetType() == typeof(BusinessCustomer))
{
//der laves en BusinessCustomer som castes til customer
BusinessCustomer businessCustomer = (BusinessCustomer)customer;
CreateBusinessCustomer(businessCustomer);
}
if (customer.GetType() == typeof(PrivateCustomer))
{
//der laves en PrivateCustomer som castes til customer
PrivateCustomer privateCustomer = (PrivateCustomer)customer;
CreatePrivateCustomer(privateCustomer);
}
return(customer);
}
private List <OperationRoom> GetAllOperationRooms(SQLQueryResult sQLQueryResult)
{
List <OperationRoom> operationRooms = new List <OperationRoom>();
for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++)
{
int operationRoomID;
if (sQLQueryResult.dataTable.Rows[i].IsNull("OperationRoomID"))
{
operationRoomID = -1;
}
else
{
operationRoomID = (int)sQLQueryResult.dataTable.Rows[i]["OperationRoomID"];
}
operationRooms.Add(OperationRoomFactory.Instance().CreateOperationRoom(operationRoomID));
}
return(operationRooms);
}
public List <Treatment> GetUnpaidTreatmentsByCustomer(Customer customer)
{
string query = Utility.ReadSQLQueryFromFile("GetUnpaidTreatmentsByCustomer.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@customerid", customer.customerID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantGetUnPaidTreatments("", sQLQueryResult.exception);
}
List <Treatment> treatments = new List <Treatment>();
treatments = GetTreatmentList(sQLQueryResult);
return(treatments);
}
public string DeleteAnimal(Animal animal)
{
string query = Utility.ReadSQLQueryFromFile("DeleteAnimal.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@animalid", animal.animalID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code == 0)
{
return("ok");
}
else
{
throw new AnimalNotDeletedException("", sQLQueryResult.exception);
}
}
public string UndeleteCustomer(Customer customer)
{
string query = Utility.ReadSQLQueryFromFile("UndeleteCustomer.txt");
SQLQuery sQLQuery = new SQLQuery(query);
//af en eller anden grund virker det her fint med varchars og strings
sQLQuery.AddParameter("@customerID", customer.customerID.ToString(), SqlDbType.VarChar);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code == 0)
{
return("Kunde gjort aktiv");
}
else
{
return(sQLQueryResult.exception.Message.ToString());
}
}
public List <Treatment> GetManyTreatmentsByDateTime(DateTime startTime, DateTime endTime)
{
string query = Utility.ReadSQLQueryFromFile("GetManyTreatmentsByDateTime.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@startTime", startTime.ToString("yyyy-MM-ddTHH:mm:ss"), SqlDbType.DateTime);
sQLQuery.AddParameter("@endTime", endTime.ToString("yyyy-MM-ddTHH:mm:ss"), SqlDbType.DateTime);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantFindTreatmentsException("", sQLQueryResult.exception);
}
List <Treatment> treatments = new List <Treatment>();
treatments = GetTreatmentList(sQLQueryResult);
return(treatments);
}
public List <TreatmentType> GetAllTreatmentTypes()
{
string query = Utility.ReadSQLQueryFromFile("GetManyTreatmentTypes.txt");
SQLQuery sQLQuery = new SQLQuery(query);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0 || sQLQueryResult.dataTable.Rows.Count == 0)
{
throw new NoTreatmentTypesFoundException("", sQLQueryResult.exception);
}
else
{
List <TreatmentType> treatments = new List <TreatmentType>();
treatments = GetTreatmentTypeList(sQLQueryResult);
return(treatments);
}
}
public List <Employee> GetAllEmployees()
{
List <Employee> employees = new List <Employee>();
string query = Utility.ReadSQLQueryFromFile("GetAllEmployees.txt");
SQLQuery sQLQuery = new SQLQuery(query);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0 || sQLQueryResult.dataTable.Rows.Count == 0)
{
throw new NoEmployeesFoundException("", sQLQueryResult.exception);
}
else
{
employees = GetEmployeeList(sQLQueryResult);
return(employees);
}
}
public List <Animal> GetManyAnimalByCustomerID(Customer customer)
{
string query = Utility.ReadSQLQueryFromFile("GetManyAnimalsByCustomerID.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@CustomerID", customer.customerID.ToString(), SqlDbType.VarChar);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code == 0)
{
List <Animal> animals = new List <Animal>();
animals = GetAnimalList(sQLQueryResult);
return(animals);
}
else
{
throw new CantGetAnimalList("", sQLQueryResult.exception);
}
}
public List <Prescription> GetUnpaidPrescriptionByCustomer(Customer customer)
{
string query = Utility.ReadSQLQueryFromFile("GetUnpaidPrescriptionsByCustomer.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@customerid", customer.customerID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code == 0)
{
List <Prescription> prescription = new List <Prescription>();
prescription = GetAllPrescriptionList(sQLQueryResult);
return(prescription);
}
else
{
throw new CantGetUnPaidPrescription("", sQLQueryResult.exception);
}
}
public List <Item> GetAllActiveItems()
{
string query = Utility.ReadSQLQueryFromFile("GetAllActiveItems.txt");
SQLQuery sQLQuery = new SQLQuery(query);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code == 0)
{
List <Item> items = GetListOfItemsFromDatatable(sQLQueryResult.dataTable);
if (items.Count == 0)
{
throw new NoItemsFoundException("1");
}
return(items);
}
else
{
throw new NoItemsFoundException("", sQLQueryResult.exception);
}
}
public List <Sale> GetManySalesByCustomerID(Customer customer)
{
List <Sale> sales;
string query = Utility.ReadSQLQueryFromFile("GetManySalesByCustomerID.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@customerid", customer.customerID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0 || sQLQueryResult.dataTable.Rows.Count == 0)
{
return(new List <Sale>());
}
else
{
sales = GetSalesFromDataTable(sQLQueryResult.dataTable, customer);
}
return(sales);
}
public MedicalRecord CreateMedicalRecordEntry(MedicalRecord medicalRecord)
{
Animal animal = medicalRecord.animal;
Treatment treatment = medicalRecord.treatment;
string query = Utility.ReadSQLQueryFromFile("CreateMedicalRecordEntry.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@entry", medicalRecord.entry.ToString(), SqlDbType.VarChar);
sQLQuery.AddParameter("@animalID", animal.animalID.ToString(), SqlDbType.Int);
sQLQuery.AddParameter("@treatmentID", treatment.treatmentID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
int medicalrecordID = (int)sQLQueryResult.dataTable.Rows[0]["MedicalRecordID"];
if (sQLQueryResult.code != 0)
{
throw new CantUpdateTreatmentException("", sQLQueryResult.exception);
}
medicalRecord.UpdateMedicalRecordID(medicalrecordID);
return(medicalRecord);
}
public Animal CreateAnimal(Animal animal)
{
string query = Utility.ReadSQLQueryFromFile("CreateAnimal.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@customerid", animal.customer.customerID.ToString(), SqlDbType.Int);
sQLQuery.AddParameter("@species", animal.Species.speciesID.ToString(), SqlDbType.Int);
sQLQuery.AddParameter("@birthday", animal.birthYear.ToString("yyyy-MM-ddTHH:mm:ss"), SqlDbType.DateTime);
sQLQuery.AddParameter("@name", animal.name.ToString(), SqlDbType.VarChar);
sQLQuery.AddParameter("@weight", animal.weight.ToString(), SqlDbType.Float);
sQLQuery.AddParameter("@gender", animal.gender.ToString(), SqlDbType.Bit);
sQLQuery.AddParameter("@active", "True", SqlDbType.Bit);
if (animal.Employee == null)
{
sQLQuery.AddParameter("@employeeid", null, SqlDbType.Int);
}
else
{
sQLQuery.AddParameter("@employeeid", animal.Employee.employeeID.ToString(), SqlDbType.Int);
}
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
int animalID = (int)sQLQueryResult.dataTable.Rows[0]["AnimalID"];
animal.UpdateID(animalID);
if (sQLQueryResult.code == 0)
{
return(animal);
}
else
{
throw new AnimalNotCreatedException("", sQLQueryResult.exception);
}
}
private List <TreatmentType> GetTreatmentTypeList(SQLQueryResult sQLQueryResult)
{
List <TreatmentType> treatmentTypes = new List <TreatmentType>();
for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++)
{
int treatmentTypeID;
if (sQLQueryResult.dataTable.Rows[i].IsNull("TreatmentTypeID"))
{
treatmentTypeID = -1;
}
else
{
treatmentTypeID = (int)sQLQueryResult.dataTable.Rows[i]["TreatmentTypeID"];
}
string name = (string)sQLQueryResult.dataTable.Rows[i]["Name"];
treatmentTypes.Add(TreatmentTypeFactory.Instance().CreateTreatmentType(treatmentTypeID, name));
}
return(treatmentTypes);
}
public string UpdateTreatment(Treatment treatment)
{
string query = Utility.ReadSQLQueryFromFile("UpdateTreatment.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@startTime", treatment.startTime.ToString(), SqlDbType.DateTime);
sQLQuery.AddParameter("@endTime", treatment.endTime.ToString(), SqlDbType.DateTime);
sQLQuery.AddParameter("@payed", treatment.payed.ToString(), SqlDbType.Bit);
sQLQuery.AddParameter("@headline", treatment.headline.ToString(), SqlDbType.VarChar);
sQLQuery.AddParameter("@active", treatment.active.ToString(), SqlDbType.Bit);
sQLQuery.AddParameter("@treatmentID", treatment.treatmentID.ToString(), SqlDbType.Int);
sQLQuery.AddParameter("@status", treatment.status.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
if (sQLQueryResult.code != 0)
{
throw new CantUpdateTreatmentException("", sQLQueryResult.exception);
}
return("ok");
}
public List <Prescription> GetAllPrescriptionByAnimal(int animalID)
{
string query = Utility.ReadSQLQueryFromFile("GetAllPrescriptionByAnimal.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@animalID", animalID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
List <Prescription> prescription = new List <Prescription>();
prescription = GetAllPrescriptionList(sQLQueryResult);
if (sQLQueryResult.code == 0)
{
return(prescription);
}
else
{
throw new PrescriptionNotFoundException("", sQLQueryResult.exception);
}
}
private List <MedicalRecord> GetMedicalRecordEntryList(Animal animal, SQLQueryResult sQLQueryResult)
{
List <MedicalRecord> entries = new List <MedicalRecord>();
for (int i = 0; i < sQLQueryResult.dataTable.Rows.Count; i++)
{
string entry = (string)sQLQueryResult.dataTable.Rows[i]["Entry"];
int MedicalRecordID = (int)sQLQueryResult.dataTable.Rows[i]["MedicalRecordID"];
int TreatmentID = (int)sQLQueryResult.dataTable.Rows[i]["TreatmentID"];
DateTime StartTime = (DateTime)sQLQueryResult.dataTable.Rows[i]["StartTime"];
DateTime EndTime = (DateTime)sQLQueryResult.dataTable.Rows[i]["EndTime"];
bool Payed = (bool)sQLQueryResult.dataTable.Rows[i]["Payed"];
string Headline = (string)sQLQueryResult.dataTable.Rows[i]["Headline"];
bool Active = (bool)sQLQueryResult.dataTable.Rows[i]["Active"];
int Status = (int)sQLQueryResult.dataTable.Rows[i]["Status"];
Treatment treatment = TreatmentFactory.Instance().CreateTreatment(TreatmentID, null, null, null, null, StartTime, EndTime, Payed, Headline, Active, animal, null, Status);
MedicalRecord medicalRecord = MedicalRecordFactory.Instance().CreateMedicalRecord(MedicalRecordID, entry, animal, treatment);
entries.Add(medicalRecord);
}
return(entries);
}
public List <MedicalRecord> GetAllMedicalRecordEntriesByAnimalID(Animal animal)
{
string query = Utility.ReadSQLQueryFromFile("GetAllMedicalRecordByAnimal.txt");
SQLQuery sQLQuery = new SQLQuery(query);
sQLQuery.AddParameter("@animalid", animal.animalID.ToString(), SqlDbType.Int);
SQLQueryResult sQLQueryResult = SQLDatabaseConnector.QueryDatabase(sQLQuery);
List <MedicalRecord> entries = new List <MedicalRecord>();
entries = GetMedicalRecordEntryList(animal, sQLQueryResult);
if (sQLQueryResult.code == 0)
{
return(entries);
}
else
{
throw new MedicalRecordEntryNotFoundException("", sQLQueryResult.exception);
}
}
